asterisk users - Apr 2010 - [asterisk users] asterisk realtime - database driven dialplan

i have installed the asterisk 1.6 before that installed the necessary
packages in Debian,

* i followed the steps as follows,
root at 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".
root at 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









root at astserver: ~#isql -v banking
[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV
failed
[ISQL]ERROR: Could not SQLConnect
root at astserver: ~#
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20100413/f85ecd51/attachment.htm