×This forum is read only. As of July 23, 2019, the UserSpice forums have been closed. To receive support, please join our Discord by clicking here. Thank you!
I was able to connect to my remote MySQL server when using my own PHP applications, however when I attempt to install userspice it's saying I can't connect.
Currently I'm using a web server and a separate MySQL server, both of which are using Windows Server 2016.
Is there a good way to go about debugging this? Thanks in advance!
attached a screenshot, I have port 3306 port open for an inbound rule. Notably I do not have one for outbound. Is it possible that might be needed? But as I stated at the start I AM able to connect to this server remotely via just writing a php connection string, but would love any ideas as to what the issue could be, or a good way to find out what the issue could be.
Good call to check that as well, I did not have an outbound rule from the webserver. I went ahead and set one up though, and it didn't have any effect. attached screenshot.
Only other thing I can think of is if you don't have the PDO module loaded? What version PHP are you using? MySQL? Are you doing this on Xampp? How did you compile your server features?
04-10-2019, 10:55 PM (This post was last modified: 04-10-2019, 11:02 PM by W11B2349.)
When I look at the first step to check the server settings are set up correctly, it says PDO is available and lit in green. However since you mentioned it specifically I checked my phpinfo page and found that there were no PDO drivers listed. I added:
extension=php_pdo.dll
extension=php_pdo_mysql.dll
to my php.ini file and this appears to have helped, but now I'm getting a bunch of errors when trying to actually run the queries (see attached.)
nevermind, it looks like some of the files got uploaded to the database previously. So I dropped the table and made it new again, and it worked with no problems. Thank you for your help!
Glad to hear we were able to resolve this with loading the PDO. I will look further into why the installer says PDO is available so we can make sure to validate this properly on all installations. I may contact you in the future to help debug this.
(04-10-2019, 10:55 PM)W11B2349 Wrote: When I look at the first step to check the server settings are set up correctly, it says PDO is available and lit in green. However since you mentioned it specifically I checked my phpinfo page and found that there were no PDO drivers listed. I added:
extension=php_pdo.dll
extension=php_pdo_mysql.dll
to my php.ini file and this appears to have helped, but now I'm getting a bunch of errors when trying to actually run the queries (see attached.)
nevermind, it looks like some of the files got uploaded to the database previously. So I dropped the table and made it new again, and it worked with no problems. Thank you for your help!
Have you double checked to make sure that those tables are not in the db? I'm wondering if it worked the first time and you didn't know it.
