BisqueBead Posted May 27, 2016 Share Posted May 27, 2016 I can't login.I keep getting the " Invalid username or password" message. I have tried to get a password reset and I am not receiving the email for it either. How do I resolve this? I have orders I need to fill! Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 27, 2016 Share Posted May 27, 2016 Eventually (maybe after the fifth time), CubeCart will have locked out attempts from your IP address and web browser. Please let us know the exact version of CubeCart you are using, if you recall. You will be needing to access your database directly. So, be ready to log in to your hosted account's Cpanel. Quote Link to comment Share on other sites More sharing options...
BisqueBead Posted May 27, 2016 Author Share Posted May 27, 2016 I can't get into the admin area to tell you what version I have. Its 6. something I have been locked out several times over the past 24 hours. I am in my hosts Cpanel right now. Not seeing anywhere to change the password. Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 27, 2016 Share Posted May 27, 2016 Please use the Cpanel's access to your database. It will probably be phpMyAdmin. In phpMyAdmin, examine the table CubeCart_admin_users. Find the row with your name. Make sure the email is correct. Quote Link to comment Share on other sites More sharing options...
BisqueBead Posted May 27, 2016 Author Share Posted May 27, 2016 I am in the phpMyAdmin. how do I get into the "table" Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 27, 2016 Share Posted May 27, 2016 In phpMyAdmin, the left panel is the list of your databases. One of them will be the database that CubeCart uses. Select that database. Probably just click on the name. Then there will be shown a list of the tables. Probably just click on the name of the table. I don't have a phpMyAdmin locally installed on my development machine, so I can't tell you exactly how to get to the Cubecart_admin_users table. Quote Link to comment Share on other sites More sharing options...
BisqueBead Posted May 27, 2016 Author Share Posted May 27, 2016 I found it. the email address is correct. Do I change the password there? Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 27, 2016 Share Posted May 27, 2016 If the email address is correct, then you should have received an email to have responded to. Maybe it is in your SPAM folder? Anyway, let's also make sure your login is not being blocked. In this table, in the row for your login, look at the "failLevel" and "blocktime" columns. If they are not both zero, make them that way. Then, in the table CubeCart_blocker, delete any and all rows that there may be shown. Quote Link to comment Share on other sites More sharing options...
BisqueBead Posted May 27, 2016 Author Share Posted May 27, 2016 Fail level was 3. Changed it to 0 Blocktime was 0 In the table CubeCart_blocker, there was one thing. I deleted it. BTW, you ROCK!!! :-D I tried the email recovery again. Still nothing. And nothing in the spam folder either. This is driving me crazy. Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 27, 2016 Share Posted May 27, 2016 Check if you can log in. You do not need to log out of Cpanel as yet. If you can't, then maybe your password is not what you remember it to be. If this is the case: 1. Enter the desired password in the "password" field. Then, using the Function drop-down selector, choose MD5. 2. Leave the "salt" field blank. 3. Set "new_password" to "0". 4. Set "status" to "1". 5. Set "super_user" to "1". Try to log in. Quote Link to comment Share on other sites More sharing options...
BisqueBead Posted May 27, 2016 Author Share Posted May 27, 2016 ok. tried to login. still not working. Same password I have always used. Haven't changed it. I don't see a FUNCTION drop-down selector. I DO see aSeach drop down that has the 2,3,4,and 5 that you listed. But the are no numbers to choose. only symbols. =, >, =>, etc I am assuming the the = sign is 0? the > sign is 1? And I don't see the MD5 at all Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 27, 2016 Share Posted May 27, 2016 Located right at the cell where you entered the desired password, is there some sort of control or indicator that there exists a set of things that you can do against the value that you just entered? Quote Link to comment Share on other sites More sharing options...
BisqueBead Posted May 27, 2016 Author Share Posted May 27, 2016 I think I found it, under inserts. Do you want just the password on MD5? Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 27, 2016 Share Posted May 27, 2016 Yes, just the password. Quote Link to comment Share on other sites More sharing options...
BisqueBead Posted May 27, 2016 Author Share Posted May 27, 2016 ok. did that. I tried to login again and it doesn't work. :-( I also resent the password reset email. No email received. Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 27, 2016 Share Posted May 27, 2016 Reload the table in phpMyAdmin. (Having tried to login should have changed the values of that row in the table from the simple MD5'd password to a more complex one.) Make the changes, again, to the values in the columns as I outlined above. (I assume phpMayAdmin updates the values of the table immediately, but I'm not sure. So, if there is a Save button, be sure to do that.) Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted May 27, 2016 Share Posted May 27, 2016 I've been following along, thinking this might be something I should learn how to do, just in case. Anyway - my password field is not currently marked as MD5 - the Function is blank. The password is obfuscated in some way, however, as it's a long string of letters and numbers. Quote Link to comment Share on other sites More sharing options...
BisqueBead Posted May 27, 2016 Author Share Posted May 27, 2016 I made the changes again. And tried to log in again. No good. Locked out for 5 more minutes. Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 27, 2016 Share Posted May 27, 2016 The drop-down (or whatever it is) applies the function to the value. There is no "marking" of what the value currently represents or how it got that way. A series of 32 seemingly random characters with a blank salt is the MD5'd old-style password (CC3). A series of 128 seemingly random characters with a value in the salt column is the new-style password (CC5/6). One failure is all that is needed to prove the password isn't going to work. Go to the CubeCart_blocker table and delete the row that should now be there. Back at the Cubecart_admin_users table, be sure to set to "0" the 'failLevel' and 'blockTime' columns. Quote Link to comment Share on other sites More sharing options...
BisqueBead Posted May 27, 2016 Author Share Posted May 27, 2016 when I first looked at the password there, it was the 128 random characters. Now with the MD5 and the blank (NULL) salt, it is 32. IT WORKED!!!!!!!! Finally!!!! Thank you SO VERY MUCH for your help!!! Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 27, 2016 Share Posted May 27, 2016 The only reasonable answers to why CubeCart is not processing the password are: 1. Your hosting provider changed something regarding the version of PHP your site is using, or 2. There is a code snippet that may be interfering with logging in. Look in the table CubeCart_code_snippet. For every snippet listed, set it's value in the 'enabled' column to "0". Let us know if there are any entries in the table that does not seem legitimate to you. Also, if the password is 32 characters, the salt is null, then the 'new_password' must be "0". Quote Link to comment Share on other sites More sharing options...
bsmither Posted May 27, 2016 Share Posted May 27, 2016 Also, please determine the exact version of CubeCart you are using. If it is CC6.0.6 or earlier, then you MUST upgrade. Quote Link to comment Share on other sites More sharing options...
mediadogg Posted June 29, 2016 Share Posted June 29, 2016 I am having this same problem, and I am about to explore using the solutions provided here. My concern is about the comment about "must" upgrade. The last and only time I attempted an upgrade, my storefront got hosed, and I finally had to get my hosting facility to revert to a backup. My business is a small step above hobby level. I would like to purchase support for converting my site, but that would wipe out a year or two of revenues. Profit, if nay, is razor thin. Is it reasonable for me to consider upgrading on my own? Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted June 29, 2016 Share Posted June 29, 2016 There are security reasons for saying the upgrade is a must. As to whether you can upgrade on your own - is your store stock code, or do you have edits you have made and/or mods that required edits to the core code? What version are you currently on and what skin do you use? (Sorry - didn't notice your nice signature!!) Quote Link to comment Share on other sites More sharing options...
bsmither Posted June 29, 2016 Share Posted June 29, 2016 According to your signature, you are running CC3. The comment above about CC606 applies only to the CC6 family and several of the latest versions of the CC5 family. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.