Configuration assistance - setup on Synology RS2211

[scottyk81]

Hi,

 

I am new to osCommerce so am hoping that someone can assist me. I have downloaded and installed both MariaDB and osCommerce on my Synology box without any issues and the website loads etc on the local network with no issues - can log in and modify it without any issues. but when I try to log into the website from a remote pc I can login to the NAS no issues but when I try to load the website from the browser I am in it comes up with " We're having trouble displaying this page". I think that from a remote pc I am having database issues - after looking into this I think that I need to setup the database so that it allows remote connections.

 

I am having issues finding any help to solve this issue - I have gone through creating a my.cnf file and made sure that the skip networking was removed from it - but also I read that I might need to bind an IP address?? I did all that but got errors saying that MariaDB couldn't load the my.cnf file so resulted to default settings. Not sure where the error was.

 

So basically just need some assistance from someone that can help me set the remote side of accessing my website.

 

Many thanks

[MrPhil]

If you have osC installed on a server, it should be using the local database (as specified in the configure.php files). When you say you are "logging into the website from a remote PC", what exactly do you mean? If you're using an ordinary web browser to access your website on the server, there is no remote DB access going on. If your remote PC is actually trying to remotely access your database (make queries), that's a whole different issue. That would require special setup of the server and database to allow remote DB access, which I can't help you with.

 

Try to access a simple HTML page from a remote browser, to see if you have that part of your system set up correctly, before jumping to assumptions that it's a DB problem.

[MrPhil]

By the way, be aware that MariaDB is an open-source fork of MySQL (which is now owned by Oracle, and whose future is uncertain). As osC (and most other open-source projects) are written specifically for MySQL, it is possible that MariaDB and MySQL will drift apart in their behavior over time, even though the stated intent of MariaDB is to stay 100% compatible. Just be aware that there's no guarantee made that osC will continue to work with MariaDB, although it would be very good if an abstract database layer were added to osC to enable it to use a range of relational databases, and not just MySQL. Of course, it would be a little slower.

 

Synology is, to the best of my knowledge, a storage system and not a server brand. I'm worried that you are not familiar enough with your system to safely work under the hood. If you are trying to set up and maintain your own server, and have no previous experience doing this, be aware that hackers will eat you for breakfast. You would be much better off starting out with a commercial shared server (Linux/Apache), where an experienced crew can help protect you against the bad guys. You can always upgrade later to VPS/cloud, dedicated, COLO, etc. as needs and experience dictate.