I just tried again with v0.7 and all is good except:
ERROR: 2019/01/08 18:55:27 log.go:26: Rolling back users INSERT: no such table: users
ERROR: 2019/01/08 18:55:27 log.go:26: Unable to create user: no such table: users
Solved by running:
./writefreely --init-db
before
./writefreely --config
So you might want to make that adjustment in the Getting Started info… 
Yes, I too got the same error and fixed it in the exact same manner, even in my localhost.
Actually, having tried again. You cannot run
init-db
before
config
I tried that route just now. So had to run config then init-db and then run config a second time…
Yes. Correct. Forgot to mention that.
I just added a bug for the --init-db --config issue, but now I see it is a known issue and addressed in 0.7.1. I’ll remove my Githib bug.
@lhl hey this guide you gave is really helpful. I plan to start on Scaleway but have you tried with the secure option yet? Do you know how to do it? I know one thing that we have to use 443 but apart from that what all procedures from Let’s Encrypt? Details please if you have done it.
Cheers, am just a bloke on the street with no documented experience, just personal trial and error…
I have a https version of my blog now. I used the following to set up:
It’s part of Let’s Encrypt - really easy to follow, you’ll need to be able to SSH to your server.
@lhl BTW, I heard that the free tier on Amazon EC2 runs out quickly. How many months have you been running your blog? If you are paying already then what is the cost. I need to be sure before I jump anywhere.
When I was using Bitbucket and an S3 instance where there is a lot of upload each time (I was using a HUGO Static Generated site at the time) my monthly costs were around $5 - $8 over the FREE allowance - roughly updating on a daily basis.
Now I am using WriteFreely, still updating once every few days or so, single user - based on a AWS EC2 instance, also using AWS Route53 to register my domain my monthly costs are approx $1.50.
For my usage it is less than when I was using VULTR to host my sites. A lot will depend on your usage environment.
One of the reasons I switched from HUGO to WriteFreely was the ease of administration. I still wanted a bare-bones blog with very few, if any, bells & whistles. I also wanted to really restrict the outgoing costs to the absolute minimum for a personal use only site that I have control over.
So, if I use Scaleway’s basic tier that costs around €1.99/mo (about $2.26) with 25GB SSD & 1 GB Memory but it has a minified version of Ubuntu 16.04, would you recommend me that?
I would think that there is not a lot of difference in most of the offers out there at this level of requirements. So long as you are not locking yourself into a minimum term contract - you can pretty much switch a VPS on/off as you please.
There is some effort required in backing-up files and db’s etc but it is always fairly easy to move from one provider to another if you find it doesn’t suit you.
Okay. Thanks!
@lhl @matt I tried everything as you have mentioned but I ran into some problems when I ran the last command
writefreely.service file
Please let me know where I have done wrong. My website is writeread.space. This whole system is hosted on Ubuntu 16.04 on Scaleway
Sorry, I don’t know. As I said I’m an average joe, not a developer or programmer. I think @matt can probably be much more useful to you to problem solve.
All I can see is that the ExecStart= in the writefreely.sevice file should read:
/var/www/example.com/writefreely as outlined in the Getting Started pages here
example.com should be replaced by the name of the folder you have used to store the files to.
If you are running the files from a reverse NGINX configuration check that your file PATH is correct first. NGINX also requires you to create a symlink to the WriteFreely files in order to be able to serve them. Again my experience of these things is generally through trial and error as I am doing them.
Can you show me these same files for your server? You can blur any sensitive details.
The writefreely.service and writefreely.conf are as in my original post (only changes are where I input specifics for my address) Not much to show really.
Have a look at this link first about how to set up a symlink with NGINX. It is for another software, but the information is useful: https://learn.getgrav.org/webservers-hosting/servers/nginx.
There should be very little different to your setup when using a localhost. Is that not what you had set up…?
