OK. You need to understand that "retrieve_sip_conf_from_mysql.pl" is a Perl script and needs to be run outside of the sip.conf file.
Edit the script and put back the -T. Also edit the script to save to a different file. Change it to "sip_additional.conf". Now run the script. It will connect to your database and create a new file "sip_additional.conf" with all your sip peers/users in it. Now go into sip.conf and add "#include sip_friends.conf" issue a 'sip reload' in asterisk and *bam* ur done. -Matthew ----- Original Message ----- From: "Thomas Hoellriegel" <[EMAIL PROTECTED]> To: "Thomas Hoellriegel" <[EMAIL PROTECTED]>; "Asterisk Users Mailing List - Non-Commercial Discussion" <[email protected]> Sent: Monday, January 03, 2005 4:06 PM Subject: [Asterisk-Users] how can setup mysql in sip.conf? Hi, i have a problem: asterisk 1.0.3 is my current version. i copy from asterisk-sources: contrib/scripts/retrieve_sip_conf_from_mysql.pl in my /usr/asterisk/etc/asterisk directory. I edit this script and remove -T -option #!/usr/bin/perl -w i create the mysql database: mysqladmin create sip i pasted the example-table in the database: CREATE TABLE sip ( id INT(11) DEFAULT -1 NOT NULL, keyword VARCHAR(20) NOT NULL, data VARCHAR(50) NOT NULL, flags INT(1) DEFAULT 0 NOT NULL, PRIMARY KEY (id,keyword) ); i settingup res_odbc.conf as follows: [mysql] dsn => sip username => root password => pre-connect => yes i add the following line in the sip.conf file: #include = "retrieve_sip_conf_from_mysql.pl" Asterisk is started with: -vvvvc the asterisk output is: == Parsing '/usr/asterisk/etc/asterisk/sip.conf': Found == Parsing '/usr/asterisk/etc/asterisk/= retrieve_sip_conf_from_mysql.pl': Not found (No such file or directory) why can't find asterisk the perl-script? mysql authentification is not working in asterisk. what can i do please? mysql and the template-database are success installed. thankx for your help. --------------- tel : 089 2500 7676 homepage: http://www.blindi.net blinde-misc mailingliste f�r blinde. anmeldung unter: http://www.blindi.net/mailman/listinfo/blinde-misc _______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
