Maian Script World Support Forums / Unable to install

Re: Unable to install

dummy@example.com (msbfrnj) — Thu, 26 Apr 2012 15:01:46 +0000

Thank You!!!

Re: Unable to install

dummy@example.com (msworld) — Thu, 26 Apr 2012 07:25:30 +0000

Glad you got it sorted Brenda and thanks for helping out Shane.

Re: Unable to install

dummy@example.com (scarr105) — Wed, 25 Apr 2012 20:56:52 +0000

No problem, David put together a great product and is very helpful when we have issues or questions, so please keep posting and helping others if and when you can. Just glad I was able to help.

Good luck,

scarr105

Re: Unable to install

dummy@example.com (msbfrnj) — Wed, 25 Apr 2012 20:36:17 +0000

Mr. Scarr.....that was it...!! I have been playing with this thing for 3 or 4 days now..... Thank you sooooooo much!!
That's exactly what happened! Bluehost put the nichola5 in front of Maian Cart....I didn't in the connection file... Whew!!

Ok....onward.....

Again, thank you...
Brenda

Re: Unable to install

dummy@example.com (scarr105) — Wed, 25 Apr 2012 20:06:06 +0000

msbfrnj wrote:

Hi yes those are the values I had....
When I change the localhost to the IP address, this is the error report that I get...
MYSQL DATABASE ERROR:
Code: 1129
Error: Host 'box83.bluehost.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
File: /home1/nichola5/public_html/store/control/functions.php
Line: 33
When it's back to localhost this is what I get....
MYSQL DATABASE ERROR:
Code: 1044
Error: Access denied for user 'nichola5_leah'@'localhost' to database 'MaianCart'
File: /home1/nichola5/public_html/store/control/functions.php
Line: 36
P.S. that is my user and database name....
Any ideas?
thanks
brenda

I see that second error message sometime when I'm coding. Usually ends up that I'm trying to connect to a different Database than the one I think I'm tryingto connect to.

In this case if MaianCart is your database than in your connection file you should have 'nichola5_MaianCart' as the name of the Database. Bluehost will always add the nichola5_ in front of all users and databases.

Please double check the database name on the connection file if it says MaianCart change it to nichola5_MaianCart. Make the change if needed and reupload file.

scarr105

Re: Unable to install

dummy@example.com (msbfrnj) — Wed, 25 Apr 2012 18:05:23 +0000

Hi yes those are the values I had....

When I change the localhost to the IP address, this is the error report that I get...

MYSQL DATABASE ERROR:
Code: 1129
Error: Host 'box83.bluehost.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
File: /home1/nichola5/public_html/store/control/functions.php
Line: 33

When it's back to localhost this is what I get....

MYSQL DATABASE ERROR:
Code: 1044
Error: Access denied for user 'nichola5_leah'@'localhost' to database 'MaianCart'
File: /home1/nichola5/public_html/store/control/functions.php
Line: 36

P.S. that is my user and database name....

Any ideas?

thanks
brenda

Re: Unable to install

dummy@example.com (scarr105) — Wed, 25 Apr 2012 17:30:58 +0000

Here is what my connect.inc.php looks like: (all values are made up)

define('DB_HOST', 'localhost');
define('DB_USER', 'talquin_user');
define('DB_PASS', 'Mypass123');
define('DB_NAME', 'talquin_cart');
define('DB_PREFIX', 'mc_');

if you were adding an IP instead of local host it would be:

define('DB_HOST', '168.75.150.125');
define('DB_USER', 'talquin_user');
define('DB_PASS', 'Mypass123');
define('DB_NAME', 'talquin_cart');
define('DB_PREFIX', 'mc_');

Re: Unable to install

dummy@example.com (msbfrnj) — Wed, 25 Apr 2012 15:31:27 +0000

Hi...

I have checked what I did against what you said.... I had completed everything as stated. I also checked that database created and the database user. Everything matches.... I also tried the IP address (with and without periods in the number) I also did upload all changes to my server....

It seems now I'm getting a Http 500 internal error...

I should be trying to connect with this kind of path correct?

http://www.philandbrendanicholas.com/store/install/

Thanks
Brenda

Re: Unable to install

dummy@example.com (scarr105) — Wed, 25 Apr 2012 13:25:27 +0000

Not sure putting that in a code tag made it easy to read like I thought it would.

When you get to the Cpanel page scroll down to the Database section

Click MYSQL DATABASES

Look and see if your cart database is listed in the Current Database list.

If not than you will need to create the database by using the Create New Database section at the top. Type name of cart database and click create.

Once the database is created go back to the current database list and make sure the new database is listed.

If you cart database is in the current database list than you just need to add a user to that database.

Now it's time to add a user to the new database. If you have current users listed you can use any of those accounts by selecting that user from the Add User To Database and selecting the database click add. On the next page select all and click add.

If you don't have a user you can create one by using the Creat New User. Once you create this new user you must add user to Database. On the next page select all and click add.

Now if you go back to the current list of Databases you should see the new database with the user field matching the new user for that database.

Now open the connection file for the cart. Please take note of the Database name that was created it will be xxxxxx_Databasename and your username will be xxxxx_User.

Making sure to plug the info into the right spots in the connection file. I would still try localhost first before the IP. I'm using bluehost right now and I use localhost.

Re: Unable to install

dummy@example.com (scarr105) — Wed, 25 Apr 2012 13:23:34 +0000

I don't think he is telling you the best way to do that, You can do everything you need to do right in Cpanel on bluehost. No need to connect directly from your PC. I wrote up a little how-to on how I got my stuff start way back when. It's assuming you are starting from the beginning so please read it through once and ask questions if you don't understand something.

I did this really quick, so please read through it to make sure you understand it.

Login to your bluehost account

When you get to the Cpanel page scroll down to the Database section

Click MYSQL DATABASES

Look and see if your cart database is listed in the Current Database list.

If not than you will need to create the database by using the Create New Database section at the top.  Type name of cart database and click create.

Once the database is created go back to the current database list and make sure the new database is listed.

If you cart database is in the current database list than you just need to add a user to that database.

Now it's time to add a user to the new database. If you have current users listed you can use any of those accounts by selecting that user from the Add User To Database and selecting the database click add. On the next page select all and click add.

If you don't have a user you can create one by using the Creat New User.  Once you create this new user you must add user to Database. On the next page select all and click add.

Now if you go back to the current list of Databases you should see the new database with the user field matching the new user for that database.

Now open the connection file for the cart.  Please take note of the Database name that was created it will be xxxxxx_Databasename and your username will be xxxxx_User.

Making sure to plug the info into the right spots in the connection file. I would still try localhost first before the IP.  I'm using bluehost right now and I use localhost.

Re: Unable to install

dummy@example.com (msbfrnj) — Tue, 24 Apr 2012 23:09:37 +0000

Actually you're right....I've had very little problems with Bluehost in the past. They've always been very helpful.

At any rate on chat with Bluehost - after some back and forth the tech sd he couldn't help me, that this was "beyond his scope". But when I insisted that the error suggested something to do with the local host issue and asked could he please check with someone who maybe had more experience than he in this, he relented and asked someone else. He did come back and apologize and said that IT IS THE IP ADDRESS NOW!
He also gave me these instructions....

"You will need to white list your IP in your phpmyadmin.. and then use this IP 69.89.21.83 to login" As he further explained it....

"you go into the phpmyadmin and tell it that it is out to let this IP connect to this server remotely
[3:39:48 PM] your IP address from your personal computer.. not the servers IP

So....first of all...just put the ip address in where the local host was right? Second of all...I'm not sure what he means about connecting to the server remotely - from my IP address on my personal computer....HELP!!

Thank You
Brenda

Re: Unable to install

dummy@example.com (msworld) — Tue, 24 Apr 2012 19:18:08 +0000

Hi Brenda,

I never had too many issues with BlueHost if I`m honest. I`m sure the connection host used to be localhost, maybe its changed. According to their FAQ it is localhost, but that may be out of date.

Re: Unable to install

dummy@example.com (msbfrnj) — Tue, 24 Apr 2012 19:02:40 +0000

Bluehost is mine also...I will check with them. Although yesterday....they were thrown in a fit....they told me I didn't have to use the Php Wizard you supplied - just go to the Software Section in Cpanel and click on Php Config and click twice and you'll be fine. Wrong.... They changed their Php configuration or something two days ago.... They couldn't even figure out what their situation was to even help me.... But I'll check in with them on the local host thingy...

I'll let you know....

Thanks again
Brenda

Re: Unable to install

dummy@example.com (msworld) — Tue, 24 Apr 2012 18:00:54 +0000

scarr105 wrote:

msbfrnj,
You may have to check with your hosting provider to find out what you need to put in the DB_Host instead of localhost. localhost should work in most cases but maybe they have it configured differently. I double checked my control/connect.inc.php file and I'm using the localhost.
my hosting provider is bluehost.com
scarr105

Correct. Some hosts have different connection hosts. In some cases an IP address, in others a different one completely. As Shane recommends check with your web host. Who is your website hosted with btw?

Re: Unable to install

dummy@example.com (scarr105) — Tue, 24 Apr 2012 16:26:32 +0000

msbfrnj,

You may have to check with your hosting provider to find out what you need to put in the DB_Host instead of localhost. localhost should work in most cases but maybe they have it configured differently. I double checked my control/connect.inc.php file and I'm using the localhost.

my hosting provider is bluehost.com

scarr105