Page 1 of 1

MySQL error log indicates some tiny changes needed

PostPosted: Tue Aug 09, 2011 10:05 pm
by williamconley
Kumba and all those with Vicibox on OpenSuSE. This is not a "required" change, but obviously doesn't hurt and helpful for the future. Easy, too.

Code: Select all
110809 22:21:49 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
110809 22:21:49 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
1


changed my.cnf:

Code: Select all
#110809 22:21:49 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
#skip-locking
skip-external-locking

and
Code: Select all
#110809 22:21:49 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
#log_slow_queries
slow_query_log
and the error disappeared.

PostPosted: Wed Aug 10, 2011 5:15 pm
by Kumba
I've put it on the list for ViciBox 4.0. As soon as Sangoma gets me updated drivers.

PostPosted: Wed Aug 10, 2011 9:19 pm
by williamconley
Also: have you considered invoking "logrotate" to manage the logs (removing the crontab entries and creating logrotate configuration entries instead)?

I bumped into that in another log error run. When mysql's root pass is created, logrotate loses the ability to hit sql ... so the configuration file must be given a user/pass ... and then I bumped into what logrotate does on opensuse. Very interesting.

Just write a "Rule" for each log file and it happens automagically. 8-)

PostPosted: Thu Aug 11, 2011 12:25 am
by DarknessBBB
Hello Kumba, what about these drivers?
http://www.vicidial.org/VICIDIALforum/v ... hp?t=19495