Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

admin or store not accessing DB yet no errors


stonenote

Recommended Posts

Posted

dreamseeds.com = website

I have it working on the ip address (in the background mode testing before switching from the old server) in the config.php files and was working fine for a month. I then switched the dns pointers to go to the actual domain name dreamseeds.com. Now the store is up and running but now I can not log on either in the admin panel or the online store. It is as if it is not accessing the database. I can log into the PHPadmin panel and add customers or administrators but through the OS admin panel I cannot log on. Below is the config file. Any help would be appreciated as the store is now live!

 

define('HTTP_SERVER', 'http://dreamseeds.com');

define('HTTPS_SERVER', 'https://dreamseeds.com');

define('ENABLE_SSL', true);

define('HTTP_COOKIE_DOMAIN', 'http://dreamseeds.com');

define('HTTPS_COOKIE_DOMAIN', 'https://dreamseeds.com');

define('HTTP_COOKIE_PATH', '/catalog/');

define('HTTPS_COOKIE_PATH', '/catalog/');

define('DIR_WS_HTTP_CATALOG', '/catalog/');

define('DIR_WS_HTTPS_CATALOG', '/catalog/');

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

 

define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');

define('DIR_FS_CATALOG', '/home/bodhitre/public_html/catalog/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 

define('DB_SERVER', 'localhost');

define('DB_SERVER_USERNAME', 'bodhitre_osc2');

define('DB_SERVER_PASSWORD', 'XXXXXXXXXXX'); /* removed for security example */

define('DB_DATABASE', 'bodhitre_osc2');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'mysql');

Posted
--> THIS might help

 

Thanks Bryce, It is also not accessing any of the 2200+ customers either or allowing them to log on or complete any purchases. So it isn't just the administrators it isn't checking the passwords or getting that information. So would I have to do that for them as well?

Posted
Thanks Bryce, It is also not accessing any of the 2200+ customers either or allowing them to log on or complete any purchases. So it isn't just the administrators it isn't checking the passwords or getting that information. So would I have to do that for them as well?

 

I tried your suggestion and then readded the administrators... no go here is the error I still get

 

Error Error: Invalid administrator login attempt.

Posted
I tried your suggestion and then readded the administrators... no go here is the error I still get

 

Error Error: Invalid administrator login attempt.

 

 

I also disabled SSL thinking that might be the problem and it doesn't affect it. So I'm at a loss as to why I cannot access the DB for passwords either administrators or customers.

Posted

catalog/includes/config.php

-------------------------------------

<?php

define('HTTP_SERVER', 'http://www.dreamseeds.com');

define('HTTPS_SERVER', 'https://www.dreamseeds.com');

define('ENABLE_SSL', false);

define('HTTP_COOKIE_DOMAIN', 'http://www.dreamseeds.com');

define('HTTPS_COOKIE_DOMAIN', 'https://www.dreamseeds.com');

define('HTTP_COOKIE_PATH', '/catalog/');

define('HTTPS_COOKIE_PATH', '/catalog/');

define('DIR_WS_HTTP_CATALOG', '/catalog/');

define('DIR_WS_HTTPS_CATALOG', '/catalog/');

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

 

define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');

define('DIR_FS_CATALOG', '/home/bodhitre/public_html/catalog/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 

catalog/admin/includes/config.php

---------------------------------------------

define('HTTP_SERVER', 'http://www.dreamseeds.com');

define('HTTP_CATALOG_SERVER', 'http://www.dreamseeds.com');

define('HTTPS_CATALOG_SERVER', 'https://www.dreamseeds.com');

define('ENABLE_SSL_CATALOG', false);

define('DIR_FS_DOCUMENT_ROOT', '/home/bodhitre/public_html/catalog/');

define('DIR_WS_ADMIN', '/catalog/admin/');

define('DIR_FS_ADMIN', '/home/bodhitre/public_html/catalog/admin/');

define('DIR_WS_CATALOG', '/catalog/');

define('DIR_FS_CATALOG', '/home/bodhitre/public_html/catalog/');

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');

define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');

define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

 

---------------------------------------

I disabled the ssl and also changed the website to www.dreamseeds.com from plain dreamseeds.com to see if these would make a difference.

Posted

Your site seems to be working fine. I was able to create an account, logon and logoff, did a test purchase up to paypal checkout page. I don't see any problems.

 

Minor changes

catalog/includes/config.php

-------------------------------------

<?php

define('HTTP_SERVER', 'http://www.dreamseeds.com');

define('HTTPS_SERVER', 'https://www.dreamseeds.com');

define('ENABLE_SSL', false);

define('HTTP_COOKIE_DOMAIN', 'www.dreamseeds.com');

define('HTTPS_COOKIE_DOMAIN', 'www.dreamseeds.com');

define('HTTP_COOKIE_PATH', '/catalog/');

define('HTTPS_COOKIE_PATH', '/catalog/');

define('DIR_WS_HTTP_CATALOG', '/catalog/');

define('DIR_WS_HTTPS_CATALOG', '/catalog/');

Posted
Your site seems to be working fine. I was able to create an account, logon and logoff, did a test purchase up to paypal checkout page. I don't see any problems.

 

will definately make the minor changes... I cannot log into the admin panel though and I am alos a user.... testing.... <G> I could not log on using my email and password. What browser are you using? I'm using firefox.

Posted
will definately make the minor changes... I cannot log into the admin panel though and I am alos a user.... testing.... <G> I could not log on using my email and password. What browser are you using? I'm using firefox.

Using Konqueror and Firefox. I can log in using both browsers.

 

Log in to phpmyadmin and go to your database server.

Check the customers table and see if you have any customers besides "testosc@some email".

 

Also, if you ran the script for the adminstrator table, there shouldn't be any entry in that table.

 

Note: (Firefox) If you fail to login in a tab or window, open another new tab or window to log in. Don't use the same tab or window, if failed login.

Posted
Using Konqueror and Firefox. I can log in using both browsers.

 

Log in to phpmyadmin and go to your database server.

Check the customers table and see if you have any customers besides "testosc@some email".

 

Also, if you ran the script for the adminstrator table, there shouldn't be any entry in that table.

 

Note: (Firefox) If you fail to login in a tab or window, open another new tab or window to log in. Don't use the same tab or window, if failed login.

 

Interesting.... I see where you did log in at testosc...

I did run the script for the administrator table and then readded the administrators to try to log in.

 

Still could not log in. Then after using firefox I logged onto IE to try logging in either as admin or customer... it didn't work there either. I really don't understand. You can but I can't. Glad it is working for you! Maybe it will work for everyone else too until I get it figured out! <G> I wonder if it has something to do with not all IP servers are propagated to the new IP address or the SSL (that was over 10 hrs ago). Maybe I need to wait a some more and see.

 

oh I did delete the cache on my machine as thought maybe that will also be the problem and I did try changing tabs as well... no go.

Thanks I appreciate your input and trying it. If you think of anything else let me know!

Posted

Bryce (thank you) was able to log on -create a password - almost pay for an item through paypal.

YET administrators from two different states with different browsers cannot log on to the ADMIN panel. Nor can they create account on the customer side.

 

Does anyone else have suggestions? I cleaned the cache and gone into the browser and deleted passwords. Still no go!!!

Posted

Bryce, Wanted to let you know. I found that my hoster had changed the account while I was logged on and that had fouled up in some way the sessions and administrators. Even though I deleted them and readded them. It still didn't "recognize" them. I had to actually come up with new logins. So used your suggestion you gave below to delete and then NOT re-add the old ones but had to create new administrators. That worked! THANKS much!

 

From Bryce:-------------------

 

Log in to your databse server and run this sql query.

 

DROP TABLE IF EXISTS administrators;

CREATE TABLE administrators (

id int NOT NULL auto_increment,

user_name varchar(32) binary NOT NULL,

user_password varchar(40) NOT NULL,

PRIMARY KEY (id)

);

 

Running SQL queries with screenshots

 

After running the query, go and try to login to your osc admin panel.

Posted

Thus happens if the db table got corrupted.

On times rather then deleting and adding a row.

You need to drop and add a table.

 

Satish

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...