search for: dbhost

...;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" inherits gratia-base { validate_re($::gratia::dbhost, ''.mysite.net'') } But if I move the ''common'' node definition to a different .pp file, puppet fails to read the value of $::gr...

...onfig.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 = 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.locald...

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

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

...reg_sollicitatie in each database I have placed a executable file cron.php ------------------------------------------------------------------------------------------------------------------- <?php include "./config.php"; //nuBuilder config file $conn = mysql_connect($DBHost, $DBUser, $DBPassword); mysql_select_db($DBName,$conn); /************************************************************** emptying zzsys_trap and zzsys_variable tables **************************************************************/ $sql = "TRUNCATE TABLE zzsys_trap&qu...

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: http://lists.digium.com/pipermail/asterisk-users/attachments/20090708/6dbb7880/attachment.htm

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

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

...ll contain a usable value, and this value will be returned by the query. Now, as for converting your database, try this, after adjusting the queries to fit your schema: #!/usr/bin/perl use strict; use warnings; use DBI; use MIME::Base64 'encode_base64'; my $dbtype = 'mysql'; my $dbhost = 'localhost'; my $dbname = 'maildb'; my $dbuser = 'dbuser'; my $dbpass = 'password'; my $dbh = DBI->connect("DBI:$dbtype:host=$dbhost;database=$dbname", $dbuser, $dbpass) or die "Could not connect to database: " . $DBI::errstr . "\n&...

...ipusers to mysql/AsteriskHosted/sip_buddies [Feb 22 19:58:23] == Binding sippeers 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/aster...

...fa49d84e8facb765f7de2 != 31610d29241e861816b83998501ee223) I configure 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), calle...

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

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] realtime_family=queue_members persistentmembers = yes autofill = yes monitor-type = MixMonitor [queue2280] music = default strategy = roundrobin timeout = 15 wrapuptime=10 a...

...for user '2205' (context = <any>) -- Playing 'vm-incorrect' Here are my configs In extensions.conf I am using Voicemail2 and VoiceMailMain2 that has support for MySQL exten => 8500,1,VoiceMailMain2 In voicemail.conf I have the MySQL connectivity settings in [general] dbhost=localhost dbname=asterisk dbuser=someuser dbpass=somepass I have commented out the entire [default] section and it's mailboxes. I do have MySQL working with CDR MySQL from asterisk-addons thanks, John Haigh -------------- next part -------------- An HTML attachment was scrubbed... URL:...

...39;t exist. If I log in with a user in the voicemail.conf file it 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: .... ......

...;,'',0,0,0); 192.168.250.20 is asterisk 192.168.250.33 is the old database server 192.168.250.254 is the new database server I have restarted the database server I have edited the files: cdr_mysql.conf [global] ;hostname=192.168.250.33 hostname=192.168.250.254 res_mysql.conf [general] ;dbhost = 192.168.250.33 dbhost = 192.168.250.254 dbname = astconf and restarted asterisk What do I miss? bye Ronald Wiplinger

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

..., but the engine is not available My cdr_mysql.conf and res_mysql.conf are: /--- 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 che...

...sing 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 => { MYSQL(Connect connid ${DBHOST} ${DBUSER} ${DBPASS} ${DB}); MYSQL(Query resultid ${connid} SELECT TIMEDIFF(callend,callstart) FROM tblCall WHERE id=7); MYSQL(fetch fetchid ${resultid} temp); MYSQL(Disconnect ${connid}); } } </CODE> The error I'm getting is below: [Mar 6 08:59:35] WARNING[27116]: app_add...