srjacob Posted July 24, 2014 Share Posted July 24, 2014 Does anyone know which module contains the database name? I am creating a test prestashop on my Synology Diskstation. I copied my live Prestashop from the live web server onto the proper web directory on the Synology. However, when I go bring it up in my browser, I get the message that it can't find the database. Is there any way I could change the database name and password manually? I can backup the database on my live shop and restore it to the shop on the Synology. Thanks in advance. Steve Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted July 25, 2014 Share Posted July 25, 2014 ps mysql db connect info config/settings.inc.php suerte! Link to comment Share on other sites More sharing options...
srjacob Posted July 25, 2014 Author Share Posted July 25, 2014 That worked. However, I can't log in to the backoffice because my user name and password isn't in the database, and I can't restore my live database because I can't log in. How can I log into the backoffice? Link to comment Share on other sites More sharing options...
vekia Posted July 25, 2014 Share Posted July 25, 2014 what you've got in ps_employees table? do you see there some other accounts? Link to comment Share on other sites More sharing options...
srjacob Posted July 25, 2014 Author Share Posted July 25, 2014 Where do I find this table? Link to comment Share on other sites More sharing options...
benjamin utterback Posted July 25, 2014 Share Posted July 25, 2014 Where do I find this table? This table is in your MySQL database. Link to comment Share on other sites More sharing options...
srjacob Posted July 25, 2014 Author Share Posted July 25, 2014 OK. I see my problem, I am just not sure how to fix it. The db on the live shop is named U278p77qa, and what looks like to be the prefix (when I restore the live db to the Diskstation) is U278p77qa_ When I try to configure Prestashop on the diskstation with these parameters (db name and prefix), it can't find the proper tables. Any suggestions? Link to comment Share on other sites More sharing options...
srjacob Posted July 25, 2014 Author Share Posted July 25, 2014 (edited) Deleted for security reasons Edited July 26, 2014 by srjacob (see edit history) Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted July 26, 2014 Share Posted July 26, 2014 it's because these two fields must match define('_COOKIE_KEY_ Link to comment Share on other sites More sharing options...
srjacob Posted July 26, 2014 Author Share Posted July 26, 2014 I made them match. Didn't help. Same problem. The Diskstation Prestashop doesn't seem to be able to read the database. Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted July 26, 2014 Share Posted July 26, 2014 I made them match. Didn't help. Same problem. The Diskstation Prestashop doesn't seem to be able to read the database. this was in response to not being able to login, which I understood to be your 'next' issue. sorry I apparently mis-understood. Link to comment Share on other sites More sharing options...
vekia Posted July 26, 2014 Share Posted July 26, 2014 btw. you published data of your database also you shared cookie key and other important things... it's definitely bad for safety Link to comment Share on other sites More sharing options...
srjacob Posted July 26, 2014 Author Share Posted July 26, 2014 Well, I didn't think I shared anything important that would compromise safety. If you could delete this thread, that would be fine. I'll try to figure out my problem some other way. Link to comment Share on other sites More sharing options...
vekia Posted July 26, 2014 Share Posted July 26, 2014 i mean that datas, especially cookie key is the easiest way to for example break password in your shop topic is okay, it will be helpful for others Link to comment Share on other sites More sharing options...
srjacob Posted July 26, 2014 Author Share Posted July 26, 2014 I deleted my security data. I will try to find another way to solve my problem. Thanks for your help. Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted July 26, 2014 Share Posted July 26, 2014 the instructions given are sufficient, so use those as you try to move forward. when these don't work it's either user error or possibly you are being redirected to production (copy of shop online). good luck Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now