i have installed the asterisk 1.6 before that installed the necessary
packages in Debian,
* i followed the steps as follows,
r...@astserver: ~# apt-get install unixodbc unixodbc-dev odbc-postgresql
postgresql-8.1 postgresql-contrib postgresql-dev
* then i installed the asterisk 1.6 version with the odbc modules as in the
selected list.
* then i created the database as asterisk and the user also with the same
name. The password is "secret".
r...@astserver: ~# su postgres
$ createuser -s -D -R -l -P -e asterisk
$ createdb -O asterisk -e asterisk
* then i did the configuration as follows,
/etc/odbc.ini
[banking]
Description = ODBC Testing
Driver = PostgreSQL
Trace = No
Database = asterisk
Servername = 127.0.0.1
Username = asterisk
Password = secret
Port = 5432
/etc/odbcinst.ini
[PostgreSQL]
Description = ODBC for PostgresQL
Driver = /usr/lib/libodbcpsql.so
Setup = /usr/lib/odbc/libodbcpsqlS.so
FileUsage = 1
/etc/asterisk/res_odbc.conf -- following lines were included,
[postgres]
enabled = yes
dsn = banking
pre-connect = yes
/etc/asterisk/func_odbc.conf -- following lines were included,
[DUMMY]
dsn=postgres
read=select name from dialplan_data where ext='${SQL_ESC(${ARG1})}'
writesql=UPDATE dialplan_data SET name='${SQL_ESC(${VAL1})}' WHERE
ext='${SQL_ESC(${ARG1})}'
then i searched and there is no file available with name libodbcpsql.so.
How do can i make it possible to work ?
Thanks in Advance,
Balakrishnan M
r...@astserver: ~#isql -v banking
[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV
failed
[ISQL]ERROR: Could not SQLConnect
r...@astserver: ~#
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
