trouble to access my site after upgrading to 3.8.0

Author Message

Pascal France

Thursday 26 October 2006 5:36:44 am

Hi,

I have just upgraded from 3.7.9 to 3.8.0 and I have a small trouble with the URI.
With ezp 3.7 and an URI like:

www.linuxorable.fr/ez_publish

the system went directly to:

www.linuxorable.fr/ez_publish/index.php/linuxorable

Now, with ezp 3.8.0 with www.linuxorable.fr/ez_publish the system goes directly to:

kernel::50
* No database connection could be made, the system might not behave properly.

Is there a file I forgot to configure correctly ?

I set a virtualhost to remove index.php from URI so now I need to type:
www.linuxorable.fr/ez_publish/linuxorable
instead of
www.linuxorable.fr/ez_publish
to not have the error message above.

Regards

Pascal

Ce qui embellit le désert c'est qu'il cache un puits... quelque part... (A. de Saint-Exupéry) - http://luxpopuli.fr/eZ-Publish

Claudia Kosny

Thursday 26 October 2006 9:22:49 am

Hi Pascal

Make sure that the virtual host settings in your site.ini are set up correctly. Most likely ez does not know which site access to use (type or space in the host matching?) and if your database settings are in the access specific site.ini files no connection can be made.

Claudia

Pascal France

Thursday 26 October 2006 10:53:50 am

Hi Claudia,

With or without virtual host I have the same problem.
I'm trying to upgrade directly from 3.7.9 to 3.8.5 (I have dumps of my database)
Well, once I installed the 3.8.5 files in my ezp install directory (ez_publish/) I run the updatedb scripts.

The first is dbupdate-3.6.0-to-3.8.0.sql and run fine. No error.
But each time I want to run the second one, dbupdate-3.8.0-to-3.8.1.sql I get:

ERROR 1061 at line 4: Duplicate key name 'ezkeyword_keyword_id'

Here is the update script:

UPDATE ezsite_data SET value='3.8.1' WHERE name='ezpublish-version';
UPDATE ezsite_data SET value='7' WHERE name='ezpublish-release';

CREATE INDEX ezkeyword_keyword_id ON ezkeyword ( keyword, id );
CREATE INDEX ezkeyword_attr_link_kid_oaid ON ezkeyword_attribute_link ( keyword_id, objectattribute_id );

CREATE INDEX ezurlalias_is_wildcard ON ezurlalias( is_wildcard );

CREATE INDEX eznode_assignment_coid_cov ON eznode_assignment( contentobject_id,contentobject_version );
CREATE INDEX eznode_assignment_is_main ON eznode_assignment( is_main );
CREATE INDEX eznode_assignment_parent_node ON eznode_assignment( parent_node );

In the ezkeyword table there is already a "ezkeyword_keyword_id" index
I am not a mysql expert, so I would like to know if I can remove the lines which want to creat an INDEX if it already exists ?

Regards

Pascal

Ce qui embellit le désert c'est qu'il cache un puits... quelque part... (A. de Saint-Exupéry) - http://luxpopuli.fr/eZ-Publish

Pascal France

Thursday 26 October 2006 12:10:04 pm

The URI access problem is the same with ezp 3.8.5:

http://www.linuxorable.fr/ez_publish/
or
http://www.linuxorable.fr/ez_publish/index.php/

goes directly to:

ernel::50
* No database connection could be made, the system might not behave properly.

Only http://www.linuxorable.fr/ez_publish/index.php/linuxorable works fine

Regards

Pascal

Ce qui embellit le désert c'est qu'il cache un puits... quelque part... (A. de Saint-Exupéry) - http://luxpopuli.fr/eZ-Publish

Claudia Kosny

Thursday 26 October 2006 1:37:40 pm

Hi Pascal

If you have already the index for the keyword table you can just remove this line from the updatescript. The index was added to a few releases some months ago to fix a performance problem with the keywords and maybe the update script does not consider that the index might already be there.

Regarding the database problem: I still think that eZ does not find a correct default siteaccess. To test that I would change the pagelayout.tpl and grab $access_type.name and also the databasesettings from ezini. Then you can see what access ez uses.

If you still have problems post the sections [SiteSettings] and [SiteAccessSettings] from the override site.ini.

Claudia

Pascal France

Thursday 26 October 2006 2:48:33 pm

Hi Claudia,

I found what was wrong and you are right.
I think I erased this lines by inadvertency in override/site.ini.append.php:

[SiteSettings]
DefaultAccess=linuxorable
SiteList[]
SiteList[]=linuxorable
SiteList[]=linuxorable_assoc

The more important line is the first:

DefaultAccess=linuxorable

Now all works fine.

Thanks for your help

Regards

Pascal

Ce qui embellit le désert c'est qu'il cache un puits... quelque part... (A. de Saint-Exupéry) - http://luxpopuli.fr/eZ-Publish

Pascal France

Monday 30 October 2006 2:13:02 pm

Hi Claudia,

I have the same access problem with a multi-sites but this time I can't solve it :-(

I have three sites and each one has its own database.
Each site.ini.append.php has these two sections:

Site 1

[SiteSettings]
SiteName=Site 1
SiteURL=xxxxx.fr/index.php/allobroges
MetaDataArray[author]=assoc AT linuxorable.fr - http://www.linuxorable.net/ez_publish/
MetaDataArray[copyright]=eZ systems
MetaDataArray[description]=Site 1
MetaDataArray[keywords]=xx,xxx,xxx,xxx,xxx,xxx
DefaultAccess=allobroges
LoginPage=embedded
SiteList[]=allobroges

[SiteAccessSettings]
CheckValidity=false
RequireUserLogin=flase
ShowHiddenNodes=false
RelatedSiteAccessList[]=allobroges
RelatedSiteAccessList[]=allobroges_admin

Site 2

SiteSettings]
SiteName=Site2
SiteURL=xxxxx.fr/index.php/mpt
MetaDataArray[author]=assoc AT linuxorable.fr - http://www.linuxorable.net/ez_publish/
MetaDataArray[copyright]=eZ systems
MetaDataArray[description]=Site 2
MetaDataArray[keywords]=xx,xxx,xxx,xxx,xxx,xxx
DefaultAccess=mpt
LoginPage=embedded
SiteList[]=mpt

[SiteAccessSettings]
RequireUserLogin=flase
ShowHiddenNodes=false
RelatedSiteAccessList[]=mpt
RelatedSiteAccessList[]=mpt_admin

Site 3

[SiteSettings]
SiteName=Site 3
SiteURL=xxxxx.fr/index.php/accueil
MetaDataArray[author]=assoc AT linuxorable.fr http://www.linuxorable.fr/ez_publish
MetaDataArray[copyright]=eZ systems
MetaDataArray[description]=Site 3
MetaDataArray[keywords]=xx,xxx,xxx,xxx,xxx,xxx
DefaultAccess=accueil
LoginPage=embedded
SiteList[]=accueil

[SiteAccessSettings]
CheckValidity=false
RequireUserLogin=flase
ShowHiddenNodes=false
RelatedSiteAccessList[]=accueil
RelatedSiteAccessList[]=accueil_admin

Site 1 and Site 2 can be accessed with:
http://www.xxxx.fr/mpt
http://www.xxxx.fr/allobroges

but Site 3 can only be accessed with:

http://www.xxxx.fr/index.php/accueil

And like with my previous problem above, if I use

http://www.xxxx.fr/

I get:

kernel::50
    * No database connection could be made, the system might not behave properly.

I followed your advice and I put {$access_type.name} in pagelayout and I get:

accueil

which is well the name of my siteaccess.

I don't have an override/site.ini.append.php file and site.ini contains:

[SiteSettings]
SiteList[]
....
....
....

[SiteAccessSettings]
AvailableSiteAccessList[]=accueil
AvailableSiteAccessList[]=accueil_admin
AvailableSiteAccessList[]=allobroges
AvailableSiteAccessList[]=allobroges_admin
AvailableSiteAccessList[]=mpt
AvailableSiteAccessList[]=mpt_admin
....
....
....

Regards

Pascal

Ce qui embellit le désert c'est qu'il cache un puits... quelque part... (A. de Saint-Exupéry) - http://luxpopuli.fr/eZ-Publish

Claudia Kosny

Wednesday 01 November 2006 8:36:30 am

Hi Pascal

I don't know much about setting up multiple sites so I doubt that I can help you much here. I am not sure why you get the database connection error again as the siteaccess seems to be correct. Although I wonder why the siteaccess is correct as I always thought that the DefaultAccess setting must be set in the override site.ini to avoid confusion between multiple site accesses. Anyhow, I would try to display the database settings in the pagelayout using ezini - maybe you can see what connection parameters ez tries to use.

Good luck

Claudia

Pascal France

Friday 03 November 2006 1:17:27 am

Hi Claudia,

Well, the solution to my problem is that it is necessary to have an override/site.ini.append.php file which contains:

[SiteSettings]
DefaultAccess=accueil

It is the minimum this file has to contain if we want the system works fine.

Regards

Pascal

Ce qui embellit le désert c'est qu'il cache un puits... quelque part... (A. de Saint-Exupéry) - http://luxpopuli.fr/eZ-Publish

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.