I have changed the table name for the user, to be om_user It should work now.
this might be the temporary solution. We double check all databases before release On Sat, Feb 9, 2013 at 9:23 PM, <[email protected]> wrote: > Hello, > > I tried to install the latest build of OM 2.1 > (2.1.0.r1444299-09-02-2013_0050) on postgres (9.1) under debian wheezy. > > But the last five tables of the database (user, user_contact, user_data, > user_level, whiteboard) where not created, not by using the red5-script > for init.d nor by using the red5-debug script. > > What do I have to do to finish the installation? > > In general: > Is it possilbe to use postgresql instead of mysql? Or is mysql the > reference-database for OM? > > Thank you for your help! > Michael > > PS: Here are an excerpt of the postgres-log: > 2013-02-09 16:07:24 CET ANWEISUNG: CREATE TABLE user (id BIGSERIAL NOT > NULL, activatehash VARCHAR(255), age TIMESTAMP, availible INTEGER, deleted > BOOL, externalUserId VARCHAR(255), externalUserType VARCHAR(255), > firstname VARCHAR(255), forceTimeZoneCheck BOOL, language_id BIGINT, > lastlogin TIMESTAMP, lastname VARCHAR(255), lasttrans BIGINT, level_id > BIGINT, login VARCHAR(255), password VARCHAR(255), pictureuri > VARCHAR(255), regdate TIMESTAMP, resethash VARCHAR(255), salutations_id > BIGINT, sendSMS BOOL, show_contact_data BOOL, > show_contact_data_to_contacts BOOL, starttime TIMESTAMP, status INTEGER, > updatetime TIMESTAMP, user_offers VARCHAR(255), user_searchs VARCHAR(255), > adresses_id BIGINT, omtimezoneId BIGINT, sip_user_id BIGINT, PRIMARY KEY > (id)) > -- WBR Maxim aka solomax
