Displaying 20 results from an estimated 24 matches for "mysql_reconnect".
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: Everything is fine.
[No...
2005 Aug 23
2
RealTime ignoringswitch=>Realtime/context@realti me_ext
...asterisk-addons. I have been
trying to setup realtime mysql voicemail but no sucess. I keep getting this
error below. The necessary modules are loaded, res_config_mysql.so ...
Any pointers will help. Thanks
mail*CLI> realtime mysql status
Aug 24 00:56:50 ERROR[963]: res_config_mysql.c:596 mysql_reconnect: MySQL
RealTime: Failed to connect database server RealTimeMaster on localhost.
Check debug for more info.
Aug 24 00:56:50 DEBUG[963]: res_config_mysql.c:597 mysql_reconnect: MySQL
RealTime: Cannot Connect: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
------...
2008 Jan 31
0
Realtime device update weirdness
...,
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_reconnect: MySQL RealT...
2006 Jan 11
1
Better solution to mysql reconnect timeout
vmail*CLI> realtime mysql status
Jan 11 09:53:04 ERROR[3597]: res_config_mysql.c:623 mysql_reconnect: MySQL
RealTime: Failed to reconnect. Check debug for more info.
vmail*CLI> realtime mysql status
Connected to asterisk_vm@tritonvoice.com, port 3306 with username voicemail
for 1 days, 5 hours, 32 minutes, 7 seconds.
vmail*CLI> realtime mysql status
Connected to asterisk_vm@tritonvoice.com,...
2005 Jan 13
1
asterisk realtime msql
...es 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]: res_config_mysql.c:637 mysql_reconnect: MySQL RealTime: Everything is fine.
Column Name Column Value
-------------------- --------------------
uniqueid 1
name 104
accountcode 104
callgroup 1
c...
2004 Dec 30
1
RealTime Drivers Connectivity Error
...not specified
;
sipfriends => mysql,asterisk,sip_friends
res_mysql.conf
[general]
dbhost = localhost.localdoamin/127.0.0.1
dbname = asterisk
dbuser = asterisk
dbpass = 123456
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock
error detail:
Dec 31 01:20:49 ERROR[4298]: res_config_mysql.c:617 mysql_reconnect:
MySQL RealTime: Failed to connect database server asterisk on
localhost.localdomain/127.0.0.1. Check debug for more info.
== Registered application 'UserEvent'
[app_verbose.so]Segmentation fault (core dumped)
i change dbhost parameter several times like(localhost,192.168.10.193
etc)...
2005 Aug 24
1
RealTime ignoringswitch=>Realtime/context@realtime_ext
...nesday, August 24, 2005 6:17 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] RealTime
ignoringswitch=>Realtime/context@realtime_ext
Araba, Michael wrote:
> mail*CLI> realtime mysql status
> Aug 24 00:56:50 ERROR[963]: res_config_mysql.c:596 mysql_reconnect:
> MySQL RealTime: Failed to connect database server RealTimeMaster on
> localhost. Check debug for more info.
> Aug 24 00:56:50 DEBUG[963]: res_config_mysql.c:597 mysql_reconnect:
> MySQL RealTime: Cannot Connect: Can't connect to local MySQL server
> through socket '/tm...
2007 Jan 15
0
Asterisk Realtime and MD5 authentication
...up Asterisk Realtime and MD5 authentication.
With clear text passwords everything is working fine.
-- Registered SIP 'edwin' at 10.0.0.37 port 5060 expires 600
-- Saved useragent "Cisco-CP7940G/8.0" for peer edwin
[2007-01-15 10:18:12] DEBUG[28528]: res_config_mysql.c:651 mysql_reconnect:
MySQL RealTime: Everything is fine.
[2007-01-15 10:18:12] DEBUG[28528]: res_config_mysql.c:355 update_mysql: MySQL
RealTime: Update SQL: UPDATE SipUser SET ipaddr = '10.0.0.37', port = '5060',
regseconds = '1168853292', username = 'edwin', fullcontact
= 'sip...
2007 Oct 26
1
Realtime Mysql error
...l is hangup sometimes astcc doesnt calculate the call cost and the call time and without writing the call status on cdrs table .
I tried to run this command "realtime mysql status" on the asterisk console and that what i've got:
[Oct 27 01:05:32] ERROR[2607]: res_config_mysql.c:637 mysql_reconnect: MySQL RealTime: Ping failed (2006). Trying an explicit reconnect.
Connected to astdb1 at localhost, port 3306 with username root for 9 hours, 43 minutes, 39 seconds.
Can any body help with this;
Thanks in advance;
Wassim
_________________________________________________________________
Expr...
2011 Mar 07
2
Asterisk 1.6 MySQL Realtime fails to connect with working username and password.
...he error messages I get:
voip2*CLI> realtime mysql status
localhost configured for mya2billing at localhost, port 3306 with username
a2billinguser.
mya2billing configured for mya2billing at localhost, port 3306 with username
a2billinguser.
[Mar 7 14:38:59] ERROR[15943]: res_config_mysql.c:1575 mysql_reconnect:
MySQL RealTime: Failed to connect database server mya2billing on localhost
(err 2002). Check debug for more info.
[Mar 7 14:38:59] ERROR[15943]: res_config_mysql.c:1575 mysql_reconnect:
MySQL RealTime: Failed to connect database server mya2billing on localhost
(err 2002). Check debug for more inf...
2015 May 22
1
Problem with realtime mysql I can't seem to resolve
...e loaded :
*CLI> realtime mysql status
general configured for asterisk on socket file /var/lib/mysql/mysql.sock
with username asterisk.
MyAsteriskDB connected to MyAsteriskDB at 127.0.0.1, port 3306 with
username astadmin for 12 minutes.
[May 22 10:32:02] ERROR[11269]: res_config_mysql.c:1599 mysql_reconnect:
MySQL RealTime: Failed to connect database server asterisk on
/var/lib/mysql/mysql.sock (err 1045). Check debug for more info.
*CLI>
However, SIP-registration for SIP peer can not be found :
[May 22 10:32:50] NOTICE[11077]: chan_sip.c:24957
handle_request_register: Registration from
'...
2005 May 13
2
Asterisk extensions from Mysql
...anges in the
extconfig.conf, the extensions.conf, res_mysql.conf,
res_config_odbc.conf,res_odbc.conf as they have mentioned on the site
www.voip-info.org <http://www.voip-info.org/> .
But still I am getting the error as
May 13 07:52:49 ERROR [6420]: res_config_mysql.c:588 mysql_reconnect: MySQL
RealTime: Failed to connect database server asterisk on. Check debug for
more info.
Does anybody know how to go about configuring Asterisk to access
extensions from the mysql database? Please kindly do reply
Regards,
Bharat M. Sarvan
-------------- next...
2007 Jun 03
0
Strange problem with channel allocation
...the following error. Someone have some ideea? Thank you.
---<Cut Here>---
pbx*CLI>console dial 1014
== Console is full duplex
-- Executing [1014@default:1] Dial("OSS/dsp", "SIP/1014|40|t") in new
stack
[2007-06-03 20:16:10] DEBUG[27424]: res_config_mysql.c:650 mysql_reconnect:
MySQL RealTime: Everything is fine.
[2007-06-03 20:16:10] DEBUG[27424]: res_config_mysql.c:138 realtime_mysql:
MySQL RealTime: Retrieve SQL: SELECT * FROM sip_peers WHERE name = '1014'
-- Called 1014
[2007-06-03 20:16:10] WARNING[27424]: channel.c:3222
ast_channel_make_compatible: No p...
2007 Aug 06
1
CDR/MySQL basic config
...get:
== Parsing '/etc/asterisk/cdr_mysql.conf': Found
[Aug 6 21:01:14] ERROR[32512]: cdr_addon_mysql.c:436 my_load_module:
Failed to connect to mysql database asteriskcdrdb on localhost.
cdr_addon_mysql.so => (MySQL CDR Backend)
[Aug 6 21:01:14] ERROR[32512]: res_config_mysql.c:627 mysql_reconnect:
MySQL RealTime: Failed to connect database server on (err 2002). Check
debug for more info.
[Aug 6 21:01:14] WARNING[32512]: res_config_mysql.c:474 load_module:
MySQL RealTime: Couldn't establish connection. Check debug.
[Aug 6 21:01:14] NOTICE[32512]: config.c:1171
ast_config_engine_regis...
2005 Mar 24
1
realtime - unable to find key
...p,voicemail
extensions => mysql,voip,extensions
and when my phone tries to register i get
Mar 24 21:26:32 DEBUG[28397]: res_config_mysql.c:117 realtime_mysql:
MySQL RealTime: Retrieve SQL: SELECT * FROM sip WHERE name =
'5625551212'
Mar 24 21:26:32 DEBUG[28397]: res_config_mysql.c:605 mysql_reconnect:
MySQL RealTime: Everything is fine.
Mar 24 21:26:32 DEBUG[28397]: db.c:177 ast_db_get: Unable to find key
'5625551212' in family 'SIP/Registry'
Mar 24 21:26:32 DEBUG[28397]: chan_sip.c:1440 create_addr: Setting NAT
on RTP to 524288
Mar 24 21:26:51 DEBUG[28397]: chan_sip.c:920 __sip...
2004 Nov 30
1
realTime configuration help needed
...es_config_mysql.c:430 parse_config: MySQL
RealTime Port: 3306
Nov 30 12:44:21 DEBUG[3088]: res_config_mysql.c:434 parse_config: MySQL
RealTime User: root
Nov 30 12:44:21 DEBUG[3088]: res_config_mysql.c:435 parse_config: MySQL
RealTime Password:
Nov 30 12:44:21 DEBUG[3088]: res_config_mysql.c:471 mysql_reconnect:
MySQL RealTime: Successfully connected to database.
Nov 30 12:44:21 NOTICE[3088]: config.c:562 ast_config_register:
Registered Config Engine mysql
Nov 30 12:44:21 DEBUG[3088]: config.c:517 __ast_load: Parsing
/home/gkon/slash/etc/asterisk/extconfig.conf
== Binding sip.conf to odbc/asterisk/sip...
2005 Mar 23
0
Asterisk Realtime.
...m trying to get calls to work correctly, and when a incoming
call comes in it gives this error
Mar 23 20:09:18 DEBUG[27067]: res_config_mysql.c:117 realtime_mysql:
MySQL RealTime: Retrieve SQL: SELECT * FROM sip WHERE name =
'5625551212'
Mar 23 20:09:18 DEBUG[27067]: res_config_mysql.c:605 mysql_reconnect:
MySQL RealTime: Everything is fine.
Mar 23 20:09:18 DEBUG[27067]: db.c:177 ast_db_get: Unable to find key
'5625551212' in family 'SIP/Registry'
i'm stumped i'm not sure why the phone won't register.
2006 Jun 21
0
MySQL Realtime Voicemail Connection Lost
...nnection error: (2006) MySQL server has gone away
Jun 21 07:54:01 NOTICE[8120]: rtp.c:564 ast_rtp_read: Unknown RTP codec 96 received
-- Executing VoiceMail("SIP/xxx.187.142.186-b773c428", "u2944017@voicemail") in new stack
Jun 21 07:54:01 ERROR[8120]: res_config_mysql.c:623 mysql_reconnect: MySQL RealTime: Failed to reconnect. Check debug for more info.
Jun 21 07:54:01 WARNING[8120]: app_voicemail.c:2411 leave_voicemail: No entry in voicemail config file for '2944017'
The next connection attempt will work. Happens like clockwork every morning. It would seem that Asterisk is...
2010 Oct 05
0
Chage Asterisk 1.6.1 to 1.6.2
...G[15081]: chan_sip.c:21639 handle_incoming: ****
Received REGISTER (2) - Command in SIP REGISTER
[Oct 5 05:39:22] DEBUG[15081]: chan_sip.c:21658 handle_incoming:
Ignoring SIP message because of retransmit (REGISTER Seqno 44199, ours
44199)
[Oct 5 05:39:22] DEBUG[15081]: res_config_mysql.c:1602 mysql_reconnect:
MySQL RealTime: Connection okay.
[Oct 5 05:39:22] DEBUG[15081]: res_config_mysql.c:371 realtime_mysql:
MySQL RealTime: Retrieve SQL: SELECT * FROM VOIP_Comptes_SIP WHERE name
= 'SIPUSER001' AND host = 'dynamic'
[Oct 5 05:39:22] DEBUG[15081]: chan_sip.c:23734 build_peer: -REALT...
2009 May 03
2
Asterisk not starting up due to database problems
..._mysql.c:570 parse_config: MySQL RealTime: No database port found, using 3306 as default.
[May 3 13:29:14] WARNING[7477]: res_config_mysql.c:577 parse_config: MySQL RealTime: No database socket found, using '/tmp/mysql.sock' as default.
[May 3 13:29:14] ERROR[7477]: res_config_mysql.c:629 mysql_reconnect: MySQL RealTime: Failed to connect database server asterisk on (err 2002). Check debug for more info.
[May 3 13:29:14] WARNING[7477]: res_config_mysql.c:476 load_module: MySQL RealTime: Couldn't establish connection. Check debug.
[May 3 13:29:14] NOTICE[7477]: config.c:1274 ast_config_engine...