Re: [Openqrm-user] Failed to init MySQL on RedHat EL 5.5 and OpenQRM4.8

[Satoru F. <fu...@os...>]

Finally, We've got what's wrong.
dropbear ssh which OpenQRM use is shared information with standard sshd (OpenSSH) of RHEL.
Therefore dropbear used wrong information about known hosts.
I removed /root/.ssh/known_hosts file and restart, it does work fine!
Many thanks,
Satoru Funai

----- 元のメッセージ -----
> Thanks Scott,
> However I used "password" as MySQL password.
> I think it isn't a complex password.
> I"m wondering that something wrong around conflict between dropbear
> ssh and standard sshd now.
> regards,
> Satoru Funai
> 
> ----- 元のメッセージ -----
> > I ran into this as well a while back.  It seems that OpenQRM can't
> > handle complex passwords when used by the root mysql user.  Change
> > your password to not include any wildcard characters and it should
> > work.  OpenQRM needs to look at this as a high level bug, as it is
> > a
> > security issue as far as I am concerned.  Complex passwords should
> > not
> > be a barrier to entry in using an "Enterprise" level software
> > package.
> >
> > My two cents.
> >
> > Scott
> >
> > On Sat, Jul 9, 2011 at 11:00 AM, Satoru Funai <fu...@os...>
> > wrote:
> > > Hi Matt-san,
> > > I'm trying to install OpenQRM4.8 on RedHat EL 5.5 disabled
> > > selinux.
> > > Installation was succeed, but After that I have started the web
> > > configuration, could not go to step3.
> > > In /var/log/messages,
> > > ------
> > > Jul  9 22:25:24 hd00 logger: openQRM-cmd-queu NOTICE : Running
> > > 92a3101043c02b0b00518ace93f041c4 with default cmd-timeout 120
> > > Jul  9 22:25:24 hd00 logger: openQRM-cmd-queu NOTICE : Running
> > > 92a3101043c02b0b00518ace93f041c4 :
> > > /usr/share/openqrm/bin/dbclient
> > > -K 10 -y -i /usr/share/openqrm/etc/dropbear/dropbear_rsa_host_key
> > > -p xxxxxxxx  root@127.0.0.1 "/usr/share/openqrm/bin/openqrm-cmd
> > > sed -i -e
> > > 's/^OPENQRM_DATABASE_SERVER=.*/OPENQRM_DATABASE_SERVER=localhost/g'
> > > -e 's/^OPENQRM_DATABASE_NAME=.*/OPENQRM_DATABASE_NAME=openqrm/g'
> > > -e 's/^OPENQRM_DATABASE_USER=.*/OPENQRM_DATABASE_USER=root/g' -e
> > > 's/^OPENQRM_DATABASE_PASSWORD=.*/OPENQRM_DATABASE_PASSWORD=password/g'
> > > /usr/share/openqrm/etc/openqrm-server.conf"
> > > Jul  9 22:25:25 hd00 logger: openQRM-cmd-queu WARNING : Command
> > > with token 0d6c5e8d61cfee7791897fd30c29071d failed :
> > > /usr/share/openqrm/bin/dbclient -K 10 -y -i
> > > /usr/share/openqrm/etc/dropbear/dropbear_rsa_host_key -p xxxxxxxx
> > >  root@127.0.0.1 "/usr/share/openqrm/bin/openqrm-cmd sed -i -e
> > > 's/^OPENQRM_DATABASE_SERVER=.*/OPENQRM_DATABASE_SERVER=localhost/g'
> > > -e 's/^OPENQRM_DATABASE_NAME=.*/OPENQRM_DATABASE_NAME=openqrm/g'
> > > -e 's/^OPENQRM_DATABASE_USER=.*/OPENQRM_DATABASE_USER=root/g' -e
> > > 's/^OPENQRM_DATABASE_PASSWORD=.*/OPENQRM_DATABASE_PASSWORD=password/g'
> > > /usr/share/openqrm/etc/openqrm-server.conf"  -----
> > > /usr/share/openqrm/bin/dbclient: Connection to
> > > root@127.0.0.1:1667
> > > exited:
> > > Jul  9 22:25:25 hd00 logger:
> > > Jul  9 22:25:25 hd00 logger: Host key mismatch for 127.0.0.1 !
> > > Jul  9 22:25:25 hd00 logger: Fingerprint is md5
> > > c4:83:99:0a:4d:3d:c3:94:aa:51:02:0d:f0:82:5a:8b
> > > Jul  9 22:25:25 hd00 logger: Expected md5
> > > 84:ef:54:04:53:ee:6f:3a:62:10:a3:82:c7:69:23:80
> > > Jul  9 22:25:25 hd00 logger: If you know that the host key is
> > > correct you can
> > > Jul  9 22:25:25 hd00 logger: remove the bad entry from
> > > ~/.ssh/known_hosts
> > > -----
> > > Installed on CentOS5.5 in same procedure, OpenQRM works fine, so
> > > I
> > > could not find out what's wrong.
> > > Please help me.
> > > Best regards,
> > > Satoru Funai
> > >
> > > ------------------------------------------------------------------------------
> > > All of the data generated in your IT infrastructure is seriously
> > > valuable.
> > > Why? It contains a definitive record of application performance,
> > > security
> > > threats, fraudulent activity, and more. Splunk takes this data
> > > and
> > > makes
> > > sense of it. IT sense. And common sense.
> > > http://p.sf.net/sfu/splunk-d2d-c2
> > > _______________________________________________
> > > Openqrm-user mailing list
> > > Ope...@li...
> > > https://lists.sourceforge.net/lists/listinfo/openqrm-user
> > >
> >
>