Fanupdate isn't installing for me. Options

[theerinkal]

On my fanupdate page it says, "ERROR: Could not connect to database server." when I have the correct database server name in it. I'm using version 2.2.1 if that is needed.

CODE

// ------------->ADMIN VARIABLES

$fanupdate['admin_username'] = 'erin';
$fanupdate['admin_password'] = md5('CORRECT PASSWORD IS HERE');

// ------------->DATABASE VARIABLES

$fanupdate['dbhost'] = 'localhost';
$fanupdate['dbuser'] = 'erin';
$fanupdate['dbpass'] = 'CORRECT PASSWORD IS HERE';
$fanupdate['dbname'] = 'mysql';

That is everything that I edited and I have everything correct but it's not working. I don't know why it's not working either.

[theerinkal]

Doesn't anyone know what's wrong?

[Mikeplyts]

You did put the correct password for your MySQL database right? Did you make a MySQL database at all?

Ok, so this is what could be wrong. You should have a password for your fanupdate and a username. Check to see if you have it, and if you don't, get it. You're going to need to put in the username and password for your fanupdate "account".

Also, you need to set up a MySQL database if you haven't done so yet. Then, there should be a page in the MySQL admin page where it gives the details of the database. The variable dbhost needs to have the host name of your MySQL database, which usually is localhost but just check to see if it's a different hostname. Then the variable dbuser needs to have the username you used for the MySQL database, where it says "erin", in this case. Next, the variable dbpass needs to have the password for your MySQL database. Finally, the variable dbname needs to have the exact name of the MySQL database you created. Save the file and see if it works. If you can't find your MySQL details, try contacting your host. Also, this won't work if you don't have MySQL provided with your hosting plan so yeah...

Good Luck.

[theerinkal]

You did put the correct password for your MySQL database right? Did you make a MySQL database at all?

I made a MySQL database. Yes I've changed the password for MySQL database and in the file several times and it still is not working.

Ok, so this is what could be wrong. You should have a password for your fanupdate and a username. Check to see if you have it, and if you don't, get it. You're going to need to put in the username and password for your fanupdate "account".

I can't get to the install page in fanupdate.

Also, you need to set up a MySQL database if you haven't done so yet. Then, there should be a page in the MySQL admin page where it gives the details of the database. The variable dbhost needs to have the host name of your MySQL database, which usually is localhost but just check to see if it's a different hostname. Then the variable dbuser needs to have the username you used for the MySQL database, where it says "erin", in this case. Next, the variable dbpass needs to have the password for your MySQL database. Finally, the variable dbname needs to have the exact name of the MySQL database you created. Save the file and see if it works. If you can't find your MySQL details, try contacting your host. Also, this won't work if you don't have MySQL provided with your hosting plan so yeah...

Good Luck.

Thanks.

I have MySQL in my plan, but it's still not working. I have everything correct. I created a new database and it's still not working. Am I supposed to create a table or something? This is where I go to go to the install.php page and that's what it says.

[fixtatik]

I created a new database and it's still not working. Am I supposed to create a table or something?.

the software will create the tables for you; all you need to do is have the database ready. did you name it "mysql," or is that just what comes in the fanupdate default configuration file?

i would also check to see if you can connect to your database manually. in your web admin panel, find the area dealing with mysql. there will probably be somethere there similar to "phpMyAdmin." if you can get into that, then it's not a database problem.

[theerinkal]

the software will create the tables for you; all you need to do is have the database ready. did you name it "mysql," or is that just what comes in the fanupdate default configuration file?

i would also check to see if you can connect to your database manually. in your web admin panel, find the area dealing with mysql. there will probably be somethere there similar to "phpMyAdmin." if you can get into that, then it's not a database problem.

I do have phpMyAdmin. I'm new to the whole database thing though. What do you mean connect it manually?

It doesn't for me. I have to create the tables myself. It starts without tables.

[fixtatik]

it starts without tables because it hasn't installed itself. i mean connect manually by seeing if you can log in to phpMyAdmin. if you can log in, and see any databases you might have, that means it's not a problem with your mysql server.

that's why i'm wondering what it is you named the database where you're installing fanupdate.

[theerinkal]

it starts without tables because it hasn't installed itself. i mean connect manually by seeing if you can log in to phpMyAdmin. if you can log in, and see any databases you might have, that means it's not a problem with your mysql server.

that's why i'm wondering what it is you named the database where you're installing fanupdate.

Well I have several databases.

I have sugar_blossom & mysql that I'm trying to use fanupdate for.

I can log in to phpMyAdmin, so that's not the problem.

[Mikeplyts]

Is your MySQL hostname "localhost"? Check to see if it's different and if it is, change it in the code and save it. See if that works.

[theerinkal]

Is your MySQL hostname "localhost"? Check to see if it's different and if it is, change it in the code and save it. See if that works.

Yes it is localhost.

[Mikeplyts]

And you are using a database called "mysql"?

[theerinkal]

And you are using a database called "mysql"?

Yes.

[Mikeplyts]

Do you have any other databases?

[theerinkal]

Do you have any other databases?

Yes. I have blog, sugar_blossom (this has "(0)" so I don't think it's set up yet.), mysql, cutenews, blog-mt.

[Mikeplyts]

Well try connecting to all the other databases, or even create a new one called "fanupdate" or something. Also, make sure to revise the instructions one fanupdate. There should be like a file called readme.txt where it should have instructions. Do you have to CHMOD any files in fanupdate?

[theerinkal]

Well try connecting to all the other databases, or even create a new one called "fanupdate" or something. Also, make sure to revise the instructions one fanupdate. There should be like a file called readme.txt where it should have instructions. Do you have to CHMOD any files in fanupdate?

Good question. I'll figure that out.

There is not readme.txt file in the folder that I have. I made a new database. How long does it take to install itself?

This post has been edited by theerinkal: May 6 2009, 05:30 PM

[theerinkal]

I still have a few questions:

1.) How long does it take a database to install itself?
2.) Would I use that password that is listed in the mysql part of phpMyAdmin? I found passwords and usernames for the database.
3.) Would I put @localhost at the end of my username?
4.) I have to edit the first username and password, right? As in I don't wait for the install.php page to come up I just put the username and password to my mysql database in there?
5.) I looked in the address bar and saw this:
cutenews/index.php?db=blog&&token=6f73353b0dc78fae38c0df56be3a674c
Would I use the bolded word as the database name?

[Mikeplyts]

I still have a few questions:

1.) How long does it take a database to install itself?
2.) Would I use that password that is listed in the mysql part of phpMyAdmin? I found passwords and usernames for the database.
3.) Would I put @localhost at the end of my username?
4.) I have to edit the first username and password, right? As in I don't wait for the install.php page to come up I just put the username and password to my mysql database in there?
5.) I looked in the address bar and saw this:
cutenews/index.php?db=blog&&token=6f73353b0dc78fae38c0df56be3a674c
Would I use the bolded word as the database name?

1. It shouldn't take long, at least under 5-10 min. I guess that depends on your host.
2. Ok, in the code, the password part of the MySQL variables has to be the password that you use to sign into the database.
3. No, you don't have to do that. The username is just simply the username you use to sign into phpMyAdmin.
4. Yes, but no. I'm pretty sure FanUpdate has to create a username and password for you in order to recgonize you. Did you have to sign up for FanUpdate?
5. Well that seems to the cutenews directory and you must have used your "blog" database for cutenews so that's why it appears like that so I don't really think it matters. You can choose any database name you want as long as you remember it and such.

[theerinkal]

1. It shouldn't take long, at least under 5-10 min. I guess that depends on your host.
2. Ok, in the code, the password part of the MySQL variables has to be the password that you use to sign into the database.
3. No, you don't have to do that. The username is just simply the username you use to sign into phpMyAdmin.
4. Yes, but no. I'm pretty sure FanUpdate has to create a username and password for you in order to recgonize you. Did you have to sign up for FanUpdate?
5. Well that seems to the cutenews directory and you must have used your "blog" database for cutenews so that's why it appears like that so I don't really think it matters. You can choose any database name you want as long as you remember it and such.

1.) My sugar_blossom is still not installed. It doesn't have any tables or anything.
2.) It would be the password I would use to sign into phpMyAdmin or the passwords that I found, Because I don't sign in to any databases I just look at them with phpMyAdmin.
3.) Okay, I wasn't sure. Thanks.
4.) No, I found a site that has it, here is the site, and I read the tutorial but I can't get past the first step with changing the variables.
5.) Okay. How is the database name supposed to look? Is it supposed to have an underscore like word_mysql or something?

[fixtatik]

looking at your databases through phpMyAdmin is technically logging into them. if you wanted to, you could make database changes there. that "test" database you created won't have any tables because you didn't add any tables. as soon as you create the database within your control panel, it's "installed."

you mentioned you have a few user names and passwords in your host's control panel. have you given the user name you want access to the database to where you're installing fan update? if you don't give the user name any database privileges, it can't do anything, and the fanupdate installation wouldn't be able to connect to the database.

[theerinkal]

looking at your databases through phpMyAdmin is technically logging into them. if you wanted to, you could make database changes there. that "test" database you created won't have any tables because you didn't add any tables. as soon as you create the database within your control panel, it's "installed."

you mentioned you have a few user names and passwords in your host's control panel. have you given the user name you want access to the database to where you're installing fan update? if you don't give the user name any database privileges, it can't do anything, and the fanupdate installation wouldn't be able to connect to the database.

Okay, I'll check that out.

_____________________

It's still not working. I'm just going to stick with cutenews. You may close this now.