search for: dbuser

...nsert cdr: %s\n",sqlcmd); return -1; } return 0; } char *description(void) { return desc; } int unload_module(void) { dbexit(); ast_cdr_unregister(name); return 0; } int load_module(void) { int res; struct ast_config *cfg; struct ast_variable *var; char *dbuser, *password, *dbserver, *application; cfg = ast_load(config); if (!cfg) { ast_log(LOG_WARNING, "Unable to load config for sybase CDR's: %s\n", config); return 0; } var = ast_variable_browse(cfg, "global"); if (!var) { return 0; } dbuser = ast_var...

...< ActiveRecord::Base end class GentestController < ApplicationController def index GenTableAs.establish_connection(:adapter => "postgresql", :host => "1.2.3.4", :port => 5432, :database => "gendb", :username => "dbuser", :password => "dbuser") @connected1 = GenTableAs.connection() @removedConnection = GenTableAs.remove_connection() @connected2 = GenTableAs.connection() # should be nil here obj1 = GenTableAs.new obj1["colaa"] = 100 obj1["colab"] = "1...

...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"; my $selectsth = $dbh->prepare('SELECT localpart, do...

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

...g_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";...

...ticate method 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=use...

...logdir = /var/log/puppet rundir = /var/run/puppet reports= log, foreman [puppetmasterd] ssl_client_header = SSL_CLIENT_S_DN ssl_client_verify_header = SSL_CLIENT_VERIFY modulepath = $confdir/modules #reports=log, foreman storeconfigs = true dbadapter = mysql dbuser = app_puppet dbpassword = password dbserver = localhost dbsocket = /sql/mysql/mysql.sock rrddir=/var/lib/puppet/rrd rrdinterval=$runinterval rrdgraph=true [puppetd] classfile = $vardir/classes.txt report = true localconfig = $vardir/localconfig What am I missin...

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

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

...uddies [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/asterisk-users/attachments/20100222/6d147d...

...861816b83998501ee223) 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 varc...

...all out. [like a calling card but auth'd by CID instead of PIN]. Here is my dialplan: 1234, 1, agi(ldusers.agi) 1234, 2, Hangup Here is my code: #!/usr/bin/perl # use Asterisk::AGI; use DBI; $db = "dbname"; $host = "hostname"; $port = "3306"; $userid = "dbuser"; $password = "dpasswd"; $connectionInfo = "DBI:mysql:database=$db;$host:$port"; $dbh = DBI->connect($connectionInfo,$userid,$password); $AGI = new Asterisk::AGI; my %input = $AGI->ReadParse(); $AGI->answer(); if (my $callerid = $input{'callerid'}) {...

...isk-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 testing.) I have removed the [default...

This looks good, except it is truncated, it should be something like 95chars long, Is your hash column set to 128 or up around there or larger? Quoting Carl A Jeptha <cajeptha at gmail.com>: > Sorry for double reply, but this what a password looks like in the > "hashed" password column: > {SHA512-CRYPT}$6$wEn1UFuiMzl9OSjd$Vh/PZ95WDID1GwI2 > > ------------

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

...t as Puppetmaster - created db (puppetdb) - crated user/pass(puppetdb/puppetdb) - granted rights - manually added a table just to check - works Puppetmaster configured to use that DB: #puppet.conf [puppetmasterd] storeconfigs = true [rails] dbadapter = mysql dbserver = localhost dbname = puppetdb dbuser = puppetdb dbpassword = puppetdb # #rails.log Defined connections: {} Active connections: {} Active connection name: # Thanks for taking a look! cheers Simon _______________________________________________ Puppet-users mailing list Puppet-users@madstop.com https://mail.madstop.com/mailman/listi...

...-- environment=test -d". Am I missing something? Here''s a copy of my puppet.conf file: [main] vardir = /var/lib/puppet manifest = /etc/puppet/manifests/site.pp modulepath = /etc/puppet/modules pluginsync = true storeconfigs = true # dbadapter = mysql dbuser = puppet dbpassword = **** dbserver = mysql.example.com [puppetmasterd] certname=puppet.example.com [testing] manifest=/etc/puppet-testing/manifests/site.pp modulepath=/etc/puppet-testing/modules [production] manifest=/etc/puppet/manifests/site.pp modulepath=/etc/pupp...

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

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

...r 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: .... .... [default] 1234 => 5555,Example...