Re: [PHP] Re: mysql_connect does not connect

2004-09-21 Thread Chris Dowell
Sam,
You're correct - the manual does leave a little bit of a grey area about 
which extension you should use for 4.1.0  MySQL version  4.1.3

However, as you're using 5.0.1 this really shouldn't confuse you to 
quite the extent which it has.

Sam Hobbs wrote:
Curt Zirzow [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED]
 

RTFM.
mysql:
This MySQL extension doesn't support full functionality of MySQL
versions greater than 4.1.0. For that, use MySQLi.
mysqli:
The mysqli extension is designed to work with the version 4.1.3 or
above of MySQL.
   

What the manual says (as quoted) is either not relevant or is not clear.
 

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP] Re: mysql_connect does not connect

2004-09-18 Thread Sam Hobbs
Jason Wong [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED]

 Unfortunately (fortunately?) there are packages out there which install 
 all
 Apache/MySQL/PHP for you or whatever. So unless you state which package
 you're using then typical is still meaningless. It's just helpful when
 posting to provide as much _relevant_ info as possible.

I am sorry I did not know anything about the other packages. I assumed it 
was clear that I meant the installation provided by MySQL from there web 
site. I had no way of knowing that I needed to state what package. The MySQL 
documentation mentions only two ways of installing MySQL; either manually or 
by using the installation program they provide.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: mysql_connect does not connect

2004-09-17 Thread Sam Hobbs
Curt Zirzow [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED]

 RTFM.

 mysql:
  This MySQL extension doesn't support full functionality of MySQL
  versions greater than 4.1.0. For that, use MySQLi.

 mysqli:
  The mysqli extension is designed to work with the version 4.1.3 or
  above of MySQL.

What the manual says (as quoted) is either not relevant or is not clear.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: mysql_connect does not connect

2004-09-17 Thread Sam Hobbs
Jason Wong [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED]

 I'm not familiar with MySQL under Windows, but I believe that there are
 different installers available from various sources. So saying Typical
 installation option doesn't really mean much.

There is only one Windows installer available rom the MySQL web site and it 
has an option that explicitly says Typical. Therefore in this context 
Typical is extremely specific and relevant.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: mysql_connect does not connect

2004-09-17 Thread Jason Davidson
Yes yes, your always relevent, we are not... funny that you have the
problem and we do not though. 

Jason

Sam Hobbs [EMAIL PROTECTED] wrote: 
 
 Jason Wong [EMAIL PROTECTED] wrote in message 
 news:[EMAIL PROTECTED]
 
  I'm not familiar with MySQL under Windows, but I believe that there are
  different installers available from various sources. So saying Typical
  installation option doesn't really mean much.
 
 There is only one Windows installer available rom the MySQL web site and it 
 has an option that explicitly says Typical. Therefore in this context 
 Typical is extremely specific and relevant.
 
 -- 
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: mysql_connect does not connect

2004-09-17 Thread Jason Wong
On Friday 17 September 2004 23:36, Sam Hobbs wrote:
 Jason Wong [EMAIL PROTECTED] wrote in message
 news:[EMAIL PROTECTED]

 There is only one Windows installer available rom the MySQL web site and it
 has an option that explicitly says Typical. Therefore in this context
 Typical is extremely specific and relevant.

Unfortunately (fortunately?) there are packages out there which install all 
Apache/MySQL/PHP for you or whatever. So unless you state which package 
you're using then typical is still meaningless. It's just helpful when 
posting to provide as much _relevant_ info as possible.

-- 
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design  Hosting * Internet  Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
--
/*
Well, I'm disenchanted too.  We're all disenchanted.
-- James Thurber
*/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: mysql_connect does not connect

2004-09-17 Thread Curt Zirzow
* Thus wrote Sam Hobbs:
 Curt Zirzow [EMAIL PROTECTED] wrote in message 
 news:[EMAIL PROTECTED]
 
  RTFM.
 
  mysql:
   This MySQL extension doesn't support full functionality of MySQL
   versions greater than 4.1.0. For that, use MySQLi.
 
  mysqli:
   The mysqli extension is designed to work with the version 4.1.3 or
   above of MySQL.
 
 What the manual says (as quoted) is either not relevant or is not clear.

sigh.


Curt
-- 
The above comments may offend you. flame at will.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: mysql_connect does not connect

2004-09-17 Thread Matthew Sims
 * Thus wrote Sam Hobbs:
 Curt Zirzow [EMAIL PROTECTED] wrote in message
 news:[EMAIL PROTECTED]
 
  RTFM.
 
  mysql:
   This MySQL extension doesn't support full functionality of MySQL
   versions greater than 4.1.0. For that, use MySQLi.
 
  mysqli:
   The mysqli extension is designed to work with the version 4.1.3 or
   above of MySQL.

 What the manual says (as quoted) is either not relevant or is not clear.

 sigh.


 Curt

PHP is either NOT IMPORTANT or I DON'T UNDERSTAND IT.

-- 
--Matthew Sims
--http://killermookie.org

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: mysql_connect does not connect

2004-09-16 Thread Jason Wong
On Thursday 16 September 2004 10:53, Sam Hobbs wrote:
 Jason Wong [EMAIL PROTECTED] wrote in message
 news:[EMAIL PROTECTED]

  So now are you fully convinced it's your firewall that's the root of your
  problem?

 No, not really. At the moment I am assuming it is a bug in something
 somewhere. The versions of php and MySQL that I am using are not fully
 tested. Therefore it is entirely possible that the problem I had is not
 supposed to be a problem.

sigh Whether it is bug or not, whether it is supposed to be a problem or 
not, the fact is that the firewall was interfering with your ability to 
connect to mysql.

  1) How are you connecting using mysql_connect()? Do you use IP addresses
  or
  hostnames?
  2) What are your exact connection parameters when connecting as an admin
  user?
  3) What are your exact connection parameters when connecting as an
  normal user?

 I am not sure how to determine these things, except to say that I am using
 MySQL as it was installed by the Typical installation option.

I'm not familiar with MySQL under Windows, but I believe that there are 
different installers available from various sources. So saying Typical 
installation option doesn't really mean much.

 Oh, now I understand better. Sorry. The username admin confused me, but I
 should have known.

I didn't say the username admin, I said the admin user.

 There is a slight chance I used a different host than localhost. 

[quote from another Sam HObbs post]
 However I also believe in being methodical and in verifying assumptions. It
 does help to eliminate possilities.
[end quote]

I would've thought that being methodical implied meticulous noting of cause 
and effect.

Using anything other than localhost/127.0.0.1 would almost certainly make you 
hit the firewall.

Note also that for troubleshooting it's probably better to use 127.0.0.1 
rather than localhost. The latter is subject to your system's dns resolution 
mechanism and also to the mysql client library's interpretation.

 Other than that, I used the following
 for both my Administrator and my non-Administrator accounts:

 ?php
 $location = localhost;
 $username = root;
 $password = ;
 $database = mysql;
 $conn = mysql_connect($location, $username, $password);
 if (!$conn) die (pCould not connect to MySQL using $location, $username,
 $password/p\n);
[...]

I would suggest that you use the above code to do the following combination of 
tests:

1) With ZoneAlarm enabled and with it disabled (yes disabled completely, if 
you're worried disconnect from the internet and any other networks)

2) With $location='localhost' and $location='127.0.0.1'

3) With $username='root' and $username='somenormaluser'

That's a total of 12 tests if you're following.

If when you have ZoneAlarm enabled and you can connect with one user and not 
with another (I believe you came across this is a previous post) then show us 
following:

The following should be performed on the 'mysql' database (ie the system 
database which holds all the user related info):


select * from user where User='user_that_can_connect';
select * from db where User='user_that_can_connect';

select * from user where User='user_that_cannot_connect';
select * from db where User='user_that_cannot_connect';

-- 
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design  Hosting * Internet  Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
--
/*
Disc space -- the final frontier!
*/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: mysql_connect does not connect

2004-09-16 Thread Jason Wong
On Thursday 16 September 2004 11:51, raditha dissanayake wrote:

 me thinks it's time to look very closely at http://www.postgresql.org
 Not just you sam, all of us.

If everyone subscribes to your reasoning then nobody would be using Windows 
(yay!).

Anyway FWIW I found postgresql's system of granting users access is way more 
complicated to get to grips to than mysql's.

-- 
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design  Hosting * Internet  Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
--
/*
Pay no attention to the man behind the curtain.
-- The Wizard Of Oz
*/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: mysql_connect does not connect

2004-09-16 Thread raditha dissanayake
Jason Wong wrote:
On Thursday 16 September 2004 11:51, raditha dissanayake wrote:
 

me thinks it's time to look very closely at http://www.postgresql.org
Not just you sam, all of us.
   

If everyone subscribes to your reasoning then nobody would be using Windows 
(yay!).
 

I am a recent convert to postgres so bear with me. last year my religion 
was pretty much mysql.

Anyway FWIW I found postgresql's system of granting users access is way more 
complicated to get to grips to than mysql's.

 


--
Raditha Dissanayake.

http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload
Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader
Graphical User Inteface. Just 128 KB | with progress bar.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP] Re: mysql_connect does not connect

2004-09-16 Thread Curt Zirzow
* Thus wrote Sam Hobbs:
 Janbro [EMAIL PROTECTED] wrote in message 
 news:[EMAIL PROTECTED]
  Hi I connect to a MySQL 4.1 with the following String:
 
 
  if
  ($db_verbin=mysqli_connect($mysql_host,$mysql_user,$mysql_passw,$DB_n
  ame))
 
  watch the i in mysqli_connect!
 
  I think I've read somewhere that you are required to use that for the 4.1
  Versions, but you
 
  better look that up, I might be wrong there.
 
  Hope this helps
 
  JanBro
 
 
 When I do try mysqli_connect, I get:
 
 Fatal error:  Call to undefined function mysqli_connect()
 
 So obviously I need to do something to enable that. I will look into that 
 later, but I am still trying to get mysql_connect to work.

RTFM.

mysql:
  This MySQL extension doesn't support full functionality of MySQL
  versions greater than 4.1.0. For that, use MySQLi.

mysqli:
  The mysqli extension is designed to work with the version 4.1.3 or
  above of MySQL.



Curt
-- 
The above comments may offend you. flame at will.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: mysql_connect does not connect

2004-09-16 Thread Jason Davidson
woah, full functionality.. it has will still connect, at least, it will
still connect for me.  Where the functionality is missing, im not sure.
 But sinse the error is cant connect to localhost, i would say that it
strying to connect to localhost, and not being allowed.  

That said, im fully open to the idea that this may be the problem, im
just reporting that i have connected to a mysql version greater than
4.1 with mysql_connect.  

Jason

Curt Zirzow [EMAIL PROTECTED] wrote: 
 
 * Thus wrote Sam Hobbs:
  Janbro [EMAIL PROTECTED] wrote in message 
  news:[EMAIL PROTECTED]
   Hi I connect to a MySQL 4.1 with the following String:
  
  
   if
   ($db_verbin=mysqli_connect($mysql_host,$mysql_user,$mysql_passw,$DB_n
   ame))
  
   watch the i in mysqli_connect!
  
   I think I've read somewhere that you are required to use that for the 4.1
   Versions, but you
  
   better look that up, I might be wrong there.
  
   Hope this helps
  
   JanBro
  
  
  When I do try mysqli_connect, I get:
  
  Fatal error:  Call to undefined function mysqli_connect()
  
  So obviously I need to do something to enable that. I will look into that 
  later, but I am still trying to get mysql_connect to work.
 
 RTFM.
 
 mysql:
   This MySQL extension doesn't support full functionality of MySQL
   versions greater than 4.1.0. For that, use MySQLi.
 
 mysqli:
   The mysqli extension is designed to work with the version 4.1.3 or
   above of MySQL.
 
 
 
 Curt
 -- 
 The above comments may offend you. flame at will.
 
 -- 
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: mysql_connect does not connect

2004-09-16 Thread John Nichel
Jason Davidson wrote:
woah, full functionality.. it has will still connect, at least, it will
still connect for me.  Where the functionality is missing, im not sure.
 But sinse the error is cant connect to localhost, i would say that it
strying to connect to localhost, and not being allowed.  
The missing functionality has to do with new functions added to MySQL 
4.1.x that didn't exist before.  It's safe to say that being able to 
connect to the database existed before MySQL 4.1.x.  Check the MySQL web 
site for changes to 4.1.x

If the error is...
Fatal error:  Call to undefined function mysqli_connect()
Then the problem is that mysqli support is not compiled in.
MySQL functions != MySQLi functions
That said, im fully open to the idea that this may be the problem, im
just reporting that i have connected to a mysql version greater than
4.1 with mysql_connect.  
mysql_connect() != mysqli_connect
--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP] Re: mysql_connect does not connect

2004-09-15 Thread Sam Hobbs
Andrew Kreps [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED]
 On Tue, 14 Sep 2004 10:11:24 -0700, Sam Hobbs [EMAIL PROTECTED] wrote:
 Also, are the warning messages documented? As I asked in my original
 question, is 10061 an error code?

 10061 is a generic winsock error for a timeout, it's not PHP or MySQL
 specific.  It means that the call couldn't connect to the socket you
 were trying to hit within the time allowed.

Again, thank you.

Apparently there is a problem with the internet being accessed. I tried to 
determine the problem but it is not clear. What I did to try to diagnose the 
problem is that I deleted from ZoneAlarm the configuration for the relevant 
programs. For those not familiar with ZoneAlarm, I essentially removed from 
it anything it knew about Apache, MySQL and php. I thne tried the 
mysql_connect, and ZoneAlarm asked if Apache could access the internet. 
However it behaved differently, depending on whether I was using an account 
with administrator privileges. If I was using administrator privileges, 
Apache tried to connect to address 0.0.0.0. If I was not using administrator 
privileges, Apache tried to connect to the DNS server address. However there 
are more details so assuming this is a bug I need to coordinate with someone 
to determine how to diagnose this.

By removing Apache, MySQL and php from ZoneAlarm and then allowing Apache to 
access the internet when I did the mysql_connect, I am able to connect. I 
assume that this is not how it should be.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: mysql_connect does not connect

2004-09-15 Thread Jason Wong
On Thursday 16 September 2004 06:14, Sam Hobbs wrote:

[quote from another Sam Hobbs post]
 I am the original poster. The reason I avoid doing things like that is
 because it is a guess. It should not be necessary; the firewal should not
 be relevant. Sometimes people suggest things that are not likely to be a
 solution but are easy to suggest.
[end quote]

 Apparently there is a problem with the internet being accessed. I tried to
 determine the problem but it is not clear. What I did to try to diagnose
 the problem is that I deleted from ZoneAlarm the configuration for the
 relevant programs. For those not familiar with ZoneAlarm, I essentially
 removed from it anything it knew about Apache, MySQL and php. I thne tried
 the
 mysql_connect, and ZoneAlarm asked if Apache could access the internet.
 However it behaved differently, depending on whether I was using an account
 with administrator privileges. If I was using administrator privileges,
 Apache tried to connect to address 0.0.0.0. If I was not using
 administrator privileges, Apache tried to connect to the DNS server
 address. However there are more details so assuming this is a bug I need to
 coordinate with someone to determine how to diagnose this.

 By removing Apache, MySQL and php from ZoneAlarm and then allowing Apache
 to access the internet when I did the mysql_connect, I am able to connect.
 I assume that this is not how it should be.

So now are you fully convinced it's your firewall that's the root of your 
problem?

1) How are you connecting using mysql_connect()? Do you use IP addresses or 
hostnames?
2) What are your exact connection parameters when connecting as an admin 
user?
3) What are your exact connection parameters when connecting as an normal 
user?

-- 
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design  Hosting * Internet  Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
--
/*
Moneyliness is next to Godliness.
-- Andries van Dam
*/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: mysql_connect does not connect

2004-09-15 Thread Jason Davidson
firewall, who would have thought

Jason Wong [EMAIL PROTECTED] wrote: 
 
 On Thursday 16 September 2004 06:14, Sam Hobbs wrote:
 
 [quote from another Sam Hobbs post]
  I am the original poster. The reason I avoid doing things like that is
  because it is a guess. It should not be necessary; the firewal should not
  be relevant. Sometimes people suggest things that are not likely to be a
  solution but are easy to suggest.
 [end quote]
 
  Apparently there is a problem with the internet being accessed. I tried to
  determine the problem but it is not clear. What I did to try to diagnose
  the problem is that I deleted from ZoneAlarm the configuration for the
  relevant programs. For those not familiar with ZoneAlarm, I essentially
  removed from it anything it knew about Apache, MySQL and php. I thne tried
  the
  mysql_connect, and ZoneAlarm asked if Apache could access the internet.
  However it behaved differently, depending on whether I was using an account
  with administrator privileges. If I was using administrator privileges,
  Apache tried to connect to address 0.0.0.0. If I was not using
  administrator privileges, Apache tried to connect to the DNS server
  address. However there are more details so assuming this is a bug I need to
  coordinate with someone to determine how to diagnose this.
 
  By removing Apache, MySQL and php from ZoneAlarm and then allowing Apache
  to access the internet when I did the mysql_connect, I am able to connect.
  I assume that this is not how it should be.
 
 So now are you fully convinced it's your firewall that's the root of your 
 problem?
 
 1) How are you connecting using mysql_connect()? Do you use IP addresses or 
 hostnames?
 2) What are your exact connection parameters when connecting as an admin 
 user?
 3) What are your exact connection parameters when connecting as an normal 
 user?
 
 -- 
 Jason Wong - Gremlins Associates - www.gremlins.biz
 Open Source Software Systems Integrators
 * Web Design  Hosting * Internet  Intranet Applications Development *
 --
 Search the list archives before you post
 http://marc.theaimsgroup.com/?l=php-general
 --
 /*
 Moneyliness is next to Godliness.
   -- Andries van Dam
 */
 
 -- 
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: mysql_connect does not connect

2004-09-15 Thread Sam Hobbs
Jason Wong [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED]

 So now are you fully convinced it's your firewall that's the root of your
 problem?

No, not really. At the moment I am assuming it is a bug in something 
somewhere. The versions of php and MySQL that I am using are not fully 
tested. Therefore it is entirely possible that the problem I had is not 
supposed to be a problem.

 1) How are you connecting using mysql_connect()? Do you use IP addresses 
 or
 hostnames?
 2) What are your exact connection parameters when connecting as an admin
 user?
 3) What are your exact connection parameters when connecting as an normal
 user?


I am not sure how to determine these things, except to say that I am using 
MySQL as it was installed by the Typical installation option.

Oh, now I understand better. Sorry. The username admin confused me, but I 
should have known.

There is a slight chance I used a different host than localhost. So to be 
absolutely sure, I will do the tests again when I make a fomal bug report, 
assuming that a bug report is needed. Other than that, I used the following 
for both my Administrator and my non-Administrator accounts:

?php
$location = localhost;
$username = root;
$password = ;
$database = mysql;
$conn = mysql_connect($location, $username, $password);
if (!$conn) die (pCould not connect to MySQL using $location, $username, 
$password/p\n);
print pConnected to MySQL using $location, $username, $password/p\n;
mysql_select_db($database, $conn) or die (pCould not open 
database/p\n);
print pDatabase $database selected./p\n;
?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: mysql_connect does not connect

2004-09-15 Thread raditha dissanayake
me thinks it's time to look very closely at http://www.postgresql.org
Not just you sam, all of us.
--
Raditha Dissanayake.

http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload
Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader
Graphical User Inteface. Just 128 KB | with progress bar.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[PHP] Re: mysql_connect does not connect

2004-09-14 Thread JanBro
Hi I connect to a MySQL 4.1 with the following String:


if
($db_verbin=mysqli_connect($mysql_host,$mysql_user,$mysql_passw,$DB_n
ame))

watch the i in mysqli_connect!

I think I've read somewhere that you are required to use that for the 4.1
Versions, but you

better look that up, I might be wrong there.

Hope this helps

JanBro

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] Re: mysql_connect does not connect

2004-09-14 Thread JanBro
Hi I connect to a MySQL 4.1 with the following String:


if
($db_verbin=mysqli_connect($mysql_host,$mysql_user,$mysql_passw,$DB_n
ame))

watch the i in mysqli_connect!

I think I've read somewhere that you are required to use that for the 4.1
Versions, but you

better look that up, I might be wrong there.

Hope this helps. By the way, can you connect thru PHPMyAdmin? If not you
might have that
old version password problem.

JanBro

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] Re: mysql_connect does not connect

2004-09-14 Thread JanBro
Hi I connect to a MySQL 4.1 with the following String:


if
($db_verbin=mysqli_connect($mysql_host,$mysql_user,$mysql_passw,$DB_n
ame))

watch the i in mysqli_connect!

I think I've read somewhere that you are required to use that for the 4.1
Versions, but you

better look that up, I might be wrong there.

Hope this helps. By the way, can you connect thru PHPMyAdmin? If not you
might have that
old version password problem.

JanBro

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] Re: mysql_connect does not connect

2004-09-14 Thread Sam Hobbs
Janbro [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED]
 Hi I connect to a MySQL 4.1 with the following String:


 if
 ($db_verbin=mysqli_connect($mysql_host,$mysql_user,$mysql_passw,$DB_n
 ame))

 watch the i in mysqli_connect!

 I think I've read somewhere that you are required to use that for the 4.1
 Versions, but you

 better look that up, I might be wrong there.

 Hope this helps

 JanBro


Thank you. Yes I know that there are two versions of interfaces to MySQL and 
the newer version has the i in it. Perhaps I should use it, but I thought 
the older version works also. I am using mysql_connect because the tutorial 
I started using uses it. Obvioulsy mysql_connect is in php version 5 so it 
should work.

So I hope no one thinks that my question has been answered.

If there is something stating that mysql_connect is not supposed to be used 
then it would help to know where that is said.

Otherwise it would help to know what to look for as possible causes, 
assuming that the host, user and password are correct.

Also, are the warning messages documented? As I asked in my original 
question, is 10061 an error code?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] Re: mysql_connect does not connect

2004-09-14 Thread Sam Hobbs
Janbro [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED]
 Hi I connect to a MySQL 4.1 with the following String:


 if
 ($db_verbin=mysqli_connect($mysql_host,$mysql_user,$mysql_passw,$DB_n
 ame))

 watch the i in mysqli_connect!

 I think I've read somewhere that you are required to use that for the 4.1
 Versions, but you

 better look that up, I might be wrong there.

 Hope this helps

 JanBro


When I do try mysqli_connect, I get:

Fatal error:  Call to undefined function mysqli_connect()

So obviously I need to do something to enable that. I will look into that 
later, but I am still trying to get mysql_connect to work.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: mysql_connect does not connect

2004-09-14 Thread John Nichel
Sam Hobbs wrote:
snip
When I do try mysqli_connect, I get:
Fatal error:  Call to undefined function mysqli_connect()
So obviously I need to do something to enable that. I will look into that 
later, but I am still trying to get mysql_connect to work.

mysqli : http://us4.php.net/mysqli
What error are you getting with mysql_connect()?
--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP] Re: mysql_connect does not connect

2004-09-14 Thread Andrew Kreps
On Tue, 14 Sep 2004 10:11:24 -0700, Sam Hobbs [EMAIL PROTECTED] wrote:
 Also, are the warning messages documented? As I asked in my original
 question, is 10061 an error code?

10061 is a generic winsock error for a timeout, it's not PHP or MySQL
specific.  It means that the call couldn't connect to the socket you
were trying to hit within the time allowed.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: mysql_connect does not connect

2004-09-14 Thread Sam Hobbs
Andrew Kreps [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED]
 On Tue, 14 Sep 2004 10:11:24 -0700, Sam Hobbs [EMAIL PROTECTED] wrote:
 Also, are the warning messages documented? As I asked in my original
 question, is 10061 an error code?

 10061 is a generic winsock error for a timeout, it's not PHP or MySQL
 specific.  It means that the call couldn't connect to the socket you
 were trying to hit within the time allowed.

Thank you; that helps.

So something that might help is for the PHP message to issue a more specific 
message indicating the timeout problem. This is just a suggestion for the 
developers.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php