3 Sep
2009
3 Sep
'09
1:46 p.m.
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