Installing Script - Sitebar

[joxley]

I recently moved my site to tch and am starting to explore the world of scripts. To say I'm a novice would be an understatement when it comes to MySQL or PHP. The script I would like to install is a Bookmarks management script so I can access and manage my bookmarks from anywhere. Here is the site: http://www.sitebar.org/. I have unpacked and uploaded the necessary files to my account, but continue to run into the problem when installing that access is denied. I am using my root username and password. Even followed some of the recommendations on the Sitebar site and created a MySQL database with associated username/password info. Any ideas on why this script wouldn't work? Any suggestions?

 

Thanks,

 

j

[TCH-Rob]

Well, the first thing that comes to mind is, did you add the user to the database after you created it? What is the exact error message you are getting?

[LisaJill]

One of the things that people usually run into is that they add the user, they add the database, but they don't add the user to the database. You need to make sure you choose the proper dropdowns in MySQL manager and click "Add user to database" -> proof that's done is a bunch of database init strings. =)

 

check that's done, the installation looks fairly straightforward....

[joxley]

Wow...thanks for the quick response. Yeah, I added a user to the database using the MySQL Account maintenance page. I just added another user (username: guest, password: guest) if you want to check it out (http://www.oxleyonline.com/sitebar/). The error message I get is:

 

Access denied for user: 'guest@server81.totalchoicehosting.com' (Using password: YES)

[TCH-Dick]

You have to add your cpanel username to the db and user.

For example:

cpanelname_user

cpanelname_database

[joxley]

That was the first thing I tried. Both without creating the database (since the install script has a 'create database' function, and with creating the database with my cpanel username and password added to the database.

[TCH-Dick]

This works.

• Upload files
  
• Change permissions for directory 'inc' to 777
  
• Create user in Manage Mysql
  
• Goto http://yoursite.com/sitebar/sitebar.php
  
• Use the following settings:
  

Host Name = localhost

Username = cpnlname_dbuser

Password = uknowwhatgoeshere

Db Name = cpnlname_sitebar

• Select Create Database
  
• Select Write to File
  
• You will be pompted to install tables, select Install
  
• You might receive a notice about "different release", choose to upgrade
  
• Select Setup and Enjoy
  

[joxley]

Well, I followed your directions exactly, substituting for the dbuser and password what I set up on MySQL manager. Still get the same error. I tried all variations of the username, db name, etc. Tried it without creating a database first in MySQL Manager, with a database, with 777 permissions on the sitebar folder, on the public_html folder. Is there something simple that I'm missing?

 

1. Upload files to public_html/sitebar

2. Change permissions on sitebar directory to 777 (tried with 777 on public_html too)

3. Create username/password in MySQL manager (tried with db created and user associated too)

4. Go to http://mysite.com/sitebar/sitebar.php

5. Enter info:

Host: localhost (also tried mysite.com)

Username: cpnlname_username (also tried without the cpnlname_)

Password: my chosen password (tried same info as cpanel login)

Database name: sitebar

6. Click creat database and get the access denied error either:

 

Thank you all for your help so far. I hope you aren't getting as frustrated with me as I am with this script.

[LisaJill]

The database name should be cpanelname_database name. That may help.

[TCH-Dick]

Change permissions on sitebar directory to 777 (tried with 777 on public_html too)

Are you changing the permissions on just your sitebar directory or all files below it? The only permissions I had to change were on the directory inc, so the file 'inc.config.php' can be created.

Also make sure there are no spaces at the end of any of the settings you enter. This can happen if you copy and paste.

Edited September 30, 2004 by TCH-Dick

[joxley]

Wooohooo! Finally got it! Turns out, the database name had to be "username_sitebar" where username is my cpanel name. Odd?

 

Thank you all for your help. Good start to hopefully a long stay with tch!

[LisaJill]

I said that I did.

 

It's not actually odd - the reason for that is that because you're in a shared hosting environment many people can make databases, if it were just the name of the database there could be confusion/difficulty in making them. This way it's easier to make sure the user doesn't try a duplicate name. =)

[joxley]

Doh! I get it now.....cpnlname = my cpanel name. I initially thought you literally meant use "cpnlname_sitebar". My bad.

[TCH-Rob]

Another one having a "Rob moment". I must be rubbing off around here. Dang ebola.