Exception Message = User (admin@konakart.com) has been blocked. Please try again in about 10 minutes
This is the response from admin@konakart.com I get when I try to log on.
This has never happened before. Is the KonaKart server down or is something wrong at my end?
jbarb
The default setup is to block for 10 minutes after 3 unsuccessful attempts. These parameters can be modified in the properties file.
All I can think of is that either your password is wrong (check CAPS lock) or the data in the database has been changed since the password is stored in the database in a hashed format.
Quote from: trevor on March 30, 2009, 09:49:57 am
The default setup is to block for 10 minutes after 3 unsuccessful attempts. These parameters can be modified in the properties file.
All I can think of is that either your password is wrong (check CAPS lock) or the data in the database has been changed since the password is stored in the database in a hashed format.
Trevor,
Is there a way to change my password through my data base, Mysql?
I'm sure I have the correct password. I have been using Konakart admin regularly adding and modifying graphics for my products and was just preparing to add my logo to the KonaKart storefront.
Is there a possibility that I could have altered my password while on admin without using the "change password" utility? The last thing I was working on was configuring the categories and attempting to add some new graphics for them.
Will I need to uninstall /reinstall 3.2.0.0 to get my password correct?
Thanks,
Jbarb
Quote from: trevor on March 30, 2009, 09:49:57 am
The default setup is to block for 10 minutes after 3 unsuccessful attempts. These parameters can be modified in the properties file.
All I can think of is that either your password is wrong (check CAPS lock) or the data in the database has been changed since the password is stored in the database in a hashed format.
Trevor,
Also in the Tom Cat window there is some additional text after "Server startup time etc"
i.e. Today's date and then "Warn <AdminMgrFactory. java:InstantiateAdminMulti-StoreMgr:1026> Admin Multi-Store Functionality has not Been Installed.
Do I need to install this function to solve the problem ???and how do I do it if required?
Thanks,
jbarb
No, that's just to inform you that multi-store functionality isn't installed.
You could register a user in the application and then copy the hashed password of the new user into the password field of the admin user. The attribute is called customers_password and the table is customers.
Don't you remember whether or not you have changed your password?
If you haven't changed our password it won't have changed.
You can always look at the database scripts for a way to set the encrypted password for a user.... since the admin user is set up with these scripts.
Quote from: trevor on March 30, 2009, 08:29:06 pm
No, that's just to inform you that multi-store functionality isn't installed.
You could register a user in the application and then copy the hashed password of the new user into the password field of the admin user. The attribute is called customers_password and the table is customers.
Trevor,
I even uninstalled reinstalled KonaKart 3.2.0.0 and it still will not accept either the default password (princess) or my existing one. Many of the changes to the products and configuration in admin are still there so whatever is blocking me out is also there.
I found the customers table and the customers_password but do not know how to register a new user and copy the hashed password into the password field of the admin user. It appears there are some specific querys or commands to accomplish this but I have gotten that far in the Mysql tutorial as of yet. If you can offer some guidance in that regard I would be grateful.
What if I disable security altogether through the konakartadmin. properties file, get into the admin program and establish a new password and or user id once inside? Then reenable security.
I even uninstalled 3.2.0 and installed my old version of Konakart and it still will not let me in. Something is resident in the config files and it will not be removed when you do an uninstall.
Thanks,
jbarb
It seems like you could be pointing at the wrong database in one of your properties files because if you reinstall you should start with the default starting database - not one with your products.
Examples of the SQL you need to run are in the database script files - eg. konakart_demo.sql
Quote from: heidi on April 02, 2009, 05:47:07 am
It seems like you could be pointing at the wrong database in one of your properties files because if you reinstall you should start with the default starting database - not one with your products.
Examples of the SQL you need to run are in the database script files - eg. konakart_demo.sql
Trevor,
Thanks for your help.
I reinstalled 3.2.0.0 and ran the utility at the end that establishes (overwrites in my case) all of my tables. This cured the problem but understandably I lost all my prior work. Whatever caused the problem of locking me out was in the data base and not KonaKart.
This may be helpful though as there were a number of things I wanted to change anyway. I now have all of the KonaKart 3.2.0.0 User's guide and will study it in detail.
I am still a little hazy on how to customize the KonaKart storefront with my company logo and trademarks/graphics etc. while keeping the basic KonaKart storefront configuration but I am sure the User's guide will give me that insight.
For now its back to the drawing board and loading all my products (under thirty of them) and reconfiguring the rest.
Thanks,
jbarb
Quote from: trevor on March 30, 2009, 08:29:06 pm
Trevor,
I have Konakart 4.1 installed and configured with a large product base.
I had for test purposes, registered three fictitious customers with my own email addresses (three separate) for testing the order function and the email responses.
I decided I would delete two of the fictitious customers and only use the single one for testing the order function and logged off. Now I cannot log back on to the admin function with my regular password i.e. (doesn't match message) and of course blocks me after three attempts.
The last time this happened I had 3.2 installed and you advised:
"You could register a user in the application and then copy the hashed password of the new user into the password field of the admin user. The attribute is called customers_password and the table is customers.
Does this still hold true with KK 4.1 and do you mean to enter my MYSQL database to effect these changes or will re-registering the two customers in Kona Kart cure it? Also explain the "Hashed" password term.
I really would appreciate some help on this. I have come so far with KonaKart that I am almost ready to publish it and I do not want to screw up all the work I have done so far with some thing that should not be difficult for me to figure out.
However, if I make an error with some thing as simple as this and destroy all I have accomplished so far I will probably not go any further with it and just keep running my old Web page. :-[
Thanks for your help.
Jabarb
James Barber
EnviroSales LLC
.
Assuming you still have an admin user, copy the value in customers_password for the newly registered user to the customers_password attribute of the admin user. Once you've done this, you will be able to login for the admin user using the password of the newly registered user.
Wow, if you've been working on KK since version 3.2 it would be a shame to throw away 1 and half years of work !
Quote from: trevor on June 21, 2010, 08:31:27 pm
Assuming you still have an admin user, copy the value in customers_password for the newly registered user to the customers_password attribute of the admin user. Once you've done this, you will be able to login for the admin user using the password of the newly registered user.
Wow, if you've been working on KK since version 3.2 it would be a shame to throw away 1 and half years of work !
Trevor, thanks for the help.
I can log into the admin utility "Cat" and "Order" using the default password "princess" but but not "admin@konankart.com" using my original password or the default "princess." Changing passwords in the admin is obviously not global.
I have gotten to the attribute customers_password in the "Customer" table but I'm still struggling with the syntax to add the "hashed" (I'm still not sure what the term hashed means) password that I just gave to the newly registered customer in the KK web application.
I can most likely figure this out but I would appreciate your help in this edit operation of the attribute. I' m sure I am just overlooking something.
Thanks,
jbarb
(Jim)
Quote from: jbarb on June 27, 2010, 12:12:27 am
Quote from: trevor on June 21, 2010, 08:31:27 pm
Assuming you still have an admin user, copy the value in customers_password for the newly registered user to the customers_password attribute of the admin user. Once you've done this, you will be able to login for the admin user using the password of the newly registered user.
Trevor,
I reinstalled 4.1 without reloading MYSQL and retained my products etc.
I can log on to cat and order using my original password (used for admin also)
but still cannot log on to admin. I assume this means I still have an admin user? If not what is my admin user? Now is "customers_password" an attribute to the MYSQL table "customers" in my data base?
Do I register this new customer in the KK webpage? What is a hashed password and where are the admin passwords in the database kept?
At this juncture I would just as soon disable all the security for the admin user until I have finished modifying the web page prior to publish. I can reinstate security after I'm finished with my customization.
This is the second time my admin password just went bad (only on "admin") for no apparent reason. Is it possible to disable user security while being blocked from the admin by going into my mysql database and how is it done?
Thanks
jbarb
(Jim)
I'll try again :)
- Register a new user in the store front application using a password "abc123xyz"
- Using a database tool, copy the value in customers_password (attribute of the customers table) for the newly registered user to the customers_password attribute of the admin user. Note that the value that you copy won't be "abc123xyz" since it has been "scrambled" for security reasons
- Log into the admin application as the admin user with the password "abc123xyz" and it should work.
Thanks for the help Trevor. I followed your instructions and discovered that in the attribute customers_password, the entire row, "admin@Konakart.com" is missing. Cat@konakart is there as is order@konakart and "user" but not admin@konakart.com.
I must have inadvertently deleted it while cleaning up what I considered to be useless customers from the admin application.
Obviously I do not know which customer is connected to the admin however I'm sure I deleted it and that is when I could no longer get in to to the admin application.
Can I simply replace that row by copy and pasting the cat@konakart.com fields with the exception of the customer number? Or will I need to duplicate the original admin fields in that row in customers_passwords?
Thanks,
James (jbarb)
I'll try again :)
Quote from: trevor on June 30, 2010, 08:22:57 am
- Register a new user in the store front application using a password "abc123xyz"
- Using a database tool, copy the value in customers_password (attribute of the customers table) for the newly registered user to the customers_password attribute of the admin user. Note that the value that you copy won't be "abc123xyz" since it has been "scrambled" for security reasons
- Log into the admin application as the admin user with the password "abc123xyz" and it should work.
You've really got yourself in a mess haven't you :-(
You could always reinstall the database and start again.
If that's not a good option for you, why don't you log in to the Admin App as order@konakart.com and create a new admin user. Make sure you create the new user as an admin user.
This is a good start but you're not out of the woods after doing that because your new user will not have any privileges to allow him to do anything in the Admin App.
So.. since you have deleted your one and only authorised user (admin@konakart.com in your case) (which is a very bad thing to do), you will have to turn to SQL to allocate some privileges rather than simply using the Admin App for this task.
Run this SQL statement using your newly-created user's email address (instead of "admin@konakart.com"):
INSERT INTO kk_customers_to_role (role_id, customers_id, date_added) SELECT 1, customers_id, now() FROM customers WHERE customers_email_address = 'admin@konakart.com'
(You're allocating role 1 to the new user which should give him the super user privileges... naturally this assumes you haven't changed the roles in your system)
Thanks Ming,
I am really in a mess but I am determined to learn from my mistakes.
I do not believe I have altered the roles but I can't be sure of anything at this stage.
I'm using a MYSQL Query Browser to access the database. I noticed in the "Customers Table" attribute Customers_Passwords, that even though the user "order@konakart.com" and "cat@konakart.com" user IDs are there the "admin@konakart.com" user is missing (this is what I must have deleted).
Also a sequential number (WHICH I assume belongs to the "admin user") is also missing at the start of the row.
If "admin@konakart.com" is in fact missing (because I deleted it from the admin application) from that table attribute, Customers_Passwords, can I just add it to the table attribute or must I use the "order@ konakart.com" user to log on to the admin utility and make up the new admin user there?
If so, (use the query browser to edit "Customers" can I use the same basic syntax (as order and cat) i.e. make up a user name and an email address?
I realize I will still also have to follow your other instructions regarding the customers ID role change.
Again, I really appreciate your help with this problem. I am certainly going to be more cautious when altering (deleting) other parts of the admin utility.
Thanks,
jbarb
Jim
I would just follow my previous instructions if I were you.
Quote from: ming on July 10, 2010, 11:41:59 am
Run this SQL statement using your newly-created user's email address (instead of "admin@konakart.com"):
INSERT INTO kk_customers_to_role (role_id, customers_id, date_added) SELECT 1, customers_id, now() FROM customers WHERE customers_email_address = 'admin@konakart.com'
Ming,
I ran the SQL statement as you instructed: "INSERT INTO kk_customers_to_role (role_id, customers_id, date_added) SELECT 1, customers_id, now(14) FROM customers WHERE customers_email_address = 'admin@konakart.com'" However it did not solve the problem of not being able to log on to the admin utility, (username or password does not match).
The only thing I added to the SQL statement was the new cust ID # 14. Was there more that I should have added to the SQL statement i.e the actual new role ID, customer ID and date added in the parenthesis and the new email address before " = 'admin@konakart'?
Thanks,
jbarb
You didn't do what I said at all. Follow the instructions more carefully if you want the SQL to work.
Ming,
I have tried every which way the MYSQL manual says to arrange the syntax for the insert, select query but nothing seems to work.
My new admin users role ID is "6", email is; productsales@envirosales.com, date added etc.
Where do I insert this into the query? I get conflicting syntax instructions from the MYSQL site's manual. I either get an error or referral to the manual. MYSQL version is 5.0.51a. Please Help! I'm almost there as I am learning.
Thanks.
James
INSERT INTO kk_customers_to_role (role_id, customers_id, date_added) SELECT 1, customers_id, now() FROM customers WHERE customers_email_address = 'admin@konakart.com'
did you try:
INSERT INTO kk_customers_to_role (role_id, customers_id, date_added) SELECT 6, customers_id, now() FROM customers WHERE customers_email_address = 'productsales@envirosales.com'
note 1: I have used 6 as the roleId (because that's what you said, but I think you may have that wrong)
note 2: I have used your admin user's email address
BUT.. a new admin user has nothing to do with roleIds so I think you may still be confused? Users are users and have a customers_id, roles are roles and have a role_id. They are different things.
Thanks Ming,
Like you wrote to me, "just follow my instructions," so I did and it worked.
I must have been looking for a more complicated solution and overlooked the obvious.
Thanks or all your help. I believe I leaned some valuable lessons, not to mention learning more on how to work with MYSQL.
Thanks
Jim.