MySQL connection fails - duplicate ports, tcp for socket

[petteyg359]

Freshly downloaded 0.8.7g, extracted it, changed nothing but settings.php for database config. PHP version is 5.3.4. I would like to use a socket to connect to the database, but not only is there no option for that, the TCP connection is impossible.

Something adds 3306, regardless of $database_port's setting. If I set it empty, or to 3306, or comment it out, I get 3306:3306 in the connection string. If I set it to anything else, I get anything else:3306 as the connection string.

Code: Select all

( ! ) Warning: mysqli_real_connect() [function.mysqli-real-connect]: [2002] Connection refused (trying to connect via tcp://localhost:3306:3306) in /home/cacti/cacti/lib/adodb/drivers/adodb-mysqli.inc.php on line 83
Call Stack
#	Time	Memory	Function	Location
1	0.0001	639584	{main}( )	../index.php:0
2	0.0003	670168	include( '/home/petteyg/cacti.foldspace.org/include/auth.php' )	../index.php:25
3	0.0007	743056	include( '/home/petteyg/cacti.foldspace.org/include/global.php' )	../auth.php:25
4	0.0195	3709064	db_connect_real( )	../global.php:197
5	0.0213	4082040	ADOConnection->PConnect( )	../database.php:48
6	0.0213	4082088	ADODB_mysqli->_pconnect( )	../adodb.inc.php:470
7	0.0213	4082136	ADODB_mysqli->_connect( )	../adodb-mysqli.inc.php:101
8	0.0214	4084488	mysqli_real_connect ( )	../adodb-mysqli.inc.php:83

[gandalf]

Freshly downloaded 0.8.7g, extracted it, changed nothing but settings.php for database config.

This should be include/config.php.
And yes, we use the default of 3306 e.g. in include/global.php in case that config.php was not found (some distros put it in a different location). I never heard about socket support for mysql in cacti. So I suspect it will not work, at least not without some testing and perhaps development work.
Contributions to this are welcome
R.

[petteyg359]

Yeah, meant config.php. Not going to turn on MySQL networking just for Cacti, though.

[gandalf]

So do you have any experience in using/implementing socket support?
R.

[TheWitness]

This makes no sense. Can you please post your config.php (sans passwords).

TheWitness

[Linegod]

My test box has run without network support (skip-networking) for at least a year. No issues.

Code: Select all

/* make sure these values refect your actual database/host/user/password */
$database_type = "mysql";
$database_default = "087svn";
$database_hostname = "localhost";
$database_username = "cactiuser";
$database_password = "xxxxxxxxxxxxxxxxxxxx";
$database_port = "3306";

/* Default session name - Session name must contain alpha characters */
#$cacti_session_name = "Cacti";

[petteyg359]

Code: Select all

$database_type = "mysqli";
$database_default = "cacti";
$database_hostname = "localhost";
$database_username = "cacti";
$database_password = "password";
$database_port = "";

If 3306 is in the config.php, I get the second 3306 as in my first post.

Code: Select all

( ! ) Warning: mysqli_real_connect() [function.mysqli-real-connect]: [2002] Connection refused (trying to connect via tcp://localhost::3306) in /home/petteyg/cacti.foldspace.org/lib/adodb/drivers/adodb-mysqli.inc.php on line 83
Call Stack
#	Time	Memory	Function	Location
1	0.0001	640848	{main}( )	../index.php:0
2	0.0004	671432	include( '/home/petteyg/cacti.foldspace.org/include/auth.php' )	../index.php:25
3	0.0007	744320	include( '/home/petteyg/cacti.foldspace.org/include/global.php' )	../auth.php:25
4	0.0197	3710072	db_connect_real( )	../global.php:197
5	0.0214	4083064	ADOConnection->PConnect( )	../database.php:48
6	0.0214	4083112	ADODB_mysqli->_pconnect( )	../adodb.inc.php:470
7	0.0214	4083160	ADODB_mysqli->_connect( )	../adodb-mysqli.inc.php:101
8	0.0214	4085512	mysqli_real_connect ( )	../adodb-mysqli.inc.php:83
Dump $_SERVER
Dump $_GET
Dump $_POST
Dump $_COOKIE
Dump $_FILES
Dump $_ENV
Dump $_SESSION
Dump $_REQUEST

So do you have any experience in using/implementing socket support?
R.

Yeah. Use a database layer that isn't insane :) However, ADO is PHP, and PHP itself has no problems with mysql(i) and socket connections, so I'm not sure where the problem actually is.