I’m getting an error and it appears it’s mistaking the field name for the value. I just updated to version 12.0.0 alpha1
res_config_mysql.c:631 update_mysql: MySQL RealTime: Failed to update database: Unknown column ‘sip:home_a580@192.168.1.121:5060’ in ‘field list’
How do I troubleshoot this? Where is the sql code generated for this? Do I need to update mysql tables? I’m not sure if fieldnames have changed or been added with this release.
I also want to mention this only happens when Registering and Unregistering peers.
It’s trying to update the status I guess in the table but the sql is wrong.
This is a real problem of Asterisk 12 (Beta2), RealTime cant update sipbuddies table when registering or updating friend:
[Dec 5 10:08:56] WARNING[1327]: res_config_mysql.c:631 update_mysql: MySQL RealTime: Failed to update database: Unknown column ‘sip:1002@192.168.1.111:5884;rinstance=6c4923182a1137f8’ in ‘field list’
it seems like error in sql query of RT, can it be resolved ?
You should expect this sort of thing in beta releases.
Note that realtime is community supported, so will not be fixed by the core developers.
the same error in stable version 12.0.0:
Connected to Asterisk 12.0.0 currently running on localhost (pid = 1337)
– Registered SIP ‘101’ at 192.168.1.25:5065
> Saved useragent “PJSUA v2.1 win32-5.1/i386/msvc-15.0” for peer 101
[Dec 22 08:49:05] WARNING[1776]: res_config_mysql.c:631 update_mysql: MySQL RealTime: Failed to update database: Unknown column ‘sip:101@192.168.1.25:5065;ob’ in 'field list’
localhost*CLI>
can You advise where i have to post this problem to be solved
Denis opened an issue on the issue tracker: https://issues.asterisk.org/jira/browse/ASTERISK-23177
A patch has been attached and if those with this issue could please test the patch and report back on the issue itself, it would be appreciated.
Thanks