UPDATE: It worked
I went through the same process and it worked this time
The only thing I did differently is not to install cloudflare template.
scp path/to/phpbb_mysql.sql root@[IP Address of your droplet]:/var/discourse/shared/standalone/import/data works fine!
Sorry me again but I’m really struggling to import phpBB. I am following the guide above, but somehow it breaks my installation of Discourse.
I not able to import the database, and I am getting the errors below:
When I try to run the importer
Loading database dump into MySQL...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
When I try to Rebuild
Pups::ExecError: socat /dev/null UNIX-CONNECT:/shared/postgres_run/.s.PGSQL.5432 || exit 0 && echo postgres already running stop container ; exit 1 failed with return #<Process::Status: pid 45 exit 1>
Location of failure: /pups/lib/pups/exec_command.rb:112:in `spawn'
exec failed with the params "socat /dev/null UNIX-CONNECT:/shared/postgres_run/.s.PGSQL.5432 || exit 0 && echo postgres already running stop container ; exit 1"
** FAILED TO BOOTSTRAP ** please scroll up and look for earlier error messages, there may be more than one
Fortunately it’s a fresh install of Discourse
My server is: Ubuntu 16, Last Version of Discourse, failtoban installed
And I am trying to import phpBB version 3.1.6
Cloudflare template installed too ( not sure if this affect the whole process )
So I guess something goes wrong at step 1.2
Just to make sure:
1 - I create the import.yml like that:
cp containers/app.yml containers/import.yml
Then add the template - “templates/import/phpbb3.template.yml” to it.
Then run :
/var/discourse/launcher stop app
/var/discourse/launcher rebuild import
That’s it ? Am I missing something ?
Should I remove the cloudflare template fro that file ?
There is where I completely lost.
Question aside, can I run this command from localhost in order to upload the sql dump ?
scp path/to/phpbb_mysql.sql root@[IP Address of your droplet]:/var/discourse/shared/standalone/import/data
But it doesn’t seem to be working.
Let’s say I want to use the remote connection instead, and edit settings.yml
type: MySQL # currently only MySQL is supported
host: localhost ( to be changed with the ip ? )
username: root ( should I use the ssh login or database username ? )
password: ( same here, it is for the ssh access ) ?
schema: phpbb ( is this the database name ? )
table_prefix: phpbb_ # Change this, if your forum is using a different prefix. Usually all table names start with phpbb_
batch_size: 1000 # Don’t change this unless you know what you’re doing. The default (1000) should work just fine.
And after editing settings.yml, I only have to run ?
/var/discourse/launcher enter import
import_phpbb3.sh # inside the Docker container
Really sorry about all this questions, and thanks if you have the courage to read all this