Additionally I'm curious if mail server password will be also dropped during web installation?
On Mon, Nov 14, 2016 at 3:09 PM, Maxim Solodovnik <solomax...@gmail.com> wrote: > 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 -- WBR Maxim aka solomax