[Cialug] mysql ssl

[jim kraai]

from https://dev.mysql.com/doc/refman/8.0/en/client-error-reference.html
<https://docs.oracle.com/cd/E19078-01/mysql/mysql-refman-5.0/error-handling.html>Error
number: 2002; Symbol: CR_CONNECTION_ERROR;
Message: Can't connect to local MySQL server through socket '%s' (%d)

"Can't connect to *local* MySQL server "

is the client  webserver (Rhel 8, php 7.2.11) on trying to connect locally
instead of to centos 7 mariadb server?


On Mon, Jul 20, 2020 at 12:20 PM Dave Hala <dave at 58ghz.net> wrote:

> That was a typo.  It's mysql error 2002, not 200. Sorry about that.
>
>
> On Mon, Jul 20, 2020 at 12:14 PM Todd Walton <tdwalton at gmail.com> wrote:
>
> > A "200" as an HTTP status code means success. Did you mean that the 200
> is
> > an HTTP status? Or is that coming from somewhere else?
> >
> > --
> > Todd
> >
> >
> > On Wed, Jul 15, 2020 at 1:34 PM Dave Hala <dave at 58ghz.net> wrote:
> >
> > > I've got a centos 7 mariadb server that I upgraded to mariadb
> 10.0.38.  I
> > > enabled the ssl connections.   From my webserver (Rhel 8, php 7.2.11),
> > I'm
> > > not able to make a ssl connection using php mysqli_real_connect().  I
> > get a
> > > 200 connect refused error.    Firewalld and selinux are disabled on
> this
> > > machine for testing.
> > >
> > > I was able from the webserver console to make an ssl connection using
> > > "mysql  -h xxx.xxx.xxx.xxx -u myuser -p mypass"  to the mariadb server.
> > > After making the connection I logged into the mariadb server confirmed
> it
> > > was an ssl connect.
> > >
> > > From apache/php ,no error messages in the mariadb, php or apache logs.
> >  I
> > > see the 200 error by returning the result from the
> mysql_real_connect();
> > >
> > > Anyone got any ideas on how to troubleshoot this?
> > >
> > > :) Dave
> > > --
> > > NIFCAP  -The Premier Client Intake System for Non-Profit Organizations.
> > > https://www.osis.us
> > > _______________________________________________
> > > Cialug mailing list
> > > Cialug at cialug.org
> > > https://www.cialug.org/cgi-bin/mailman/listinfo/cialug
> > >
> > _______________________________________________
> > Cialug mailing list
> > Cialug at cialug.org
> > https://www.cialug.org/cgi-bin/mailman/listinfo/cialug
> >
>
>
> --
> NIFCAP  -The Premier Client Intake System for Non-Profit Organizations.
> https://www.osis.us
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> https://www.cialug.org/cgi-bin/mailman/listinfo/cialug
>