Having trouble migrating Invoiceplane to new server / domain


#1

Hello,

I’m trying trying te migrate Invoiceplane 1.5.9 to a new domain / server but I have some issues.
A made a clean install on the new server. Deleted fields in database, exported the database of the old server, imported it to my new one and changed the database credentials in a/application/config/database.php to the ones on my new server / new database.

When I visit my domain I get the following errors. What am I missing?
Hope someone more technical then me can help me out.
Thanks a bunch

Bjorn

A PHP Error was encountered
Severity: Warning

Message: mysqli::real_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Filename: mysqli/mysqli_driver.php

Line Number: 201

Backtrace:

File: /mnt/web321/a2/79/59303379/htdocs/application/third_party/MX/Loader.php
Line: 180
Function: DB

File: /mnt/web321/a2/79/59303379/htdocs/application/core/Base_Controller.php
Line: 56
Function: database

File: /mnt/web321/a2/79/59303379/htdocs/application/core/User_Controller.php
Line: 29
Function: __construct

File: /mnt/web321/a2/79/59303379/htdocs/application/core/Admin_Controller.php
Line: 26
Function: __construct

File: /mnt/web321/a2/79/59303379/htdocs/index.php
Line: 325
Function: require_once

A PHP Error was encountered
Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /mnt/web321/a2/79/59303379/htdocs/vendor/codeigniter/framework/system/core/Exceptions.php:271)

Filename: core/Common.php

Line Number: 564

Backtrace:

File: /mnt/web321/a2/79/59303379/htdocs/application/third_party/MX/Loader.php
Line: 180
Function: DB

File: /mnt/web321/a2/79/59303379/htdocs/application/core/Base_Controller.php
Line: 56
Function: database

File: /mnt/web321/a2/79/59303379/htdocs/application/core/User_Controller.php
Line: 29
Function: __construct

File: /mnt/web321/a2/79/59303379/htdocs/application/core/Admin_Controller.php
Line: 26
Function: __construct

File: /mnt/web321/a2/79/59303379/htdocs/index.php
Line: 325
Function: require_once

A Database Error Occurred
Unable to connect to your database server using the provided settings.

Filename: core/User_Controller.php

Line Number: 29

#2

I think you should make the chages in the file ipconfig.php.
There you should also change the IP_URL if that has changed.
Maybe you should also run a setup and you could do that after setting DISABLE_SETUP to false.

I’m not an expert but hope this will help you.


#3

Thanks for your reply,

During the clean install of Invoiceplane, at the setup process, a good ipconfig.php is being created as far as I can see (not an expert as well). I’ve already looked into the ipconfig.php and see that both URL and database settings are the right ones.
Bummer…
Any other suggestions maybe?

thanks


#4

Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’

Not a problem with InvoicePlane but with your MySQL server. Probably a wrong configuration. Please search on Google or Stack Overflow, there are many results for this particular error.


#5

Thanks, I’ll look into this!