CSF stats connection fails with 'password'

This forum is only for reproducible bugs with csf and lfd (i.e. not iptables problems, lack of understanding how to use a feature, etc). Posts must be accompanied with full technical details of the problem and how it can be recreated. Any posts not adhering to this, or not considered bugs, will be moved to the General Discussion (csf) forum.
Post Reply
jimlongo
Junior Member
Posts: 19
Joined: 19 Oct 2013, 00:33

CSF stats connection fails with 'password'

Post by jimlongo »

Due to repeated warnings from mysql.err and mysqltuner I had changed 'pass' to 'password' in /root/.my.cnf

Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead.

Changing to 'password' will stop those warnings.

If CSF configuration for MYSQL Stats collection is set as follows and .my.cnf has only 'password' then the connection will fail.

Code: Select all

ST_MYSQL =  1
ST_MYSQL_USER = root
ST_MYSQL_PASS = 
ST_MYSQL_HOST = localhost
So you need to have 'pass' set in .my.cnf for CSF to connect in this way, however if 'pass' is present you get the warnings.

Note: I have mentioned this to cPanel since WHM>SQL Services>Change MYSQL USer Password generates 'pass' not 'password'


Thanks,
jim
ForumAdmin
Moderator
Posts: 1523
Joined: 01 Oct 2008, 09:24

Re: CSF stats connection fails with 'password'

Post by ForumAdmin »

This should now be fixed in v6.37:
http://blog.configserver.com/?p=2085
jimlongo
Junior Member
Posts: 19
Joined: 19 Oct 2013, 00:33

Re: CSF stats connection fails with 'password'

Post by jimlongo »

Confirmed.
Thanks for a great product.
Post Reply