[vlad]

amxx mysql module doesn't work with a custom port

When i use 3306 i have no error.

Any other port just give me

[MySQL] DB Connection failed(2005): Unknown MySQL Server Host 'localhost:9506' (1)

tried it with mysql 4.0 / 4.1, same result

did i miss some variable in sql.ini to define my port ??

anybody an idea ??

tia

[f1del1ty.oXi]

Show us your sql.cfg file

And if it works for 3306, then why are you using another port?

[vlad]

// SQL configuration file
// File location: $moddir/addons/amxx/configs/sql.cfg

// *NOTE* Linux users may encounter problems if they specify "localhost" instead of "127.0.0.1"
// We recommend using your server IP address instead of its name

amx_sql_host    "localhost:9506"
amx_sql_user    "vlad"
amx_sql_pass    "*******"
amx_sql_db      "amx"
amx_sql_table   "admins"

because my mysql server runs on port 9506 for other purposes

btw it should be working according to this thread

[f1del1ty.oXi]

Can you connect to it by command line and or a GUI? (PHPMyadmin or MySQL Command Center)??

Have you also tried 127.0.0.1, just to be safe?

[vlad]

mysql is working fine with phpmyadmin and other stuff

also tried 127.0.0.1 same problem connection failed

[L1nuxm4ster]

You really don't need to specify the port when you are using localhost. You may have to edit the /etc/hosts file and make sure that it has an entry for localhost. The entry should be something like this:

127.0.0.1 localhost.localdomain localhost

Let me know if this works for you.