MySQL error log indicates some tiny changes needed

[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.

[Kumba]

I've put it on the list for ViciBox 4.0. As soon as Sangoma gets me updated drivers.

[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.

[DarknessBBB]

Hello Kumba, what about these drivers?
http://www.vicidial.org/VICIDIALforum/v ... hp?t=19495