Re: perl DBI cannot connect to host=hhhh
[email protected] (Zheng Li Sheng) Sun, 1 Sep 2024 08:39:23 +0700
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <CAHYMEFRhZ+-64YOD8MguVwpAKvBEenK4xOuxfNfVUfJYaRZ-zA@mail.gmail.com> |
--000000000000842cd5062104e5b3
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
something like this:
# Define database connection parametersmy $database =3D
'your_database';my $hostname =3D '127.0.0.1'; # or any other valid
hostname/IP addressmy $port =3D '3306'; # Default MySQL port#
Construct DSN stringmy $dsn =3D
"DBI:mysql:database=3D$database;host=3D$hostname;port=3D$port";# Define
username and passwordmy $user =3D 'your_username';my $password =3D
'your_password';# Connect to the databasemy $dbh =3D DBI->connect($dsn,
$user, $password, {RaiseError =3D> 1});
Regards,
On Sun, Sep 1, 2024 at 8:25=E2=80=AFAM Dennis German <DGerman@real-world-sy=
stems.com>
wrote:
> How can DBI use a database SERVER not a socket?
>
> 1) perl code segment
>
> $host=3D"sdb-74.hosting.stackcp.net"; #actually not used
>
> $database=3D"realger1_birding"; $user=3D'realger1_observr'; $pass=3D'bir=
xxx';
> use DBI;
> use DBD::mysql;
>
> my $dbh =3D DBI->connect("DBI:mysql:$database",$user, $pass );
> if ( ! $dbh ) { die "-- Failed to connect to MySQL
> database:DBI->errstr()"; }
>
> 2) ERROR
>
> DBI connect('realger1_birding','realger1_observr',...) failed: Can't
> connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' =
(2
> "No such file or directory") at ./history.pl line 25.
>
> 3) cat ~/.my.cnf #only used by MySQL programs anyway
> [mysql]
> host=3Dsdb-74.hosting.stackcp.net
>
> 4) platform:
>
> uname -a
> Linux ssh5.dfw.stackcp.net 3.10.0-1160.114.2.el7.x86_64 #1 SMP Wed Mar 20
> 15:54:52 UTC 2024 x86_64 x86_64 x86_64 GNU/Linux
>
> 5) perl -MDBI -e 'DBI->installed_versions'
> Perl : 5.016003 (x86_64-linux-thread-multi)
> OS : linux (3.10.0-957.1.3.el7.x86_64)
> DBI : 1.627
> DBD::mysql : 4.023
> DBD::Sponge : 12.010002
> DBD::Proxy : 0.2004
> DBD::Gofer : 0.015326
> DBD::File : 0.41
> DBD::ExampleP : 12.014310
> DBD::DBM : 0.08
>
>
--000000000000842cd5062104e5b3
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr"><div>something like this:</div><div><span><pre class=3D"gm=
ail-not-prose gmail-w-full gmail-overflow-hidden gmail-rounded gmail-font-m=
ono gmail-text-sm gmail-font-extralight"><span style=3D"font-size:inherit;f=
ont-family:inherit;background:transparent;color:rgb(77,77,76);border-radius=
:3px;display:flex;line-height:1.42857;overflow-x:auto;white-space:pre"><cod=
e style=3D"font-size:inherit;font-family:inherit;line-height:1.66667;paddin=
g:8px;white-space:pre-wrap"><span style=3D"opacity:1;font-size:inherit;line=
-height:1.42857;color:rgb(77,77,76);background-color:transparent;padding:8p=
x;text-align:right"><span class=3D"gmail-token gmail-token" style=3D"color:=
rgb(142,144,140);font-family:inherit;font-style:italic"># Define database c=
onnection parameters</span><span>
</span></span><span style=3D"opacity:1;font-size:inherit;line-height:1.4285=
7;color:rgb(77,77,76);background-color:transparent;padding:8px;text-align:r=
ight"><span></span><span class=3D"gmail-token gmail-token" style=3D"color:r=
gb(137,89,168);font-weight:bolder">my</span><span> </span><span class=3D"gm=
ail-token gmail-token" style=3D"color:rgb(200,40,41)">$database</span><span=
> </span><span class=3D"gmail-token gmail-token gmail-operator">=3D</span><=
span> </span><span class=3D"gmail-token gmail-token" style=3D"color:rgb(113=
,140,0)">'your_database'</span><span class=3D"gmail-token gmail-tok=
en gmail-punctuation">;</span><span>
</span></span><span style=3D"opacity:1;font-size:inherit;line-height:1.4285=
7;color:rgb(77,77,76);background-color:transparent;padding:8px;text-align:r=
ight"><span></span><span class=3D"gmail-token gmail-token" style=3D"color:r=
gb(137,89,168);font-weight:bolder">my</span><span> </span><span class=3D"gm=
ail-token gmail-token" style=3D"color:rgb(200,40,41)">$hostname</span><span=
> </span><span class=3D"gmail-token gmail-token gmail-operator">=3D</span><=
span> </span><span class=3D"gmail-token gmail-token" style=3D"color:rgb(113=
,140,0)">'127.0.0.1'</span><span class=3D"gmail-token gmail-token g=
mail-punctuation">;</span><span> </span><span class=3D"gmail-token gmail-to=
ken" style=3D"color:rgb(142,144,140);font-family:inherit;font-style:italic"=
># or any other valid hostname/IP address</span><span>
</span></span><span style=3D"opacity:1;font-size:inherit;line-height:1.4285=
7;color:rgb(77,77,76);background-color:transparent;padding:8px;text-align:r=
ight"><span></span><span class=3D"gmail-token gmail-token" style=3D"color:r=
gb(137,89,168);font-weight:bolder">my</span><span> </span><span class=3D"gm=
ail-token gmail-token" style=3D"color:rgb(200,40,41)">$port</span><span> =
</span><span class=3D"gmail-token gmail-token gmail-operator">=3D</span><=
span> </span><span class=3D"gmail-token gmail-token" style=3D"color:rgb(113=
,140,0)">'3306'</span><span class=3D"gmail-token gmail-token gmail-=
punctuation">;</span><span> </span><span class=3D"gmail-token gmail-tok=
en" style=3D"color:rgb(142,144,140);font-family:inherit;font-style:italic">=
# Default MySQL port</span><span>
</span></span><span style=3D"opacity:1;font-size:inherit;line-height:1.4285=
7;color:rgb(77,77,76);background-color:transparent;padding:8px;text-align:r=
ight">
</span><span style=3D"opacity:1;font-size:inherit;line-height:1.42857;color=
:rgb(77,77,76);background-color:transparent;padding:8px;text-align:right"><=
span></span><span class=3D"gmail-token gmail-token" style=3D"color:rgb(142,=
144,140);font-family:inherit;font-style:italic"># Construct DSN string</spa=
n><span>
</span></span><span style=3D"opacity:1;font-size:inherit;line-height:1.4285=
7;color:rgb(77,77,76);background-color:transparent;padding:8px;text-align:r=
ight"><span></span><span class=3D"gmail-token gmail-token" style=3D"color:r=
gb(137,89,168);font-weight:bolder">my</span><span> </span><span class=3D"gm=
ail-token gmail-token" style=3D"color:rgb(200,40,41)">$dsn</span><span> </s=
pan><span class=3D"gmail-token gmail-token gmail-operator">=3D</span><span>=
</span><span class=3D"gmail-token gmail-token" style=3D"color:rgb(113,140,=
0)">"DBI:mysql:database=3D$database;host=3D$hostname;port=3D$port"=
;</span><span class=3D"gmail-token gmail-token gmail-punctuation">;</span><=
span>
</span></span><span style=3D"opacity:1;font-size:inherit;line-height:1.4285=
7;color:rgb(77,77,76);background-color:transparent;padding:8px;text-align:r=
ight">
</span><span style=3D"opacity:1;font-size:inherit;line-height:1.42857;color=
:rgb(77,77,76);background-color:transparent;padding:8px;text-align:right"><=
span></span><span class=3D"gmail-token gmail-token" style=3D"color:rgb(142,=
144,140);font-family:inherit;font-style:italic"># Define username and passw=
ord</span><span>
</span></span><span style=3D"opacity:1;font-size:inherit;line-height:1.4285=
7;color:rgb(77,77,76);background-color:transparent;padding:8px;text-align:r=
ight"><span></span><span class=3D"gmail-token gmail-token" style=3D"color:r=
gb(137,89,168);font-weight:bolder">my</span><span> </span><span class=3D"gm=
ail-token gmail-token" style=3D"color:rgb(200,40,41)">$user</span><span> =
</span><span class=3D"gmail-token gmail-token gmail-operator">=3D</span><sp=
an> </span><span class=3D"gmail-token gmail-token" style=3D"color:rgb(113,1=
40,0)">'your_username'</span><span class=3D"gmail-token gmail-token=
gmail-punctuation">;</span><span>
</span></span><span style=3D"opacity:1;font-size:inherit;line-height:1.4285=
7;color:rgb(77,77,76);background-color:transparent;padding:8px;text-align:r=
ight"><span></span><span class=3D"gmail-token gmail-token" style=3D"color:r=
gb(137,89,168);font-weight:bolder">my</span><span> </span><span class=3D"gm=
ail-token gmail-token" style=3D"color:rgb(200,40,41)">$password</span><span=
> </span><span class=3D"gmail-token gmail-token gmail-operator">=3D</span><=
span> </span><span class=3D"gmail-token gmail-token" style=3D"color:rgb(113=
,140,0)">'your_password'</span><span class=3D"gmail-token gmail-tok=
en gmail-punctuation">;</span><span>
</span></span><span style=3D"opacity:1;font-size:inherit;line-height:1.4285=
7;color:rgb(77,77,76);background-color:transparent;padding:8px;text-align:r=
ight">
</span><span style=3D"opacity:1;font-size:inherit;line-height:1.42857;color=
:rgb(77,77,76);background-color:transparent;padding:8px;text-align:right"><=
span></span><span class=3D"gmail-token gmail-token" style=3D"color:rgb(142,=
144,140);font-family:inherit;font-style:italic"># Connect to the database</=
span><span>
</span></span><span style=3D"opacity:1;font-size:inherit;line-height:1.4285=
7;color:rgb(77,77,76);background-color:transparent;padding:8px;text-align:r=
ight"><span></span><span class=3D"gmail-token gmail-token" style=3D"color:r=
gb(137,89,168);font-weight:bolder">my</span><span> </span><span class=3D"gm=
ail-token gmail-token" style=3D"color:rgb(200,40,41)">$dbh</span><span> </s=
pan><span class=3D"gmail-token gmail-token gmail-operator">=3D</span><span>=
DBI</span><span class=3D"gmail-token gmail-token gmail-operator">-></sp=
an><span>connect</span><span class=3D"gmail-token gmail-token gmail-punctua=
tion">(</span><span class=3D"gmail-token gmail-token" style=3D"color:rgb(20=
0,40,41)">$dsn</span><span class=3D"gmail-token gmail-token gmail-punctuati=
on">,</span><span> </span><span class=3D"gmail-token gmail-token" style=3D"=
color:rgb(200,40,41)">$user</span><span class=3D"gmail-token gmail-token gm=
ail-punctuation">,</span><span> </span><span class=3D"gmail-token gmail-tok=
en" style=3D"color:rgb(200,40,41)">$password</span><span class=3D"gmail-tok=
en gmail-token gmail-punctuation">,</span><span> </span><span class=3D"gmai=
l-token gmail-token gmail-punctuation">{</span><span>RaiseError </span><spa=
n class=3D"gmail-token gmail-token gmail-operator">=3D></span><span> </s=
pan><span class=3D"gmail-token gmail-token" style=3D"color:rgb(245,135,31)"=
>1</span><span class=3D"gmail-token gmail-token gmail-punctuation">}</span>=
<span class=3D"gmail-token gmail-token gmail-punctuation">)</span><span cla=
ss=3D"gmail-token gmail-token gmail-punctuation">;</span></span></code></sp=
an></pre></span></div><div>Regards,<br></div></div><br><div class=3D"gmail_=
quote"><div dir=3D"ltr" class=3D"gmail_attr">On Sun, Sep 1, 2024 at 8:25=E2=
=80=AFAM Dennis German <<a href=3D"mailto:[email protected]=
">[email protected]</a>> wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><u></u>
=20
=20
=20
<div>
<p>How can DBI use a database SERVER not a socket?<br>
</p>
<p>1) perl code segment</p>
<p><font size=3D"4" face=3D"monospace">$host=3D"<a href=3D"http://=
sdb-74.hosting.stackcp.net" target=3D"_blank">sdb-74.hosting.stackcp.net</a=
>";=C2=A0=C2=A0
#actually not used</font></p>
<p><font size=3D"4" face=3D"monospace">$database=3D"realger1_birdi=
ng";=C2=A0
$user=3D'realger1_observr'; $pass=3D'birxxx';<br>
use DBI;=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0 <br>
use DBD::mysql;=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <br=
>
<br>
my $dbh =3D DBI->connect("DBI:mysql:$database",$user, =
$pass );<br>
if ( ! $dbh ) { die "-- Failed to connect to MySQL
database:DBI->errstr()"; }</font></p>
<p>2) ERROR</p>
<p><font size=3D"4" face=3D"monospace">DBI
connect('realger1_birding','realger1_observr',...) =
failed: Can't
connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2 "No such file or direct=
ory") at
./<a href=3D"http://history.pl" target=3D"_blank">history.pl</a> li=
ne 25.</font><font size=3D"4"><br>
</font></p>
<p>3) <font face=3D"monospace">cat ~/.my.cnf=C2=A0=C2=A0=C2=A0 #only us=
ed by MySQL
programs anyway<br>
[mysql]<br>
host=3D<a href=3D"http://sdb-74.hosting.stackcp.net" target=3D"_bla=
nk">sdb-74.hosting.stackcp.net</a></font></p>
<p>4) platform: <br>
</p>
<p><font size=3D"4" face=3D"monospace">uname -a<br>
Linux <a href=3D"http://ssh5.dfw.stackcp.net" target=3D"_blank">ssh=
5.dfw.stackcp.net</a> 3.10.0-1160.114.2.el7.x86_64 #1 SMP
Wed Mar 20 15:54:52 UTC 2024 x86_64 x86_64 x86_64 GNU/Linux</font><=
/p>
<p>5)=C2=A0 perl -MDBI -e 'DBI->installed_versions'<br>
=C2=A0 Perl=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 : 5.016003=C2=A0=C2=A0=C2=A0 (x86_64-linux-thread-multi)<br>
=C2=A0 OS=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0 : linux=C2=A0=C2=A0=C2=A0 (3.10.0-957.1.3.el7.x86_64)<br=
>
=C2=A0 DBI=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0 : 1.627<br>
=C2=A0 DBD::mysql=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 4.023<br>
=C2=A0 DBD::Sponge=C2=A0=C2=A0=C2=A0=C2=A0 : 12.010002<br>
=C2=A0 DBD::Proxy=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 0.2004<br>
=C2=A0 DBD::Gofer=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 0.015326<br>
=C2=A0 DBD::File=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 0.41<br>
=C2=A0 DBD::ExampleP=C2=A0=C2=A0 : 12.014310<br>
=C2=A0 DBD::DBM=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 : 0.08<br>
<br>
</p>
<p></p>
</div>
</blockquote></div>
--000000000000842cd5062104e5b3--