Jump to content


Photo

Oscommerce Install


  • Please log in to reply
25 replies to this topic

#1 tolrodco

tolrodco

    New To The Neighborhood

  • Members
  • Pip
  • 6 posts

Posted 02 June 2004 - 07:10 AM

Hi,

I'm having a problem when I installing oscommerce, I keep getting the following error:

1044: Access denied for user: 'xhiyldom_tolrodc@localhost' to database 'osCommerce'

Does anyone have an idea of what I'm doing wrong?

Thanks!

#2 vengavenga

vengavenga

    Distant Family

  • Members
  • PipPipPip
  • 185 posts

Posted 02 June 2004 - 08:47 AM

Hi,

It sounds like you've just given it wrong username and password for the database.

I'm guessing the following from what you've posted:

Your tch username is "xhiyldom"
You've set up the database "oscommerce"
And you've added a user to the dayabase called "tolrodc"

More than likely, your full database name is actually "xhiyldom_oscommerce"

Hope that helps :blink:

#3 tolrodco

tolrodco

    New To The Neighborhood

  • Members
  • Pip
  • 6 posts

Posted 02 June 2004 - 08:59 AM

Thanks, it didn't register in my head until you said that it would be the "xhiyldom_oscommerce". Besides that it was too early in the morning for me! LOL!

Thanks for the help! :D

#4 vengavenga

vengavenga

    Distant Family

  • Members
  • PipPipPip
  • 185 posts

Posted 02 June 2004 - 09:16 AM

No problem - anytime :D

#5 TomMarch

TomMarch

    New To The Neighborhood

  • Members
  • Pip
  • 6 posts

Posted 25 February 2005 - 01:25 AM

Hi,

I am having a similar problem with deined access to the database when installing oscommerce. I have carefully checked the username and password and dbase name (even deleted and re-set-up mysql dbase and user twice to no avail).

The message I get is: Access denied for user: 'storeoz_store@server91.totalchoicehosting.com' (Using password: YES)

Any help would be appreciated,

thanks, Tom --

#6 TCH-Andy

TCH-Andy

    Immediate Family

  • Members
  • PipPipPipPip
  • 4,699 posts

Posted 25 February 2005 - 02:10 AM

Hi Tom,

Welcome to the Family ;)

looking on 91, the database name you have used seems to be "storeoz_storedb" not "storeoz_store"
Andy Beckett
-----------------
Part of the TCH family since the beginnings of time.

#7 TCH-Don

TCH-Don

    Immediate Family

  • Members
  • PipPipPipPip
  • 11,642 posts

Posted 25 February 2005 - 02:34 AM

;) Welcome to the Family Tom :(

and your new home!

We really are like family here.
So if you need anything,
just ask your new family!
We love to help :)

#8 TCH-Bruce

TCH-Bruce

    Volunteer Moderator

  • Members
  • PipPipPipPip
  • 19,960 posts

Posted 25 February 2005 - 08:20 AM

Welcome to the family and forums Tom! :clapping:

Bruce Richards
Forum Moderator
TotalChoice Hosting, Inc.
Webhosting by Total Choice Web Hosting - General Support Forum

I am a Forum Moderator. While I can assist in answering most of your hosting related questions, I am unable to answer questions about specifics relating to your account such as billing and server related issues. Should you need assistance in these areas, please contact our Help Desk or our many other options. Another good place to find answers is with our help pages, tutorials and movie tutorials.


#9 TomMarch

TomMarch

    New To The Neighborhood

  • Members
  • Pip
  • 6 posts

Posted 16 March 2005 - 06:42 PM

Hi Guys thanks for your quick feedback.

I didn't really expect it so I didn't check back till now :ph34r:

I'm trying to get the store up and running today so here's where I am still at:

The info I'm using is:

host: store.ozline.com
user: storeoz_store
dbase: storeoz_storedb

and I still get this message: Access denied for user: 'storeoz_store@server91.totalchoicehosting.com' (Using password: YES)

I'll plug away at it today if anyone's online.

Thanks again. It's nice to be supported!

Tom --

#10 GroovyFish

GroovyFish

    Immediate Family

  • Members
  • PipPipPipPip
  • 691 posts

Posted 16 March 2005 - 06:47 PM

Hi Tom,

Are you installing OSC from cpanel? I haven't done that before (I have only installed it manually) so I am unsure if the one-click install automatically creates the db for you... If you created the db, make sure you have added the user to the database.

Also, for host, try using localhost.

#11 TomMarch

TomMarch

    New To The Neighborhood

  • Members
  • Pip
  • 6 posts

Posted 16 March 2005 - 09:55 PM

Hi Tom,

Are you installing OSC from cpanel?


I'm using the oscommmerce Web-based install.

I created the dbase in cpanel's mySQL interface and added the dbase user. It looks like oscommerce adds the host itself.

Any thing else?

Thanks,

Tom --

#12 GroovyFish

GroovyFish

    Immediate Family

  • Members
  • PipPipPipPip
  • 691 posts

Posted 17 March 2005 - 08:58 AM

I created the dbase in cpanel's mySQL interface and added the dbase user.  It looks like oscommerce adds the host itself.

<{POST_SNAPBACK}>


Not to harp on this issue...but just to clarify, you created a database, and a database user, and then you added the user to the database? Many of people miss that last step.

Double check your database password. The only reason I mention this is because not too long ago I was setting up a zen-cart and chose a long password for my database. And I was having difficulty getting the cart to connect. I changed the password to something shorter and it worked. I am not sure if PhpMyAdmin has a limit on number of characters and truncated my long password... I didn't have time to investigate so I went with the shorter password. (maybe a staff member can confirm?)

If none of that works, PM me if you would like me to take a look at your config file.

#13 TomMarch

TomMarch

    New To The Neighborhood

  • Members
  • Pip
  • 6 posts

Posted 17 March 2005 - 02:37 PM

I will check all these again, but I have done them before with WordPress and it all went well.

Where is the Config file located and I can check it.

thanks a lot for your help!

Tom --

#14 TCH-Thomas

TCH-Thomas

    Volunteer Moderator

  • Members
  • PipPipPipPip
  • 14,908 posts

Posted 17 March 2005 - 02:43 PM

Welcome to the forums Tom. :)

Thomas Jikrantz
Forum Moderator
TotalChoice Hosting, Inc.

Any links or suggestions for third party software/sites should be used at your own risk. My opinions and recommendations are not necessary those of TCH and TCH is not responsible.

As a Forum Moderator I can assist in answering many of your hosting related questions. However, I am unable to answer questions about specifics relating to your account such as billing and server related issues. Should you need assistance in these areas, please contact our Help Desk or our many other options. Another good place to find answers is with our help pages, tutorials and movie tutorials.
Web Hosting by Total Choice Web Hosting - 24/7 Help Desk


#15 GroovyFish

GroovyFish

    Immediate Family

  • Members
  • PipPipPipPip
  • 691 posts

Posted 17 March 2005 - 04:49 PM

Hi Tom,

From what I can tell, you are installing OSC manually. Have you tried the one-click install in Cpanel for OSCommerce? I just tried it and it's pretty slick. You just tell it the name of the folder you want the store in, and the login and password you'd like for the admin section and it takes care of everything else... creates the database, user...everything.

Looks like the only thing you might need to do is to modify the configure.php file to add SSL support (if you need that)

Anyway...if I was going with OSC, that is what I would use....MUCH easier than doing it by hand!

#16 GroovyFish

GroovyFish

    Immediate Family

  • Members
  • PipPipPipPip
  • 691 posts

Posted 17 March 2005 - 04:50 PM

By the way...the configure.php files are in

/includes
/admin/includes

HTH!

#17 TomMarch

TomMarch

    New To The Neighborhood

  • Members
  • Pip
  • 6 posts

Posted 20 March 2005 - 08:48 PM

Dear GroovyFish,

Thanks for your help. I've now discovered the one-click osCommerce in Cpanel and it's been great. I didn't know it was lurking there in the scripts library.

Thanks for all your quick help,

Tom --

#18 karlkablisk

karlkablisk
  • Members
  • 3 posts

Posted 03 May 2006 - 05:04 AM

Hi everyone I'm new here. It looked like you guys were friendly and knowledgable about OScommerce so I wanted to see if I could get some help.

When i go to my site i get this error

Warning: mysql_connect(): Access denied for user: 'kablisk_osc1@localhost' (Using password: YES) in /home/kablisk0/public_html/store/includes/functions/database.php on line 19
Unable to connect to database server!

site is www.kabliskkeep.com/store/

Oscommerece worked and then one day it was broken its been like that for a bit. the server changed usernames for the admin login. someone told me my old one wont work and i cant add it for some reason. any idea why the error is coming up?

I'm fine with scrapping the whole thing (even though i had a lot listed on there) and re-installing osCommerce but i dont know how. I can do it with FTP? I use Cpanel is that easier?

thanks



TCH-Thomas made the link inactive.

#19 TCH-Thomas

TCH-Thomas

    Volunteer Moderator

  • Members
  • PipPipPipPip
  • 14,908 posts

Posted 03 May 2006 - 05:19 AM

Welcome to the forum, karlkablisk. :)

Be sure that in MySql you
1 - created the database
2 - created a user
3 -added the user to the database (go back to MySql and find the Add user select the user and database, and then [bold]Add user to database[/bold])

Then to connect to the database in a script, use:
host: localhost
database: yourCpanelName_databaseName
user: yourCpanelName_databaseUser
password: mypassword

Note: password is just as the password, do not add the CpanelName to it.

If this doesn´t work, we can go from there. :)

Thomas Jikrantz
Forum Moderator
TotalChoice Hosting, Inc.

Any links or suggestions for third party software/sites should be used at your own risk. My opinions and recommendations are not necessary those of TCH and TCH is not responsible.

As a Forum Moderator I can assist in answering many of your hosting related questions. However, I am unable to answer questions about specifics relating to your account such as billing and server related issues. Should you need assistance in these areas, please contact our Help Desk or our many other options. Another good place to find answers is with our help pages, tutorials and movie tutorials.
Web Hosting by Total Choice Web Hosting - 24/7 Help Desk


#20 TCH-Don

TCH-Don

    Immediate Family

  • Members
  • PipPipPipPip
  • 11,642 posts

Posted 03 May 2006 - 06:53 AM

Welcome to the forum, karlkablisk :)

#21 TCH-Bruce

TCH-Bruce

    Volunteer Moderator

  • Members
  • PipPipPipPip
  • 19,960 posts

Posted 03 May 2006 - 07:23 AM

Welcome to the forum, karlkablisk

Bruce Richards
Forum Moderator
TotalChoice Hosting, Inc.
Webhosting by Total Choice Web Hosting - General Support Forum

I am a Forum Moderator. While I can assist in answering most of your hosting related questions, I am unable to answer questions about specifics relating to your account such as billing and server related issues. Should you need assistance in these areas, please contact our Help Desk or our many other options. Another good place to find answers is with our help pages, tutorials and movie tutorials.


#22 Samrc

Samrc

    Immediate Family

  • Members
  • PipPipPipPip
  • 1,336 posts

Posted 03 May 2006 - 08:34 AM

Welcome to the forum!

Posted Image
Samantha
SamiSite.com CSB and WYSIWYG program tutorials
Feel free to right click the silly little forum images I use and save them to your own website space.
Then link to your own site. Please don't hotlink to my website to use the images. Thanks!

#23 karlkablisk

karlkablisk
  • Members
  • 3 posts

Posted 05 May 2006 - 12:42 AM

thanks, i went into cpane and mysql and did the add database and add ueser thing but nothing worked. :/

If I gave you my login maybe you could see more clearly whats going on, my site is pretty much dead as it is wihtout me being able to access the database. Let me know if you dont mind helping me out with a PM and I'll give the info.

I got this new error when trying to reinstall os commerce

----


Upgrade

A test connection made to the database was NOT successful.

The error message returned is:

Host 's1.bandhoster.com' is not allowed to connect to this MySQL server

Please click on the Back button below to review your database server settings.

If you require help with your database server settings, please consult your hosting company.
------

another error i see is this

Warning: mysql_connect(): Access denied for user: 'userName0@localhost' (Using password: YES) in /home/userName0/public_html/core/database-mysql.php on line 50

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/userName0/public_html/core/database-mysql.php on line 52
------

see my login used to be "userName" but something happened and now its userName0 and im told i cant make userName again. :/ If i could just make "userName" again everything that was set to recognize that name would still get it, if not then everything needs to see the new username.

Let me know what you think.

thanks a lot guys
- KKL

Welcome to the forum, karlkablisk. :)

Be sure that in MySql you
1 - created the database
2 - created a user
3 -added the user to the database (go back to MySql and find the Add user select the user and database, and then [bold]Add user to database[/bold])

Then to connect to the database in a script, use:
host: localhost
database: yourCpanelName_databaseName
user: yourCpanelName_databaseUser
password: mypassword

Note: password is just as the password, do not add the CpanelName to it.

If this doesn´t work, we can go from there. :)


edit: not a good idea to post your cpanel username in the forum -th

#24 TCH-Bruce

TCH-Bruce

    Volunteer Moderator

  • Members
  • PipPipPipPip
  • 19,960 posts

Posted 05 May 2006 - 07:11 AM

Remember when setting up a database that the following naming convention is used.

database -- cpanelname_databasename
user -- cpanelname_username

Did you configure your db using this naming scheme?

Bruce Richards
Forum Moderator
TotalChoice Hosting, Inc.
Webhosting by Total Choice Web Hosting - General Support Forum

I am a Forum Moderator. While I can assist in answering most of your hosting related questions, I am unable to answer questions about specifics relating to your account such as billing and server related issues. Should you need assistance in these areas, please contact our Help Desk or our many other options. Another good place to find answers is with our help pages, tutorials and movie tutorials.


#25 karlkablisk

karlkablisk
  • Members
  • 3 posts

Posted 08 May 2006 - 03:16 PM

can anyone give me an idea of how to make a "database.sql file" without using cpanel? For some reason when I use cpanel it says it made a new login (Im assuming thats what the database.sql file is, if it isnt someone please tell me what and how to make one i know i need that at least) but nothing is added.

:/

thanks all
- KKL

#26 TCH-Bruce

TCH-Bruce

    Volunteer Moderator

  • Members
  • PipPipPipPip
  • 19,960 posts

Posted 08 May 2006 - 05:20 PM

I am not sure that you can. I could be wrong. You could open a ticket with the help desk and ask them. But the instructions are simple enough for creating them in cPanel.

See the movie tutorial

Bruce Richards
Forum Moderator
TotalChoice Hosting, Inc.
Webhosting by Total Choice Web Hosting - General Support Forum

I am a Forum Moderator. While I can assist in answering most of your hosting related questions, I am unable to answer questions about specifics relating to your account such as billing and server related issues. Should you need assistance in these areas, please contact our Help Desk or our many other options. Another good place to find answers is with our help pages, tutorials and movie tutorials.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users