Displaying 20 results from an estimated 800 matches similar to: "Upgrade from 1.4 to 1.6 : problems with realtimemysql"
2010 Sep 08
1
Upgrade from 1.4 to 1.6 : problems with realtime mysql
Hello,
in asterisk 1.4.30 all realtime configurations go well.
In asterisk 1.6.2.11 the following appears on CLI :
[Sep 8 16:43:43] WARNING[1843]: res_config_mysql.c:325 realtime_mysql:
MySQL RealTime: Invalid database specified: MyDBase (check res_mysql.conf)
[Sep 8 16:43:43] WARNING[1843]: res_config_mysql.c:325 realtime_mysql:
MySQL RealTime: Invalid database specified: MyDBase (check
2010 Jan 25
1
MySQL RealTime Error
hi,all
when i upgrade from 1.4.28 to 1.6.2.1, i can't connect to mysql
database anymore, error as follow:
[Jan 25 15:38:25] WARNING[3003]: res_config_mysql.c:325
realtime_mysql: MySQL RealTime: Invalid database specified: asterisk
(check res_mysql.conf)
the content of res_mysql.conf is:
http://www.pastebin.org/81966
i've try command " mysql -uroot -proot" ,i can connect to
2015 May 22
1
Problem with realtime mysql I can't seem to resolve
Hello
I have already several Asterisk servers running with similar
configuration, but now I stumble into a problem.
I have mysql configuration res_config_mysql.conf :
[MyAsteriskDB]
dbhost = 127.0.0.1
dbname = MyAsteriskDB
dbuser = astadmin
dbpass = mysecret
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock
requirements=warn ; or createclose or createchar
Realtime seems to be loaded :
2005 Jan 13
1
asterisk realtime msql
Hi there
asterisk goes to 90% cpu usage when trying to authenticate a sip friend using realtime mysql, no other message does appear at cli and asterisk hungs;
here some info:
*CLI> realtime load sipfriends name 104
Jan 13 11:52:21 DEBUG[8928]: res_config_mysql.c:109 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sipfriends WHERE name = '104'
Jan 13 11:52:21 DEBUG[8928]:
2011 May 18
1
asterisk18 - realtime/mysql - take 3
Still a couple of questions......
I did configure extconfig.conf
...
;iaxusers => odbc,asterisk
;iaxpeers => odbc,asterisk
;sipusers => odbc,asterisk
sipusers => mysql,asterisk,sip_devices
sippeers => mysql,asterisk,sip_devices
;sippeers => odbc,asterisk
;sipregs => odbc,asterisk
;voicemail => odbc,asterisk
;extensions => odbc,asterisk
;meetme => mysql,general
2007 Mar 26
0
Asterisk 1.4 Realtime problems
Hi all,
I have recently installed asterisk 1.4.1 and asterisk-addons (1.4).
I have configured the extconfig.conf file and mapped sippeers to mysql
as such;
sippeers => mysql,asterisk,sip_buddies
I have created the sip_buddies table and checked that we can login to
the mysql db from the command prompt.
I have also copied the res_mysql.conf.sample file as res_mysql.conf to
the
2007 May 23
1
Asterisk Realtime problem
Hi,
I have installed asterisk-1.4.4 and asterisk-addon-1.4.1.
I followed every step to configure RealTime but something is not working
properly; the warning that I am geting is:
WARNING[32709]: config.c:1229 find_engine: Realtime mapping for
'sippeers' found to engine 'mysql', but the engine is not available
WARNING[1359]: config.c:1229 find_engine: Realtime mapping for
2006 Feb 23
1
mysql problems
My database machine is broken and I have to use another one.
I made somewhere mistake(s) and get now in the debug file:
[Feb 24 09:05:24] DEBUG[32664]: MySQL RealTime: Query: SELECT * FROM
sip_buddies WHERE name = '886'
[Feb 24 09:05:24] DEBUG[32664]: MySQL RealTime: Query Failed because:
Can't find file: './astconf/sip_buddies.frm' (errno: 13)
[Feb 24 09:05:25]
2010 Feb 22
2
Problems with SIP realtime
I have followed the instructions on voip-info.org for Realtime SIP
peers, but I get this notice :
[Feb 22 20:05:32] NOTICE[15298]: chan_sip.c:15889
handle_request_register: Registration from
'<sip:testsip at 192.168.1.150;transport=UDP>' failed for '192.168.1.105' -
No matching peer found
The CLI shows :
[Feb 22 19:58:23] == Parsing
2011 May 19
2
[Fwd: FW: realtime mysql - p4]
Ok, i tried the suggestion:
Instead of:
sippuser => resource, database_name, table_name
sippeer => resource, database_name, table_name
I put in:
sippuser => resource, context, table_name
sippeer => resource, context, table_name
Unfortunately, with the same results.
btw i tried both "general" as "default"
Besids the commands i tried below, isn't there any
2006 May 14
1
Getting Realtime running (1.2.7.1)
I've got my res_mysql.conf stating:
[general]
dbhost = 127.0.0.1
dbname = switchref
dbuser = asteriskuser
dbpass = xxxxxxx
dbport = 3306
and my extconfig.conf stating:
sipusers => mysql,switchref,sip_buddies
sippeers => mysql,switchref,sip_buddies
When Asterisk starts, and I show peers and show users, I don't see anything
that is in the database. When looking at the traffic
2008 Mar 07
3
Asterisk Realtime and SIP configuration
Dear all
I'm writing to the list for help as a last resort. I've exhausted all
other options, so please forgive me. I've lurked here for years but
never actually posted.
I'm trying to get Asterisk Realtime SIP configuration working, but it
refuses to do so. I have all the necessary configuration in place,
Asterisk makes a connection to the database, which can be verified with
2005 Aug 24
2
RealTime ignoringswitch=>Realtime/context@re altime_ext
Thanks John, You are my savior. This is such a great relief. Apparently
realtime will not use either '127.0.0.1' or 'localhost' to connect to the
database. I had to use the actual IP address attached to the NIC before it
worked.
My OS is Debian just a note and Asterisk HEAD from August 20, 2005
Details below for those who might be swimming in the same pool with me.
2005 Mar 23
0
Asterisk Realtime.
So this is what i've done so far...
my extconfig.conf looks like this
[settings]
;example => odbc,asterisk,alttable
;iaxusers => odbc,asterisk
;iaxpeers => odbc,asterisk
sipusers => mysql,voip,sip
sippeers => mysql,voip,sip
voicemail => mysql,voip,voicemail
extensions => mysql,voip,extensions
--------------------
and my extensions.conf has the following lines in it.
2005 Mar 24
1
realtime - unable to find key
ok so my table looks like this...
REATE TABLE `sip` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(80) NOT NULL default '',
`accountcode` varchar(20) default NULL,
`amaflags` varchar(7) default NULL,
`callgroup` varchar(10) default NULL,
`callerid` varchar(80) default NULL,
`canreinvite` char(3) default 'yes',
`context` varchar(80) default NULL,
`defaultip`
2007 Aug 20
4
Realtime Queue Members
Does anybody have realtime queue members working? Not the queues
themselves, just the members. I have realtime working for voicemail and
sippeers, but I can't get queue members to work. Here is what I have:
res_mysql.conf:
[general]
dbhost = 127.0.0.1
dbname = ASTERISK
dbuser = myuser
dbpass = mypass
dbport = 3306
dbsock = /tmp/mysql.sock
queues.conf:
[general]
2008 May 26
0
realtime problem with two Asterisk servers
Hi all,
I have a problem with using remote MySQL database server with two Asterisk (1.4.17) servers. PhoneA registers with Asterisk#1 using realtime into MySQL on remote server and everything is working fine and when I call Phone A from Phone B (also registered with Asterisk#1) call is established. Problem is when I call PhoneA
(which is registered with Asterisk#1) from PhoneC (which is
2006 Oct 30
0
Realtime trouble with contex
Hello, Asterisk.
I am currently using Asterisk (asterisk-1.2.13) and asterisk-addons-1.2.3_1
on FreeBSD 6.1-RELEASE-p10
So, after setup asterisk for realtime extension:
res_mysql.conf:
[general]
dbhost = 127.0.0.1
dbname = asterisk
dbuser = asterisk
dbpass = asterisk
dbport = 3306
dbsock = /tmp/mysql.sock
res_odbc.conf:
[mysql]
enabled => yes
dsn => asterisk
username => asterisk
2007 Jun 20
1
Asterisk RealTime
Hello All,
I manage to configure Asterisk RealTime and now it loads the SIP
users/peers from MySQL DB. The table I am using is of A2Billing DB
"cc_sip_buddies".
Now the only problem I am facing is incoming calls are failing... The
ATA which is assigned this DID number is behind NAT and according to
Olle's explanations he said "*there's no support for NAT keep-alives
2007 Sep 26
0
asterisk-users Digest, Vol 38, Issue 83
Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk
softphones. I followed the steps of "how to" of voip-org but always have
this error:
Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL
RealTime: Failed to query database. Check debug for more info.
Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL
RealTime: