Go Back   DaemonForums > FreeBSD > FreeBSD Ports and Packages

FreeBSD Ports and Packages Installation and upgrading of ports and packages on FreeBSD.

Closed Thread
Thread Tools Display Modes
  #1   (View Single Post)  
Old 5th November 2013
Lexus45 Lexus45 is offline
Port Guard
Join Date: May 2010
Location: Kurgan, Russia
Posts: 39
Default 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:
[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
And now I need to set up /usr/local/etc/odbcinst.ini and /usr/local/etc/odbc.ini.

In Debian they look like (and work):
root@debian:~# cat /etc/odbcinst.ini 
Driver	= psqlodbca.so
Setup		= libodbcpsqlS.so
root@debian:~# cat /etc/odbc.ini 
Driver = PostgreSQL
Database = astertest
Servername =
Port = 5432

Protocol = 8.4
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
In fact, everything is obvious with odbc.ini.
But what libraries shall I use in odbcinst.ini ?
The FreeBSD system does not have neither psqlodbca.so, nor libodbcpsqlS.so .
  #2   (View Single Post)  
Old 8th November 2013
Carpetsmoker's Avatar
Carpetsmoker Carpetsmoker is offline
Real Name: Martin
Old man from scene 24
Join Date: Apr 2008
Location: Dutchman living in the UK
Posts: 2,199

databases/postgresql-odbc installs psqlodbcw.so & psqlodbcw.la in /usr/local/lib/

I have no experience with ODBC, but perhaps this helps ...
UNIX was not designed to stop you from doing stupid things, because that would also stop you from doing clever things.
  #3   (View Single Post)  
Old 9th November 2013
Lexus45 Lexus45 is offline
Port Guard
Join Date: May 2010
Location: Kurgan, Russia
Posts: 39

I have psqlodbcw.la only.
Anyway, thank you for being ready to help.
  #4   (View Single Post)  
Old 3rd December 2013
Lexus45 Lexus45 is offline
Port Guard
Join Date: May 2010
Location: Kurgan, Russia
Posts: 39

Close the thread please, it is solved.
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

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

All times are GMT. The time now is 04:07 PM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Content copyright © 2007-2010, the authors
Daemon image copyright ©1988, Marshall Kirk McKusick