OPEN-XCHANGE
You are here: Community > Mailinglist
freshmeat.net
[OX General] Problems with adduser_ox

emfau at t-online.de emfau at t-online.de
Wed Jan 11 16:46:43 CET 2006


Hi list,

I'm a newbie to open-xchange trying to install the latest stable version
(open-xchange-0.8.0-6.tar.gz) on a FreeBSD 6.0.
With the distributions's INSTALL file and how-tos for debian sarge and FreeBSD 
at hand I'm still not able to start the beast:-)

I successfully installed the applications and went through the initialization
steps as stated in the different documents up to the point where it is
suggested to create an initial user account using the adduser_ox script.
When calling

   ./adduser_ox --username="john" --passwd="password" --name="john"
     --sname="doe" --maildomain="example.org" --ox_timezone="Europe/Paris"

the following output is generated on the console

   LDAP Success
   LOG:  statement: SET TIME ZONE 'CET-1DST';INSERT INTO usr_general_rights
   SELECT creating_date, created_from, changing_date,
   changed_from,text('john'), addr_u, addr_r, addr_d, cont_u, cont_r, cont_d,
   data_u, data_r, data_d, serie_u, serie_r, serie_d, task_u, task_r, task_d,
   refer, proj_u, proj_r, proj_d, dfolder_u, dfolder_r, dfolder_d, doc_u,
   doc_r, doc_d, knowl_u, knowl_r, knowl_d, bfolder_u, bfolder_r, bfolder_d,
   bookm_u, bookm_r, bookm_d, pin_u, pin_r, pin_d, forum_n, fentrie_n, setup,
   pin_public, internal, int_groups, kfolder_u, kfolder_r, kfolder_d, webmail
   FROM sys_gen_rights_template WHERE login LIKE 'default_template'
   LOG:  duration: 104.032 ms
   SQL Error
   Deleting User from LDAP

and the logfile contains

   Jan 11 02:33:00 ox pgsql[1531]: [22-1] ERROR:  42804: column "creating_date"
   	is of type timestamp with time zone but expression is of type character
   	varying
   Jan 11 16:15:52 ox pgsql[650]: [18-2] HINT:  You will need to rewrite or cast
   	the expression.

I'm pretty clueless with respect to databases in general so I'm kind of lost
here.

Installed are postgresql-client-8.0.5, postgresql-jdbc-8.1.404 and postgresql-
server-8.0.5_1.

Any suggestions how to correct the "creating_date" issue?

If there is more information needed please let me know.

Thanks in advance
  Michael




More information about the General mailing list