[Kamailio-Users] Siremis with postgres

[Karl Heinz Wolf]

I just tried to get Siremis working with postgres. First I had
problems because I created the table and columns with uppercase
letters and the behaviour of mysql and postgres is different in this
aspect so the Siremis queries weren't successful.

Now I created the user access table the following way:

CREATE TABLE ob_users (
  sysid serial NOT NULL,
  userid varchar(15) NOT NULL,
  password varchar(15) default NULL,
  PRIMARY KEY  (sysid)
);

I also modified Config.xml:

Driver="Pdo_Pgsql" instead of Driver="Pdo_Mysql"

and Siremis seems to work fine with postgres.

cheers,
karl heinz