Date: Fri, 10 Nov 2006 10:36:59 -0500 (EST) From: Michael S <msherman77@yahoo.com> To: Michael S <msherman77@yahoo.com>, FreeBSD Mailing List <freebsd-questions@freebsd.org> Subject: mysq/php/blowfish (was vtiger/mysql/encryption) Message-ID: <20061110153700.15984.qmail@web88312.mail.re4.yahoo.com> In-Reply-To: <20061109193430.19489.qmail@web88304.mail.re4.yahoo.com>
next in thread | previous in thread | raw e-mail | index | archive | help
I figured that must have something to do with the way MySQL stores and php encrypts/decrypts data. I used mysqldump and saw that the passwords in MySQL are stored as Blowfish hashes, and I suspect that php uses a different algorithm when it tries to authenticate against the mysql database. As a result I can never log in, since passwords don't match. Is there a way to force php to use Blowfish? In php.ini there is session.hash_function variable, but the only two possible options are MD5 and SHA-1. And I am not even sure that this is the problem. Any clues? Thanks in advance, Michael --- Michael S <msherman77@yahoo.com> wrote: > Good day all. > > I am trying to get the vtiger CRM going on two > machines with varying success. > > I installed all the software packages required by > vtiger: php5, mysql50-server and client, and the > latest apache version 2, all with exactly the same > compile options. I also made all the necessary > adjustments to mysql, php and apache configuration > files. I grabbed the compressed archive from > vtiger.com and extracted it under my Apache document > root. The web-based setup went smoothly, on both > machines. However after the setup was done and it > was > time to test the CRM, I was able to go past the > login > screen (claiming I typed the wrong password) on one > of > the machines, but not on the other one. I tried the > setup procedure various times on the second machine, > but no luck. > > The only two differences between the two machines > (software wise of course) is that the machine I was > able to get vtiger to work is a 5.5-RELEASE, while > the > other one is a 6.1-p10. The second difference is > that > the 5.5 machine uses md5 for passwords, and 6.1 > blowfish. > > I know that this question doesn't pertain > particularly > to FreeBSD, but maybe people who installed the usual > php/apache/mysql under FreeBSD (which isn't > uncommon) > have experienced something similar. > > Thanks in advance. > Michael > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20061110153700.15984.qmail>