search for: res_config_mysql

Displaying 20 results from an estimated 177 matches for "res_config_mysql".

2007 May 23
0
Problems compiling res_config_mysql (asterisk addons)
Hello All: I'm having some difficutly getting res_config_mysql from the 1.4.1 addons package to compile ( I need it for Realtime) First of all, when I make everything appears to compile ok with no errors however the res_config_mysql doesn't get compiled. So I tried "make res_config_mysql" and a whackload of errors starting with the following...
2005 Feb 02
6
problem in compiling asterisk-addons
there is a problem in compiling asterisk-addons any one have fixed this problem. i want res_config_mysql.so any one help me ----------------------------------------------------- [root@localhost asterisk-addons]# make cc -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/include/mysql -c -o res_config_mysql.o res_config_mysql.c res_config_mysql.c: In function `realtime_mysql': res_config_mysql.c:142: w...
2007 Jan 24
1
Query Failed because: Incorrect information in file: './asterisk/sip.frm'
Hi, I have a working asterisk 1.4.0 with Mysql Realtime configuration, and today I encountered this error. Now, I have no acces to any information in mysql realtime, so nothing work now !!!!! [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: Everything is fine. [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM extensions WHERE exten = 'h' AND context = ' interne' AND priority = '1' [Jan 24 10:32:40] DEBUG[31070] res_config_mysql.c: MySQL RealTime...
2004 Dec 03
1
compiling asterisk-addons for Mysql-cdr
Hi ALL; I got the latest Asterisk-addons for Mysql-Cdr, but I have problem compiling that.It says: # make ..... ........ res_config_mysql.c: In function `realtime_mysql': res_config_mysql.c:143: warning: passing arg 1 of `ast_strlen_zero' makes pointer from integer without a cast res_config_mysql.c: In function `realtime_multi_mysql': res_config_mysql.c:242: warning: passing arg 1 of `ast_strlen_zero' makes pointer fr...
2005 Jan 30
1
Slackware + Asterisk + asterisk-addons
Hello I am trying to get asterisk-addons installed so that I can use the mysql cdr feature. OK, I have the MySQL server (mysqld) installed, but I noticed that mysql-devel is also required. I tried to compile asterisk-addons and got a: --CUT--- res_config_mysql.c:422: error: unknown field `realtime_multi_func' specified in initializer res_config_mysql.c:422: warning: excess elements in struct initializer res_config_mysql.c:422: warning: (near initialization for `mysql_engine') res_config_mysql.c:423: error: unknown field `update_func' specifie...
2005 Mar 18
2
Asterisk 1.0.7 Released
Hello everyone, Version 1.0.7 of Asterisk, Zaptel, libpri, and Asterisk-addons has now been released. Libpri and -addons have not changed, but have been updated anyway to keep the version numbers consistent. All of the tarballs are available on the ftp site. ftp://ftp.asterisk.org/pub/asterisk/ I have posted the ChangeLogs for easy viewing at the following address.
2007 Nov 20
1
Realtime - mysql query gives wrong results??
Hi, I am using Realtime for sip configuration. When there is an INVITE which arrives at asterisk asterisk makes the following selects: Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: Everything is fine. [Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_conf WHERE name = 'tzl' [Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: E...
2005 Jan 26
2
Issue with res_config_mysql.so in latest CVS
Hello, I just checked out the latest CVS and compiled and now get the following error: [res_config_mysql.so] => (MySQL RealTime Configuration Driver) Jan 26 13:03:51 WARNING[27081]: config_old.c:27 ast_load: ast_load is deprecated, use ast_config_load instead! == Parsing '/etc/asterisk/res_mysql.conf': Found Jan 26 13:03:51 WARNING[27081]: res_config_mysql.c:561 parse_config: MySQL RealTi...
2013 Jun 03
2
Difference MySQL between 1.6.x and 11.4.x
Hi i have installed a new Asterisk server on Fedora. My first server use Asterisk 1.6.x with a MySQL CDR and realtime. I have a small problems, when i configure on the new server, the same information in MySQL, we have a error: [Jun 3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime: Failed to connect database server SSI on myhost.myserver.com (err 2003). Check debug for more info. [Jun 3 16:27:59] WARNING[3140] res_config_mysql.c: Table VoiceMail not found in database. This table should exist if you're using realtime. [Jun 3 16:27:59] ERROR[3140] cdr_...
2007 Nov 19
3
How to enable res_config_mysql
Hi, I was trying to compiles addons 1.4 and res_config_mysql doesn't compile. is res_config_mysql still supported and is it still posible to use mysql with asterisk RealTime?? Bests Tomasz
2009 Aug 24
1
problem on compiling asterisk-addons-1.6.2.0-rc1
hello, I tried to compil asterisk-addons-1.6.2.0-rc1, and I have that error: [CC] res_config_mysql.c -> res_config_mysql.o res_config_mysql.c:1367: error: unknown field ?update2_func? specified in initializer res_config_mysql.c: In function ?parse_config?: res_config_mysql.c:1432: error: ?CONFIG_STATUS_FILEMISSING? undeclared (first use in this function) res_config_mysql.c:1432: error: (Each...
2016 Sep 12
4
Mysql PJSIP realtime > 13.10?
Has anyone successfully used Mysql realtime PJSIP with Asterisk 13.11? I have tried 13.11, 13.11.1 and 13.11.2 but I always get the following error now: Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general at ps_contacts: column 'qualify_timeout' cannot be type 'int(10)' (need char) [Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general at ps_contacts: column 'expiration_time' cannot be t...
2008 Jan 31
0
Realtime device update weirdness
Hello, We use Asterisk Realtime for our billing software. 200+ installations of Asterisk with Realtime, but I see this for the first time. Asterisk 1.4.17, Addons 1.4.5, No patches, no NAT - just plain simple installation. With debug I can see: [Jan 30 22:38:21] DEBUG[27885]: res_config_mysql.c:662 mysql_reconnect: MySQL RealTime: Everything is fine. [Jan 30 22:38:21] DEBUG[27885]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM devices WHERE name = '109' AND host = 'dynamic' [Jan 30 22:38:21] DEBUG[27917]: res_config_mysql.c:662 mysql_...
2016 Sep 12
3
Mysql PJSIP realtime > 13.10?
...rlos Chavez <cursor at telecomabmex.com> > wrote: > >> Has anyone successfully used Mysql realtime PJSIP with Asterisk >> 13.11? I have tried 13.11, 13.11.1 and 13.11.2 but I always get the >> following error now: >> >> Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: >> Realtime table general at ps_contacts: column 'qualify_timeout' cannot be >> type 'int(10)' (need char) >> [Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: >> Realtime table general at ps_contacts: column '...
2016 Sep 12
2
Mysql PJSIP realtime > 13.10?
...lecomabmex.com> >> wrote: >> >>> Has anyone successfully used Mysql realtime PJSIP with Asterisk >>> 13.11? I have tried 13.11, 13.11.1 and 13.11.2 but I always get the >>> following error now: >>> >>> Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: >>> Realtime table general at ps_contacts: column 'qualify_timeout' cannot be >>> type 'int(10)' (need char) >>> [Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: >>> Realtime table general at ps_contac...
2015 Jul 06
4
CDR in an MySQL-Database
...KEY `dst` (`dst`), KEY `src` (`src`), KEY `dcontext` (`dcontext`), KEY `clid` (`clid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ; Then I restarted Asterisk (core restart now). Unfortunately it does not work, since I get on boot: [Jul 6 21:20:39] WARNING[9735]: res_config_mysql.c:1468 load_mysql_config: MySQL RealTime: No database user found, using 'asterisk' as default. [Jul 6 21:20:39] WARNING[9735]: res_config_mysql.c:1474 load_mysql_config: MySQL RealTime: No database password found, using 'asterisk' as default. [Jul 6 21:20:39] WARNING[9735]: res_co...
2004 Nov 30
1
realTime configuration help needed
...he DB from mySQL-logs, I can't seem to get anything else.... How can I get my configuration from the DB ? Am I doing something worng ? My traces are bellow.. Thanx in advance, for any help, George Konstantoulakis. ------------------------------------------ When I start with vvvcd I get : [res_config_mysql.so] => (MySQL RealTime Configuration Driver) Nov 30 12:44:21 DEBUG[3088]: config.c:517 __ast_load: Parsing /home/gkon/slash/etc/asterisk/res_mysql.conf Nov 30 12:44:21 WARNING[3088]: res_config_mysql.c:413 parse_config: MySQL RealTime: No database port found, using 3306 as default. Nov 30 12:4...
2018 Oct 04
3
Spontaneous reboot due to MySQL lookups ?
...namic Loader Starting: [Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22 15:19:18]   == Parsing '/etc/asterisk/modules.conf': [Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22 15:19:18]   == Found [Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22 15:19:18]   == Parsing '/etc/asterisk/res_config_mysql.conf': [Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22 15:19:18]   == Found [Aug 22 15:19:18] VERBOSE[3306] res_config_mysql.c: [Aug 22 15:19:18]   == MySQL RealTime driver loaded. [Aug 22 15:19:18] VERBOSE[3306] loader.c: [Aug 22 15:19:18] res_config_mysql.so => (MySQL RealTime Configu...
2016 Sep 02
2
Asterisk 13.11 realtime problem registering phones
I upgraded my office installation from 13.10 to 13.11 yesterday and now I am having problems registering phones. Here is what I get on the CLI: [Sep 2 15:38:46] WARNING[2098]: res_config_mysql.c:1162 require_mysql: Realtime table general at ps_contacts: column 'qualify_timeout' cannot be type 'int(10)' (need char) [Sep 2 15:38:46] WARNING[2098]: res_config_mysql.c:1162 require_mysql: Realtime table general at ps_contacts: column 'expiration_time' cannot be ty...
2007 Jan 02
4
asterisk and mysql
Dear All, I' I have a problem in installing asterisk 1.4.0. how can i compile res_config_mysql.c in astersisk-addons dir. I've downloaded asterisk-addons-1.4.0 compiling and installing it. But i can't found shared object of res_config_mysql.so. My system is : Debian Linux 3.1 Kernel 2.6.8-11 asterisk-1.4.0 zaptel-1.4.0 asterisk-addons-1.4.0 libmysqlclient using apt-get webserver...