Latest posts for the topic "correct database settings with iPowerWeb?"

correct database settings with iPowerWeb?

Anonymous — GMT

Hello all,
I've tried to install the Advanced Guestbook 2 with the help of the Jam'n's tutorial but when I set the values in the install.php file and click on "Create new DB and table" I keep getting an error (below). I've tried different combinations of database names (I read here in the forums that some providers need a prefix in front of the database name, etc.). I've searched all the posts for help, but what ever I try I get the same error.
I've changed all the chmod settings as they should be.
I'm using the username provided to me by iPowerWeb. I never set a password. I tried creating one just to see if it works, and still nothing. My site is [url]www.reneezara.com[/url]
If anyone can help, that would be great coz I'm out of ideas?
Thanx

[u]THE ERROR[/u]
Warning: mysql_connect(): Access denied for user: 'reneezar@localhost' (Using password: NO) in /home/reneezar/public_html/guestbook/install.php on line 242
Cannot connect to database
--------------------------------------------------------------------------------

MySQL Error : Cannot connect to database
Error Number: 1045 Access denied for user: 'reneezar@localhost' (Using password: NO)
Date : Thu, July 1, 2004 13:18:24
IP : 138.89.141.57
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Referer : http://www.reneezara.com/guestbook/install.php
PHP Version : 4.3.4
OS : FreeBSD
Server : Apache/1.3.27 (Unix) mod_log_bytes/0.3 FrontPage/5.0.2.2635 PHP/4.3.4 mod_ssl/2.8.14 OpenSSL/0.9.7d
Server Name : reneezara.com

JTD — GMT

Very simple you dont have your password set correctly. The password for the guestbook mysql setup has to be the same as your password for your host cpanel.

Anonymous — GMT

Nope, I've tried that too. Still nutting

Anonymous — GMT

This is what it tells me when I use my password:

Cannot create new database: guestbook
--------------------------------------------------------------------------------

MySQL Error : Cannot create new database: guestbook
Error Number: 1044 Access denied for user: 'reneezar@localhost' to database 'guestbook'
Date : Fri, July 2, 2004 08:52:32
IP : 138.89.187.196
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Referer : http://www.reneezara.com/guestbook/install.php
PHP Version : 4.3.4
OS : FreeBSD
Server : Apache/1.3.27 (Unix) mod_log_bytes/0.3 FrontPage/5.0.2.2635 PHP/4.3.4 mod_ssl/2.8.14 OpenSSL/0.9.7d
Server Name : reneezara.com

JTD — GMT

have you manually tried to create it in your cpanel phpmyadmin???

Anonymous — GMT

Yes I have. Then it also says it is unable to connect to the database. I've tried using the username given to me from iPowerWeb, I've tried using the username for my phpBB database (I read in these forums that one username can have two databases) and I've also tried to create a new username for the guestbook database. Whatever I try, I either get Cannot create database or Cannot connect to database. I wonder what I'm missing, there must be something...

JTD — GMT

Ok what host do you use? And how many databases do they allow you. And from looking at your install.php file You need to create one manuely. Say for instance mine is called in my database ravenpro_guestbook Also did you set the permissions correctly.

PS is this your host. http://www.ipowerweb.com/ PM me or add me to one of my listed chats clients below and let me know we can talk.

Help is on the way. :)

Anonymous — GMT

Hi Renee,

I think I can make your day, my friend! Right this second, I'm configuring a guestbook for a client of mine (who uses iPowerWeb as his hosting service also). I had the same trouble you did. I found a working solution! I see no reason it be cannot used to help you as well. Try this:

1. Open Admin/config.inc.php in notepad. (You're going to be working with the file you have placed on your server already.)

2. /* database settings */

$GB_DB["dbName"] = ""; <-- Change this to whatever database name you want (i.e. "MyCoolAndFinallyWorkingDB")
$GB_DB["host"] = "localhost"; <-- Touch this and you will die
$GB_DB["user"] = "root"; <-- Change this to your primary login for iPowerWeb
$GB_DB["pass"] = ""; <-- Here you type in your primary password

Save. Upload the updated config.inc.php file to your server, overwritting the one that is there.

3. Go into your iPowerWeb control panel. Click Host Manager -> Databases -> Setup

4. Here, add a new user (at the bottom). Make certain to write down your username and password.

5. At the top, in the 'add database' edit box, type the exact name of the database you chose to add to step 2. Press 'add'.

6. Now got to: www.YOURURL.com/(name of your guestbook folder)/install.php

7. You will be greeted with a familiar screen. This time you will conquer it! :) Type the info in. Copy what you added in Step 2.

8. Press the 'ceate table' button. Presto! :)

9. Log into to your iPowerWeb control panel again. This time, go to Host Manager -> Databases -> Admin

10. Type in your new User account name and password.

11. Press the databases link on the main page that appears. Next select the database you just created. Here you will see that 10 tables were correctly added to your guestbook database.

12. Jump up and down excitedly and stop yanking your hair out. ;)

.

I hope this helps you! This is what I just did a few minutes ago. I am having no troubles as of yet...

Take care.

- Art Sentinel

http://www.artsentinel.net

IT WORKED!!! THANK YOU!!!

Anonymous — GMT

First of all, I want to thank you both, JTD and Art Sentinel for responding so quickly and helping me out.
Art, your approach definitely worked, but I did have to change just a few minor details. I hope you don't mind if I write them down because it might help someone as confused as me in the future

- 1st, in step 2 of your tutorial, i couldn't just enter the name I wanted for my DB. I had to do step 5 first, because my cpanel automatically added a prefix to the DB name. I wanted to name it gbook, but my cpanel renamed it into reneezar_gbook. This, reneezar_gbook is what I needed to enter into my install.php file in step 2 in order for it to work.

- 2nd, in step 9 when i went to Host Manager -> Databases -> Admin, it reported some kind of error because I had multiple usernames (I also have a username for my phpBB forum). It said something about not creating the tables properly. I started over, went into my cpanel where I SKIPPED step 4 and created a DB only (step 5). I got to the end and it worked! until...

- 3rd, the guestbook administration page popped up, but I was unable to log in. So I searched the forums some more and found out that in this case the username and password must be reset following the easy directions at this link [url]http://proxy2.de/forum/viewtopic.php?t=2934&highlight=reset+password [/url].

And it was fixed!!! Once again, thabk you for your help

MISTAKE!

Anonymous — GMT

Ok, Seems I've made a big mistake, so scratch skipping step 4 of Art Sentinel's tutorial. I've tried using only one username for two databases, and it worked at first, but the very next time I tried to log in, it wouldn't. Now it won't even load up my guestbook page or my forum page (both db are sharing the same user). I gotta ask iPowerWeb how to fix that. Well, you learn by making mistakes I guess.
I was just wondering, when I do create a separate user for the guestbook database, do the errors mentioned about the tables in phpAdmin matter?

Anonymous — GMT

Ipowerweb has a autoinstall under cgi advanced guestbook in the control panel just click it enter a dir name and waaala its done!