https://issues.apache.org/jira/browse/OPENMEETINGS-1504
Could you please check 3.2.0/3.1.4? The question is are other passwords being set as expected (Register/Appointment/Invitation etc.) On Mon, Nov 14, 2016 at 1:07 PM, Maxim Solodovnik <solomax...@gmail.com> wrote: > 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 -- WBR Maxim aka solomax