search for: dbpass

Is this command the best way to access a MySQL database - MYSQL(Connect connid dhhost dbuser dbpass dbname) ? I thought I heard that using ODBC was a bit more stable. Anyone have any experience? Thanks, Matt

...and set "encrypt passwords = no","obey pam restrictions = yes","pam password change = yes" which are the needed changes I found at a lot of docummentation. I did setup pam.d/samba like the guides I've found: auth required pam_mysql.so user=dbuser passwd=dbpass db=users table=users usercolumn=login crypt=0 passwordcolumn=password account required pam_mysql.so user=dbuser passwd=dbpass db=users table=users usercolumn=login crypt=0 passwordcolumn=password password required pam_mysql.so user=dbuser passwd=dbpass db=users table=users usercolumn=...

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

...g 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"; my $selectsth = $dbh->prepare('SELECT localpart, domain, plain_pass FROM mailuser...

...3] == 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/asterisk-users/attachments/20100222/6d147dcc/attachment.htm

...1ee223) 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), callerid varchar(100), context varchar(100),...

...re 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 testing.) I have removed the [default] section from my...

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 announce-frequency = 30 announce-holdtime = no joinemp...

...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: http://lists.digium.com/pipermail/asterisk-users/att...

...amily 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.localdomain/127.0.0.1. Check debug for more info. == Registered application '...

...mail.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: .... .... [default] 1234 => 5555,Example Mailbox,root@...

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

...s_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 check that the driver was installed properly from the addonss?...

...ny 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_addon_sql_mysql.c:268 a...

...ome kind of cache replication between this two Asterisk servers (if yes, how should I do it?) Configuration on both Asterisk servers: extconfig.conf sippeers => mysql,asterisk,sipfriends sipusers => mysql,asterisk,sipfriends res_mysql.conf dbhost = 10.2.4.13 dbname = asterisk dbuser = xxx dbpass = yyy port = 3306 sip.conf dbhost = 10.2.4.13 dbname = asterisk dbuser = xxx dbpass = yyy port = 3306 Thanks Dubravko -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20080525/24a461bf/attachmen...

...RealTime: Invalid 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...

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

...= " quota sieve quota" } protocol imap { mail_max_userip_connections = 20 mail_plugins = " quota quota imap_quota" } protocol pop3 { mail_plugins = " quota quota" } >From dovecot-dict-sql.conf.ext: connect = host=localhost dbname=maildb user=dbuser password=dbpass # CREATE TABLE quota ( # username varchar(100) not null, # bytes bigint not null default 0, # messages integer not null default 0, # primary key (username) # ); map { pattern = priv/quota/storage table = quota_usage username_field = address value_field = quota_bytes } map { patt...

...g form the database and want to have the dialplan variables to be replaced with the correct content. How can I do this ? Currently this is not working. The variable ${PARAMS} contains the exact string of the database field : my dialplan : exten => s,n,MYSQL(Connect connid localhost dbuser dbpass MyTable) exten => s,n,MYSQL(Query resultid ${connid} SELECT script_url, script_params FROM my_tbl WHERE ID="${myID}") exten => s,n,MYSQL(Fetch fetchid ${resultid} scriptURL PARAMS) exten => s,n,NoOp(scriptURL = ${scriptURL} PARAMS = ${PARAMS}) becomes : -- Executing [s at sub-...

...sql cli it gives a result like: mysql> call call_control(78236721,1000,1233); +------+ | pass | +------+ | 1 | +------+ So I need asterisk to recognize this pass and take some actions based on what the pass value is. Dialplan looks like this: MYSQL(Connect connid ${DBDefaultHost} ${DBuser} ${DBpass} ${DBname}) MySQL(Query resultid ${connid} CALL call_control(78236721,1000,1233)) MySQL(Fetch fetchid ${resultid} pass) MYSQL(clear ${resultid}) MySQL(Query resultid ${connid} SELECT/INSERT whatever from table) So, it gives me this pass value correct, but if I execute some other query INSERT or SE...