Re: ERROR: MYSQL: can not connect to database!

2010-07-28 Thread Cezary Siwek
Hi, Have you tried to add the port definition in the mysql-connection group? port = 3306 BR - Original Message - From: "Aldo Zavala" To: Sent: Tuesday, July 27, 2010 8:14 PM Subject: Re: ERROR: MYSQL: can not connect to database! Sorry, I forgot to post the sqlbox.conf grou

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

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

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

[SOLVED] Re: sms is not delivered to phone

2010-07-28 Thread dorian
Thanks a lot for the hint. It was very helpful. Having the dlr err response I've contacted with SMSC people and it turned out that there is a filter which forbade to send to another operators. The problem is fixed now. But I have another question. In my config file I have store-type = "spool"

Re: ERROR: MYSQL: can not connect to database!

2010-07-28 Thread Nikos Balkanas
Hi, That makes all the difference. You should have mentioned it before we started, so that we didn't waiste all this time. It crashes when sqlbox tries to create the tables in Mysql. That part works fine in Linux. Talk to the guys in VsPhere. BR, Nikos - Original Message - From: "Al

Re: SQLBox problems with postgresql

2010-07-28 Thread 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 postgress specific binary. To confirm what you have ple

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: [SOLVED] Re: sms is not delivered to phone

2010-07-28 Thread Nikos Balkanas
Hi, 1) Directories are constant and reused. Do not delete. 2) They are a maximum of 100, to optimize file access times. 3) Some hash from the message-id, which is really not all that important. BR, Nikos - Original Message - From: "dorian" To: "Nikos Balkanas" Cc: Sent: Wednesday, J

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, 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 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, 2010/7/28 Nikos B

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 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 Nikos Balkanas
It is there. If it is not, ldd will say 'not found'. Not so. It will say "Not found" only if it was compiled with support for it. If not it won't say anything. The only thing I see is mysqlclient. If you see postgress library please point out. BR, Nikos - Original Message - From: "M

Re: SQLBox problems with postgresql

2010-07-28 Thread Nikos Balkanas
OK. Where is the postgress client library in the ldd output? Lastly what's the point of compiling with all DBs? It would require the client to have all 3 DB's installed, just to run it, even if not using them! BR, Nikos - Original Message - From: "Milan P. Stanic" To: Sent: Wednesda

Re: SQLBox problems with postgresql

2010-07-28 Thread Milan P. Stanic
On Wed, 2010-07-28 at 14:53, Nikos Balkanas wrote: > >It is there. If it is not, ldd will say 'not found'. > > Not so. It will say "Not found" only if it was compiled with support > for it. If not it won't say anything. The only thing I see is > mysqlclient. If you see postgress library please poi

Re: SQLBox problems with postgresql

2010-07-28 Thread Milan P. Stanic
On Wed, 2010-07-28 at 14:55, Nikos Balkanas wrote: > OK. Where is the postgress client library in the ldd output? Look at my answer to your previous question in the same thread. > Lastly what's the point of compiling with all DBs? It would require > the client to have all 3 DB's installed, just t

unable to receive messages into kannel

2010-07-28 Thread macboy
Hi Folks I have configured kannel on fedora 13 and presently am able to send out messages from the system but am so unfortunate when i send the sms back to the platorm.I am using nokia 6303 as my modem but whenever i send the messages to the system they only land on the phone and i tried with

Re: SQLBox problems with postgresql

2010-07-28 Thread Nikos Balkanas
Thanks for pointing that out. Didn't know that libpq.so is Postgressql. I agree that this point belongs to ubuntu devel, but please also consider the case at hand: Sqlbox is a bit intelligent about its DB. It generates its own tablesand indeces. In the process it also tries to figure out what

unable to receive messages into kannel

2010-07-28 Thread macboy
Hi Folks I have configured kannel on fedora 13 and presently am able to send out messages from the system but am so unfortunate when i send the sms back to the platorm.I am using nokia 6303 as my modem but whenever i send the messages to the system they only land on the phone and i tried with

Re: unable to receive messages into kannel

2010-07-28 Thread Nikos Balkanas
Why 2 exact same emails? 1 is not enough? Nikos - Original Message - From: To: Sent: Wednesday, July 28, 2010 3:58 PM Subject: unable to receive messages into kannel Hi Folks I have configured kannel on fedora 13 and presently am able to send out messages from the system but am s

Re: unable to receive messages into kannel

2010-07-28 Thread tariq sand
hi,try sim-buffering = true in smsc group and message-storage = "SM"  in modem groupi hope it helpsBRSando --- On Wed, 7/28/10, mac...@fastermail.com wrote: From: mac...@fastermail.com Subject: unable to receive messages into kannel To: users@kannel.org Date: Wednesday, July 28, 2010, 5:25 AM

Re: ERROR: MYSQL: can not connect to database!

2010-07-28 Thread Aldo Zavala
Yes I did and still don't work. Thanks, Aldo Zavala 24/7 (760).890.4221 Mobile (760).556.5050 Office (760).234.0015 GTalk: aldo.zav...@gmail.com - Original Message - From: Cezary Siwek [mailto:cza...@thebestisp.co.uk] To: users@kannel.org, Aldo Zavala [mailto:a...@cleartalk.net] Sen

Re: Telnet device (Multi-Tech MTCBA-G-EN-F4)

2010-07-28 Thread Arnau Rebassa
Hi all, 2010/7/27 Nikos Balkanas : > 1) Use keyword = default in your sms-service. > 2) Read User's guide about configuring smsbox-route. Thank you everybody for your help, I already received the MO and I'm able to deliver them to an URL. The problem I'm facing now is although I have configured

Re: Telnet device (Multi-Tech MTCBA-G-EN-F4)

2010-07-28 Thread Nikos Balkanas
Hi, What you have as service_number is the destination number. What is the meaning of destination number for an MO? Nothing at all. The sms will go back to the sender, which is you enduser_number. BR, Nikos - Original Message - From: "Arnau Rebassa" To: Sent: Wednesday, July 28,

Re: unable to receive messages into kannel

2010-07-28 Thread tariq sand
i am actually using SIEMENS MC39i modem.here is my configuration file: kannel.conf// // // // // // /group = coreadmin-port

Re: Telnet device (Multi-Tech MTCBA-G-EN-F4)

2010-07-28 Thread Arnau Rebassa
Hi Nikos, On Wednesday, July 28, 2010, Nikos Balkanas wrote: > Hi, > > What you have as service_number is the destination number. What is the > meaning of destination number for an MO? Nothing at all. The sms will go back > to the sender, which is you enduser_number. In my case is important

Re: Telnet device (Multi-Tech MTCBA-G-EN-F4)

2010-07-28 Thread Nikos Balkanas
Hi, All you need is the sender number. In MOs destination number = sender number. Get the short code from there. It is not going anywhere else, just the place it originated from. BR, Nikos - Original Message - From: "Arnau Rebassa" Cc: Sent: Thursday, July 29, 2010 12:07 AM Subjec