I have a very specific issue. Environment is RedHat enterprise 4 64-bit Linux. MySQL v5.1.
EE version 1.6.4.
Got to the page during installation where I fill in server/database/encryption settings, etc. Filled out completely click ‘install’ button and ee returns with the following error:

ERROR: The following Errors were encountered

  1. Unable to connect to your database server.
  2. Unable to select the database

I captured network traffic between server EE is on and the DB server on the next attempt and watched it log in and follow MySQL protocol with ethereal until it gets to this:

ee—> db
Mysql Request Command: Change User lpnonmemberee
command change user (17)
parameter: lpnonmemberee

ee <—- db
Mysql response error code: 417
response code: 255
error code: 1047
payload: #08S01 Unknown command

As soon as we reach that error ee returns and says it ‘cannot select’ the database - which is based on the observed network traffic not actually the issue.

My guess is that ee is attempting to execute a command that perhaps mysql 5.1 doesn’t support?  I have manually verified that this username/passwod works from the ee server using the command line mysql client.

Any known issues?

Mod Edit: Moved to the EECore Installation Issues forum.  Please review the Support Policy

Antonio, I don’t see how this is exactly a Pre-Sales question? Depending on whether you have a license or not, may I suggest you post in Installation Problems or Core: Installation Issues?

That said, I am not familiar with any issues concerning MySQL 5.1. Just make sure you haven’t Strict mode enabled.

I didn’t notice the installation problems area. I thought it was a pre sales question because I’m trying to install the demo to see if we want to purpose.  I think I noticed that a moderator already moved it there thanks.

You can close.  I edited the source of a few ee files to have it set sql_mode=’’ immediately after connecting to the database