Error with long name

I have an user which family name is 18 characters long his name is 6
Characters long.
I use the LDAP import. It imports many important fields, you can see
something in the first log line, which creates my ldap import.
If I insert the user manually in the web interface, the user is created.
It is strange that it says value too long on creating users by my
script…
Ho someone have an idea?

Thanks

Samuel

[Tue Oct 14 11:47:42 2003] [debug]: after import Comments Xxxxxxx xx
Xxxxxx City Xxxxxxx RealName Xxxxxxxxxxxxxxxxxx Xxxxxx EmailAddress
Xxxxxx.Xxxxxxxxxxxxxxxxxx@xxxxx.xx
mailto:Xxxxxx.Xxxxxxxxxxxxxxxxxx@xxxxx.xx Country Italy Address1
Xxxxxxxxxxxxx x Zip xxxxx WorkPhone xxx xxxx xxx Organization Xxxxxx
Xxxxxxxxxx xx Xxxxxxx Name XXxxxxxxxxxxxxxxxxx
(/usr/share/perl5/RT/EmailParser_Local.pm:116)
[Tue Oct 14 11:47:42 2003] [warning]: DBD::Pg::st execute failed: ERROR:
value too long for type character varying(16) at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 410, line 283.
(/usr/share/perl5/RT.pm:235)
[Tue Oct 14 11:47:42 2003] [warning]: RT::Handle=HASH(0x8b32554)
couldn’t execute the query ‘INSERT INTO Users (Comments, City, RealName,
EmailAddress, Creator, Gecos, Password, Country, LastUpdatedBy,
Address1, WorkPhone, Zip, Created, id, Organization, Name, LastUpdated)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 417, line 283.
(/usr/share/perl5/RT.pm:235)
[Tue Oct 14 11:47:42 2003] [error]: Could not create a new user -
(/usr/share/perl5/RT/User_Overlay.pm:277)
[Tue Oct 14 11:47:43 2003] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, queries ignored until end of transaction
block at /usr/share/perl5/Apache/Session/Store/DBI.pm line 65.
(/usr/share/perl5/RT.pm:235)
[Tue Oct 14 11:47:43 2003] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, queries ignored until end of transaction
block at /usr/share/perl5/Apache/Session/Store/DBI.pm line 65.
(/usr/share/perl5/RT.pm:235)
[Tue Oct 14 11:47:43 2003] [warning]: DBD::Pg::st execute failed: ERROR:
current transaction is aborted, queries ignored until end of transaction
block at /usr/share/perl5/Apache/Session/Store/DBI.pm line 65.
(/usr/share/perl5/RT.pm:235)

Senoner Samuel wrote:

It is strange that it says value too long on creating users by my
script…
[Tue Oct 14 11:47:42 2003] [warning]: DBD::Pg::st execute failed: ERROR:
value too long for type character varying(16) at

So, you’re trying to insert more than 16 characters into
a 16-character-wide field. Looking at the schema, the
possibilities are:

NickName varchar(16) NULL ,
Lang varchar(16) NULL ,
EmailEncoding varchar(16) NULL ,
WebEncoding varchar(16) NULL ,
Gecos varchar(16) NULL ,

My bet is on either NickName or Gecos.
Phil Homewood, Systems Janitor, http://www.SnapGear.com
pdh@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances

I only insert this fields.

Comments Xxxxxxx xx Xxxxxx City Xxxxxxx RealName Xxxxxxxxxxxxxxxxxx
Xxxxxx EmailAddress Xxxxxx.Xxxxxxxxxxxxxxxxxx@xxxxx.xx Country Italy
Address1 Xxxxxxxxxxxxx x Zip xxxxx WorkPhone xxx xxxx xxx Organization
Xxxxxx Xxxxxxxxxx xx Xxxxxxx Name XXxxxxxxxxxxxxxxxxx

And after I created the user manually it was ok, as far I see from my
webinterface…From: Phil Homewood [mailto:pdh@snapgear.com]
Sent: Friday,24 October,2003 10:10
To: rt-devel@lists.fsck.com

Senoner Samuel wrote:

It is strange that it says value too long on creating users by my
script…
[Tue Oct 14 11:47:42 2003] [warning]: DBD::Pg::st execute failed:
ERROR:
value too long for type character varying(16) at

So, you’re trying to insert more than 16 characters into a
16-character-wide field. Looking at the schema, the possibilities are:

NickName varchar(16) NULL ,
Lang varchar(16) NULL ,
EmailEncoding varchar(16) NULL ,
WebEncoding varchar(16) NULL ,
Gecos varchar(16) NULL ,

My bet is on either NickName or Gecos.
Phil Homewood, Systems Janitor, http://www.SnapGear.com pdh@snapgear.com
Ph: +61 7 3435 2810 Fx: +61 7 3891 3630 SnapGear - Custom Embedded
Solutions and Security Appliances
rt-devel mailing list
rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

Sorry Phil, you are right
It can be gecos, because I set in autohandler that gecos data is the
username.
For what is gecos used?
For which use should I set gecos to username in the user db?

Thanks

SamuelFrom: Senoner Samuel
Sent: Friday,24 October,2003 10:27
To: Phil Homewood; rt-devel@lists.fsck.com

I only insert this fields.

Comments Xxxxxxx xx Xxxxxx City Xxxxxxx RealName Xxxxxxxxxxxxxxxxxx
Xxxxxx EmailAddress Xxxxxx.Xxxxxxxxxxxxxxxxxx@xxxxx.xx Country Italy
Address1 Xxxxxxxxxxxxx x Zip xxxxx WorkPhone xxx xxxx xxx Organization
Xxxxxx Xxxxxxxxxx xx Xxxxxxx Name XXxxxxxxxxxxxxxxxxx

And after I created the user manually it was ok, as far I see from my
webinterface…

From: Phil Homewood [mailto:pdh@snapgear.com]
Sent: Friday,24 October,2003 10:10
To: rt-devel@lists.fsck.com

Senoner Samuel wrote:

It is strange that it says value too long on creating users by my
script…
[Tue Oct 14 11:47:42 2003] [warning]: DBD::Pg::st execute failed:
ERROR:
value too long for type character varying(16) at

So, you’re trying to insert more than 16 characters into a
16-character-wide field. Looking at the schema, the possibilities are:

NickName varchar(16) NULL ,
Lang varchar(16) NULL ,
EmailEncoding varchar(16) NULL ,
WebEncoding varchar(16) NULL ,
Gecos varchar(16) NULL ,

My bet is on either NickName or Gecos.
Phil Homewood, Systems Janitor, http://www.SnapGear.com pdh@snapgear.com
Ph: +61 7 3435 2810 Fx: +61 7 3891 3630 SnapGear - Custom Embedded
Solutions and Security Appliances
rt-devel mailing list
rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

rt-devel mailing list
rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel