Solved: Converting from SQLite to MySQL - Error Produced

9.1.x
help

#1

Hi,
I'm following this guide on converting my database as recently Owncloud has become unusable - predicting weeks to sync 1.5GB of data with little in the way of changes.

https://doc.owncloud.org/server/9.0/admin_manual/configuration_database/db_conversion.html

Above is the guide that I'm following, I type in the following and I get this error

sudo -u www-data php occ db:convert-type --all-apps mysql oc_mysql_user 127.0.0.1 owncloud_db
What is the database password?
    
  [Doctrine\DBAL\DBALException]                                                
  Failed to connect to the database: An exception occured in driver: SQLSTATE  
  [HY000] [2002] Connection refused                                            
db:convert-type [--port PORT] [--password PASSWORD] [--clear-schema] [--all-apps] [--chunk-size CHUNK-SIZE] [--] <type> <username> <hostname> <database>

Could anyone suggest a way I can move forwards please? SQLlite doesn't set a password unlike MySQL when you first setup ownCloud.

I'm running $OC_Version = array(9,1,3,1); on OpenMediaVault using Nginx.


#2

Hi,

a good starting point would be to google for that error message here.

A few topics you can see there are showing some debugging notes / infos. Overall, your mysql database doesn't accept the connection to its port. Either the MySQL server is not running at all, doesn't listen on TCP, listen on a non-default port or similar.


#3

I discovered the problem was actually related to the fact I already has MySQL installed and configured without even realising it. Once I dug out the password it all worked (at least, I think it did). I have a different set of problems instead.