You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Sandro Isoletta <sa...@pl.rlp.de> on 2014/04/03 08:55:40 UTC
Re: OM 3.0 - Can not login with imported users
Anything new about this bug?
Am 31.03.2014 13:20, schrieb Sandro Isoletta:
> Yes, I sent you a copy of our database to
>
> solomax666@gmail.com
>
>
>
> Am 28.03.2014 10:40, schrieb Maxim Solodovnik:
>> Is it possible to get this backup privately to investigate/fix this issue?
>>
>>
>> On Fri, Mar 28, 2014 at 4:38 PM, Sandro Isoletta <sandro.isoletta@pl.rlp.de
>> <ma...@pl.rlp.de>> wrote:
>>
>> Yes, we only have 66 users and all of them are assigned to an
>> organization ( select * from organisation_users > user_id and
>> organisation_id is filled)
>>
>> Am 28.03.2014 10:08, schrieb Maxim Solodovnik:
>> > Can you check if these users are assigned to any organization?
>> >
>> >
>> > On Fri, Mar 28, 2014 at 3:26 PM, Peter Dähn <daehn@vcrp.de
>> <ma...@vcrp.de>
>> > <mailto:daehn@vcrp.de <ma...@vcrp.de>>> wrote:
>> >
>> > Hallo,
>> >
>> > we have the same issue here...
>> >
>> > I thought it was related to the use here as standalone and plugged in
>> > via API to our LMS. So I didn't investigate because we didn't use
>> > standalone that much...
>> >
>> > Try to find out something...
>> >
>> > BR Peter
>> >
>> > Am 28.03.2014 08:12, schrieb Sandro Isoletta:
>> > > Good morning,
>> > >
>> > > I can't find any exeptions. I put you a copy of the output of both
>> logs
>> > > (openmeetings.log and jvm.out) when I try to login.
>> > >
>> > > Am 27.03.2014 17:13, schrieb Maxim Solodovnik:
>> > >> Hello,
>> > >>
>> > >> while "can not login anymore." are there any exceptions in the logs?
>> > >>
>> > >>
>> > >> On Thu, Mar 27, 2014 at 10:16 PM, Sandro Isoletta
>> > <sandro.isoletta@pl.rlp.de <ma...@pl.rlp.de>
>> <mailto:sandro.isoletta@pl.rlp.de <ma...@pl.rlp.de>>
>> > >> <mailto:sandro.isoletta@pl.rlp.de
>> <ma...@pl.rlp.de> <mailto:sandro.isoletta@pl.rlp.de
>> <ma...@pl.rlp.de>>>>
>> > wrote:
>> > >>
>> > >> Hi,
>> > >>
>> > >> I have run an update from OpenMeetings 2.20 to OpenMeetings 3.0.
>> > >> I followed the upgrade instructions on your site
>> > >>
>> > >> http://openmeetings.apache.org/Upgrade.html
>> > >>
>> > >> The upgrade worked fine, but after importing my backup I have
>> the issue,
>> > >> that all imported users with the exception of the admin accounts
>> > >> can not login anymore.
>> > >> When I add a new user, everything is fine. I used the encryption
>> > method by
>> > >> default (org.apache.openmeetings.util.crypt.MD5Implementation).
>> > >>
>> > >> After that, I tried it a second time and choose the bsd
>> encryption
>> > method
>> > >> (org.apache.openmeetings.utils.crypt.MD5CryptImplementation), but
>> > this one
>> > >> failed completely.
>> > >> I've got the message:
>> > >>
>> > >>
>> > >> Installation is failed
>> > >>
>> > >> java.lang.NullPointerException
>> > >> at
>> >
>> org.apache.openmeetings.data.user.UserManager.registerUserInit(UserManager.java:738)
>> > >> at
>> >
>> org.apache.openmeetings.data.user.UserManager$$FastClassByCGLIB$$c43b186d.invoke(<generated>)
>> > >> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
>> > >> at
>> >
>> org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
>> > >> at
>> >
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
>> > >> at
>> >
>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
>> > >> at
>> >
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
>> > >> at
>> >
>> org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
>> > >> at
>> >
>> org.apache.openmeetings.data.user.UserManager$$EnhancerByCGLIB$$ed09b855.registerUserInit(<generated>)
>> > >> at
>> >
>> org.apache.openmeetings.installation.ImportInitvalues.loadInitUserAndOrganisation(ImportInitvalues.java:655)
>> > >> at
>> >
>> org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:999)
>> > >> at
>> >
>> org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess.run(InstallWizard.java:389)
>> > >> at java.lang.Thread.run(Thread.java:724)
>> > >>
>> > >>
>> > >> With kind regards
>> > >>
>> > >> --
>> > >> Sandro Isoletta
>> > >> Abteilung 4 Zentrale Dienste und IT-Dienste
>> > >> Referat 4.07 Schulische IT-Dienstleistungen
>> > >> PÄDAGOGISCHES LANDESINSTITUT RHEINLAND-PFALZ
>> > >>
>> > >>
>> > >> Hofstraße 257c
>> > >> 56077 Koblenz
>> > >> it-support@pl.rlp.de <ma...@pl.rlp.de>
>> <mailto:it-support@pl.rlp.de <ma...@pl.rlp.de>>
>> > <mailto:it-support@pl.rlp.de <ma...@pl.rlp.de>
>> <mailto:it-support@pl.rlp.de <ma...@pl.rlp.de>>>
>> > >> www.pl.rlp.de <http://www.pl.rlp.de> <http://www.pl.rlp.de>
>> <http://www.pl.rlp.de>
>> > >>
>> > >>
>> > >>
>> > >>
>> > >>
>> > >> --
>> > >> WBR
>> > >> Maxim aka solomax
>> > >
>> >
>> >
>> >
>> >
>> > --
>> > WBR
>> > Maxim aka solomax
>>
>>
>> --
>> Sandro Isoletta
>> Abteilung 4 Zentrale Dienste und IT-Dienste
>> Referat 4.07 Schulische IT-Dienstleistungen
>> PÄDAGOGISCHES LANDESINSTITUT RHEINLAND-PFALZ
>>
>>
>> Hofstraße 257c
>> 56077 Koblenz
>> it-support@pl.rlp.de <ma...@pl.rlp.de>
>> www.pl.rlp.de <http://www.pl.rlp.de>
>>
>>
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>
--
Sandro Isoletta
Abteilung 4 Zentrale Dienste und IT-Dienste
Referat 4.07 Schulische IT-Dienstleistungen
PÄDAGOGISCHES LANDESINSTITUT RHEINLAND-PFALZ
Hofstraße 257c
56077 Koblenz
it-support@pl.rlp.de
www.pl.rlp.de
Re: OM 3.0 - Can not login with imported users
Posted by Sandro Isoletta <sa...@pl.rlp.de>.
We figured out a work around for this bug.
We had run this sql script:
use openmeetings;
update om_user set externalUserType=NULL;
update om_user set externalUserId=NULL;
update om_user set availible=NULL;
update om_user set pictureuri=NULL;
update om_user set resethash=NULL;
update om_user set lasttrans=NULL;
And after that it was possible to login with all imported users.
We have installed this branch:
svn co http://svn.apache.org/repos/asf/openmeetings/branches/3.0.x
Greetings
--
Sandro Isoletta
Abteilung 4 Zentrale Dienste und IT-Dienste
Referat 4.07 Schulische IT-Dienstleistungen
PÄDAGOGISCHES LANDESINSTITUT RHEINLAND-PFALZ
Hofstraße 257c
56077 Koblenz
it-support@pl.rlp.de
www.pl.rlp.de
Re: OM 3.0 - Can not login with imported users
Posted by Maxim Solodovnik <so...@gmail.com>.
Hello Sandro,
was extremely busy on my regular work these days
will try to address this today
I be on business trip since tomorrow (ApacheCon Denver) maybe will be able
to work on it during trip
Thanks for the backup
On Thu, Apr 3, 2014 at 1:55 PM, Sandro Isoletta
<sa...@pl.rlp.de>wrote:
> Anything new about this bug?
>
> Am 31.03.2014 13:20, schrieb Sandro Isoletta:
> > Yes, I sent you a copy of our database to
> >
> > solomax666@gmail.com
> >
> >
> >
> > Am 28.03.2014 10:40, schrieb Maxim Solodovnik:
> >> Is it possible to get this backup privately to investigate/fix this
> issue?
> >>
> >>
> >> On Fri, Mar 28, 2014 at 4:38 PM, Sandro Isoletta <
> sandro.isoletta@pl.rlp.de
> >> <ma...@pl.rlp.de>> wrote:
> >>
> >> Yes, we only have 66 users and all of them are assigned to an
> >> organization ( select * from organisation_users > user_id and
> >> organisation_id is filled)
> >>
> >> Am 28.03.2014 10:08, schrieb Maxim Solodovnik:
> >> > Can you check if these users are assigned to any organization?
> >> >
> >> >
> >> > On Fri, Mar 28, 2014 at 3:26 PM, Peter Dähn <daehn@vcrp.de
> >> <ma...@vcrp.de>
> >> > <mailto:daehn@vcrp.de <ma...@vcrp.de>>> wrote:
> >> >
> >> > Hallo,
> >> >
> >> > we have the same issue here...
> >> >
> >> > I thought it was related to the use here as standalone and
> plugged in
> >> > via API to our LMS. So I didn't investigate because we
> didn't use
> >> > standalone that much...
> >> >
> >> > Try to find out something...
> >> >
> >> > BR Peter
> >> >
> >> > Am 28.03.2014 08:12, schrieb Sandro Isoletta:
> >> > > Good morning,
> >> > >
> >> > > I can't find any exeptions. I put you a copy of the
> output of both
> >> logs
> >> > > (openmeetings.log and jvm.out) when I try to login.
> >> > >
> >> > > Am 27.03.2014 17:13, schrieb Maxim Solodovnik:
> >> > >> Hello,
> >> > >>
> >> > >> while "can not login anymore." are there any exceptions
> in the logs?
> >> > >>
> >> > >>
> >> > >> On Thu, Mar 27, 2014 at 10:16 PM, Sandro Isoletta
> >> > <sandro.isoletta@pl.rlp.de <mailto:sandro.isoletta@pl.rlp.de
> >
> >> <mailto:sandro.isoletta@pl.rlp.de <mailto:sandro.isoletta@pl.rlp.de
> >>
> >> > >> <mailto:sandro.isoletta@pl.rlp.de
> >> <ma...@pl.rlp.de> <mailto:
> sandro.isoletta@pl.rlp.de
> >> <ma...@pl.rlp.de>>>>
> >> > wrote:
> >> > >>
> >> > >> Hi,
> >> > >>
> >> > >> I have run an update from OpenMeetings 2.20 to
> OpenMeetings 3.0.
> >> > >> I followed the upgrade instructions on your site
> >> > >>
> >> > >> http://openmeetings.apache.org/Upgrade.html
> >> > >>
> >> > >> The upgrade worked fine, but after importing my
> backup I have
> >> the issue,
> >> > >> that all imported users with the exception of the
> admin accounts
> >> > >> can not login anymore.
> >> > >> When I add a new user, everything is fine. I used
> the encryption
> >> > method by
> >> > >> default
> (org.apache.openmeetings.util.crypt.MD5Implementation).
> >> > >>
> >> > >> After that, I tried it a second time and choose the
> bsd
> >> encryption
> >> > method
> >> > >>
> (org.apache.openmeetings.utils.crypt.MD5CryptImplementation), but
> >> > this one
> >> > >> failed completely.
> >> > >> I've got the message:
> >> > >>
> >> > >>
> >> > >> Installation is failed
> >> > >>
> >> > >> java.lang.NullPointerException
> >> > >> at
> >> >
> >>
> org.apache.openmeetings.data.user.UserManager.registerUserInit(UserManager.java:738)
> >> > >> at
> >> >
> >>
> org.apache.openmeetings.data.user.UserManager$$FastClassByCGLIB$$c43b186d.invoke(<generated>)
> >> > >> at
> net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
> >> > >> at
> >> >
> >>
> org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
> >> > >> at
> >> >
> >>
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
> >> > >> at
> >> >
> >>
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
> >> > >> at
> >> >
> >>
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
> >> > >> at
> >> >
> >>
> org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
> >> > >> at
> >> >
> >>
> org.apache.openmeetings.data.user.UserManager$$EnhancerByCGLIB$$ed09b855.registerUserInit(<generated>)
> >> > >> at
> >> >
> >>
> org.apache.openmeetings.installation.ImportInitvalues.loadInitUserAndOrganisation(ImportInitvalues.java:655)
> >> > >> at
> >> >
> >>
> org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:999)
> >> > >> at
> >> >
> >>
> org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess.run(InstallWizard.java:389)
> >> > >> at java.lang.Thread.run(Thread.java:724)
> >> > >>
> >> > >>
> >> > >> With kind regards
> >> > >>
> >> > >> --
> >> > >> Sandro Isoletta
> >> > >> Abteilung 4 Zentrale Dienste und IT-Dienste
> >> > >> Referat 4.07 Schulische IT-Dienstleistungen
> >> > >> PÄDAGOGISCHES LANDESINSTITUT RHEINLAND-PFALZ
> >> > >>
> >> > >>
> >> > >> Hofstraße 257c
> >> > >> 56077 Koblenz
> >> > >> it-support@pl.rlp.de <ma...@pl.rlp.de>
> >> <mailto:it-support@pl.rlp.de <ma...@pl.rlp.de>>
> >> > <mailto:it-support@pl.rlp.de <ma...@pl.rlp.de>
> >> <mailto:it-support@pl.rlp.de <ma...@pl.rlp.de>>>
> >> > >> www.pl.rlp.de <http://www.pl.rlp.de> <
> http://www.pl.rlp.de>
> >> <http://www.pl.rlp.de>
> >> > >>
> >> > >>
> >> > >>
> >> > >>
> >> > >>
> >> > >> --
> >> > >> WBR
> >> > >> Maxim aka solomax
> >> > >
> >> >
> >> >
> >> >
> >> >
> >> > --
> >> > WBR
> >> > Maxim aka solomax
> >>
> >>
> >> --
> >> Sandro Isoletta
> >> Abteilung 4 Zentrale Dienste und IT-Dienste
> >> Referat 4.07 Schulische IT-Dienstleistungen
> >> PÄDAGOGISCHES LANDESINSTITUT RHEINLAND-PFALZ
> >>
> >>
> >> Hofstraße 257c
> >> 56077 Koblenz
> >> it-support@pl.rlp.de <ma...@pl.rlp.de>
> >> www.pl.rlp.de <http://www.pl.rlp.de>
> >>
> >>
> >>
> >>
> >>
> >> --
> >> WBR
> >> Maxim aka solomax
> >
>
>
> --
> Sandro Isoletta
> Abteilung 4 Zentrale Dienste und IT-Dienste
> Referat 4.07 Schulische IT-Dienstleistungen
> PÄDAGOGISCHES LANDESINSTITUT RHEINLAND-PFALZ
>
>
> Hofstraße 257c
> 56077 Koblenz
> it-support@pl.rlp.de
> www.pl.rlp.de
>
>
>
--
WBR
Maxim aka solomax