Watch out here I come again ;)

[B. Koeller]

Greets Dejan,

|Warning: Host 'boca02.u.washington.edu' is not allowed to connect to this
|MySQL server in /nfs/guido06/dw01/d82/dejann/install/newtables.php on line=
 2
|
|Warning: MySQL Connection Failed: Host 'boca02.u.washington.edu' is not
|allowed to connect to this MySQL server in
|/nfs/guido06/dw01/d82/dejann/install/newtables.php on line 2

This is indeed most likely an issue with the permission tables in mysql.
boca## or veron## are the actual web servers (I think) that are making the
query to the msyql database running on ovid or vergil. I usually make a
couple of user accounts like admin and user and set their hostnames to be
veron%.u.washington.edu (or boca%) and grant them privileges accordingly.

Good luck! Thanks.

--------------------
Brandon Koeller
http://koellers.org
brandon at koellers.org

On Thu, 20 Dec 2001, Dejan Nikic wrote:

|Who else but my buddy Trevor :)  Thnx a lot for all the help last time.
|
|Ok now I got rid of the previous problem, but now I have another one.
|I get this error:
|
|
|so what I did is i went and did this in mysql db:
|
|GRANT ALL PRIVILEGES on *.* to username@*.u.washington.edu;
|
|I know that this is insecure, but I was intending on keeping it like this
|just till i found a problem.  But even after this I'm still getting the sa=
me
|error even apparently user username has access to any db from any host at
|u.washington.edu domain.
|
|>From: Trevor Leffler <tleffler at u.washington.edu>
|>Reply-To: linux at u.washington.edu
|>To: UW Linux Group <linux at u.washington.edu>
|>Subject: Re: Watch out here I come again ;)
|>Date: Thu, 20 Dec 2001 14:56:44 -0800
|>
|>Dejan,
|>
|>   You're .my.cnf doesn't really matter in this case, because your php
|>script can't even see it--the web servers can't see your home directory.
|>  Your script should make a connection to your DB via tcp, not a file
|>socket.  You might write something analogous to:
|>
|>$dbh =3D DBI->connect("DBI:mysql:$table:$host:$port", $user, $password);
|>
|>   Sorry I don't know how PHP would do that.
|>
|>--Trevor
|>
|>Dejan Nikic wrote:
|>
|>>Well guys here i'm again with my PHP and MySQL installations.  Now here
|>>is the deal.  I deleted my previous installations and decided to go
|>>fresh.  Now what I have problems with is that when i try to connect to
|>>mysql trough php i get this error:
|>>
|>>Warning: Can't connect to local MySQL server through socket
|>>'/tmp/mysql.sock' (2) in
|>>/nfs/guido06/dw01/d82/dejann/install/newtables.php on line 2
|>>
|>>now I have no idea why is trying to use /tmp/mysql.sock because in
|>>.my.cnf i put in a full path to my mysql.sock which is in the root of my
|>>home directory.
|>>
|>>is there a way to change this /tmp/mysql.sock to a working socket inside
|>>php?  I made a file with phpinfo() in it and there it tells me that
|>>mysql socket is /tmp/mysql so I would like to have it changed.
|>>
|>>Thank you.
|>>
|>>p.s.
|>>Sorry I'm bothering you guys with all this, but I've been trying to find
|>>something on this since 3 last night and nothing yet. All help is
|>>greatly appreciated.
|>>
|>>_________________________________________________________________
|>>Join the world's largest e-mail service with MSN Hotmail.
|>>http://www.hotmail.com
|>
|>
|
|
|
|
|Dejan Nikic
|webmaster at peoplehangout.com
|http://www.peoplehangout.com
|
|
|_________________________________________________________________
|Join the world=92s largest e-mail service with MSN Hotmail.
|http://www.hotmail.com
|
|