J Mauricio Mejia Vargas
2005-Oct-28 13:52 UTC
[Asterisk-Users] problem with asterisk-realtime-odbc
hello: I need guide with the following question. I am trying to use asterisk - realtime using ODBC, and when I make a call to number XXXX the CLI show the next error: ""Oct 28 15:17:34 WARNING[7034]: config.c:893 find_engine: Realtime mapping for 'sippeers' found to engine 'odbc', but the engine is not available Oct 28 15:17:34 NOTICE[7034]: chan_sip.c:9835 handle_request_register: Registration from '<sip:101@192.168.10.29>' failed for '192.168.10.109' - Wrong password Oct 28 15:17:36 WARNING[7034]: config.c:893 find_engine: Realtime mapping for 'sipusers' found to engine 'odbc', but the engine is not available Oct 28 15:17:36 WARNING[7034]: config.c:893 find_engine: Realtime mapping for 'sippeers' found to engine 'odbc', but the engine is not available"" I make the next configuration: (software) asterisk 1.2.0-beta1; asterisk ADDONS 1.2.0-beta1; UNIXodbc 2,2,11; UNIXodbc - devel 2,2,11; Fedora 4; MySQL 4,1,11 FC4 steps that have become. *********************************************** 1.I created database with name "asterisk", inside this I make a table "sip_buddies", a user of the database with name "asterisk" without password has all the permissions. 2. I have entered data to the database manually to the table "sip_buddies" 3. I modified the files" ODBC.INI, ODBCINST.INI" located in /etc with the next information ************************** file ODBC.INI: [MySQL-asterisk] Description = MySQL Asterisk database Trace = Yes TraceFile = /var/log/odbc.log Driver = MySQL SERVER = localhost USER = asterisk PASSWORD #PORT = 3306 DATABASE = asterisk Socket = /var/lib/mysql/mysqld.sock ********************** file ODBCINST.INI [PostgreSQL] Description = ODBC for PostgreSQL Driver = /usr/lib/libodbcpsql.so Setup = /usr/lib/libodbcpsqlS.so FileUsage = 1 [MySQL] Description = ODBC for MySQL Driver = /usr/lib/libmyodbc.so Setup = /usr/lib/libodbcmyS.so FileUsage = 1 *************************************** 4. After that I modified the files "res_odbc.conf, res_mysql.conf" located in /etc/asterisk. ********************************* file: res_odbc.conf [general] dbhost = 192.168.10.29 dbname = asterisk dbuser = asterisk dbpass = "" dbport = 3306 dbsock = /tmp/mysql.sock ******************************** file: res_mysql.conf ;[asterisk] ;dsn => asterisk ;username => myuser ;password => mypass ;pre-connect => yes [mysql1] dsn => MySQL-asterisk username => asterisk ;password => mypass pre-connect => yes ********************************* 5. after that I setup one telephone GRANDSTREAM 102 using info from the database. 6. execute asterisk -vvvvrc 7. I look the error: Oct 28 15:17:34 WARNING[7034]: config.c:893 find_engine: Realtime mapping for 'sippeers' found to engine 'odbc', but the engine is not available Oct 28 15:17:34 NOTICE[7034]: chan_sip.c:9835 handle_request_register: Registration from '<sip:101@192.168.10.29>' failed for '192.168.10.109' - Wrong password Oct 28 15:17:36 WARNING[7034]: config.c:893 find_engine: Realtime mapping for 'sipusers' found to engine 'odbc', but the engine is not available Oct 28 15:17:36 WARNING[7034]: config.c:893 find_engine: Realtime mapping for 'sippeers' found to engine 'odbc', but the engine is not available If you know where the problem is...please tell to me. -- Atentamente J Mauricio Mejia Vargas