RE: smsd and postgres with schemas problem

[Rogers, Paul]

Jan

Have patched as suggested. I now get the following error message.

177: SELECT FROM (null).outbox command failed.
Error: ERROR:  syntax error at or near "null" at character 40

To confirm I did everything else correctly:

1. Copied diff file to gnokii directory
2. patch -p1 < pq-schema.diff

This failed at Hunk 1 but as this only appeared to be ChangeLog I
ingnored it.

3. make; make libpq.la; make install

4. smsd -u username -p password -c hostname -d mowlem -s sms -m pq

It appears the schema name isn't being passed on (I guess).

Any thoughts?


Paul 

-----Original Message-----
From: address@hidden
[mailto:address@hidden On
Behalf Of Jan Derfinak
Sent: 29 January 2006 23:56
To: Discussion forum for gnokii users.
Subject: Re: smsd and postgres with schemas problem


On Thu, 26 Jan 2006 address@hidden wrote:

> Dear All
>  
> We have been using smsd on mysql and now wish to change the underlying

> database to postgres so the sms functionality is available to other 
> applications we use.  The smd daemon connects the database but is 
> unable to find the outbox table. I think that the problem is that the 
> database uses schemas so while I can specify the database name using 
> the -d option I am unable to specify the schema.

Please try the attached patch and let me know the result. Specify schema
with -s or --schema.

Did you use schemas with mysql? I searched documentation but schema in
mysql is only alias to database.

jan

-------------------------------------------------------------------
This email and any attachments transmitted with it are confidential (and 
potentially legally privileged) and intended solely for the use of the 
individual or entity to whom they are addressed. If you have received this 
email in error please notify the sender and do not store, copy or disclose the 
content to any other person.
It is the responsibility of the recipient to ensure that opening this message 
and/or any of its attachments will not adversely affect its systems. No 
responsibility is accepted by the sender.
-------------------------------------------------------------------