You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by mi...@eledia.de on 2013/02/09 15:23:04 UTC
Problems with installing OM 2.1 on postgresql
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))
Re: Problems with installing OM 2.1 on postgresql
Posted by mi...@eledia.de.
Hello Maxim,
now with the Revision 1444312 (the change of the table name 'user' to
'om_user') the installation of OM succeed with postgresql.
Thank you!
Michael
> 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, <mi...@eledia.de> 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
>
Re: Problems with installing OM 2.1 on postgresql
Posted by Maxim Solodovnik <so...@gmail.com>.
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, <mi...@eledia.de> 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