The mailing list for listmasters using Sympa

[Olivier Salaün - CRU <address@concealed>]

You are right.
We did a mistake in the create_db.Oracle and it looks like we don't have 
that many users using Oracle...

Here is a patch from the CVS stable branch :
http://sourcesup.cru.fr/cgi/viewcvs.cgi/sympa/src/etc/script/create_db.Oracle.diff?r1=1.9&r2=1.9.8.1&cvsroot=sympa&only_with_tag=sympa-5_0-branch

Thanks for reporting this.

address@concealed wrote:

> Am I the only one having trouble creating the admin_table on an Oracle DB?
>
> Our Oracle DBA insists that there is no such thing as an enum in Oracle and 
> that the provided table creation parameters are just plain wrong.  Since I 
> can not create the table as suggested I assume he
> is correct.
>
> In particular, the line:
>
>    role_admin              number('listmaster','owner','editor') NOT NULL,
>
> is not valid in an Oracle database.
>
> What am I missing here?  Has anyone managed to get Sympa running with an 
> Oracle DB (with the enums needed in the admin_table)
>
> thanks!
>

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature