search for: dbhosts

Hi, I''m running into some trouble when trying to access some variables which actually are a class parameter. The following works OK: node "common" { $var=''foo'' } node "gratia-base" inherits common { class { ''gratia'': dbhost => ''server.mysite.net'', } } node "node1"

Hello *'s, i am using Realtime Sip drivers but its not working here is my configs: extconfig.conf [settings] ; Realtime configuration engine ; ; maps a particular family of realtime ; 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 =

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

Hi friends, I am using Real Time Asterisk Architecture where I have put the Sip users/peers and extensions defining the dialplan in tables in a mysql database. Currently, asterisk points to my single database server as configured: ------------------------------------------ /etc/asterisk/res_mysql.conf ------------------------------------------ [general] dbhost = xxx dbname =

Dear All, we have some Nubuilder databases on a Centos6.3 server: [root at caw-server2 db]# ls /var/www/html/nubuilder/db reg_begeleidingsteam reg_jww_archief reg_personeel reg_straathoekwerk reg_bib reg_jww_dossiers reg_resident reg_vrijwilligers reg_drughulp reg_jww_dvd reg_signaleren reg_jac_activiteit reg_onthaal reg_sollicitatie in each

Hi Guys, As it looks like from CLI command " show cdr mysql " , can somebody confirms that cdr-mysql creates persistent connection with in asterisk? " show cdr mysql " shows " connected to user at dbhost from 18 hours ......." -------------- next part -------------- An HTML attachment was scrubbed... URL:

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

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

First of all, you can probably go online before you convert all passwords. You can modify your query in dovecot-sql.conf.ext to something like the following: SELECT IF(crypt_pass IS NULL OR crypt_pass='', CONCAT('{PLAIN}',plain_pass), crypt_pass) as password FROM mailuser .. This is assuming that: * for incoming users, you have a plain_pass column containing just the plaintext

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

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:

I have installed the CVS Head as of 12/12/04, as well as the asterisk-addons to ensure that /usr/lib/asterisk/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 =

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

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]

Voicemail.conf in MySQL is not functioning where I get the following error from Asterisk messages log file: CLI debug output is as follows: Executing VoiceMailMain2("SIP/2205-3df0", "") in new stack -- Playing 'vm-login' -- Playing 'vm-password' -- Incorrect password '1234' for user '0' (context = <any>) -- Playing

I am trying to configure RealTime Voicemail with MySQL. I downloaded compiled and installed the CVS HEAD for asterisk, and for asterisk-addons. MySQL seems to be loading correctly (the cdr table is recording incoming calls). But the RealTime Voicemail doesn't seem to be checking the database table for the voicemail users. When trying to login to voicemailMain if I use a user in the

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]

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

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

Hello list, I'm having some problem integrating the SELECT TIMEDIFF() and SELECT DATEDIFF() in my code. The syntax I'm using works without any problems if I run them directly from the MySQL Client, but from the Asterisk Dialplan it just wont work. Is there a limitation in the MySQL() application for the Asterisk dialplan that produces this error? <CODE> context testsql { s =>