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

Tim Verhoeven tim.verhoeven.be at gmail.com
Thu Jul 16 17:34:21 CEST 2009


Hi,

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.

Thanks,
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)


More information about the Obm mailing list