hello all,

I'm using XOOPS for more than a year now and I'm using it in three different social projects. I even used it for my personal log.
You should say I must be familiar with installing/moving XOOPS but this time is different again and I think I made all the right changes.

This time I'm moving it within the same server but between virtual servers.
The steps I took:
I moved all the XOOPS files from one html folder to the other.
Then I changed the database name corresponding to the new project.
Made a new database user for this database.
(using webmin - servers - MySQL database server)
Changed the mainfile.php the way it should.
Checked all permissions on the files according to
http://wiki.xoops.org/wakka.php?wakka=FAQMoving
http://wiki.xoops.org/wakka.php?wakka=TroubleshootingBlankPage

Can anybody tell me why I still get this error message?

Quote:

The help pages could not help me, maybe I'm looking in the wrong place?

greetings Erik

The error states that the MySQL user isn't authorised to access the database. Make sure that in Webmin, you have given the MySQL user (not XOOPS related) complete rights for the database. Creating the db alone is not enough.

Herko

I have given the user all rights beforehand.
Can it be I have to execute SQL or restart the MySQL database srever to really see the change?
(Like I have to restart the apache server when I change the config file that include the different virtual servers.)

Checked and rechecked the database names and permissions and the mainfile.php
Can't find anything wrong.

Then I re-entered the pasword from the user that has permission to this database. (using webmin-servers-mysql database server-global options - user permissions) Saved it and saved the list again, and it works!

I'm one happy bever who will start working on his new lodge.
Thanks

gr. Erik

You could try doing a FLUSH PRIVILEGES query. IF that doesn't have any effect, try stopping/restarting the MySQL server.