Mailing-List: contact user-help@openmeetings.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@openmeetings.apache.org
Received-SPF: pass (athena.apache.org: domain of solomax666@gmail.com
 designates 209.85.160.43 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <36045.92.231.250.47.1360419784.squirrel@webmail.eledia.de>
References: <687297651.20130207193829@3bits.es>
	<55D8E823-095E-443D-AC3A-018DDA7BBC48@robertbird.com.au>
	<D72A6642D1DDEE4BBFD7E6CE187F89C101AB3722@rbg-bne-exchang.robertbird.internal>
	<E86A54E2C01E064DA91E86EB4AF1772A0EB9@gcs2.CO2CRC.local>
	<1360312956.75675.YahooMailNeo@web162403.mail.bf1.yahoo.com>
	<CACeMiA8iV_m7ejKe6GtN9i_W5WPcaiByCov7Row-n50sqQ86mg@mail.gmail.com>
	<36045.92.231.250.47.1360419784.squirrel@webmail.eledia.de>
Date: Sat, 9 Feb 2013 21:55:46 +0700
Message-ID: 
 <CAJmbs8jTHE=GOq=iExV9QawG5eHrSgcQYZ47URce-_FUaF7AwQ@mail.gmail.com>
Subject: Re: Problems with installing OM 2.1 on postgresql
From: Maxim Solodovnik <solomax666@gmail.com>
To: user <user@openmeetings.apache.org>
Content-Type: multipart/alternative; boundary=f46d042f9494ecff5f04d54bdef9

--f46d042f9494ecff5f04d54bdef9
Content-Type: text/plain; charset=UTF-8

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, <michael.wuttke@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

--f46d042f9494ecff5f04d54bdef9
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I have changed the table name for the user, to be om_user<=
div style>It should work now.</div><div style><br></div><div style>this mig=
ht be the temporary solution. We double check all databases before release<=
/div>
</div><div class=3D"gmail_extra"><br><br><div class=3D"gmail_quote">On Sat,=
 Feb 9, 2013 at 9:23 PM,  <span dir=3D"ltr">&lt;<a href=3D"mailto:michael.w=
uttke@eledia.de" target=3D"_blank">michael.wuttke@eledia.de</a>&gt;</span> =
wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">Hello,<br>
<br>
I tried to install the latest build of OM 2.1<br>
(2.1.0.r1444299-09-02-2013_0050) on postgres (9.1) under debian wheezy.<br>
<br>
But the last five tables of the database (user, user_contact, user_data,<br=
>
user_level, whiteboard) where not created, not by using the red5-script<br>
for init.d nor by using the red5-debug script.<br>
<br>
What do I have to do to finish the installation?<br>
<br>
In general:<br>
Is it possilbe to use postgresql instead of mysql? Or is mysql the<br>
reference-database for OM?<br>
<br>
Thank you for your help!<br>
Michael<br>
<br>
PS: Here are an excerpt of the postgres-log:<br>
2013-02-09 16:07:24 CET ANWEISUNG: =C2=A0CREATE TABLE user (id BIGSERIAL NO=
T<br>
NULL, activatehash VARCHAR(255), age TIMESTAMP, availible INTEGER, deleted<=
br>
BOOL, externalUserId VARCHAR(255), externalUserType VARCHAR(255),<br>
firstname VARCHAR(255), forceTimeZoneCheck BOOL, language_id BIGINT,<br>
lastlogin TIMESTAMP, lastname VARCHAR(255), lasttrans BIGINT, level_id<br>
BIGINT, login VARCHAR(255), password VARCHAR(255), pictureuri<br>
VARCHAR(255), regdate TIMESTAMP, resethash VARCHAR(255), salutations_id<br>
BIGINT, sendSMS BOOL, show_contact_data BOOL,<br>
show_contact_data_to_contacts BOOL, starttime TIMESTAMP, status INTEGER,<br=
>
updatetime TIMESTAMP, user_offers VARCHAR(255), user_searchs VARCHAR(255),<=
br>
adresses_id BIGINT, omtimezoneId BIGINT, sip_user_id BIGINT, PRIMARY KEY<br=
>
(id))<br>
</blockquote></div><br><br clear=3D"all"><div><br></div>-- <br>WBR<br>Maxim=
 aka solomax
</div>

--f46d042f9494ecff5f04d54bdef9--