Welcome to the new forum!
Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
/var/log/asterisk/full:[Nov 3 13:37:57] VERBOSE[25801] config.c: == Binding queue_log to mysql/general/queue_log
/var/log/asterisk/full:[Nov 3 13:37:57] WARNING[25801] res_config_mysql.c: Realtime table general@queue_log: column 'time' cannot be type 'int(10) unsigned' (need char)
CREATE TABLE `queue_log` (
`id` int(10) unsigned NOT NULL auto_increment,
`time` varchar(30) NOT NULL default '',
`callid` varchar(32) NOT NULL default '',
`queuename` varchar(32) NOT NULL default '',
`agent` varchar(32) NOT NULL default '',
`event` varchar(32) NOT NULL default '',
`data` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
);mysql> use asterisk;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select * from queue_log;
+----+------------+------------------+-----------+------------------------+----------------+----------+
| id | time | callid | queuename | agent | event | data |
+----+------------+------------------+-----------+------------------------+----------------+----------+
| 1 | 1288362313 | NONE | NONE | NONE | CONFIGRELOAD | |
| 2 | 1288362334 | 1288362186.10990 | 400 | Local/127@from-queue/n | COMPLETECALLER | 11|132|2 |
+----+------------+------------------+-----------+------------------------+----------------+----------+
2 rows in set (0.01 sec)
mysql> ALTER TABLE `queue_log` CHANGE `time` `time` VARCHAR( 30 ) NOT NULL;
Query OK, 2 rows affected (0.03 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> select * from queue_log;
+----+------------+------------------+-----------+------------------------+----------------+----------+
| id | time | callid | queuename | agent | event | data |
+----+------------+------------------+-----------+------------------------+----------------+----------+
| 1 | 1288362313 | NONE | NONE | NONE | CONFIGRELOAD | |
| 2 | 1288362334 | 1288362186.10990 | 400 | Local/127@from-queue/n | COMPLETECALLER | 11|132|2 |
+----+------------+------------------+-----------+------------------------+----------------+----------+
2 rows in set (0.00 sec)
[Oct 29 10:25:34] WARNING[9853] res_config_mysql.c: Realtime table general@queue_log: column 'time' cannot be type 'int(10) unsigned' (need char)`time` int(10) unsigned default NULL,16:23.41 cusco__ hi
16:23.43 cusco__ "require_mysql: Realtime table general@csr_queue: column 'time' cannot be type 'int(10) unsigned' (need char)"
16:23.48 cusco__ what type must it be?
16:25.44 cusco__ type char
16:25.45 cusco__ ok
16:25.46 cusco__ lolvox*CLI> core show config mappings
Config Engine: pgsql
Config Engine: odbc
Config Engine: mysql
Config Engine: curlvox*CLI> module show like mysql
Module Description Use Count
app_cbmysql.so CBMysql conference scheduling 0
res_config_mysql.so MySQL RealTime Configuration Driver 0
app_addon_sql_mysql.so Simple Mysql Interface 0
cdr_addon_mysql.so MySQL CDR Backend 0
4 modules loaded[Oct 29 10:17:22] VERBOSE[9785] config.c: == Binding queue_log to mysql/asterisk/queue_log
[Oct 29 10:17:22] WARNING[9785] res_config_mysql.c: MySQL RealTime: Invalid database specified: 'asterisk' (check res_mysql.conf[Oct 26 17:07:50] WARNING[25195] config.c: Realtime mapping for 'queue_log' found to engine 'mysql', but the engine is not available[Oct 26 17:47:41] VERBOSE[12854] config.c: == Binding queue_log to mysql/asterisk/queue_log
[Oct 26 17:47:41] WARNING[12854] res_config_mysql.c: MySQL RealTime: Invalid database specified: 'asterisk' (check res_mysql.conf)
;
; Sample configuration for res_config_mysql.c
;
; The value of dbhost may be either a hostname or an IP address.
; If dbhost is commented out or the string "localhost", a connection
; to the local host is assumed and dbsock is used instead of TCP/IP
; to connect to the server.
;
; Modified "dbname" to "asterisk" from "asteriskrealtime" as part of enabling
; realtime storage of queue_log. - Tom Rymes 10-26-10
[general]
dbhost = 127.0.0.1
dbname = asterisk
dbuser = asteriskuser
dbpass = eLaStIx.asteriskuser.2oo7
;dbport = 3306
;dbsock = /var/lib/mysql/mysql.sock
[root@vox ~]# mysql -u asteriskuser -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2293
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use asterisk;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select * from queue_log;
Empty set (0.00 sec)
mysql>
So, I am stumped here. Going to switch back to the old method until someone can point me in the right direction....[Oct 25 14:48:43] VERBOSE[28356] config.c: == Binding queue_log to mysql/asterisk/queue_log
[Oct 25 14:48:43] WARNING[28356] res_config_mysql.c: MySQL RealTime: Invalid database specified: 'asterisk' (check res_mysql.conf)
[Oct 25 14:48:43] VERBOSE[28356] logger.c: Asterisk Queue Logger restarted
[;
; Sample configuration for res_config_mysql.c
;
; The value of dbhost may be either a hostname or an IP address.
; If dbhost is commented out or the string "localhost", a connection
; to the local host is assumed and dbsock is used instead of TCP/IP
; to connect to the server.
;
[general]
dbhost = 127.0.0.1
dbname = asteriskrealtime
dbuser = asteriskuser
dbpass = eLaStIx.asteriskuser.2oo7
;dbport = 3306
;dbsock = /tmp/mysql.sock
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| asterisk |
| asteriskcdrdb |
| meetme |
| mya2billing |
| mysql |
| queuemetrics |
| roundcubedb |
| test |
| vtigercrm510 |
+--------------------+
10 rows in set (0.01 sec)