2. PHPRunner General questions
  3. connecting to an SSL MySQL server
This topic is locked

connecting to an SSL MySQL server

 		11/7/2014 11:01:11 AM
PHPRunner General questions
Myr0n author

Hello everybody,
Probably for a lot of you is an easy question but for me nop <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=22742&image=1&table=forumtopics' class='bbc_emoticon' alt=':P' />
We move all our phprunner apps to an external webserver (1and1) and our databases are in the company (why? is a space thing, some databases have a lot of info and don't want to pay to 1and1 for that thing)
Our mysql has SSL connection and the company wants that the connection between the external webserver and the databases have ssl connection, everything was fine before that decision.
Since the database administrator gave grants to all the users with REQUIRE SSL, all the phprunner apps they are unable to connect to our databases that are in the company.
Now the question is,
What can I do to solved this issue?
Can you help me please.
I apply manually to a phprunner app the example that I found in this forum but every time that I made a change in the app, I need to apply.
If you have just one phprunner app, it will be ok, but when you have more than 5, starts #^##&^&#, you know what I mean.
Thank you so much for your answers.
p.d.

I am using phprunner 7.1
S
 		swanside 11/8/2014



Hello everybody,
Probably for a lot of you is an easy question but for me nop <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=76173&image=1&table=forumreplies' class='bbc_emoticon' alt=':P' />
We move all our phprunner apps to an external webserver (1and1) and our databases are in the company (why? is a space thing, some databases have a lot of info and don't want to pay to 1and1 for that thing)
Our mysql has SSL connection and the company wants that the connection between the external webserver and the databases have ssl connection, everything was fine before that decision.
Since the database administrator gave grants to all the users with REQUIRE SSL, all the phprunner apps they are unable to connect to our databases that are in the company.
Now the question is,
What can I do to solved this issue?
Can you help me please.
I apply manually to a phprunner app the example that I found in this forum but every time that I made a change in the app, I need to apply.
If you have just one phprunner app, it will be ok, but when you have more than 5, starts #^##&^&#, you know what I mean.
Thank you so much for your answers.
p.d.

I am using phprunner 7.1


When you open your project, and connect to your database, in the Upload phprunner,php part, and connect to FTP server, would you not just change the Port from 21 to 22 for SSL? The port for your web would be 443 that would give you https:// access, I am guessing, but thats about all?

I can try it out later on a server I have and se how it works, when I get home this afternoon if that helps
Myr0n author 11/8/2014



When you open your project, and connect to your database, in the Upload phprunner,php part, and connect to FTP server, would you not just change the Port from 21 to 22 for SSL? The port for your web would be 443 that would give you https:// access, I am guessing, but thats about all?

I can try it out later on a server I have and se how it works, when I get home this afternoon if that helps


Hi
In développement mode meaning connecting me from PHPRUNNER IDE I am using https://intranetserver/phprunner.php

But my problem is the php connection to the database through the Port 3306 of mysql server that is using ssl and the client to connect to the database should have the respective certificates if they don't have the certificates then they are not able yo connect to the database.
Thank you
Admin 11/8/2014

Check MySQLiConnection.php file in source\connections folder. This is where PHPRunner connects to MySQL and function connect() is the one that you need to modify adding the code that sets SSL options.
Myr0n author 11/11/2014



Check MySQLiConnection.php file in source\connections folder. This is where PHPRunner connects to MySQL and function connect() is the one that you need to modify adding the code that sets SSL options.


Thank you so much, I start working on it <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=76207&image=1&table=forumreplies' class='bbc_emoticon' alt=';)' />