FreeBSD ODBS PostgreSQL
The situation is as follows. There is a FreeBSD 8.2 server with Asterisk. We need to set up Asterisk Realtime - to take SIP peers from the database, not from the txt config files (like sip.conf).
I tested such an installation on Debian: connected Asterisk with PostgreSQL through ODBC connector. Everything worked. The major thing I had to test was the ability of Asterisk to see the database and to take data from it. So, I know how to set up realtime in Asterisk.
The problem occured with FreeBSD, because I know GNU/Linux better, but the server has been set up many times ago, before I started working here.
So, I installed two packages:
[root@pbx-office /root]# pkg_info | grep -i odbc postgresql-odbc-08.04.0200 PostgreSQL ODBC driver unixODBC-2.3.0_1 ODBC library suite for Unix
In Debian they look like (and work):
root@debian:~# cat /etc/odbcinst.ini [PostgreSQL] Driver = psqlodbca.so Setup = libodbcpsqlS.so
root@debian:~# cat /etc/odbc.ini [asterisk-test] Driver = PostgreSQL Database = astertest Servername = 10.14.10.12 Port = 5432 Protocol = 8.4 ReadOnly = No RowVersioning = No ShowSystemTables = No ShowOidColumn = No FakeOidIndex = No
But what libraries shall I use in odbcinst.ini ?
The FreeBSD system does not have neither psqlodbca.so, nor libodbcpsqlS.so .
|Thread||Thread Starter||Forum||Replies||Last Post|
|postgresql VS mysql .. when which is better ?||daemonfowl||General software and network||3||12th September 2012 05:30 AM|
|Security PostgreSQL updates fix bugs||J65nko||News||0||8th December 2011 01:09 PM|
|PostgreSQL developers fix vulnerabilities||J65nko||News||0||17th May 2010 01:58 PM|
|[FreeBSD] which version of PostgreSQL?||MacApp||FreeBSD Ports and Packages||8||12th July 2008 09:25 AM|
|PostgreSql rc.d script||fridder||FreeBSD Ports and Packages||1||1st July 2008 01:12 AM|