seems to be reproducible going to check ASAP Thanks for reporting! On Mon, Nov 14, 2016 at 12:51 PM, Coscend@OM <om.insig...@coscend.com> wrote: > Dear Maxim, > > We created the admin user during Web install: > > database check SUCCESS ->> username/password/e-mail/timezone / Organization > name. > > Thank you. > > Sincerely, > > Hemant K. Sabat > > > > Coscend Communications Solutions > > Web site: www.Coscend.com > > ------------------------------------------------------------------ > > Real-time, Interactive Video Collaboration and Communications Services, on > the fly… > > ------------------------------------------------------------------ > > CONFIDENTIALITY NOTICE: See 'Confidentiality Notice Regarding E-mail > Messages from Coscend Communications Solutions' posted at: > http://www.Coscend.com/Terms_and_Conditions.html > > -----Original Message----- > From: Maxim Solodovnik [mailto:solomax...@gmail.com] > Sent: Sunday, November 13, 2016 10:35 PM > To: Openmeetings user-list <user@openmeetings.apache.org>; > om.insig...@coscend.com > Subject: Re: OM 3.2.0: Unable to Login > > owner_id == NULL is expected, this field is set for the users of type > 'contact' only The issue is: PASSWORD == NULL > > How have you created this user? > > On Mon, Nov 14, 2016 at 9:59 AM, Coscend@OM <om.insig...@coscend.com> wrote: > >> Dear Maxim, > >> > >> Table om_user in DB has login as <Ourcompany.Username>, but owner_id > >> is NULL. > >> > >> | id | activatehash | age | deleted | domain_id | > >> external_id | external_type | firstname | forceTimeZoneCheck | > >> inserted > >> | language_id | lastlogin | lastname | lasttrans | login | > >> owner_id | password | pictureuri | regdate | resethash | > >> salutation | sendSMS | show_contact_data | show_contact_data_to_contacts | > >> time_zone_id | type | updated | user_offers | user_searchs | address_id >> | > >> sip_user_id | > >> > >> >> +----+--------------+---------------------+---------+-----------+-------------+---------------+-----------+--------------------+---------------------+-------------+-----------+----------+-----------+--------------------+----------+----------+------------+---------------------+-----------+------------+---------+-------------------+-------------------------------+-----------------+------+---------+-------------+--------------+------------+-------------+ > >> > >> | 1 | NULL | 2016-11-13 01:43:08 | | NULL | NULL > >> | NULL | firstname | | 2016-11-13 01:43:08 | > >> 1 | NULL | lastname | NULL | <Ourcompany.Username> | NULL | > >> NULL | NULL | 2016-11-13 01:43:08 | NULL | mr | > >> | | | America/Chicago | >> user > >> | NULL | NULL | NULL | 1 | NULL | > >> > >> Thank you. > >> > >> Sincerely, > >> > >> Hemant K. Sabat > >> > >> > >> > >> Coscend Communications Solutions > >> > >> Web site: www.Coscend.com > >> > >> ------------------------------------------------------------------ > >> > >> Real-time, Interactive Video Collaboration and Communications > >> Services, on the fly… > >> > >> ------------------------------------------------------------------ > >> > >> CONFIDENTIALITY NOTICE: See 'Confidentiality Notice Regarding E-mail > >> Messages from Coscend Communications Solutions' posted at: > >> http://www.Coscend.com/Terms_and_Conditions.html > >> > >> From: Maxim Solodovnik [mailto:solomax...@gmail.com] > >> Sent: Sunday, November 13, 2016 2:38 AM > >> To: Openmeetings user-list <user@openmeetings.apache.org>; > >> om.insig...@coscend.com > >> Subject: RE: OM 3.2.0: Unable to Login > >> > >> What is in om_user DB table? > >> Can you check if admin user is valid? > >> I'll try to double-check your scenario on Monday Today is my birthday, > >> so I'm off duty :) > >> > >> WBR, Maxim > >> (from mobile, sorry for the typos) > >> > >> On Nov 13, 2016 15:34, "Coscend@OM" <om.insig...@coscend.com> wrote: > >> > >> Dear OpenMeetings Community and Maxim: > >> > >> Here is what we did: > >> > >> · Created the admin user during Web install: database check step -> > >> username/password/e-mail/timezone step. > >> > >> · Used the DEFAULT crypt class during installation: > >> org.apache.openmeetings.util.crypt.SHA256Implementation > >> > >> From the DB, the the cryptClassName is in the snipped output below. > >> The user_id is NULL. Should it have our admin username? > >> > >> (We cannot get Admin->Config because we cannot login as admin user.) > >> > >> | id | comment | deleted | inserted | >> om_key > >> | updated | value | user_id >> | > >> > >> > >> > >> | 1 | This Class…CustomCryptMechanism.html | | 2016-11-13 01:43:08 | > >> crypt_ClassName | NULL | > >> org.apache.openmeetings.util.crypt.SHA256Implementation | NULL | > >> > >> Thank you. > >> > >> Sincerely, > >> > >> Hemant K. Sabat > >> > >> > >> > >> Coscend Communications Solutions > >> > >> Web site: www.Coscend.com > >> > >> ------------------------------------------------------------------ > >> > >> Real-time, Interactive Video Collaboration and Communications > >> Services, on the fly… > >> > >> ------------------------------------------------------------------ > >> > >> CONFIDENTIALITY NOTICE: See 'Confidentiality Notice Regarding E-mail > >> Messages from Coscend Communications Solutions' posted at: > >> http://www.Coscend.com/Terms_and_Conditions.html > >> > >> -----Original Message----- > >> From: Maxim Solodovnik [mailto:solomax...@gmail.com] > >> Sent: Saturday, November 12, 2016 9:37 PM > >> To: Openmeetings user-list <user@openmeetings.apache.org>; > >> om.insig...@coscend.com > >> Subject: Re: OM 3.2.0: Unable to Login > >> > >> How have you created your admin user? what is cryptClassName in the > >> > >> Admin->config (or DB) > >> > >> On Sun, Nov 13, 2016 at 4:40 AM, Coscend@OM <om.insig...@coscend.com> >> wrote: > >> > >>> Dear OpenMeetings Users: > >> > >>> > >> > >>> > >> > >>> > >> > >>> Further to the previous message, > >> > >>> > >> > >>> 1. a NEW USER registered at FRONTEND login page. Login SUCCESS. > >>> This > >> > >>> implies the installation and configuration is correct. > >> > >>> > >> > >>> 2. ADMINISTRATOR: login FAIL. “Invalid Password” > >> > >>> > >> > >>> > >> > >>> > >> > >>> Resetting password on login page for ADMINISTRATOR or NEW FRONTEND > >> > >>> REGISTERED USER gives the error shown below. Your vectors to resolve > >> > >>> this issue would be appreciated. > >> > >>> > >> > >>> > >> > >>> > >> > >>> Environment: > >> > >>> > >> > >>> Server: CentOS 7.2, MariaDB 10.x, mysql-jdbc-connector 5.1.39 > >> > >>> > >> > >>> User: Windows > >> > >>> > >> > >>> Browser: Chrome, Firefox > >> > >>> > >> > >>> > >> > >>> > >> > >>> =========== > >> > >>> > >> > >>> Password reset on login does not go through > >> > >>> > >> > >>> -------------------------------------- > >> > >>> > >> > >>> ERROR 11-12 15:13:22.623 o.a.o.c.m.MailHandler:244 [taskExecutor-4] - > >> > >>> Error while sending message > >> > >>> > >> > >>> com.sun.mail.smtp.SMTPSendFailedException: 530 authentication > >>> required > >> > >>> > >> > >>> > >> > >>> > >> > >>> at > >> > >>> com.sun.mail.smtp.SMTPTransport.issueSendCommand(SMTPTransport.java:2 > >>> 2 > >> > >>> 67) > >> > >>> > >> > >>> at > >> > >>> com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:1758) > >> > >>> > >> > >>> at > >> > >>> com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:1257) > >> > >>> > >> > >>> at javax.mail.Transport.send0(Transport.java:255) > >> > >>> > >> > >>> at javax.mail.Transport.send(Transport.java:124) > >> > >>> > >> > >>> at > >> > >>> org.apache.openmeetings.core.mail.MailHandler$2.run(MailHandler.java: > >>> 2 > >> > >>> 40) > >> > >>> > >> > >>> at > >> > >>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor. > >>> j > >> > >>> ava:1142) > >> > >>> > >> > >>> at > >> > >>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor. > >> > >>> java:617) > >> > >>> > >> > >>> at java.lang.Thread.run(Thread.java:745) > >> > >>> > >> > >>> > >> > >>> > >> > >>> > >> > >>> > >> > >>> Thank you. > >> > >>> > >> > >>> > >> > >>> > >> > >>> Sincerely, > >> > >>> > >> > >>> > >> > >>> > >> > >>> Hemant K. Sabat > >> > >>> > >> > >>> > >> > >>> > >> > >>> Coscend Communications Solutions > >> > >>> > >> > >>> Web site: www.Coscend.com > >> > >>> > >> > >>> ------------------------------------------------------------------ > >> > >>> > >> > >>> Real-time, Interactive Video Collaboration and Communications > >> > >>> Services, on the fly… > >> > >>> > >> > >>> ------------------------------------------------------------------ > >> > >>> > >> > >>> CONFIDENTIALITY NOTICE: See 'Confidentiality Notice Regarding E-mail > >> > >>> Messages from Coscend Communications Solutions' posted at: > >> > >>> http://www.Coscend.com/Terms_and_Conditions.html > >> > >>> > >> > >>> > >> > >>> > >> > >>> > >> > >>> > >> > >>> > >> > >>> > >> > >>> > >> > >>> > >> > >>> From: Coscend@OM [mailto:om.insig...@coscend.com] > >> > >>> Sent: Saturday, November 12, 2016 3:15 AM > >> > >>> To: user@openmeetings.apache.org > >> > >>> Subject: OM 3.2.0: Unable to Login > >> > >>> > >> > >>> > >> > >>> > >> > >>> Dear OpenMeetings Users: > >> > >>> > >> > >>> > >> > >>> > >> > >>> Your assistance with this test of 3.2.0 snapshot would be appreciated. > >> > >>> > >> > >>> > >> > >>> > >> > >>> We successfully compiled and installed the nightly build of > >> > >>> OpenMeetings > >> > >>> 3.2.0 (skipping tests). Created the database with one user and password. > >> > >>> Unfortunately, we are unable to login. It states “Invalid Password”. > >> > >>> We have deleted the database and added the user and password again to > >> > >>> ensure that we enter the correct password. We repeated this many > >> > >>> times. Still the problem persists. > >> > >>> > >> > >>> > >> > >>> > >> > >>> Would you advise what the issue could be? > >> > >>> > >> > >>> > >> > >>> > >> > >>> OpenMeetings.log > >> > >>> > >> > >>> ------------- > >> > >>> > >> > >>> DEBUG 11-12 03:04:23.057 o.a.o.d.d.u.UserDao:608 > >> > >>> [http-nio-0.0.0.0-7083-exec-8] - login:: 1 users were found > >> > >>> > >> > >>> DEBUG 11-12 03:04:23.058 o.a.o.u.c.CryptProvider:32 > >> > >>> [http-nio-0.0.0.0-7083-exec-8] - getInstanceOfCrypt:: > >> > >>> configKeyCryptClassName: > >> > >>> org.apache.openmeetings.util.crypt.SHA256Implementation > >> > >>> > >> > >>> DEBUG 11-12 03:04:23.058 o.a.o.d.d.u.UserDao:617 > >> > >>> [http-nio-0.0.0.0-7083-exec-8] - Password does not match: User [id=1, > >> > >>> firstname=firstname, lastname=lastname, login=Coscend.Test, > >> > >>> pictureuri=null, deleted=false, languageId=1, address=Address [id=1, > >> > >>> country=US, street=null, town=null, zip=null, deleted=false, > >> > >>> email=email@<domain>.com, phone=null], externalId=null, > >> > >>> externalType=null, type=user] > >> > >>> > >> > >>> > >> > >>> > >> > >>> Thank you. > >> > >>> > >> > >>> > >> > >>> > >> > >>> Sincerely, > >> > >>> > >> > >>> > >> > >>> > >> > >>> Hemant K. Sabat > >> > >>> > >> > >>> > >> > >>> > >> > >>> Coscend Communications Solutions > >> > >>> > >> > >>> Web site: www.Coscend.com > >> > >>> > >> > >>> ------------------------------------------------------------------ > >> > >>> > >> > >>> Real-time, Interactive Video Collaboration and Communications > >> > >>> Services, on the fly… > >> > >>> > >> > >>> ------------------------------------------------------------------ > >> > >>> > >> > >>> CONFIDENTIALITY NOTICE: See 'Confidentiality Notice Regarding E-mail > >> > >>> Messages from Coscend Communications Solutions' posted at: > >> > >>> http://www.Coscend.com/Terms_and_Conditions.html > > > > -- > > WBR > > Maxim aka solomax > > > > ----- > > No virus found in this message. > > Checked by AVG - www.avg.com > > Version: 2016.0.7859 / Virus Database: 4664/13405 - Release Date: 11/13/16 > > > ----- > > No virus found in this message. > > Checked by AVG - www.avg.com > > Version: 2016.0.7859 / Virus Database: 4664/13405 - Release Date: 11/13/16
-- WBR Maxim aka solomax