Page 1 of 1
no more connection to database
Posted: Wed Apr 25, 2007 7:28 pm
by mev
I installed CMS-MS 1.0.5. (MySQL 4.1, PHP 5.2) and adapted a template to create a site for one of my clients and it runs perfectly well since 3 weeks ago.
Some days ago the owner gave permissions to someone else to create some other database for another cms.
Since then, the site I made for him is Offline....
I can log-in to the database I created, using the web-server, so password and login name are right. These details are also set correct in the config.php file in the root !!! (supposing that's the only file which sets the dbase-connection?)
However the site does NOT show when calling the index.php, it says "Internal server error" or "cannot find the page" (the url is:
http://www.ikenklinefelter.nl/)
The helpdesk of the Host talked about permissions, according to them the config.php should be set to chmod 664. (I thougt the documentation said first 666, and after installing back to 444), but NONE of these permissions make any difference..
Could someone Please help, give any clue where to search for a solution???
And, in case the other dbase has ruined mine, I suppose I will have to re-install cms-ms??
If so, will all stylesheets and templates be lost, as well as the content?
Thanks so much in advance!!!
Re: no more connection to database
Posted: Wed Apr 25, 2007 7:47 pm
by RonnyK
Check if you go through FTP to the given domain (as you uploaded the CMS) if all is still typed correctly, then check if the folder containing CMS (if that is not the root of the www.****.nl domain) is correctly reflected in the config.php
Can you login to the admin backend, by going to the domain/cmsdir/admin.
Ronny
Re: no more connection to database
Posted: Wed Apr 25, 2007 7:55 pm
by Nullig
It looks like the admin folder is ok, as I can see the login screen at
http://www.ikenklinefelter.nl/admin/
Is it possible that the root index.php file was overwritten by the new cms install?
Nullig
Re: no more connection to database
Posted: Wed Apr 25, 2007 7:59 pm
by RonnyK
If the "other person" did an install as well and you don't see the subdomain created, he will probably have FTP-ed his CMS installation in the main-domain folder. Can you login to the backend.....
Ronny
Re: no more connection to database
Posted: Wed Apr 25, 2007 8:13 pm
by mev
Thanks much for your replies, Ronny and Nullig
The folder containing CMS is the root.
Yes the login screen is shown, however I cannot login to the backend since the login-name and password (as administrator) are not recognized any longer by the system.. (ohhh it worked sooo well all the time)
there are several other domains of the owner at the same host.
Still, maybe the other person installed that cms into the domain for which i made the site... I hope NOT.
If so, could anything else solve the problem?
Thanks in advance again!!
Willemijn
Re: no more connection to database
Posted: Wed Apr 25, 2007 8:14 pm
by RonnyK
Willemijn,
check the config.php stored in the root. This holds the link to the DB/name/password. See if it still reflects your familiar DB and login.
Ronny
Re: no more connection to database
Posted: Wed Apr 25, 2007 8:22 pm
by RonnyK
Willemijn,
the templates/stylesheets and content are stored in the DB, these are still available. You can reinstall CMSMS, even in another folder, against another DB. Afterwards you can change the config.php manually to reflect the original db/login/path.
If the current installation is done in the root, you can also change that config.php as it now isn't the one you want. By just editing the config.php, you should be able to connect against the correct DB, and have your data back again.
Ronny
Re: no more connection to database
Posted: Wed Apr 25, 2007 8:32 pm
by mev
Ronny, thanks!
Yes the DB name, login and password are reflected correctly in the config.php, checked it over and over meanwhile. I Just copied the data from the config.php right into the login screen for entering the dbase itself (at the webserver's interface),
after which I smoothly enter that nice little dbase of mine...
that's the strange thing!
Am I getting nuts?
Thanks also for the tips on how to re-install while keeping content etc, in worst case!
Thanks Willemijn
Re: no more connection to database
Posted: Wed Apr 25, 2007 8:44 pm
by mev
By the way, how can I check whether the original dbase itself created for my cms-ms is still allright / correct, has not been messed up by the other install???
Have a nice evening.
Willemijn
Re: no more connection to database
Posted: Thu Apr 26, 2007 10:49 am
by RonnyK
Willemijn,
you mentioned that he/she gave another person permissions to create a new DB. If that is the case, he can't have touched your DB, as he/she didn't know the name/user/pwd for the original DB.
Ronny
Re: no more connection to database
Posted: Thu Apr 26, 2007 10:11 pm
by mev
Ronny, well today I found out that the other person has indeed been able to delete my database.. Whether the name/user/psw for that DB was known to him, it appears to be possible at this Host, I noticed. After that he created a new DB with the same name, presuming that would solve the case... Must have been rather desparate, I guess.
Also, he installed his cms into the wrong directory, which happened to be the one I installed cms-ms in..
Worst case scenarios.
Anyway, nothing else left for me than performing a re-install of cms-ms with a fresh DB,
and the site is finally up and running again.
pffff
Thanks so much anyway for your kind replies and help.
I learned a lot again during all this
Willemijn
(I suppose I should close the subject now?)
Re: no more connection to database
Posted: Fri Apr 27, 2007 6:12 am
by RonnyK
Willemijn,
I now get what he did. Instead of creating a DB for the other person and giving him the login for that DB, he gave that person his account to mijndomein.nl, to create a DB himself. With the login to mijndomein.nl you're able to add/edit/delete all DB's under the account, so you don't need the specific DB-accounts to administer, as you're the administrator for all DB's under the mijndomein.nl.
For this time, there is a lot of work to do for you.
For the next time, is it better to create a DB for others and give the details for that specific DB to others, instead of having them creating one for themselves through, the mijndomein.nl administration, as they than can change all.
Ronny