stonenote Posted October 30, 2008 Posted October 30, 2008 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');
stonenote Posted October 30, 2008 Author Posted October 30, 2008 --> 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?
stonenote Posted October 30, 2008 Author Posted October 30, 2008 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.
stonenote Posted October 30, 2008 Author Posted October 30, 2008 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.
BryceJr Posted October 30, 2008 Posted October 30, 2008 Post your configure.php files for both catalog and admin WITHOUT the database info.
stonenote Posted October 30, 2008 Author Posted October 30, 2008 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.
BryceJr Posted October 30, 2008 Posted October 30, 2008 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/');
stonenote Posted October 30, 2008 Author Posted October 30, 2008 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.
BryceJr Posted October 30, 2008 Posted October 30, 2008 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.
stonenote Posted October 30, 2008 Author Posted October 30, 2008 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!
stonenote Posted October 30, 2008 Author Posted October 30, 2008 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!!!
stonenote Posted November 2, 2008 Author Posted November 2, 2008 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.
satish Posted November 2, 2008 Posted November 2, 2008 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.