[asterisk-bugs] [JIRA] (ASTERISK-29360) Asterisk, Mysql, Odbc (Unknown column 'data' in 'field list')

[Maksim (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-29360?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=254309#comment-254309 ] 

Maksim commented on ASTERISK-29360:
-----------------------------------

Hi, George  

I create file cli.conf
and add lines:  
     [startup_commands]
     logger reload = yes


After restart full system, and dial to the queue and get same errors: 

   -- Executing [s at Gosub-INBOUND-ROUTES:11] Queue("SIP/268-22-30-00000000", "6901,rtTc,,,,,,,6901") in new stack
[2021-03-24 21:39:01] WARNING[16351][C-00000001]: res_odbc.c:538 ast_odbc_print_errors: SQL Prepare returned an error: 42S22: [MySQL][ODBC 5.2(w) Driver][mysqld-5.5.62]Unknown column 'data' in 'field list'
[2021-03-24 21:39:01] WARNING[16351][C-00000001]: res_config_odbc.c:122 custom_prepare: SQL Prepare failed! [INSERT INTO queuelog (time, data, event, agent, queuename, callid) VALUES (?, ?, ?, ?, ?, ?)]
       > 0x7f5a8c08ced0 -- Strict RTP learning complete - Locking on source address 10.200.24.55:31210
[2021-03-24 21:39:05] WARNING[16351][C-00000001]: res_odbc.c:538 ast_odbc_print_errors: SQL Prepare returned an error: 42S22: [MySQL][ODBC 5.2(w) Driver][mysqld-5.5.62]Unknown column 'data' in 'field list'
[2021-03-24 21:39:05] WARNING[16351][C-00000001]: res_config_odbc.c:122 custom_prepare: SQL Prepare failed! [INSERT INTO queuelog (time, data, event, agent, queuename, callid) VALUES (?, ?, ?, ?, ?, ?)]
  == Spawn extension (Gosub-INBOUND-ROUTES, s, 11) exited non-zero on 'SIP/268-22-30-00000000'



> Asterisk, Mysql, Odbc (Unknown column 'data' in 'field list')
> -------------------------------------------------------------
>
>                 Key: ASTERISK-29360
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-29360
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Core/Logging
>    Affects Versions: 16.15.1
>         Environment: CentOS Linux release 8.3.2011
> Your MySQL connection id is 108
> Server version: 5.5.62 MySQL Community Server (GPL)
>            Reporter: Maksim
>            Assignee: Maksim
>            Severity: Major
>
> Hi, 
> We use for logging queuelog events to mysql database use odbc driver.
> When first start asterisk and after started mysqlDB we have trouble with queuelog logging. 
> WARNING[1995]: res_odbc.c:538 ast_odbc_print_errors: SQL Prepare returned an error: 42S22: [MySQL][ODBC 8.0(w) Driver][mysqld-5.7.28-log]Unknown column 'data' in 'field list'
> WARNING[1995]: res_config_odbc.c:122 custom_prepare: SQL Prepare failed! [INSERT INTO queue_log (time, data, event, agent, queuename, callid) VALUES (?, ?, ?, ?, ?, ?)]  
> after I run command asterisk -rx "core reload" is temp fixed. 
> I try add that column data to my sql sheme: 
> ALTER TABLE queuelog ADD data varchar(40) COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER event;
> and I don't get error, but column data1, data2, data3, data4 is empty.
> Asterisk write all volumes to data fields like "|11-9873630826|11"
> after asterisk -rx "core reload"



--
This message was sent by Atlassian JIRA
(v6.2#6252)