Prosody error log to connect to MySQL but user authenticate successfull


#1

Hi @damencho,
My prosody have some error with connect MySQL,
Can you review it and give me how can i fix it?

THanks,

Nov 21 16:37:45 boshfab298c0-3a0f-4a90-953f-5de5889fb19b info Authenticated as 25b665a8-b3f8-4b17-8f08-c65e4ec0b2fe@guest.vc1.covavi.vn
Nov 21 16:37:46 sql error Error in SQL transaction: /usr/lib/prosody/util/sql.lua:167: Error preparing statement handle: MySQL server has gone away
stack traceback:
/usr/lib/prosody/util/sql.lua:167: in function ‘select’
/usr/lib/prosody/modules/mod_storage_sql.lua:60: in function </usr/lib/prosody/modules/mod_storage_sql.lua:57>
(tail call): ?
[C]: in function ‘xpcall’
/usr/lib/prosody/util/sql.lua:220: in function ‘_transaction’
/usr/lib/prosody/util/sql.lua:234: in function ‘transaction’
/usr/lib/prosody/modules/mod_storage_sql.lua:103: in function ‘get’
/usr/lib/prosody/core/rostermanager.lua:112: in function ‘rm_load_roster’
/usr/lib/prosody/core/sessionmanager.lua:185: in function ‘sm_bind_resource’
/usr/lib/prosody/modules/mod_saslauth.lua:293: in function ‘?’
/usr/lib/prosody/util/events.lua:78: in function </usr/lib/prosody/util/events.lua:74>
(tail call): ?
/usr/lib/prosody/core/stanza_router.lua:149: in function ‘dispatch_stanza’
/usr/lib/prosody/modules/mod_bosh.lua:322: in function ‘func’
/usr/lib/prosody/util/async.lua:90: in function </usr/lib/prosody/util/async.lua:88>
Nov 21 16:37:54 mod_bosh info New BOSH session, assigned it sid ‘8cbc15e4-b00b-4093-8794-8607e942f9db’
Nov 21 16:37:55 bosh8cbc15e4-b00b-4093-8794-8607e942f9db info Authenticated as quyetnc@vc1.covavi.vn
Nov 21 16:37:55 sql error Error in SQL transaction: /usr/lib/prosody/util/sql.lua:167: Error preparing statement handle: MySQL server has gone away
stack traceback:
/usr/lib/prosody/util/sql.lua:167: in function ‘select’
/usr/lib/prosody/modules/mod_storage_sql.lua:60: in function </usr/lib/prosody/modules/mod_storage_sql.lua:57>
(tail call): ?
[C]: in function ‘xpcall’
/usr/lib/prosody/util/sql.lua:220: in function ‘_transaction’
/usr/lib/prosody/util/sql.lua:234: in function ‘transaction’
/usr/lib/prosody/modules/mod_storage_sql.lua:103: in function ‘get’
/usr/lib/prosody/modules/muc/mod_muc.lua:138: in function </usr/lib/prosody/modules/muc/mod_muc.lua:136>
(tail call): ?
/usr/lib/prosody/modules/muc/mod_muc.lua:287: in function ‘?’
/usr/lib/prosody/util/events.lua:78: in function </usr/lib/prosody/util/events.lua:74>
(tail call): ?
/usr/lib/prosody/core/stanza_router.lua:187: in function ‘core_post_stanza’
/usr/lib/prosody/core/stanza_router.lua:135: in function ‘core_process_stanza’
/usr/lib/prosody/modules/mod_c2s.lua:254: in function ‘func’
/usr/lib/prosody/util/async.lua:90: in function </usr/lib/prosody/util/async.lua:88>
Nov 21 16:37:56 bosh8cbc15e4-b00b-4093-8794-8607e942f9db info BOSH client disconnected
Nov 21 16:39:40 boshfab298c0-3a0f-4a90-953f-5de5889fb19b info BOSH client disconnected


#2

No idea, sorry. I had never used prosody with mysql, but looking at the error message “Error preparing statement handle: MySQL server has gone away” you need to check mysql, did it crash or it has some error …


#4

Thank @damencho for reply.