Re: SQLBox problems with postgresql

2010-07-28 Thread Nikos Balkanas
ompile from svn, is the best in his case. BR, Nikos - Original Message - From: "Milan P. Stanic" To: Sent: Wednesday, July 28, 2010 3:18 PM Subject: Re: SQLBox problems with postgresql On Wed, 2010-07-28 at 14:55, Nikos Balkanas wrote: OK. Where is the postgress client

Re: SQLBox problems with postgresql

2010-07-28 Thread Milan P. Stanic
ebian-devel (or others) list but not to kannel users. > BR, > Nikos > - Original Message - From: "Milan P. Stanic" > > To: > Sent: Wednesday, July 28, 2010 2:38 PM > Subject: Re: SQLBox problems with postgresql > > > >On Wed, 2010-07-28 at 13

Re: SQLBox problems with postgresql

2010-07-28 Thread Milan P. Stanic
client. If you see postgress library please point out. I did, but looks like you didn't read carefully. Look bellow lines with a lot of asterisks (): > BR, > Nikos > - Original Message - From: "Milan P. Stanic" > > To: > Sent: Wednesday, July 28, 2010

Re: SQLBox problems with postgresql

2010-07-28 Thread Nikos Balkanas
ic" To: Sent: Wednesday, July 28, 2010 2:38 PM Subject: Re: SQLBox problems with postgresql On Wed, 2010-07-28 at 13:05, Nikos Balkanas wrote: >>I'm running this sqlbox on a debian unstable and using the kannel >> and >>kannel-sqlbox packages from the official

Re: SQLBox problems with postgresql

2010-07-28 Thread Nikos Balkanas
ginal Message - From: "Milan P. Stanic" To: Sent: Wednesday, July 28, 2010 2:30 PM Subject: Re: SQLBox problems with postgresql On Wed, 2010-07-28 at 12:13, Arnau Rebassa wrote: Hi Nikos, 2010/7/28 Nikos Balkanas : > Hi, > >>> I'm running this sqlbox on a deb

Re: SQLBox problems with postgresql

2010-07-28 Thread Milan P. Stanic
On Wed, 2010-07-28 at 13:05, Nikos Balkanas wrote: > >>I'm running this sqlbox on a debian unstable and using the kannel and > >>kannel-sqlbox packages from the official repositories. Do I have to > >>recompile sqlbox to include postgresql support? > > Definitely, unless you downloaded

Re: SQLBox problems with postgresql

2010-07-28 Thread Milan P. Stanic
On Wed, 2010-07-28 at 12:13, Arnau Rebassa wrote: > Hi Nikos, > > 2010/7/28 Nikos Balkanas : > > Hi, > > > >>>    I'm running this sqlbox on a debian unstable and using the kannel and > >>>    kannel-sqlbox packages from the official repositories. Do I have to > >>>    recompile sqlbox to include

Re: SQLBox problems with postgresql

2010-07-28 Thread Nikos Balkanas
Hi, As suspected: libmysqlclient_r.so.16 => /usr/lib/libmysqlclient_r.so.16 (0xb746e000) Try configure --help. BR, Nikos - Original Message - From: "Arnau Rebassa" To: Sent: Wednesday, July 28, 2010 1:13 PM Subject: Re: SQLBox problems with postgresql Hi Nikos, 20

Re: SQLBox problems with postgresql

2010-07-28 Thread Arnau Rebassa
Hi, I tried your configuration and the same error. I guess it's not compiled with the postgresql support. Anybody knows how to enable it? On Wed, Jul 28, 2010 at 11:43 AM, seikath wrote: > r...@bubu:[Wed Jul 28 12:41:59]:[~]$ cat /opt/kannel/etc/sqlbox.conf > group = sqlbox > id = sqlbox-db > s

Re: SQLBox problems with postgresql

2010-07-28 Thread Arnau Rebassa
Hi Nikos, 2010/7/28 Nikos Balkanas : > Hi, > >>>    I'm running this sqlbox on a debian unstable and using the kannel and >>>    kannel-sqlbox packages from the official repositories. Do I have to >>>    recompile sqlbox to include postgresql support? > > Definitely, unless you downloaded a postgr

Re: SQLBox problems with postgresql

2010-07-28 Thread Arnau Rebassa
Hi Alejandro, Then it's a bug in the sqlbox.conf file. I have just uncommented the postgresql section. On Wed, Jul 28, 2010 at 11:37 AM, Alejandro Guerrieri wrote: > The repeated "id = sqlbox-db" line on the connection it's a typo, or is it > actually repeated? If so, remove one and try again.

Re: SQLBox problems with postgresql

2010-07-28 Thread Nikos Balkanas
have please type: ldd $(which sqlbox) you will see that the binary is for mysql, not postgress. BR, Nikos - Original Message - From: "seikath" To: Sent: Wednesday, July 28, 2010 12:43 PM Subject: Re: SQLBox problems with postgresql r...@bubu:[Wed Jul 28 12:41:59]:[~]$ cat

Re: SQLBox problems with postgresql

2010-07-28 Thread seikath
r...@bubu:[Wed Jul 28 12:41:59]:[~]$ cat /opt/kannel/etc/sqlbox.conf group = sqlbox id = sqlbox-db smsbox-id = smsbox #global-sender = "" bearerbox-host = localhost bearerbox-port = 13001 smsbox-port = 13005 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = "/v

Re: SQLBox problems with postgresql

2010-07-28 Thread Alejandro Guerrieri
The repeated "id = sqlbox-db" line on the connection it's a typo, or is it actually repeated? If so, remove one and try again... On Wed, Jul 28, 2010 at 11:33 AM, Arnau Rebassa < arnau.mailingli...@gmail.com> wrote: > Hi all, > > I'm trying to configure sqlbox to run with PostgreSQL. When I try

SQLBox problems with postgresql

2010-07-28 Thread Arnau Rebassa
Hi all, I'm trying to configure sqlbox to run with PostgreSQL. When I try to start sqlbox from the command line, just to test if it creates de DB I get the following error message: debian:/etc/kannel# sqlbox 2010-07-28 11:25:08 [8521] [0] INFO: Debug_lvl = -1, log_file = , log_lvl = 0 2010-07-2