Connect to storefront and database on a different server.

[abcschooldr]

PHP 5.6.40 PHPMyAdmin version: 7.3.27 Fast and Easy Checkout

Last week my zen-cart was copied to another domain because I couldn't stop google from throwing a phishing warning on my Zen-cart storefront order page.

Both zen-carts, on 2 different domains have their own storefront, admin mgmt and database. So...I have Zen-cart fully set up on both domains.

Purchasers are still finding the old order form storefront and ordering from it.

I use Zen-cart for students to order courses, and the moodle course management system that students use to access online courses, verifies the order on the zen-cart database before it allows a student to log-in to his/her course. I switched the moodle check to find the order in the new zen-cart database, so the student can't get into the course if he/she orders on the old order form, connected to the old database. Also the student's information enters into the old admin site.

Is it possible to keep the old order form storefront operational but have it send the student order information to a Zen-cart database and admin site on another domain so that everything would gather in one spot and the student can be verified by the moodle?

[DrByte]

If your database is still on the same physical server there should be no lag involved by specifying the "new" database in the "old" site's configure.php files.

[abcschooldr]

One database is on abcrealestateschools.com and 1 database is on abcrealestateschool.com. I want both storefronts to send information to the admin and database on abcrealestateschool.com. So I need to tell the storefront on abcrealestateschools.com to send the orders to the admin and database on abcrealestateschool.com and not the database and admin on its server on abcrealestateschools.com.

[DrByte]

Are they actually physically separate "servers"? Or just different domains on the "same server" hardware?

Apart from security, the main concern is speed of database queries:
Fastest: both databases on the same physical server
Next fastest: both databases on servers in the same network, with proper firewall rules allowing both servers to talk to each other
Slowest: servers on different networks

Your hosting company should be able to set up the database firewall rules on the new server to allow only the IP address of the old server to "use" the new server's database.
Then in your old site's configure.php files you'd put all the DB_XXXXXX credentials copied from the new server's configure.php. Admin and non-admin.

[abcschooldr]

They are both hosted by siteground, but the database locations are different. So are there multiple config.php files to change?

[DrByte]

So are there multiple config.php files to change?

Every Zen Cart store (at least until until v1.5.7 which is the most recent as of today) has two configure.php files: /includes/configure.php and /admin/includes/configure.php ... and both need the database details set in them.

[swguy]

Last week my zen-cart was copied to another domain because I couldn't stop google from throwing a phishing warning on my Zen-cart storefront order page.

I really think you should spend time figuring this out, because it sounds like your site has been hacked and you haven't actually fixed the issue. (This means that sooner or later Google will be throwing phishing warnings on the new site.)

[abcschooldr]

I was never hacked. My main site is abcrealestateschool.com. I linked to abcrealestateschools.com for educational materials and the zen-cart order form. Google didn't like it that I was sending students to such a similar site to order. They are both protected and safe but they were a flag to google.

[abcschooldr]

Siteground responded:

I see. I'm afraid that this is actually down to the website configuration more than the hosting configuration. If the files are saved with the same database details this means that the websites will open the information from the same database and may not show up as two separate websites. I would recommend reaching out to a professional website developer, as this is more of a development related inquiry. As a hosting provider we focus on finding and resolving hosting related issues and as such website configuration and development does fall outside of our hosting scope of support.

I want abcrealestateschools.com to remain a usable Web site because I have students using that site for their courses, different courses for the courses on abcrealestateschool.com. I was hoping to let students use both domains to order, but have a central location for the student information to flow in to.

[abcschooldr]

I changed the 2 config files. Because the set-up is identical, there were only 7 url changes - including changing the location of the catalog. I had to change file permissions to change one of the config files. Because it wouldn't let me change the permission back to 444, after the change, and when I clicked on the page link, it was a Zen-cart message - I panicked and changed it back. Than I had to ask siteground to fix the permissions anyway.
Do you think it would have worked if I had been able to change the permissions back to 444? It is possible to have multiple storefronts, all pouring into a single database and admin just by changing those 2 files to the new database location?