dbConnect failled; Could not connect

[Banex]

I am unable to connect to my database, i enabled remote access on my host, yet i keep getting this error.

I'm using Linux - Debian 8 64Bit

[LabiVila]

The code maybe?

[Banex]

local data = Database.getDetails() 
    self.connection = dbConnect("mysql",format('dbname={1};host={2};port={3}',data.Name,data.Host,data.Port),data.User,data.Password,"share=1") 

[JR10]

Sometimes the unix_socket might be the problem. What exactly is the error?

[Banex]

this is the error: http://i.imgur.com/461AwRo.png

i believe that the problem is not with the script, because i wore it a few months ago on another VPS.

[Banex]

I really do not know what to do.

In wiki says that i must have installed the libmysqlclient.so.16. I have it installed, but the problem persists. I tried to connect to another database to another host, but also i did not have success.

I reinstalled the operating system for Debian 7 - 64bits in last hope, but to no avail at all.

[JR10]

Try debugging the dbConnect parameters. Try checking for problems from the MySQL server itself.

[LabiVila]

Are you sure your modules are rightly placed? Try doing /loadmodule mta_mysql.dll or mta_mysql.so for linux and tell us what you get

[JR10]

He's not using modules, he's using MTA's db* functions.

[LabiVila]

Funny how I got exactly the same problem, yet can't seem to find the solution

[xeon17]

Make sure that you've installed the libmysqlclient.so which you need to run MySQL on a Linux OS.

[ixjf]

If he didn't have it installed, the server wouldn't even run since it statically links to libmysqlclient.

[xeon17]

If he didn't have it installed, the server wouldn't even run since it statically links to libmysqlclient.

If i remember well, i had the same error before when i haven't installed it. The server runs fine though.