[Lazarus] TMysql57Connection won't connect to localhost

Discussion:

Larry Dalton via Lazarus

2018-05-29 03:36:01 UTC

I am running lazarus 1.8.2 on linux mnt 17.2.
I am trying to access a mysql database that was installed with Bitnami.

- Server: Localhost via UNIX socket
- Server type: MySQL
- Server connection: SSL is not being used [image: Documentation]
<http://127.0.0.1:8080/phpmyadmin/doc/html/setup.html#ssl>
- Server version: 5.7.22 - MySQL Community Server (GPL)
- Server: Server: localhost:3307
<http://127.0.0.1:8080/phpmyadmin/index.php>
- Protocol version: 10
- User: ***@localhost
- Server charset: UTF-8 Unicode (utf8)

- Apache
- Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 -
$Id: 38fea24f2847fa7519001be390c98ae0acafe387 $
- PHP extension: mysqli[image: Documentation]
<http://127.0.0.1:8080/phpmyadmin/url.php?url=https%3A%2F%2Fsecure.php.net%2Fmanual%2Fen%2Fbook.mysqli.php>
curl[image: Documentation]
<http://127.0.0.1:8080/phpmyadmin/url.php?url=https%3A%2F%2Fsecure.php.net%2Fmanual%2Fen%2Fbook.curl.php>
mbstring[image: Documentation]
<http://127.0.0.1:8080/phpmyadmin/url.php?url=https%3A%2F%2Fsecure.php.net%2Fmanual%2Fen%2Fbook.mbstring.php>
- PHP version: 7.1.17

- Phpmyadmin Version information: 4.8.0.1, latest stable version: 4.8.1
<https://www.phpmyadmin.net/files/4.8.1/>
- Web Address http://127.0.0.1:8080/phpmyadmin/

I am using localhost as hostname on Tmysql57Connection.

I cannot connect the Tmysql57Connection to localhost.
Help?

Michael Van Canneyt via Lazarus

2018-05-29 05:57:47 UTC

Permalink

What is the error you are getting ?

If you want to connect through unix socket, you should leave hostname empty.
If you set it to localhost, TCP/IP will be used.

Michael.

Post by Larry Dalton via Lazarus
I am running lazarus 1.8.2 on linux mnt 17.2.
I am trying to access a mysql database that was installed with Bitnami.
- Server: Localhost via UNIX socket
- Server type: MySQL
- Server connection: SSL is not being used [image: Documentation]
<http://127.0.0.1:8080/phpmyadmin/doc/html/setup.html#ssl>
- Server version: 5.7.22 - MySQL Community Server (GPL)
- Server: Server: localhost:3307
<http://127.0.0.1:8080/phpmyadmin/index.php>
- Protocol version: 10
- Server charset: UTF-8 Unicode (utf8)
- Apache
- Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 -
$Id: 38fea24f2847fa7519001be390c98ae0acafe387 $
- PHP extension: mysqli[image: Documentation]
<http://127.0.0.1:8080/phpmyadmin/url.php?url=https%3A%2F%2Fsecure.php.net%2Fmanual%2Fen%2Fbook.mysqli.php>
curl[image: Documentation]
<http://127.0.0.1:8080/phpmyadmin/url.php?url=https%3A%2F%2Fsecure.php.net%2Fmanual%2Fen%2Fbook.curl.php>
mbstring[image: Documentation]
<http://127.0.0.1:8080/phpmyadmin/url.php?url=https%3A%2F%2Fsecure.php.net%2Fmanual%2Fen%2Fbook.mbstring.php>
- PHP version: 7.1.17
- Phpmyadmin Version information: 4.8.0.1, latest stable version: 4.8.1
<https://www.phpmyadmin.net/files/4.8.1/>
- Web Address http://127.0.0.1:8080/phpmyadmin/
I am using localhost as hostname on Tmysql57Connection.
I cannot connect the Tmysql57Connection to localhost.
Help?

Landmesser John via Lazarus

2018-05-29 11:24:44 UTC

Permalink

try Zeoslib,Â i use it for an Oracle Connection, but they have allso MySQL

https://sourceforge.net/projects/zeoslib/

they even handle german Umlauts correct :-)

Post by Larry Dalton via Lazarus
I am running lazarus 1.8.2 on linux mnt 17.2.
I am trying to access a mysql database that was installed with Bitnami.
* Server: Localhost via UNIX socket
* Server type: MySQL
* Server connection:SSL is not being usedDocumentation
<http://127.0.0.1:8080/phpmyadmin/doc/html/setup.html#ssl>
* Server version: 5.7.22 - MySQL Community Server (GPL)
* Server: Server: localhost:3307
<http://127.0.0.1:8080/phpmyadmin/index.php>
* Protocol version: 10
* Server charset:UTF-8 Unicode (utf8)
* Apache
* Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407
- $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $
* PHP extension: mysqliDocumentation
<http://127.0.0.1:8080/phpmyadmin/url.php?url=https%3A%2F%2Fsecure.php.net%2Fmanual%2Fen%2Fbook.mysqli.php>curlDocumentation
<http://127.0.0.1:8080/phpmyadmin/url.php?url=https%3A%2F%2Fsecure.php.net%2Fmanual%2Fen%2Fbook.curl.php>mbstringDocumentation
<http://127.0.0.1:8080/phpmyadmin/url.php?url=https%3A%2F%2Fsecure.php.net%2Fmanual%2Fen%2Fbook.mbstring.php>
* PHP version: 7.1.17
4.8.1 <https://www.phpmyadmin.net/files/4.8.1/>
* Web Address http://127.0.0.1:8080/phpmyadmin/
Â Â Â Â I am using localhost as hostname on Tmysql57Connection.
Â Â Â Â I cannot connect the Tmysql57Connection to localhost.
Help?

larrydalton71 via Lazarus

2018-05-30 00:16:44 UTC

Permalink

The error I am getting is simply "server connect failed." I am getting the same after I removed localhost from hostname.

Sent from my Verizon, Samsung Galaxy smartphone
-------- Original message --------From: Michael Van Canneyt via Lazarus <***@lists.lazarus-ide.org> Date: 5/29/18 01:57 (GMT-05:00) To: Larry Dalton via Lazarus <***@lists.lazarus-ide.org> Cc: Michael Van Canneyt <***@freepascal.org> Subject: Re: [Lazarus] TMysql57Connection won't connect to localhost

What is the error you are getting ?

If you want to connect through unix socket, you should leave hostname empty.
If you set it to localhost, TCP/IP will be used.

Michael.

Post by Larry Dalton via Lazarus
I am running lazarus 1.8.2 on linux mnt 17.2.
I am trying to access a mysql database that was installed with Bitnami.
Â Â - Server: Localhost via UNIX socket
Â Â - Server type: MySQL
Â Â - Server connection: SSL is not being used [image: Documentation]
Â Â <http://127.0.0.1:8080/phpmyadmin/doc/html/setup.html#ssl>
Â Â - Server version: 5.7.22 - MySQL Community Server (GPL)
Â Â - Server: Server: localhost:3307
Â Â <http://127.0.0.1:8080/phpmyadmin/index.php>
Â Â - Protocol version: 10
Â Â - Server charset: UTF-8 Unicode (utf8)
Â Â - Apache
Â Â - Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 -
Â Â $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $
Â Â - PHP extension: mysqli[image: Documentation]
Â Â <http://127.0.0.1:8080/phpmyadmin/url.php?url=https%3A%2F%2Fsecure.php.net%2Fmanual%2Fen%2Fbook.mysqli.php>
Â Â Â curl[image: Documentation]
Â Â <http://127.0.0.1:8080/phpmyadmin/url.php?url=https%3A%2F%2Fsecure.php.net%2Fmanual%2Fen%2Fbook.curl.php>
Â Â Â mbstring[image: Documentation]
Â Â <http://127.0.0.1:8080/phpmyadmin/url.php?url=https%3A%2F%2Fsecure.php.net%2Fmanual%2Fen%2Fbook.mbstring.php>
Â Â - PHP version: 7.1.17
Â Â - Phpmyadmin Version information: 4.8.0.1, latest stable version: 4.8.1
Â Â <https://www.phpmyadmin.net/files/4.8.1/>
Â Â - Web Address http://127.0.0.1:8080/phpmyadmin/
Â Â Â Â Â Â I am using localhost as hostname on Tmysql57Connection.
Â Â Â Â Â Â I cannot connect the Tmysql57Connection to localhost.
Help?

Michael Van Canneyt via Lazarus

2018-05-30 03:38:12 UTC

Permalink

Hello,

This means the mysql_real_connect() call failed. That means mysql itself
reports an error.

This means your connection parameters are somehow not correct:
one of hostname, port, username or password.

At this point the database name is not yet used. First a connection is made,
then the database is selected...

If you leave empty the hostname, it assumes localhost and will attempt a unix
socket connection first.

Do I understand it correctly that you are running the mysql in a bitnami
virtual machine ?

Is your lazarus also running in the virtual machine ? Or is lazarus running
on the host computer ?

Because if that is the case, you cannot use hostname localhost, but you must
use the IP address of the virtual machine.

If lazarus and mysql are running on the same (virtual) machine, then it is
something else.

For instance, what username did you use ? ***@localhost or root ?
Hopefully the latter :).

Michael.

Post by larrydalton71 via Lazarus
The error I am getting is simply "server connect failed." I am getting the same after I removed localhost from hostname.
Sent from my Verizon, Samsung Galaxy smartphone
What is the error you are getting ?
If you want to connect through unix socket, you should leave hostname empty.
If you set it to localhost, TCP/IP will be used.
Michael.

--
_______________________________________________
Lazarus mailing list
https://lists.lazarus-ide.org/listinfo/lazarus

larrydalton71 via Lazarus

2018-05-30 00:16:44 UTC

Permalink

larrydalton71 via Lazarus

2018-05-30 02:52:52 UTC

Permalink

How does TMysql57Connection know how to connect to the server if there is no hostname defined?

Sent from my Verizon, Samsung Galaxy smartphone
-------- Original message --------From: Michael Van Canneyt via Lazarus <***@lists.lazarus-ide.org> Date: 5/29/18 01:57 (GMT-05:00) To: Larry Dalton via Lazarus <***@lists.lazarus-ide.org> Cc: Michael Van Canneyt <***@freepascal.org> Subject: Re: [Lazarus] TMysql57Connection won't connect to localhost

What is the error you are getting ?

If you want to connect through unix socket, you should leave hostname empty.
If you set it to localhost, TCP/IP will be used.

Michael.

wkitty42--- via Lazarus

2018-05-30 16:59:59 UTC

Permalink

Post by larrydalton71 via Lazarus
How does TMysql57Connection know how to connect to the server if there is no
hostname defined?

--
NOTE: No off-list assistance is given without prior approval.
*Please keep mailing list traffic on the list unless*
*a signed and pre-paid contract is in effect with us.*
--

larrydalton71 via Lazarus

2018-05-30 17:12:08 UTC

Permalink

So what settings do I need to use?

Sent from my Verizon, Samsung Galaxy smartphone

Post by larrydalton71 via Lazarus
How does TMysql57Connection know how to connect to the server if there is no
hostname defined?

--
Â NOTE: No off-list assistance is given without prior approval.
Â Â Â Â Â Â Â *Please keep mailing list traffic on the list unless*
Â Â Â Â Â Â Â *a signed and pre-paid contract is in effect with us.*
--

Michael Van Canneyt via Lazarus

2018-05-30 18:50:57 UTC

Permalink

Please take a look at my reply for questions that need to be answered before
we can further help you.

Michael.

Post by larrydalton71 via Lazarus
So what settings do I need to use?
Sent from my Verizon, Samsung Galaxy smartphone

Post by larrydalton71 via Lazarus
How does TMysql57Connection know how to connect to the server if there is no
hostname defined?

because if there's no host name it will try using a unix socket defined for the
server... that /is/ local but not localhost and not using tcp/ip networking
protocols... it is another way to connect to a server running on the same machine...
--
Â NOTE: No off-list assistance is given without prior approval.
Â Â Â Â Â Â Â *Please keep mailing list traffic on the list unless*
Â Â Â Â Â Â Â *a signed and pre-paid contract is in effect with us.*
--
_______________________________________________
Lazarus mailing list
https://lists.lazarus-ide.org/listinfo/lazarus

larrydalton71 via Lazarus

2018-05-30 21:18:00 UTC

Permalink

Michael, am I missing an email? The only question I found was 'what was the error message?'. Thanks, Larry

Sent from my Verizon, Samsung Galaxy smartphone
-------- Original message --------From: Michael Van Canneyt via Lazarus <***@lists.lazarus-ide.org> Date: 5/30/18 14:50 (GMT-05:00) To: larrydalton71 via Lazarus <***@lists.lazarus-ide.org> Cc: Michael Van Canneyt <***@freepascal.org> Subject: Re: [Lazarus] TMysql57Connection won't connect to localhost

Please take a look at my reply for questions that need to be answered before
we can further help you.

Michael.

Post by larrydalton71 via Lazarus
So what settings do I need to use?
Sent from my Verizon, Samsung Galaxy smartphone

Post by larrydalton71 via Lazarus
How does TMysql57Connection know how to connect to the server if there is no
hostname defined?

Michael Van Canneyt via Lazarus

2018-05-31 05:53:13 UTC

Permalink

Seems you are missing one. I've resent it. Sent also to your private email address.
(At least I have seen it appearing on the mailing list)

Michael.

Post by larrydalton71 via Lazarus
So what settings do I need to use?
Sent from my Verizon, Samsung Galaxy smartphone

Post by larrydalton71 via Lazarus
How does TMysql57Connection know how to connect to the server if there is no
hostname defined?

Larry Dalton via Lazarus

2018-06-03 21:14:45 UTC

Permalink

The error message reads :Project MoneyProject raised exception
class:'ESQLDatabaseError' with message:'CreateConnection:Server Connect
Failed."

Post by larrydalton71 via Lazarus
Michael, am I missing an email? The only question I found was 'what was
the error message?'. Thanks, Larry
Sent from my Verizon, Samsung Galaxy smartphone
-------- Original message --------
Date: 5/30/18 14:50 (GMT-05:00)
Subject: Re: [Lazarus] TMysql57Connection won't connect to localhost
Please take a look at my reply for questions that need to be answered before
we can further help you.
Michael.

Post by larrydalton71 via Lazarus
So what settings do I need to use?
Sent from my Verizon, Samsung Galaxy smartphone
-------- Original message --------From: wkitty42--- via Lazarus <

[Lazarus] TMysql57Connection won't connect to localhost

Post by larrydalton71 via Lazarus

Post by larrydalton71 via Lazarus
How does TMysql57Connection know how to connect to the server if there

is no

Post by larrydalton71 via Lazarus

Post by larrydalton71 via Lazarus
hostname defined?

because if there's no host name it will try using a unix socket defined

for the

Post by larrydalton71 via Lazarus
server... that /is/ local but not localhost and not using tcp/ip

networking

Post by larrydalton71 via Lazarus
protocols... it is another way to connect to a server running on the

same machine...

Post by larrydalton71 via Lazarus
--
NOTE: No off-list assistance is given without prior approval.
*Please keep mailing list traffic on the list unless*
*a signed and pre-paid contract is in effect with us.*
--
_______________________________________________
Lazarus mailing list
https://lists.lazarus-ide.org/listinfo/lazarus