phpwebsite-developers

[Phpwebsite-developers] remote mysql connections

[Robert B. <ro...@pr...>]

I have a desire (for cpu reasons) to have phpwebsite(s) on one box and th=
e=20
MySql server running locally on another box -

I have it setup and what I believe are the necessary permissions for the=20
remote box to connect to the MySql box- but when it does, mysql remits th=
is=20
error:
mysql> /usr/bin/safe_mysqld: line 278:  4715 Segmentation fault     =20
$NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=3D$MY_BASEDIR_VERSION=20
--datadir=3D$DATADIR $USER_OPTION --pid-file=3D$pid_file --skip-locking=20
>>$err_log 2>&1

Number of processes running now: 1
mysqld process hanging, pid 4725 - killed
030205 20:32:21  mysqld restarted

THe script, db_look.php, reports back this:

X-Powered-By: PHP/4.1.2
Content-type: text/html

<pre>mysqldump: Got error: 2013: Lost connection to MySQL server during q=
uery=20
when trying to connect

Any idea?

I have looked all over for info on this and can not find it.

TIA,

--=20
 Robert Brandtjen
 ------------------------------------
Web Site Creation and Hosting Services
 Hos...@pr...
      www.prometheusmedia.com
         =20

Re: [Phpwebsite-developers] remote mysql connections

[Adam M. <ad...@tu...>]

I'm not sure if this is exactl what you're looking for but I was surfing
the mysql site and found some of this information about connecting
remotely to be useful:

http://www.mysql.com/doc/en/Can_not_connect_to_server.html

Adam

> I have a desire (for cpu reasons) to have phpwebsite(s) on one box and
> the  MySql server running locally on another box -
>
> I have it setup and what I believe are the necessary permissions for the
>  remote box to connect to the MySql box- but when it does, mysql remits
> this  error:
> mysql> /usr/bin/safe_mysqld: line 278:  4715 Segmentation fault
> $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION
> --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking
>>>$err_log 2>&1
>
> Number of processes running now: 1
> mysqld process hanging, pid 4725 - killed
> 030205 20:32:21  mysqld restarted
>
> THe script, db_look.php, reports back this:
>
> X-Powered-By: PHP/4.1.2
> Content-type: text/html
>
> <pre>mysqldump: Got error: 2013: Lost connection to MySQL server during
> query  when trying to connect
>
> Any idea?
>
> I have looked all over for info on this and can not find it.
>
> TIA,
>
> --
>  Robert Brandtjen
>  ------------------------------------
> Web Site Creation and Hosting Services
>  Hos...@pr...
>       www.prometheusmedia.com
>
>
>
>
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by:
> SourceForge Enterprise Edition + IBM + LinuxWorld
> http://www.vasoftware.com
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers


---------------------------------------------------------------------
Adam Morton
Developer - Electronic Student Services
http://phpwebsite.appstate.edu
Founder - Appalachian Linux Users Group
http://alug.appstate.edu

Re: [Phpwebsite-developers] remote mysql connections

[Jeremy A. <ja...@tu...>]

There are still a loot i don't know about your setup but hope this helps.

Do you have a firewall or hosts.allow/deny in place? --probable not this
since you get a connection.

Can you do local query's on the sql server?

Do you have the port(3306) defined in the my.cnf file(both servers)
--Usually in /etc, The mysql.sock is for local stuff.

Do you have the mysql info in you services file.  --Usually in /etc/services

Do you have the host(webserver) defined in the mysql user you are using? 
phpMyAdmin has a verry nice "user" admin on the opening page.

This probable isn't it but remember when working on user info in mysql you
need to reload the server.  phpMyAdmin has a link to do this at the bottom
when doing user edits.

> I have a desire (for cpu reasons) to have phpwebsite(s) on one box and
> the  MySql server running locally on another box -
>
> I have it setup and what I believe are the necessary permissions for the
>  remote box to connect to the MySql box- but when it does, mysql remits
> this  error:
> mysql> /usr/bin/safe_mysqld: line 278:  4715 Segmentation fault
> $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION
> --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking
>>>$err_log 2>&1
>
> Number of processes running now: 1
> mysqld process hanging, pid 4725 - killed
> 030205 20:32:21  mysqld restarted
>
> THe script, db_look.php, reports back this:
>
> X-Powered-By: PHP/4.1.2
> Content-type: text/html
>
> <pre>mysqldump: Got error: 2013: Lost connection to MySQL server during
> query  when trying to connect
>
> Any idea?
>
> I have looked all over for info on this and can not find it.
>
> TIA,
>
> --
>  Robert Brandtjen
>  ------------------------------------
> Web Site Creation and Hosting Services
>  Hos...@pr...
>       www.prometheusmedia.com
>
>
>
>
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by:
> SourceForge Enterprise Edition + IBM + LinuxWorld
> http://www.vasoftware.com
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers


-- 
Jeremy Agee
phpWebSite Development Team (http://phpwebsite.appstate.edu)
Appalachian State University
SF.net id: jagee or 94756