OS_SOS Posted December 22, 2009 Posted December 22, 2009 Dear all, I have recently decided to set up Oscommerce 2.2 on my website. The database runs on mySQL. 1. I attempted to setup my website through the admin panel at this link: http://mydomain.com/admin/index.php'>http://mydomain.com/admin/index.php 2. I then get a dialog box asking for the user name and password: Authentication Required Enter user name and password for http://mydomain.com 3. Very simply, what is this as the default user name and password? I have asked my service provider and they say that it is native to Oscommerce and cannot therefore help. This sounds reasonable. I have trawled the forums here and come across numerous advice pages concerning 'htaccess' and 'passwd' and '.htpasswds' None of them seem to do what I want. I get the impression that there needs to be a file called either 'passwd' or 'htaccess'. This file needs to be a text file which will look something like this: "adminuser:adminpassword" I do not have a .htpasswds folder as decribed in slide 32 of the otherwise excellent video tutorial: http://www.oscommerce-template-easy.com/general-admin-series/os-commerce-reset-login-password.htm My folder structure looks something like this (i have not listed all of the files - there are loads of them): \ -mydomain.com -\catalog (this folder contains a '.htaccess' file which doesn't appear to have a username/password combination in it. Just a lot of comments and some basic settings) -\admin -.htmaster (no files in this folder) I know how to create text files. I know how to upload files. I know how to browse my file structure on my website. Surely I have enough ammo to solve this problem. Would someone be kind enough to tell me what file to create and where to stick it, please? :) Many thanks. SOS
♥mdtaylorlrim Posted December 23, 2009 Posted December 23, 2009 It's in the install guide. I don't remember what they are. I could be mistaken. Have you tried just clicking OK without entering a username or password? How about username as admin with no password? Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...?
Guest Posted December 23, 2009 Posted December 23, 2009 In the install guide ? That's new to me. I have ALWAYS entered the admin name and password during the install process. However, I have never used cpanel to install any OSC site because they usually do not have the most current version available and NEVER have them configured the way the client wants it. Having said that, you could try this: http://addons.oscommerce.com/info/5857 Chris
♥mdtaylorlrim Posted December 23, 2009 Posted December 23, 2009 It's been a long time but I thought I remembered finding in the install guide. Maybe you're right... If you have access to the database you can simply put in any username/password combination you want with a simple sql statement, or with phpMyAdmin. Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...?
OS_SOS Posted December 23, 2009 Author Posted December 23, 2009 Cheers guys, DunWeb, I am not exactly 'installing' it myself. Sorry, I didn't explain that. It is a default freeby application on my web hosting package. I simply click the button in my web control panel to create it and it does everything in the background for me. No messages, interactions or anything (apart from naming my database and the DBA user). I'm sure if I did it myself on my own server I would get the options you are talking about. This is not a typical install, although I understand from reading posts, that this is a common method for a lot of people - to use the default install from their web space provider. I hear what you are saying about configuring the versions correctly etc. but this is not the key point for me at the moment. I just need the basic functionality and in particular to test out the connectivity and storage of credit card details. mdtaylorlrim, I tried a combination of obvious user/passwords including the ones you said but nothing happened. I don't think that this is a database username and password, I think it is more of a file or folder level one. That said I have tried my 'dba' username and password that owns the database and that didn't work. Craig.
♥mdtaylorlrim Posted December 23, 2009 Posted December 23, 2009 I don't think that this is a database username and password, I think it is more of a file or folder level one. That said I have tried my 'dba' username and password that owns the database and that didn't work. It's not. The admin login/password for OSC is stored in the Administrators table of the database. Now use phpMyAdmin and fix it! Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...?
OS_SOS Posted December 24, 2009 Author Posted December 24, 2009 OK, I'm going for it... I have logged in but can only see the following tables: address_book address_format banners banners_history categories categories_description configuration configuration_group counter counter_history countries currencies customers customers_basket customers_basket_attributes customers_info geo_zones languages manufacturers manufacturers_info newsletters orders orders_products orders_products_attributes orders_products_download orders_status orders_status_history orders_total products products_attributes products_attributes_download products_description products_notifications products_options products_options_values products_options_values_to_products_options products_to_categories reviews reviews_description sessions specials tax_class tax_rates whos_online zones zones_to_geo_zones 46 table(s) Is the Administrators table somehow hidden?
OS_SOS Posted December 24, 2009 Author Posted December 24, 2009 OK, I have done some more digging but I am still not there yet... I found this link: http://www.colostate.edu/~ric/htpass.html I am back to thinking that this is a file level password protection rather than a OSCommerce protection problem. My reason for this is that the example at the bottom of the tutorial brings up pretty much exactly the same dialog box up as the one I get prompted with when I attempt to log in to my admin area and the example given has nothing to do with OSCommerce. My problem now is that, according to the tutorial, a '.htaccess' must exist in the directory that is being protected, along with the associated '.htpasswd' file. Well, my Admin directory does not have either of these files so I am struggling to understand why it is prompting me at all. Hmmm...unless it is the permissions on the folder that makes the prompt happen. I'll have a dig around that.
Ben Nevis Posted December 24, 2009 Posted December 24, 2009 If you have installed osc2.2 then there certainly should be a table called administrators! Like others I can't remember the default username/password, sorry! If the directory isn't protected by .htaccess (you should do this to secure it, as well as other measures) then if you can't access it, it has to be because the index script is bringing up the login script, as it should, and that will surely be looking in the database to find the usernames and passwords to check against, so there just has to be an administrator table! www.jyoshna.com. Currently using OsC with STS, Super Download Store, Categories Descriptons, Manufacturers Description, Individual Item Status, Infopages unlimited, Product Sort, Osplayer with flashmp3player, Product Tabs 2.1 with WebFx Tabpane and other bits and pieces including some I made myself. Many thanks to all whose contributions I have used!
♥mdtaylorlrim Posted December 24, 2009 Posted December 24, 2009 I am back to thinking that this is a file level password protection rather than a OSCommerce protection problem. My reason for this is that the example at the bottom of the tutorial brings up pretty much exactly the same dialog box up as the one I get prompted with when I attempt to log in to my admin area and the example given has nothing to do with OSCommerce. Maybe it's time now for you to take a screen shot of the login screen where you do not know the username and password and let's have a look at it. All of the passwords you mention use different input screens and we will recognize which one it is and be able to point you directly to the right place. Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...?
OS_SOS Posted January 4, 2010 Author Posted January 4, 2010 When I go to this adddress: http://www.mydomain.co.uk/admin/index.php I'm sorry I can't seem to work out how to paste the dialog box that I snapshotted to this forum, so I have found an equivalent snapshot at: http://www.settingupwordpress.com/images/authentication_required.jpg The title and prompt for which are: Authentication Required Enter user name and password for http://mydomain.com My prompt then contains the 'User Name' and 'Password' fields as in the shot. That make sense? The prompt is a seperate dialog box, not something that is part of the HTML of the web page. I hope this explains it. Cheers.
BryceJr Posted January 4, 2010 Posted January 4, 2010 Prior to RC1, oscommerce doesn't have an admin login screen by default. It's protected by htaccess login screen which you have. Any reason why you decided to use an older version rather than RC2a? You can download RC2a ->here. Less headaches than what you currently have. If you don't have a htpasswd, your login will be an infinite loop of logins. <--SECURITY HINT Anyway ->this should help.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.