Messages

How do I start the Apache Tomcat servlet engine once the KonaKart based website is uploaded and installed on my server?

I am in the process of uploading konaKart (Now Envirosales.com) to my server. the KonaKart web page uploaded tyo my server without a hitch.

However I must use the "mysqldump" command to backup my mysql database(s) to upload to the server. It must be run from the mysql "SHELL" command interpreter. There are multiple databases in the installed mysql that appear to be required to be uploaded together.

Where do I find the "SHELL" command enterpreter prompt in mysql in order to run the mysqldump command in order to use mysqldump?

Thanks

jbarb

How can I change the username in MySQL?
I changed the MySQL username in my KonaKart admin configuration files but now mysql will not allow KonaKart admin to start. The error message I get when I attempt to start KonaKart says I must change the config files in the servlet engine to reflect this username change. How do I accomplish this?

My MySQL query browser shows the old username and will start using the old username but will not start if I type in the new username that I changed in the KonaKart admin config files. There is obviously a parameter in the MYSQL configuration itself that requires editing to change this username.
Where can I locate this parameter in MySQL?

Thanks

jbarb

This sounds like a question for your hosting company

Thanks Michael,

I neglected to change the default database username "root" in MySQL. Can I change this without causing a major problem like having to re-run the KonaKart install wizard?
I have a MySQL query browser utility installed that has been quite helpful in the past for making changes in MySQL and upgrading versions of KonaKart. Can I use this to effect changes in KonaKart or is there and admin app in KonaKart that I can edit if necessary to reflect the change in the database username if needed?

I have (asked my service provider) and am waiting for their answer. I have a feeling they want me to simply upload all my tables from my installed database MySql 5.0.51 to the existing MySql server supplied database MySQL 4.1.22. I don't believe this will work.


Thanks
Jbarb

I'm having problems with my web hosting server regarding uploading MySQL database ver 5.0.51 to my new site.

It seems an existing earlier version mysql database is in existence in conjunction with my old web site but contains no tables so it appears it does not serve a purpose for use with my old html site. The existing server supplied MySQL database is also and earlier version, 4.1.
All I want to do is replace the earlier version that exists with my newer MySQL database version 5.0.51.
They do not seem to know if this is possible and are checking on it now.

Should this be a problem and why can't I simply upload and replace the existing MySQL database with my newer configured version for use with KonaKart.
Also I neglected to change the username on the database from "root". Can I change it now without causing myself problems?



Thanks,  Jim (jbarb)

Brian,

Is it possible to change the Yourpay module, or any pay gateway module for that matter, to send the credit card info along with the product order to the shipper for processing the card info, through his gateway?
My business' income is earned through sales commissions on the orders and I do not handle monies from purchases.

I need this aspect as uncomplicated as possible. Is SSL encryption insufficient protection for email submission of this credit card data? What type of encryption or secure methods do the payment modules use or do the processing entity use their own secure methods of receiving secure data?

Thanks.
Jim

Brian,

Thanks for your reply.

I did Review the User's guide section on creating a module however the module (I have "YourPay" module installed) is too involved for what I am attempting to accomplish. I do not believe I need a sophisticated payment gateway to collect the credit card info along with the order details and send all of this info to my company email address.
I then forwarded this to a distributor for product ship and credit card processing. I handle no money nor stock/ship products.
That is left to my clients.
Can credit card info be included in the "Order Details" en.vm by adding additional text boxes to the checkout section and then emailed to my company email address, productsales@envirosales.com? Which class or jsp would I need to modify to accomplish this?
Also, I noticed if I place an order to a fictitious customer using one of my email address', it will send an order confirmation to the fictitious customer. Does KonaKart use a CGI bin function once on-line to communicate order information?

Thanks,
jbarb

Jim

I want to configure my credit card input so as to forward the customer's credit card data to my distributor for processing it instead of myself. Do I need to modify one of the existing modules (I do not want them processed through a third party contained within the konakart payment modules) or simply use the order information message generated with the credit card info included using an ssl supplied by my service provider.? Can I configure one of the classes to accomplish this?

Thanks.

Jim
(jbarb)

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.

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'

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

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

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 

• 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.

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)

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)