PHPRad Classic Initial 2.7.3 Forum

PHPRad Forum => Issues => Topic started by: MAH on February 22, 2019, 09:52:48 AM

Title: Error connecting with a mysql database
Post by: MAH on February 22, 2019, 09:52:48 AM

Hello friends

I install the version phprad 2.6.1 is well installed but when establishing the connection with a database mysql gives me the following error "the host does not support SSL connections" if someone can help me to solve this problem and thank you

Title: Re: Error connecting with a mysql database
Post by: ewwgee on February 22, 2019, 10:04:41 AM
Hello, check this thread for a similar problem and solutions:

https://forum.radsystems.io/index.php?topic=173.msg449#msg449
Title: Re: Error connecting with a mysql database
Post by: MAH on February 22, 2019, 10:23:56 AM

for me I use a local server and not in a cpanel
Title: Re: Error connecting with a mysql database
Post by: MAH on February 22, 2019, 01:34:12 PM
Please how can give me a answer for this problème
Title: Re: Error connecting with a mysql database
Post by: Emman on February 22, 2019, 02:31:23 PM
it's better to build your application on the local server then upload to your web server. You can google on how to setup local server with xampp... Beside you don't want to waste time connecting with live data. The process is slow and tedious.

Regards
Title: Re: Error connecting with a mysql database
Post by: MAH on February 22, 2019, 07:07:55 PM

I connect to xampp and he gives me the same things and I work in local mode
Title: Re: Error connecting with a mysql database
Post by: Emman on February 22, 2019, 08:58:25 PM
Please add this to your the database server name

to become "localhost;SslMode=none"

(https://snag.gy/p4Qwjk.jpg)
...

Title: Re: Error connecting with a mysql database
Post by: leo on January 26, 2020, 08:01:24 AM

Hello guys. I'm having the same problem. someone could give a help on how to solve this problem.
Title: Re: Error connecting with a mysql database
Post by: willvin on January 26, 2020, 10:55:13 AM
@leo‍ your error is different from the one mentioned above. Yours have to do with your MySQL server not running, please make sure you have installed Xampp or Wamp server and make sure you have launched/started the server and that Apache and MySQL servers are running.

Regards.
Title: Re: Error connecting with a mysql database
Post by: cristydavidd on November 08, 2022, 05:58:53 AM
In some of the ways, spacing and the order of parameters in the MySql connection string does matters. So, stick to the standard format:

MysqlConn.ConnectionString = "Server=localhost;Port=1234;Database=My_Mysql_Database;Uid=root;Pwd=root;"

If the above connection string fails,  try update your c# mysql connection string as shown below (without port variable as well):

MysqlConn.ConnectionString = "Server=localhost;Database=My_Mysql_Database;Uid=root;Pwd=root;"

Or, sometime the problem could be on your windows firewall, make sure your server allow access to all port associated with your mysql database.

http://net-informations.com/q/faq/mysql.html