citabriabob Posted December 1, 2021 Share Posted December 1, 2021 Doing a new install of 6.4.4 into a sub-domain and I get this message with daatabase host blanked out: Double and triple-checked databse, user etc. What now? Quote The following errors were detected: Incorrect database host, username, and/or password. Access denied for user 'aac-Robert'@'localhost' (using password: YES) Link to comment Share on other sites More sharing options...
bsmither Posted December 1, 2021 Share Posted December 1, 2021 Please verify that the database user (as configured in the database server) allows 'aac-Robert' to access it at 'localhost'. A database server user can be limited to 'localhost', '127.0.0.1', coming from a specific IP address, using some other authentication method, any method whatsoever ('*'), any one or more of these methods. So, if CubeCart wants to use 'localhost', but the server sees for 'aac-Robert' access only by '127.0.0.1', that user will be denied. In a subdomain -- so other CubeCarts in sibling folders can access that same database? Link to comment Share on other sites More sharing options...
citabriabob Posted December 1, 2021 Author Share Posted December 1, 2021 Verified that database user has all privileges to the database. Don't see where .... BUT some dumb fool entered the username with a dash rather than an underscore! Problem solved - sorry for the false issue. Thanks for the assistance, Link to comment Share on other sites More sharing options...
citabriabob Posted December 2, 2021 Author Share Posted December 2, 2021 New issue: did a "new install" of 6.4.4 into a new sub-domain and finally everything worked using the original 6.2.2 database. Except my categories, products and logo do not show up. Checked the database and they are there. Is there a database update that needs to run? Or how do I connect the new store with the contents of the database? Link to comment Share on other sites More sharing options...
bsmither Posted December 2, 2021 Share Posted December 2, 2021 I see there is a change that happened in CC623 that added a 'live_from' column to CubeCart_inventory, and if CubeCart does not know how to handle that missing column, then I can postulate (aka, wild guess) that products won't be found "live" to show. So, if that's the case, then if no products, and if CubeCart is set to not show empty categories, then no categories. The store's configuration settings are saved in the database. So, if sharing a database between two stores, that means also sharing the Store Settings. Logos (and the location of the images) are part of that. Are you using a copy of the CC622 database, or actually sharing the database? Link to comment Share on other sites More sharing options...
citabriabob Posted December 2, 2021 Author Share Posted December 2, 2021 I copied the 6.2.2 database and attempting to use that for 6.4.4. Is there an update program to add in the two columns you mentioned? We don't use Inventory. Not sharing. Standalone installation. Link to comment Share on other sites More sharing options...
bsmither Posted December 3, 2021 Share Posted December 3, 2021 You don't use inventory? Then what did you mean when having said: "My categories, products and logo do not show up"? Link to comment Share on other sites More sharing options...
citabriabob Posted December 3, 2021 Author Share Posted December 3, 2021 I guess I misunderstood "inventory". We don't use the stocking options. Still the categories and products do not show up. As to the database update scripts, does that mean I have to download each of the intervening versions, run the SQL script each time? Is there a shortcut to this? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.