|
FreeBSD Ports and Packages Installation and upgrading of ports and packages on FreeBSD. |
|
Thread Tools | Display Modes |
|
|||
FreeBSD ODBS PostgreSQL
Hello all.
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: Code:
[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): Code:
root@debian:~# cat /etc/odbcinst.ini [PostgreSQL] Driver = psqlodbca.so Setup = libodbcpsqlS.so Code:
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 Tools | |
Display Modes | |
|
|
Similar Threads | ||||
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 |