[opencms-dev] MySQL Serialization Error

[Christian Steinert]

Mekonnen, Daniel schrieb:
>
> Greetings,
> Last Friday we applied the 6.2.1 upgrad wizard to our 6.0.0 
> installation. It went without error but when trying to login to the 
> admin page it rejects all usernames. There error logs show that that a 
> stray "x" is appearing after the "=" sign as in: USER_INFO=x'A......'. 
> I poked through the web CVS interface but couldn't find where the 
> extra "x" is coming from. Likewise webusers to the site can no longer 
> get it. Below is the error message for the Admin user, the error is 
> identical in form for other users.
>
> Any help is much appreciated.
> Thanks!
> Daniel
> org.opencms.db.CmsDbSqlException: An SQL error occurred when executing 
> the following query: com.mysql.jdbc.PreparedStatement at 18346a3: UPDATE 
> CMS_USERS SET USER_DESCRIPTION='The admin 
> user',USER_FIRSTNAME='',USER_LASTNAME='',USER_EMAIL='',USER_LASTLOGIN=1149533119007,USER_FLAGS=0,USER_INFO=x'ACED0005737200136A6176612E7574696C2E486173687461626C6513BB0F25214AE4B803000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000877080000000B0000000274002D55534552505245464552454E4345535F776F726B706C6163652D7374617274757073657474696E6773736974657400012F74002F55534552505245464552454E4345535F776F726B706C6163652D7374617274757073657474696E6773666F6C6465727400132F73697465732F4F70656E546F6F6C6B69742F78',USER_ADDRESS='',USER_TYPE=0 
> WHERE USER_ID='c300ba5c-01e8-3727-b305-5dcc9ccae1ee'.
>
> at org.opencms.db.mysql.CmsUserDriver.writeUser(CmsUserDriver.java:166)
> at org.opencms.db.CmsDriverManager.loginUser(CmsDriverManager.java:4121)
> at 
> org.opencms.db.CmsSecurityManager.loginUser(CmsSecurityManager.java:2787)
> at org.opencms.file.CmsObject.loginUser(CmsObject.java:1836)
> at org.opencms.jsp.CmsJspLoginBean.login(CmsJspLoginBean.java:189)
> at org.opencms.jsp.CmsJspLoginBean.login(CmsJspLoginBean.java:169)
>
This is really weird.

I don't have trouble with 6.21 (after finding my own faults at least 
with some help from the list... - but I did not use 6.0.0; I went from 
5->6.03->6.04->6.20->6.21, I think)

Does login via cmsshell work?
Any old classes/jars lying around somewhere in your webapp folder?
Any strange log entries in your update.log?

Christian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20060606/5440826e/attachment.htm>