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: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 > >> > >> ------------------------------------------------------------------ > >> > >> 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
