MYSQL connection issues

--------------010608050606020807090204
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

03272005 1457 GMT-6

I have been working on a db and form that is hosted at Yahoo. I have had
massive troubles getting anything to work there.
At the moment I keep getting these errors.

This is how I connect to a database usually:
$db_name="name";
$connection=mysql_connect("localhost", "user", "pass");
$db= mysql_select_db($db_name, $connection);

But apparently I have to do it this way at yahoo:
$connection=mysql_connect("mysql", "user", "pass");
mysql_select_db("name", $connection);

But even making these changes its a hit and miss situation.

Now I have searched on the first line of code on google and found LOTS
of people who have had this same problem - though no answers are forth
coming. Anyone on this list have any ideas?

Wade

[27-Mar-2005 20:11:55] PHP Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46) in /html/login.php on line 123
[27-Mar-2005 20:11:55] PHP Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /html/login.php on line 124
[27-Mar-2005 20:11:55] PHP Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /html/login.php on line 132
[27-Mar-2005 20:14:15] PHP Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46) in /html/login.php on line 123
[27-Mar-2005 20:14:15] PHP Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /html/login.php on line 124
[27-Mar-2005 20:14:15] PHP Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /html/login.php on line 132
[27-Mar-2005 20:29:44] PHP Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46) in /html/login.php on line 123
[27-Mar-2005 20:29:44] PHP Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /html/login.php on line 124
[27-Mar-2005 20:29:44] PHP Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /html/login.php on line 132
%% [Sun Mar 27 12:50:46 2005] GET /test/login.php HTTP/1.1
%% 500 /z/dr/a_cats_desire/us1/test/login.php
%request
Accept: application/x-shockwave-flash,text/xml,application/xml,appli cation/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png, image/jpeg,image/gif;q=0.2,*/*;q=0.1
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
Accept-Encoding: gzip,deflate
Accept-Language: en-us,en;q=0.5
Connection: keep-alive
Host: www.acatsdesire.com
Keep-Alive: 300
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040803
%response
%stderr
Invalid owner:/test/login.php



--------------010608050606020807090204--

Re: MYSQL connection issues

This is more of a problem for Yahoo than for you or this list, they
must give you ways to access their databases, revealing the address
and db name, and ways to connect to it, I didn't even know that they
had this kind of services, but it seems to me you'll have to check for
help at their site. I'm sure they have a well documented place with
instructions on how to do this (else they shouldn't offer the
service).


On Sun, 27 Mar 2005 15:01:50 -0600, Wade wrote:
> 03272005 1457 GMT-6
>
> I have been working on a db and form that is hosted at Yahoo. I have had
> massive troubles getting anything to work there.
> At the moment I keep getting these errors.
>
> This is how I connect to a database usually:
> $db_name="name";
> $connection=mysql_connect("localhost", "user", "pass");
> $db= mysql_select_db($db_name, $connection);
>
> But apparently I have to do it this way at yahoo:
> $connection=mysql_connect("mysql", "user", "pass");
> mysql_select_db("name", $connection);
>
> But even making these changes its a hit and miss situation.
>
> Now I have searched on the first line of code on google and found LOTS
> of people who have had this same problem - though no answers are forth
> coming. Anyone on this list have any ideas?
>
> Wade
>
> [27-Mar-2005 20:11:55] PHP Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46) in /html/login.php on line 123
> [27-Mar-2005 20:11:55] PHP Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /html/login.php on line 124
> [27-Mar-2005 20:11:55] PHP Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /html/login.php on line 132
> [27-Mar-2005 20:14:15] PHP Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46) in /html/login.php on line 123
> [27-Mar-2005 20:14:15] PHP Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /html/login.php on line 124
> [27-Mar-2005 20:14:15] PHP Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /html/login.php on line 132
> [27-Mar-2005 20:29:44] PHP Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46) in /html/login.php on line 123
> [27-Mar-2005 20:29:44] PHP Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /html/login.php on line 124
> [27-Mar-2005 20:29:44] PHP Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /html/login.php on line 132
> %% [Sun Mar 27 12:50:46 2005] GET /test/login.php HTTP/1.1
> %% 500 /z/dr/a_cats_desire/us1/test/login.php
> %request
> Accept: application/x-shockwave-flash,text/xml,application/xml,appli cation/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png, image/jpeg,image/gif;q=0.2,*/*;q=0.1
> Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
> Accept-Encoding: gzip,deflate
> Accept-Language: en-us,en;q=0.5
> Connection: keep-alive
> Host: www.acatsdesire.com
> Keep-Alive: 300
> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040803
> %response
> %stderr
> Invalid owner:/test/login.php
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: MYSQL connection issues

-------------------------------1112029896
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit


I don't think it would matter really, personally I connect this way:

$db = mysql_connect("localhost","database_username","password");
mysql_select_db("my_database_name", $db);
$query = "SELECT * FROM member_info";
$result = mysql_query($query);
while ($record = mysql_fetch_assoc($result)) {
while(list ($fieldname, $fieldvalue) = each ($record)){
echo $fieldname.": ".$fieldvalue."
";
}
echo "
";
}

?>


In a message dated 3/28/2005 2:47:19 PM GMT Standard Time,
danieldaveiga@gmail.com writes:

>
> I have been working on a db and form that is hosted at Yahoo. I have had
> massive troubles getting anything to work there.
> At the moment I keep getting these errors.
>
> This is how I connect to a database usually:
> $db_name="name";
> $connection=mysql_connect("localhost", "user", "pass");
> $db= mysql_select_db($db_name, $connection);
>
> But apparently I have to do it this way at yahoo:
> $connection=mysql_connect("mysql", "user", "pass");
> mysql_select_db("name", $connection);
>
> But even making these changes its a hit and miss situation.
>
> Now I have searched on the first line of code on google and found LOTS
> of people who have had this same problem - though no answers are forth
> coming. Anyone on this list have any ideas?
>
> Wade





-------------------------------1112029896--

5.03 Still crashes on win32

Warning, do not install 5.03 it still crashes on win32. This occured after
very few minutes of testing. I will send more info as I locate it.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: 5.03 Still crashes on win32

I don't think MySQL AB Team would release a unstable version as an
official version if it was not exaustive tested on all platforms, it
MAY happen, but its really, really hard. Its more likely to be a
problem related to your configuration of hardware and/or software than
a problem with the release.

Anyway, it still MAY happen, I didn't tested it myself, but I guess
its a bit early for you to advice everyone not to install it, all
experienced users will backup their config and data before any
upgrade.

Just my two cents,

On Mon, 28 Mar 2005 10:13:55 -0800, Fredrick Bartlett
wrote:
> Warning, do not install 5.03 it still crashes on win32. This occured after
> very few minutes of testing. I will send more info as I locate it.
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: 5.03 Still crashes on win32

Ok, I allow you to use it. My nickel...

----- Original Message -----
From: "Daniel da Veiga"
To: "MySQL Win32 List"
Sent: Monday, March 28, 2005 10:47 AM
Subject: Re: 5.03 Still crashes on win32


> I don't think MySQL AB Team would release a unstable version as an
> official version if it was not exaustive tested on all platforms, it
> MAY happen, but its really, really hard. Its more likely to be a
> problem related to your configuration of hardware and/or software than
> a problem with the release.
>
> Anyway, it still MAY happen, I didn't tested it myself, but I guess
> its a bit early for you to advice everyone not to install it, all
> experienced users will backup their config and data before any
> upgrade.
>
> Just my two cents,
>
> On Mon, 28 Mar 2005 10:13:55 -0800, Fredrick Bartlett
> wrote:
> > Warning, do not install 5.03 it still crashes on win32. This occured
after
> > very few minutes of testing. I will send more info as I locate it.
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
> >
> >
>
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=palmtreeFRB@earthlink.net
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: 5.03 Still crashes on win32

A few things please, and not meaning to criticize:

1) 5.0.x is still considered a Dev release, meaning it's not been
certified as a GA release. It is possible there could be issues with it
because of that, but generally at the very least it will run on any
given platform.
2) I've seen many people complaining that the GA 4.0.x releases were
crashing on Win32 and have never once had it crash on me. If you find a
specific bug you should report it to bugs.mysql.com with some specific
details so that they can investigate. If the bug is valid, then I am
sure they will let people know about it.

Cheers.

Armando

Daniel da Veiga wrote:
> I don't think MySQL AB Team would release a unstable version as an
> official version if it was not exaustive tested on all platforms, it
> MAY happen, but its really, really hard. Its more likely to be a
> problem related to your configuration of hardware and/or software than
> a problem with the release.
>
> Anyway, it still MAY happen, I didn't tested it myself, but I guess
> its a bit early for you to advice everyone not to install it, all
> experienced users will backup their config and data before any
> upgrade.
>
> Just my two cents,
>
> On Mon, 28 Mar 2005 10:13:55 -0800, Fredrick Bartlett
> wrote:
>
>>Warning, do not install 5.03 it still crashes on win32. This occured after
>>very few minutes of testing. I will send more info as I locate it.
>>
>>--
>>MySQL Windows Mailing List
>>For list archives: http://lists.mysql.com/win32
>>To unsubscribe: http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
>>
>>
>
>
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org