upgrading Serendipity

[Blue]

Hello.

I am trying to upgrade my Serendipity blog to the latest version (from 0.8.5). I've never used it before, so my DB (for the blog) is clean.
I've uploaded all the files on my space, then I've the "configuration change detection" screen

Serendipity a détecté que votre configuration (version 0.8.5) ne correspond pas à la version de votre installation de Serendipity (version 1.1). Pour continuer à utiliser Serendipity, l'assistant de mise à jour va vous guider pour mettre à jour votre installation.

Telling me that it will guide me to upgrade my installation (yes, cool ).
But I cannot go further the next screen, telling me that there are "permissions" problems.

Permissions
/home/charlieb/www/blog/ Protégé en écriture
/home/charlieb/www/blog/templates_c Protégé en écriture

These directories are "write protected".
I've "chmod" these to 777 with my FileZilla ftp soft; but the problems remains.
I've contacted OVH support, because the soft (Serendipity) was installed by default by OVH, but they don't know where the problem is.

Anyone can help me with this problem ?

Thanks.
Florent.

[judebert]

PHP is unable to write to those directories. Is safe_mode enabled?

[Blue]

According to PhpInfo(), safe_mode is Off and the version of Php is 4.4.4.

[garvinhicking]

Hi!

Hm, the problem is that if PHP reports a directory is not writable, this is usually true.

Can you use a different FTP application to check if those directories are REALLY chmodded to 777?

Regards,
Garvin

[Blue]

Hello.

I've used another ftp program, but it is well chmod to 777.
I've made some tries in the config file of Serendipity, because I am conviced that it is a problem of user and rights.

In the config file, I've two lines :

Code: Select all

$serendipity['dbName']            = 'charlieb_ovh';
$serendipity['dbUser']            = 'charlieb_ovh';

I've changed the dbUser to 'charlieb'; the user I was connected when I've ftpised my files.
After that, all permissions were in green and the process bring me a step further.
But, then, I've some errors when importing the sql files (access denied).
I've changed some times from one user to another, resulting in : the new tables were created, but not the indexes.
I've tried to executes them in phpMyAdmin, resulting also in an "access denies for user 'charlieb_ovh@%'.

I send a new message to OVH support to have some explanations to this strange user ??

At this stage, when I try to point to /blog directory with dbUser = 'charlieb', I've a query failed message.
When I change dbUser to 'charlieb_ovh', I've a directory (/template_c) write permission denied

I made some progress, but I guess the road is still long

Florent.

[Blue]

Another thing :
In phpMyAdmin, creating an index with :
- CREATE INDEX syntax fails (access denied)
But if I create it with :
- ALTER TABLE ..... ADD INDEX ; the creation succeeded !

Florent.

[garvinhicking]

Hi!

Uhm, the variable you change there only affects the Database username! It does NOT affect anything directory related!

So actually it should not make a difference at all to the report of directories you get.

Usually you should also only have a serendiipty_config_local.inc.php file once serendipity is installed. If that file exists, s9y can'T show you the installation screen?!?!

In phpMyAdmin, creating an index with :
- CREATE INDEX syntax fails (access denied)
But if I create it with :
- ALTER TABLE ..... ADD INDEX ; the creation succeeded !

This is a misconfiguration of your MySQL server, please ask your provider to give your databaseuser the "INDEX" privileges. It makes no sense for you to not have those privileges, they are vital for proper DB operation.

Best regards,
Garvin