Cannot create Admin account

vidar.ostevik · Post by **vidar.ostevik** » Wed 19. Jul 2006, 22:05

Hi!
I'm having a problem during the installation process. In step 2, I can't create an Admin account..? After filling in username, password and e-mail, the installation program says Check your admin user name and password!.
I'm installing this on my laptop, running XP Pro, Apache 1.3.35, php 4.3.11, and MySQL 5.0.11 using old passwords.
When opening MySQL admin, and opening the schema (Database), I can see that the data has been installed. Any suggestions?

Regards Vidar

Pappnase · Post by **Pappnase** » Wed 19. Jul 2006, 22:17

hello

detele the whole tables and re run the setup

DeXXus · Post by **DeXXus** » Thu 20. Jul 2006, 00:06

To re-enable setup remove the line

Code: Select all

$NO_ACCESS = true;

in setup.conf.inc.php.

Pappnase · Post by **Pappnase** » Thu 20. Jul 2006, 08:52

DeXXus wrote:To re-enable setup remove the line
Code: Select all
$NO_ACCESS = true;
in setup.conf.inc.php.

hello

did we both start the same good game again

and support each other

DeXXus · Post by **DeXXus** » Thu 20. Jul 2006, 09:24

LOL

Just to see you here... hard at work (as usual)

YOU are "the Man" !!!

Pappnase · Post by **Pappnase** » Thu 20. Jul 2006, 09:28

DeXXus wrote:LOL
Just to see you here... hard at work (as usual)
YOU are "the Man" !!!

hehe dex

after taking a offtime from the forum i must renew all my knowings

vidar.ostevik · Post by **vidar.ostevik** » Thu 20. Jul 2006, 23:01

Hi Pappnase!

I've tried to re-install the system several times...
Every time I have deleted the database, still no luck!
I've even tried to set "root" as DB user, still no luck!

DeXXus · Post by **DeXXus** » Fri 21. Jul 2006, 01:29

DB user and Admin account are not the same! Db username and password are something you create (or have been given by your host).

You provide phpWCMS install script with this username, password, the address to your MySQL database and the name of the database you want phpWCMS to use (where you have already created a database for phpWCMS).

You make sure you checkmark "Create admin account" and leave default (u:webmaster p:admin).

If everything is GREEN then phpWCMS is confirming that your answers were entered in the proper format for it to proceed. (NOT that it has "connected" yet)

Then phpWCMS uses this info (that you gave) to try connecting to database and creating tables and "default" Admin user.

If you give it a database URL, username, password that is not right (or it cannot connect, because the database is down)
You will get a message that says:-->Check your admin user name and password!

If all goes well... Later you login with "default" Admin user and change Admin users to your liking. confirm that it is working and then delete SETUP folder.

Uups · Post by **Uups** » Wed 16. Aug 2006, 11:49

Hi
I got the same Problem. On first setup screen, I added all all the stuff correctly. When trying to add an admin account on saving the second screen, I get the Message:
Warning: mysql_connect(): Access denied for user 'db_user'@'localhost' (using password: YES) in
/www/htdocs/w007075f/web/Durbusch2/setup/setup.php on line 100

Instead "db_user" there should be the database user I entered an saved on first screen - but it isn't
>> error in setup script?

Pappnase · Post by **Pappnase** » Wed 16. Aug 2006, 11:53

Uups wrote:Hi
I got the same Problem. On first setup screen, I added all all the stuff correctly. When trying to add an admin account on saving the second screen, I get the Message:
Warning: mysql_connect(): Access denied for user 'db_user'@'localhost' (using password: YES) in
/www/htdocs/w007075f/web/Durbusch2/setup/setup.php on line 100

Instead "db_user" there should be the database user I entered an saved on first screen - but it isn't
>> error in setup script?

hello

then YOU have the wrong settings setup in the setup script! the setup script is ok

Uups · Post by **Uups** » Wed 16. Aug 2006, 12:08

Sorry for the post
Solution is: When creating the MySQL Databese at least on some site admin tools, you must create explicitly a database *within* this new created databse. As long as this db inside the created login does'nt exist, nothing works.
>> Go to Site-Admin, open you MySQL Admin tool (i.e. mysladmin) and check if the databese existst *within* the database you use for login.

(For the developers: Gallery, another free product, seems to check this on installation and solve the Problem by itself. Maybe the code used there is useful?)

Uups · Post by **Uups** » Wed 16. Aug 2006, 12:35

Pappnase wrote: then YOU have the wrong settings setup in the setup script! the setup script is ok

Nothing changed in your code

Seems when creating a database in my website Admin tool just an accout is created but not the database itself.

Pappnase · Post by **Pappnase** » Wed 16. Aug 2006, 12:37

Uups wrote:
Pappnase wrote: then YOU have the wrong settings setup in the setup script! the setup script is ok
Nothing changed in your code
Seems when creating a database in my website Admin tool just an accout is created but not the database itself.

hehe it's not my code!

ist Oliver G.'s code

Cannot create Admin account

Cannot create Admin account

Same problem

Re: Same problem

Found Solution

Re: Same problem

Re: Same problem