FrontAccounting forum — Database connection issue

Re: Database connection issue

null@example.com (apmuthu) — Thu, 27 Jul 2017 09:49:24 +0000

@joe / @itronics: Thanks for the commit that now allows non standard db ports in FA 2.4.x.

Gracefully degrades to accommodate old config_db.php files that do not have the port element in each connection instance.

For later versions of MySQL (v5.7+) turn off strict mode with:

SET @@global.sql_mode= '';

This will accomodate zero values in dates.

Re: Database connection issue

null@example.com (apmuthu) — Tue, 25 Jul 2017 11:57:59 +0000

Maybe it is time the array $db_connections in config_db.php now has a new element dbport implemented in create/edit/list new company and in the connect files.

Re: Database connection issue

null@example.com (Pkemoi Dickson) — Tue, 25 Jul 2017 10:07:33 +0000

You need to modify the string according to mysqli connections (for FA 2.4.1) string format, which is

mysqli_connect(host,username,password,dbname,port,socket);

So go to the "connect_db_mysqli.inc" file under
..\public_html\frontaccounting\includes\db\connect_db_mysqli.inc

Line 203

$db = mysqli_connect($connection["host"], $connection["dbuser"], $connection["dbpassword"]);

change to

$db = mysqli_connect($connection["host"], $connection["dbuser"], $connection["dbpassword"],NULL,3307);
Where 3307 is your mysql port.

Re: Database connection issue

null@example.com (chrisf) — Sat, 20 Jul 2013 18:17:14 +0000

Having rummaged around in the code, I found that the problem stemmed from the php function mysql_connect.
The solution was here: http://stackoverflow.com/questions/6366192/specifying-protocol-in-mysql-connect-php

If you specify your server and port as localhost:12345 the php will use a socket.
The fudgearound is to specify it as 127.0.0.1:12345 then php will use TCP/IP.

Excellent. FA's now up and running on my new server!

Database connection issue

null@example.com (chrisf) — Sat, 20 Jul 2013 17:33:50 +0000

I'm a new user so firstly I'd like to say what an excellent piece of software FrontAccounting is - Thanks to all contributors!

I've just moved to a new server and am struggling to get a connection to the mysql database. I've checked that the user and password are correct.

I can access the database from the command line but have to specify port and protocol so I use:
mysql -P 12345 -u user_name -p --protocol=tcp (where 12345 is the port number)

Is there any place I can specify the port number and protocol in the FA setup?