BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => AO 0.6 support => Topic started by: Equinox on June 23, 2009, 04:07:47 pm

Title: Mysql Error
Post by: Equinox on June 23, 2009, 04:07:47 pm

Hi,

i installed Mysql Server on an Debian System and createt a Database.
than i added this Database and User in the mysql.conf of the Bot and startet the bot.
After 30Minutes the BeBot goes down and if i want to restart comes this

Quote

MySQL error (# 0) on query: UPDATE online SET reinvite = '0' WHERE botname = 'helferlein' AND status_pg = '0'
MySQL server has gone away
MySQL error (# 0) on query: Database not found or insufficient priviledges!
MySQL server has gone away
MySQL error (# 0) on query: SELECT * FROM helferlein_string_filter
MySQL server has gone away
MySQL error (# 0) on query: Database not found or insufficient priviledges!
MySQL server has gone away
MySQL error (# 0) on query: SELECT alias, nickname, main FROM alias
MySQL server has gone away
helferlein [SETTINGS]   [ERROR] The setting named notify_delay for setting group logon_notifies does not exisit.
MySQL error (# 0) on query: Database not found or insufficient priviledges!
MySQL server has gone away
MySQL error (# 0) on query: UPDATE helferlein_raid_points SET raiding = 0
MySQL server has gone away
helferlein [SETTINGS]   [ERROR] The setting named autoinvite for setting group relay does not exisit.
helferlein [SETTINGS]   [ERROR] The setting named reconnect for setting group irc does not exisit.
..
..
..
..
MySQL error (# 0) on query: SELECT * FROM craftingclass WHERE name = 'Azucai'
MySQL server has gone away
MySQL error (# 0) on query: Database not found or insufficient priviledges!
MySQL server has gone away
MySQL error (# 0) on query: INSERT INTO whois (id, nickname, level, class, craft1, craft2, location, online, updated) VALUES ('117527405', 'Azucai', '80', 'Demonologist', '', '', 1025254, 1, '1245768554') ON DUPLICATE KEY UPDATE id = VALUES(id), level = VALUES(level), class = VALUES(class), craft1 = VALUES(craft1), craft2 = VALUES(craft2), online = VALUES(online), location = VALUES(location),  updated = VALUES(updated)
MySQL server has gone away
helferlein [SETTINGS]   [ERROR] The setting named usealts for setting group security does not exisit.
helferlein [SETTINGS]   [ERROR] The setting named guestinchannel for setting group security does not exisit.
MySQL error (# 0) on query: Database not found or insufficient priviledges!
MySQL server has gone away
MySQL error (# 0) on query: SELECT char_id FROM helferlein_users WHERE nickname = 'Azucai'
MySQL server has gone away
helferlein [SETTINGS]   [ERROR] The setting named usealts for setting group security does not exisit.
..
..
..
..

the bot restarts and the same

Title: Re: Mysql Error
Post by: Glarawyn on June 23, 2009, 11:03:09 pm

Did you install any Debian updates via apt-get? Debian's package system will automatically restart MySQL for you if it's required.

BeBot doesn't close the lost MySQL connection and start a new one, only restarting the bot does that.

Make sure MySQL is running (/etc/init.d/mysql restart) then restart the bot.