search for: mysql1

...rything according to the wiki page: http://www.voip-info.org/tiki-index.php?page=Asterisk+res_config. However it doesn't work. I am using 1.0.8 asterisk version and here are my config files: Extconfig.conf: [settings] ;uncomment to load queues.conf via the db engine. ;queues.conf => odbc,mysql1,ast_config ;extensions.conf => odbc,mysql1,ast_config sip.conf => odbc,mysql1,ast_config res_odbc.conf: ;;; odbc setup file [mysql1] dsn => MySQL-asterisk username => blaat password => blaat pre-connect => yes [mysql2] dsn => MySQL-asterisk username => myuser password =...

hello i m using asterisk-1.0.9. i want to connect to db through odbc. isql is working. but asterisk is not getting user information from this table. can any one pls check this /etc/asterisk/extconfig.conf [settings] sipusers => odbc,mysql1,sip_buddies sippeers => odbc,mysql1,sip_buddies sip.conf => odbc,mysql1,sip_buddies sipfriends => odbc,mysql1,sip_buddies /etc/asterisk/res_config_odbc.conf [settings] ;table => ast_config connection => mysql1 /etc/asterisk/res_odbc.conf [mysql1] dsn => dsn username => usern...

...i m using asterisk-1.0.9. i want to connect to db through odbc. isql is working. but asterisk is not getting user information from this table. can any one pls check this odbc connection is working properly is there some thing required /etc/asterisk/extconfig.conf [settings] sipusers => odbc,mysql1,sip_buddies sippeers => odbc,mysql1,sip_buddies sip.conf => odbc,mysql1,sip_buddies sipfriends => odbc,mysql1,sip_buddies /etc/asterisk/res_config_odbc.conf [settings] ;table => ast_config connection => mysql1 /etc/asterisk/res_odbc.conf [mysql1] dsn => dsn username => usern...

...rything according to the wiki page: http://www.voip-info.org/tiki-index.php?page=Asterisk+res_config. However it doesn't work. I am using 1.0.8 asterisk version and here are my config files: Extconfig.conf: [settings] ;uncomment to load queues.conf via the db engine. ;queues.conf => odbc,mysql1,ast_config ;extensions.conf => odbc,mysql1,ast_config sip.conf => odbc,mysql1,ast_config res_odbc.conf: ;;; odbc setup file [mysql1] dsn => MySQL-asterisk username => blaat password => blaat pre-connect => yes [mysql2] dsn => MySQL-asterisk username => myuser password =...

...7023,Soft Phone,sp at localhost 703 => -7034,Pro Nek,pronek at gmail.com *res_odbc Configuration* [asterisk] enabled => yes dsn => asterisk-connector username => thet password => MyPassword pooling => 1 limit => 5 pre-connect => yes *func_odbc Configuration* [SQL] dsn=mysql1,asterisk readsql=${ARG1} ; ODBC_ANTIGF - A blacklist. [ANTIGF] dsn=mysql1,mysql2 ; Use mysql1 as the primary handle, but fall back to mysql2 ; if mysql1 is down. Supports up to 5 comma-separated ; DSNs. "dsn" may also be specified as "read...

...----------------+----------+----------+---------+ | 1 | 0 | 0 | 0 | voicemail.conf | default | | | +----+------------+------------+-----------+----------------+----------+----------+---------+ 6) I edited /etc/asterisk/configs/res_odbc.conf to contain: [mysql1] dsn = MySQL-asterisk username = myuser password = mypass pre-connect = yes [mysql1] dsn = asterisk_vm username = myuser ;; changed to my userid on mysql password = mypass ;; changed to my password on mysql pre-connect = yes [mysql2] dsn = MySQL2-asterisk username = myuser2 password = mypass2 enab...

i am getting 403 Forbidden message from asterisk when it try to register my user agent. i am basically useing mysql through ODBC. i hvae checked ODBC connecteion with 'ODBC Show' command. ------------------------------------------------------ *CLI> odbc show Name: mysql1 DSN: asteriskdsn Connected: yes *CLI> ------------------------------------------------------ and user is added to sip_buddies table. ------------------------------------------------------ mysql> update sip_buddies set auth='plaintext'; Query OK, 1 row affected (0.00 sec) Rows matched:...

Hi all, I have been trying to get my asterisk (v1.2.10) to lookup voicemail config data from my mysql database as opposed to voicemail.conf + sip.conf for my users. Users register with SER and get passed through to asterisk when they dial out. I followed the instructions as per http://www.voip-info.org/wiki/view/Asterisk+voicemail+database so basically I have 1) Build asterisk-addons-1.2.5 and

I have my master IMAP server running DC V1.0.10. The homedir and INBOXdir are physically resident there and NFS exported (no caching) to 3 other machines. I have installed V1.1beta13 on one of them (which thus accesses the homedir/INBOXdir remotely) and plan to have a limited community test-drive it there. Are there any hazards or drawbacks in doing this? While the homedirs and INBOXdirs

...am getting this error when reload my asterisk "cdr_addon_mysql.c:264 my_load_module: Unable to load config for mysql CDR's: cdr_mysql.conf" I don't have res_mysql.conf in /etc/asterisk/. I have res_odbc.conf which is attached Res_odbc.conf ============== ;;; odbc setup file [mysql1] dsn => MySQL-asterisk username => myuser password => mypass pre-connect => yes [mysql2] dsn => MySQL-asterisk username => myuser password => mypass pre-connect => yes Shafqat -----Original Message----- From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users...

...= /[DOMAIN]/home browseable = no writable = yes # acl compatibility = auto acl check permissions = True nt acl support = yes ea support = yes acl map full control = True map acl inherit = yes inherit acls = yes vfs object = mysql_audit mysql_audit:host=mysql1.[DOMAIN].local mysql_audit:user=smbd mysql_audit:pass=TpwqOnYz mysql_audit:name=smbd mysql_audit:port=3306 Here is a copy of my ctdb configuration: CTDB_RECOVERY_LOCK="/[DOMAIN]/ctdb/CTDB_lock" CTDB_PUBLIC_INTERFACE=eth0 CTDB_PUBLIC_ADDRESSES=/etc/ctdb/pu...

...= /[DOMAIN]/home browseable = no writable = yes # acl compatibility = auto acl check permissions = True nt acl support = yes ea support = yes acl map full control = True map acl inherit = yes inherit acls = yes vfs object = mysql_audit mysql_audit:host=mysql1.[ DOMAIN].local mysql_audit:user=smbd mysql_audit:pass=TpwqOnYz mysql_audit:name=smbd mysql_audit:port=3306 Here is a copy of my ctdb configuration: CTDB_RECOVERY_LOCK="/[DOMAIN]/ctdb/CTDB_lock" CTDB_PUBLIC_INTERFACE=eth0 CTDB_PUBLIC_ADDRESSES=/etc/ctdb/p...

...roblem can be cleared in one of two ways - the phone line can be unplugged and plugged back in again, or asterisk can be shut down, the zaptel module uloaded from the kernel, and then reloaded. Here is another snipit from the log: > Sep 13 05:40:50 NOTICE[16384]: registered database handle 'mysql1' dsn->[MySQL-asterisk] > Sep 13 05:40:50 NOTICE[16384]: registered database handle 'mysql2' dsn->[MySQL-asterisk] > Sep 13 05:40:50 NOTICE[16384]: res_odbc loaded. > Sep 13 05:40:50 NOTICE[16384]: Registered Config Engine odbc > Sep 13 05:40:50 NOTICE[16384]: res_confi...

...t = Home Directories path = /[DOMAIN]/home browseable = no writable = yes acl check permissions = True nt acl support = yes ea support = yes acl map full control = True map acl inherit = yes inherit acls = yes vfs object = mysql_audit mysql_audit:host=mysql1.[DOMAIN].local mysql_audit:user=smbd mysql_audit:pass=password mysql_audit:name=smbd mysql_audit:port=3306 [[DOMAIN]] comment = All Shared Folders path = /[DOMAIN] copy = homes admin users = "[DOMAIN]\[USERNAME]" Here is my /etc/pam.d/sam...

Hello guys, I need to be able to throw cdrs on more than one servers at a time. Please let me know how this can be done. Thanks

...cesfully executed. So, why the res_config_odbc.so is returning such error? [res_odbc.so] => (ODBC Resource) Aug 7 16:38:43 DEBUG[16384]: config.c:779 __ast_load: Parsing /etc/asterisk/res_odbc.conf Aug 7 16:38:43 NOTICE[16384]: res_odbc.c:131 load_odbc_config: registered database handle 'mysql1' dsn->[MySQL-asterisk] Aug 7 16:38:43 NOTICE[16384]: res_odbc.c:375 load_module: res_odbc loaded. [res_config_odbc.so] => (ODBC Configuration) Aug 7 16:38:43 NOTICE[16384]: config.c:880 ast_config_register: Registered Config Engine odbc Aug 7 16:38:43 DEBUG[16384]: config.c:779 __ast...