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 <http://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 <mailto: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 <http://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 <mailto:user@openmeetings.apache.org> >; om.insig...@coscend.com <mailto: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 <mailto: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:22 > 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 <http://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 <mailto: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 <mailto:email=email@%3Cdomain%3E.com> , phone=null], > externalId=null, > externalType=null, type=user] > > > > Thank you. > > > > Sincerely, > > > > Hemant K. Sabat > > > > Coscend Communications Solutions > > Web site: www.Coscend.com <http://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