From owner-freebsd-questions@FreeBSD.ORG Fri Nov 10 15:37:07 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1FFCE16A4D2 for ; Fri, 10 Nov 2006 15:37:07 +0000 (UTC) (envelope-from msherman77@yahoo.com) Received: from web88312.mail.re4.yahoo.com (web88312.mail.re4.yahoo.com [216.39.53.235]) by mx1.FreeBSD.org (Postfix) with SMTP id C8BF143D9D for ; Fri, 10 Nov 2006 15:37:00 +0000 (GMT) (envelope-from msherman77@yahoo.com) Received: (qmail 15986 invoked by uid 60001); 10 Nov 2006 15:37:00 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=gOhS0OePyIsQl4fSwC79tMOmk0Pt1GMVtZdNeXGbowa6+a43rfVvmii6i5WmU43KO8rxPbfq5SgBE4pjmd0wr1ejPtdKK66sV6X0SYpSQ9wCLaEphPWZpvj/2AzliAasVEtBZQ7bKLim11YeIM7X9ePnZ6ij8df7a253pkLRVr0= ; Message-ID: <20061110153700.15984.qmail@web88312.mail.re4.yahoo.com> Received: from [63.65.68.246] by web88312.mail.re4.yahoo.com via HTTP; Fri, 10 Nov 2006 10:36:59 EST Date: Fri, 10 Nov 2006 10:36:59 -0500 (EST) From: Michael S To: Michael S , FreeBSD Mailing List In-Reply-To: <20061109193430.19489.qmail@web88304.mail.re4.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Cc: Subject: mysq/php/blowfish (was vtiger/mysql/encryption) X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 10 Nov 2006 15:37:07 -0000 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 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" >