[solved] Cannot access admin page locally after install

[rory]

Hello. First - I am a noob. Plain and simple. Now some details:

CMSMS 1.9.4.2
PHP 5.3.5-1
MySQL 5.1.54
Apache 2.2.17
Ubuntu Linux 11.04

That said, I have managed to install a local LAMP server on my laptop that seems to work.

The problem. I cannot access the local admin page after a seemingly sucessful installation, 'wrong username or password'. I've looked at the CMSMS installation FAQ on this:

"Install went well, but I can't login to the admin

It seems the install went well. You can even browse the site. But you can't login to the admin console. You may face either:

a server side PHP session problem
a browser side cookie problem

Solution: enable server side PHP sessions and let the admin's browser accept cookies (at least transient cookies from your site).

maybe you used the wrong userid/password?"

"enable server side PHP sessions..." running testphp.php shows me all sorts of things, among them: 'session support: Enabled'. Is this the same sort of session the FAQ referrs to? Do I have server side php sessions enabled?

So, assuming that is all correct, maybe I have just forgotten my username/password? But I made them very easy on purpose and am pretty sure (unless I made a typo, twice, on the password) I have them correct... so... is there anywhere locally I can find these user details? From a security point of view it seems unlikley, but I did find the database details I entered in config.php and was wondering if there was a hidden file somewhere I could access and check my username and password?

Why don't I just use the 'forgotten password?' link? Because i'm on Ubuntu and can't work out how to set up my email in php5/apache2/php.ini to use the 'sendmail' fuction correctly!

Can anyone help me with any of this? Any advice/pointers would be very appreciated.

Many thanks.

[RonnyK]

And you are trying to login with the account that you created in step 3 of the install? So not the DB-password....

If you are not sure about the password, then you might want to reset the password. In the wiki there is a command to reset the password to a new one...

http://wiki.cmsmadesimple.org/index.php ... d_password

Ronny

[rory]

Hi there, thanks for the reply.

I'm not using the database password, i'm defo using the (or so I thought) CMSMS admin details (I thought) I set up.

UPDATE `cms_users` SET PASSWORD = md5('admin') WHERE user_id =1;

This command... it returns 'No database selected', sorry, I know I'm being very useless. is the database called 'cms_users'? what is the syntax to access this?

Thanks muchly.

[rory]

OK. So following the above instructions - I was able to reset and enter the admin page all OK.

Many thanks.