Password change for imap user in mysql table

[intrusion]

Hello,

I resolved this problem writing a script that called vchangepw from vpopmail, but now after I succesfully changed the password, I have errors like :

Jul 24 14:19:22 2013-07-24 14: 19:22,459 open-xchange ERROR [com.openexchange.ajax.requesthandler.DispatcherSer vlet][OX-Logger]: com.openexchange.log.internal.callback.ErrorCallba ck,log Logged at: com.openexchange.ajax.requesthandler.DispatcherSer vlet.logException(DispatcherServlet.java:418)#012 com.openexchange.ajax.requestNumber=55#012 com.openexchange.ajpv13.remoteAddress=127.0.0.1#01 2 com.openexchange.ajpv13.remotePort=33179#012 com.openexchange.database.schema=oxa_5#012 com.openexchange.session.clientId=com.openexchange .ox.gui.dhtml#012 com.openexchange.session.contextId=1#012 com.openexchange.session.userId=6#012 #012 Error processing request:#012 com.openexchange.ajax.action=init#012 com.openexchange.ajp13.httpSession=f8148aeddc2641e fb5e018c222a56a38.OX0#012 com.openexchange.ajpv13.requestIp=10.20.30.1#012 com.openexchange.ajpv13.requestURI=/ajax/oauth/accounts#012 com.openexchange.ajpv13.serverName=mail.copeland.r o#012 com.openexchange.ajpv13.servletPath=/ajax/oauth/accounts#012 com.openexchange.ajpv13.threadName=AJP-Processor-0000037#012 com.openexchange.session.session={contextId=1, userId=6, sessionId=75ccc710625d4d33a54efd69dd29c0e3, login=daniel, localIp=10.20.30.1, authId=a84d8f82-d353-48c8-b3fd-a2ef38720000, hash=SzrJWpSFmizuC3t01ogmQ, client=com.openexchange.ox.gui.dhtml, transient=false}#012 com.openexchange.session.sessionId=75ccc710625d4d3 3a54efd69dd29c0e3#012
Jul 24 14:19:22 CRP-0001 Categories=USER_INPUT Message='Wrong Password.' exceptionID=1719996157-154
Jul 24 14:19:22 localhost.localdomain at com.openexchange.exception.OXExceptionFactory.crea te(OXExceptionFactory.java:151)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.crypto.CryptoErrorMessage.create( CryptoErrorMessage.java:161)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.crypto.internal.CryptoServiceImpl .decrypt(CryptoServiceImpl.java:246)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.crypto.internal.CryptoServiceImpl .decrypt(CryptoServiceImpl.java:148)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.crypto.internal.CryptoServiceImpl .decrypt(CryptoServiceImpl.java:139)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.secret.impl.CryptoSecretEncryptio nService.decrypthWithSecretService(CryptoSecretEnc ryptionService.java:279)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.secret.impl.CryptoSecretEncryptio nService.decrypt(CryptoSecretEncryptionService.jav a:238)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.oauth.internal.OAuthServiceImpl.g etAccount(OAuthServiceImpl.java:597)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.oauth.json.osgi.OSGiOAuthService. getAccount(OSGiOAuthService.java:98)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.oauth.json.oauthaccount.actions.I nitAction.reauthorizeCallbackAction(InitAction.jav a:198)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.oauth.json.oauthaccount.actions.I nitAction.perform(InitAction.java:112)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.ajax.requesthandler.DefaultDispat cher.perform(DefaultDispatcher.java:207)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.ajax.requesthandler.DispatcherSer vlet.handle(DispatcherServlet.java:345)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.ajax.requesthandler.DispatcherSer vlet.doGet(DispatcherServlet.java:282)
Jul 24 14:19:22 localhost.localdomain at javax.servlet.http.HttpServlet.service(HttpServlet .java:707)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.ajax.AJAXServlet.service(AJAXServ let.java:514)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.ajax.SessionServlet.service(Sessi onServlet.java:319)
Jul 24 14:19:22 localhost.localdomain at javax.servlet.http.HttpServlet.service(HttpServlet .java:820)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.ajp13.coyote.AjpProcessor.process (AjpProcessor.java:912)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.ajp13.coyote.sockethandler.Coyote Task.call(CoyoteTask.java:185)
Jul 24 14:19:22 localhost.localdomain at java.util.concurrent.FutureTask$Sync.innerRun(Futu reTask.java:334)
Jul 24 14:19:22 localhost.localdomain at java.util.concurrent.FutureTask.run(FutureTask.jav a:166)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.runTask(CustomThreadPoolExecuto r.java:799)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.run(CustomThreadPoolExecutor.ja va:826)
Jul 24 14:19:22 localhost.localdomain at java.lang.Thread.run(Thread.java:679)
Jul 24 14:19:22 localhost.localdomain aused by: javax.crypto.BadPaddingException: Given final block not properly padded
Jul 24 14:19:22 localhost.localdomain at com.sun.crypto.provider.CipherCore.doFinal(CipherC ore.java:811)
Jul 24 14:19:22 localhost.localdomain at com.sun.crypto.provider.CipherCore.doFinal(CipherC ore.java:676)
Jul 24 14:19:22 localhost.localdomain at com.sun.crypto.provider.AESCipher.engineDoFinal(AE SCipher.java:317)
Jul 24 14:19:22 localhost.localdomain at javax.crypto.Cipher.doFinal(Cipher.java:1813)
Jul 24 14:19:22 localhost.localdomain at com.openexchange.crypto.internal.CryptoServiceImpl .decrypt(CryptoServiceImpl.java:243)
Jul 24 14:19:22 localhost.localdomain ... 22 more

Could you help me to resolve this issues ? Until now I didn't had this problem.

Thanks!

[Wolfgang Rosenauer]

You can for sure write a simple script to change the password in your database. Just write any script using SQL doing this. I guess there is just noone reading here using qmail/vpopmail knowing its database. At least I don't.

[intrusion]

This is the final solution ? There is no other ? I still searching for a script to change the password for user in mysql vpopmail database. I don't believe that is not done a simple solution like this....

[intrusion]

Yes, this is a way, and I'm interested about this idea if I can't get it work in the way mentioned before.

Thanks!

[hbwinther]

If you can not get this solution to work you can make it the other way round. In our setup we do account management in openxchange and tell dovecot / postfix to authenticate the users with the openxchange mysql database. Drop me a note if you should be interested in more info.

[intrusion]

Hello,

Please tell me if I can use open-xchange-passwordchange-script for changing user password.
I configured open xchange for using open-xchange-imap. I use qmail+vpopmail (with mysql backend) and dovecot.
Please tell me if it's any solution to change the user password in the vpopmail database. From what I saw there are few scripts for changing password but are for ldap.

Thank you very much!