search for: dbsock

...riskHosted/sip_buddies I have the following in extconfig.conf : sipusers => mysql,Asterisk,sip_buddies sippeers => mysql,Asterisk,sip_buddies I have the following in res_mysql.conf : [general] dbhost = 127.0.0.1 dbname = Asterisk dbuser = asteriskuser dbpass = asteriskpasswd dbport = 3306 dbsock = /tmp/mysql.sock Something I'm missing ?? Need extra configuration ? Jonas. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100222/6d147dcc/attachment.htm

...onf as: [settings] iaxusers => mysql,asterisk,iax_buddies iaxpeers => mysql,asterisk,iax_buddies sipusers => mysql,asterisk,sip_buddies sippeers => mysql,asterisk,sip_buddies res_mysql.conf as: [general] dbhost = localhost dbname = asterisk dbuser = root dbpass = asterisk dbport = 3306 dbsock = /var/lib/mysql/mysql.sock My table as: CREATE TABLE iax_buddies ( name varchar(30) primary key NOT NULL, username varchar(30), type varchar(6) NOT NULL, secret varchar(50), callerid varchar(100), context varchar(100), host varchar(31) NOT NULL def...

.../res_config_mysql.so exists. I have configured the following (after building a new DB with the appropriate SQL examples, with mods to drop the invalid keys, on the Wiki): - /etc/asterisk/res_mysql.conf [general] dbhost = 127.0.0.1 dbname = my_db dbuser = my_uname dbpass = my_secret dbport = 3306 dbsock = /tmp/mysql.sock - /etc/asterisk/extconfig.conf ; Extconfig.conf for realtime configuration voicemail => mysql,my_db,voicemail_users (Just want to try something simple such as voicemail for the initial testing.) I have removed the [default] section from my voicemail.conf. When I try to acc...

...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] realtime_family=queue_members persistentmembers = yes autofill = yes monitor-type = MixMonitor [queue2280] music = default strategy = roundrobin timeout = 15 wrapuptime=10 announce-frequency = 30 announce-holdtime = no joinempty = yes extconfig.conf: [se...

...ion to a given database driver, ; database and table (or uses the name of ; the family if the table is 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.s...

...ly. Any suggestions? Thanks, Michael extconfig.conf: [settings] ;uncomment to load queues.conf via the db engine. ;queues.conf => odbc voicemail => mysql,tenant_new, voicemail_users res_mysql.conf: [general] dbhost = localhost dbname = tenant dbuser = yyyy dbpass = xxxxx ;dbport = 3306 ;dbsock = /tmp/mysql.sock cdr_mysql.conf: [global] hostname=localhost dbname=tenant_new table=cdr password=xxxxx user=yyyy port=3306 sock=/tmp/mysql.sock userfield=1 voicemail.conf: .... .... [default] 1234 => 5555,Example Mailbox,root@localhost #### this box works t...

...l.conf ---/ [global] hostname = localhost dbname = asteriskcdrdb password = passw0rd user = root table = cdr port = 3306 sock = /var/run/mysqld/mysqld.sock userfield = 1 /--- res_mysql.conf ---/ [general] dbhost = localhost dbname = asteriskrealtime dbuser = root dbpass = passw0rd dbport = 3306 dbsock = /var/run/mysqld/mysqld.sock Mysql is working properly, I test it using the parameters included in res_mysql.conf. Is there a way of checking the asterisk conection to the database manually? How can I check that the driver was installed properly from the addonss? Any idea, suggestion? Regars,...

...fied: 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 res_mysql.conf) res_mysql.conf : [general] dbhost = 127.0.0.1 dbname = MyDBase dbuser = asterisk dbpass = mysecret dbport = 3306 dbsock = /tmp/mysql.sock requirements=warn ; or createclose or createchar What do I need to change to be conform asterisk 1.6 ?! Reloading, restarting asterisk and restarting my CentOS-server all doesn't help. Jonas. -------------- next part -------------- An HTML attachment was scrubbed... URL:...

...gs on /var/log/asterisk/queue_log . With extconfig.conf configurations no events logs on /var/log/asterisk/queue_log. What happens?? My asterisk version is 1.6.1.11. addons 1.6.1.2 res_mysql.conf [general] dbhost = 127.0.0.1 dbname = asterisk dbuser = userX dbpass = passX dbport = 3306 dbsock = /tmp/mysql.sock -------------------------------------------------- extconfig.conf [settings] queue_log => mysql,general ---------------------------------------------------- logger.conf [general] queue_log = yes queue_log_name = queue_log Thanks, Best regards!! Cristian Arguello....

...with username root for 4 seconds. in extconfig.conf i have: [settings] ;<family name> => <driver>,<database name>[,table_name] sipfriends => mysql,asterisk,sipfriends in res_mysql.conf [general] dbhost = 192.168.1.10 dbname = asterisk dbuser = root dbpass = dbport = 3306 dbsock = /var/lib/mysql/mysql.sock thnx in advance any help will be very apreciated :) -- Maurizio Marini

Hello, I am using asterisk realtime with a postgresql database on the same server. In res_pgsql.conf I have specified [general] dbhost=localhost dbport=5432 dbname=asteriskdb dbuser=psql dbsock=/tmp/.s.PGSQL.5432 Since both asterisk and db are on same server, I would like asterisk to connect to db using the local unix socket. However asterisk is not using the local unix socket to connect to database, it is making a tcp connection with the db. Is there anyway I can force asterisk to use t...

...s 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. ________________________________ res_mysql.conf settings [general] dbhost = <IP Address> dbname = RealTimeMaster dbuser = xxxxxxx dbpass = xxxxxxx dbport = 3306 dbsock = /tmp/mysql.sock extconf.conf [settings] voicemail => mysql,RealTimeMaster,voicemail sipusers => mysql,RealTimeMaster,sip_buddies sippeers => mysql,RealTimeMaster,sip_buddies queues => mysql,RealTimeMaster,queue queue_members => mysql,RealTimeMaster,queue_member cdr_mysql.conf [gl...

I'm having trouble with the Realtime setup. I've followed the instructions on voip-info using odbc but I get this message during asterisk boot: Parsing '/etc/asterisk/sip.conf': Not found (No such file or directory) Dec 14 16:11:37 NOTICE[8868]: chan_sip.c:8462 reload_config: Unable to load config sip.conf, SIP disabled == Registered channel type 'SIP' (Session

...char(50) NOT NULL default '', pager varchar(50) NOT NULL default '', stamp datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ); ####### ####res_mysql.conf#### [general] dbhost = localhost dbname = asterisk dbuser = asterisk dbpass = ******** dbport = 3306 dbsock = /var/run/mysqld/mysqld.sock #### ####Debug Log#### Aug 11 01:16:23 DEBUG[1028] res_config_mysql.c: MySQL RealTime: Static SQL: SELECT category, var_name, var_val, cat_metric FROM voicemail_users WHERE filename='voicemail.conf' and commented=0 ORDER BY filename, cat_metric desc, var_me...

...guration file). I'm tailing the MySQL query log and there simply aren't ANY queries on the table containing my SIP users. Here's my config: -- res_mysql.conf [general] dbhost = 127.0.0.1 dbname = <valid name> dbuser = <valid user> dbpass = <valid pass> dbport = 3306 dbsock = /var/lib/mysql/mysql.sock -- extconfig.conf [global] sipusers => mysql,<valid db>,telephones sippeers => mysql,<valid db>,telephones (combinations of removing sipusers and sippeers lines make no difference) Asterisk is *definitely* connecting successfully, and I've verifi...

...------------------------------------------------- My configuration files are : extconfig.conf : -------------------- [settings] sip.conf => odbc,asterisk,sip sipfriends => odbc,asterisk,sip res_mysql.conf: -------------------- [general] dbuser=root dbpass= dbhost=localhost dbname=asterisk dbsock=/var/lib/mysql/mysql.sock

...database. Currently, asterisk points to my single database server as configured: ------------------------------------------ /etc/asterisk/res_mysql.conf ------------------------------------------ [general] dbhost = xxx dbname = asterisk dbuser = asterisk dbpass = xxx dbport = 3306 dbsock = /tmp/mysql.sock But what I want to do is to set "dbhost" in "/etc/asterisk/res_mysql.conf" to point asterisk to a DNS SRV record so that I can implement mysql redundancy. I defined the SRV record in our DNS server and put it in "dbhost" field in "/etc/aste...

Could someone provide some steps for troubleshooting Realtime? I can't see any signs that it's working. I followed and double-checked a few different guides around the net, but haven't been able to figure it out. -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hi Guys, We have just set up Asterisk (CVS Head) for a realtime enviorment using MySQL & Asterisk Addons. I have populated the "sip_buddies" table with the same information that is came from our sip.conf, however registration seems to fail for the softphone we have set up. Does anyone have any idea as to what I should be looking for here? I'm not getting any error messages

.../res_config_mysql.so exists. I have configured the following (after building a new DB with the appropriate SQL examples, with mods to drop the invalid keys, on the Wiki): - /etc/asterisk/res_mysql.conf [general] dbhost = 127.0.0.1 dbname = my_db dbuser = my_uname dbpass = my_secret dbport = 3306 dbsock = /tmp/mysql.sock - /etc/asterisk/extconfig.conf ; Extconfig.conf for realtime configuration voicemail => mysql,my_db,voicemail_users (Just want to try something simple such as voicemail for the initial testing.) I have removed the [default] section from my voicemail.conf. When I try to acc...