Hello,

We haven't tested ser_ctl with postgresql much, but this appears to be a bug in ser_ctl. May I ask you to create a bug ticket at http://tracker.iptel.org

thanks, Jan.

Marcus Better wrote:

Hi,

I'm trying to use SER 2.0 (daily snapshot) with a PostgreSQL backend, and have a few problems. What is the status of PostgreSQL support in SER?

I created the schema with the ser_postgres script. That didn't populate the version table, so I had to do that manually. Now I need to add a domain with ser_ctl, but get this:

ERROR: argument of AND must be type boolean, not type integer STATEMENT: SELECT did FROM domain WHERE 1 AND (NOT ((flags & 128)!='0')) AND (did='example.org') LIMIT 1

Is there another way to create domain entries, or should I switch to MySQL?

Regards,

Marcus Better

---

Serusers mailing list Serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

Hi,

Marcus Better napsal(a):

Hi,

I'm trying to use SER 2.0 (daily snapshot) with a PostgreSQL backend, and have a few problems. What is the status of PostgreSQL support in SER?

I created the schema with the ser_postgres script. That didn't populate the version table, so I had to do that manually. Now I need to add a domain with ser_ctl, but get this:

ERROR: argument of AND must be type boolean, not type integer STATEMENT: SELECT did FROM domain WHERE 1 AND (NOT ((flags & 128)!='0')) AND (did='example.org') LIMIT 1

Is there another way to create domain entries, or should I switch to MySQL?

Probably you could use serweb for create domain entries, etc. But it also has not been tested with postgres so much.

regards, Karel

Regards,

Marcus Better

---

Serusers mailing list Serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers