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...