search for: dbport

Hello List, I would like to connect to a postgreSQL database on a remote server and I am wondering what is the best package to do that. I have just installed RpgSQL, RPostgreSQL, Rdbi and RODBC. The handiest to me is RPostgreSQL but I don't see how to connect to a remote server with it. For sure I can connect to remote server with RODBC, but since I am on a Mac OSX 10.6, I have quite

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

Hi actually, i test a new Asterisk Server and i want add Mysql Realtime SIP. I read on the wiki: =================================================== Database Config put the following in res_mysql.conf [general] dbhost = 127.0.0.1 dbname = asterisk dbuser = myuser dbpass = mypass dbport = 3306 Values in sip.conf or iax.conf like in older versions of * are no longer used. Database Table Lets create the table we need: NOTE: You can use any table name you wish, just make sure the table name matches what you have the family name bound to. =======================================...

...to mysql/AsteriskHosted/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

...re extconfig.conf 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...

...terisk/modules/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. Whe...

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

...e ; configuration 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'...

...t works correctly. 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 #### t...

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 between Asterisk and MySQL, it's o...

.../--- cdr_mysql.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, suggest...

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

...so here's the configuration I have for MySQL Realtime (Asterisk version 1.6.2.17): In /etc/asterisk/extconfig.conf: sipusers => mysql,mya2billing,cc_sip_buddies In /etc/asterisk/res_mysql.conf: [mya2billing] dbhost = localhost dbname = mya2billing dbuser = a2billinguser dbpass = REDACTED dbport = 3306 And here's the 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]:...

Hello, How do I use multiple postgresql databases using res_config_pgsql? I tried creating multiple contexts in res_pgsql.conf, but asterisk is only using the 'general' context. My res_pgsq.conf is [general] ;; Connect to mydb on localhost dbport=5432 dbname=mydb dbuser=pgdbuser requirements=warn [pgwritedb] ;; Connect to mydb2 on another host dbhost=<IP of other db server> dbport=5432 dbname=mydb2 dbuser=pgdbuser2 dbpass=xxxxx requirements=warn In extconfig.conf I configured sippeers => pgsql,general,sip_peers sipreg...

...well, events logs 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!! Cristi...

....10, port 3306 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

...ked. 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. ________________________________ 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_...

...39;, email varchar(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_metri...

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

...les in a mysql 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...