Installation issues with mysql

Thursday 25 November 2004 7:04:07 pm

Hi all,
Im having a fair amount of pain trying to install ezpublish on a redhat linux box (version XXXXXXX).
Ive already installed and had running the same version of ezpublish on both a debian and a solaris platform.

Im running:
ezpublish 3.4.4
mysql 4.1.7
PHP 4.3.9
apache apache 1.3.33

I can through the setup wizzard up until the database settings page. Here I cant enter in the username and password for the database I have created for ezpublish (I can log in manually from the command line and prove the user and password are valid).
The only settings that will allow me past this stage is to use, root as the user with no password (I removed the mysql root password for testing purposes), I also have to use the actual hostname of the server instead of localhost. The database is residing on the same server, so Im unsure as to why that is required and wont be suprised if thats part of the problem.

If I continue on, It will allow me to select the correct database from the wizzard page further on, but eventually will fail with the error: Fatal error: Call to a member function on a non-object
in /home/www/ezpublish/kernel/classes/ezcontenobjectversion.php on line 911. Fatal error: eZ publish did not finish its request.
-no further debug infromation is provided.

Just for testing I also tried with ezpublish-3[1].5.0rc1 with the same results only the debug output from the wizzard is:
EZSW-004Failed inserting data to mysql
EZSW-040Failed to initialize site package intranet

I am stumped. As stated, the users with passwords can succesfully connect to mysql from the command line.

Friday 26 November 2004 5:09:25 am

Hi,

Strange bug. With MySQL 4.0.xx eZ publish intalation works fine
http://www.ez.no/community/bug_reports/problem_with_instalation_fatal_error

I had problems with PHP and MySQL 4.1.7 on both Win32 and Linux platform.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Friday 26 November 2004 5:23:54 am

I had this error when i`m running MySQL 4.1.7 with old_password parametr. So i think that problem is somewhere else, because during instalations tables was created properly in MySQL 4.1.7. phpMyAdmin 2.6.0 works properly (old_password enabled) eZ publish don`t

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Sunday 28 November 2004 12:03:26 pm

Installing an earlier version of mysql has fixed the problem for us.
On our redhat box we used version 4.0.22, and its now working.
For those interested the 2 rpms you want are:
MySQL-client-4.0.22-0.i386.rpm
MySQL-server-4.0.22-0.i386.rpm

cheers

Arran

Monday 29 November 2004 12:36:42 am

This problem is concerned to MySQL 4.1.x "bug" -- eztrigger table contains too long key eztrigger_def_id, because key lentgh in MySQL 4.1.x is limited to ~330 chars(UTF), AFAIK.

So, eZ setup can't fill up the database.
Only way to istall eZ, imho, is to insert data manually from modified kernel/sql/mysql/kernel_schema.sql :

CREATE TABLE eztrigger (
  connect_type char(1) NOT NULL default '',
  function_name varchar(160) NOT NULL default '',
  id int(11) NOT NULL auto_increment,
  module_name varchar(160) NOT NULL default '',
  name varchar(255) default NULL,
  workflow_id int(11) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY eztrigger_def_id (module_name,function_name,connect_type),
  KEY eztrigger_fetch (name(25),module_name(50),function_name(50))
);

then insert data from cleandata.sql.
During install eZ will ask what to do with database, just leave the database alone.
This is a very dirty hack, but...
Also you can try to tune your MySQL to use latin1 charset (for example), but I'm unassured of the effect.

--
mike
#6595551