[Obm] Re: SQL error adding admin user for a newly created domain

[Tim Verhoeven]

On Thu, Jul 16, 2009 at 5:34 PM, Tim
Verhoeven<tim.verhoeven.be at gmail.com> wrote:
>
> I'm getting these SQL errors :
>
> Database error: Invalid SQL: INSERT INTO UserObm ( userobm_domain_id,
> userobm_timeupdate, userobm_timecreate, userobm_userupdate,
> userobm_usercreate, userobm_login, userobm_password,
> userobm_password_type, userobm_perms, userobm_uid, userobm_gid,
> userobm_archive, userobm_hidden, userobm_datebegin,
> userobm_account_dateexp, userobm_kind, userobm_lastname,
> userobm_firstname, userobm_title, userobm_company, userobm_direction,
> userobm_service, userobm_address1, userobm_address2, userobm_address3,
> userobm_zipcode, userobm_town, userobm_expresspostal,
> userobm_country_iso3166, userobm_phone, userobm_phone2,
> userobm_mobile, userobm_fax, userobm_fax2, userobm_email ,
> userobm_delegation_target , userobm_delegation, userobm_description ,
> userobm_web_perms, userobm_web_all, userobm_web_list ,
> userobm_mail_perms, userobm_mail_ext_perms, userobm_mail_server_id,
> userobm_mail_quota , userobm_email_nomade, userobm_nomade_perms,
> userobm_nomade_enable, userobm_nomade_local_copy ,
> userobm_vacation_enable, userobm_vacation_datebegin,
> userobm_vacation_dateend, userobm_vacation_message ) VALUES ( 2,
> NOW(), NOW(), 1, 1, 'admin1', 'admin', 'PLAIN', 'admin', '1003',
> '1000', 0, 0, null, null, 'Administrator', 'Administrator', '', '',
> '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '' , '' ,
> '', '' , 0, 0, '' , 0, 0, NULL, 0 , '', NULL, NULL, NULL , 0, null,
> null, '' )
> PostgreSQL Error: 1 (ERROR: value too long for type character varying(12))
> Database error: Invalid SQL: INSERT INTO UserObmGroup
> (userobmgroup_group_id, userobmgroup_userobm_id) VALUES (1, NULL)
> PostgreSQL Error: 1 (ERROR: null value in column
> "userobmgroup_userobm_id" violates not-null constraint)
>
> When I tried to create a admin user for a newly created domain. Anyone
> any idea what is wrong here ? This is a fresh install using OBM 2.2.6
> and with PostgreSQL as DB.
>

Did anyone had the change to have a look at this ? I'm stuck right now
since I can't create a admin user for my normal domain, so I can't
create normal users etc.

If anything else is needed or if I need to test certain things, just
let me know.

Regards,
Tim

-- 
Tim Verhoeven - tim.verhoeven.be at gmail.com - 0479 / 88 11 83

Hoping the problem  magically goes away  by ignoring it is the
"microsoft approach to programming" and should never be allowed.
(Linus Torvalds)