★ wanayoo — archive 1999 http://www.devshed.com/Talk/Forums/Forum5/HTML/000059.htmlNouvelle recherche | Portail wanayoo
DevShed Menu
* DevShed Home
* Developer News
* DevShed Brain Dump




UBBFriend: Email This Page to Someone!
  DevShed Discussion Forums
  PHP
  Warning: MySQL Connection Failed: Can't create IP socket (10036)

Post New Topic  Post A Reply
profile | register | preferences | faq | search

next newest topic | next oldest topic
Author Topic:   Warning: MySQL Connection Failed: Can't create IP socket (10036)
baerinfodat
Junior Member
posted July 08, 1999 06:40 AM     Click Here to See the Profile for baerinfodat   Click Here to Email baerinfodat     Edit/Delete Message Reply w/Quote
Hello to all specialists

I have a Problem with together MySQL, PHP3 and Apache-Server on Windows95.

I run Apache-Server as Webserver , also on this machine runbs MySQLWIN32.

Ihave written a simple PHP3 code as follows:


<html>
<Title>Datenbanktest</title>
<head>
<a>Datenbank wird erzeugt...</a><br>
</head>

<body>

<!--Datenbank erstellen-->
<?
mysql_connect("localhost", "username") ;
@mysql_select_db("databasename");

$create = "CREATE TABLE test
(
Name CHAR(50),
)";

MYSQL_QUERY($create);


mysql_close();
?>

<a>Fertig.</a>
</body>

</html>

if let it run I get an errormessage as follows:

Warning: MySQL Connection Failed: Can't create IP socket (10036) in D:\Programme\Apache_Group\Apache\htdocs/create_table_katalog.php3 on line 11

Warning: MySQL Connection Failed: Can't create IP socket (10036) in D:\Programme\Apache_Group\Apache\htdocs/create_table_katalog.php3 on line 28

Warning: -1 is not a MySQL link index in D:\Programme\Apache_Group\Apache\htdocs/create_table_katalog.php3 on line 28

Warning: -1 is not a MySQL link index in D:\Programme\Apache_Group\Apache\htdocs/create_table_katalog.php3 on line 31

I need help because iàm really no know whats gonna happen here.

Thanks in advanced

Oliver

Thanks for your information but I have started MYSQL wi´th the command mysqld
already and the same problem appears.

[This message has been edited by baerinfodat (edited 07-08-99).]

rod k
Member
posted July 08, 1999 08:27 AM     Click Here to See the Profile for rod k   Click Here to Email rod k     Edit/Delete Message Reply w/Quote
It appears you haven't started mysql.

Run mysqld from the command line.

baerinfodat
Junior Member
posted July 08, 1999 09:32 AM     Click Here to See the Profile for baerinfodat   Click Here to Email baerinfodat     Edit/Delete Message Reply w/Quote
Thanks for your information but I have started MYSQL wi´th the command mysqld
already and the same problem appears.

Do you have another idea

rod k
Member
posted July 09, 1999 05:50 AM     Click Here to See the Profile for rod k   Click Here to Email rod k     Edit/Delete Message Reply w/Quote
First, I'd suggest that you access the return values for the functions you are calling. i.e.:
$linkid=mysql_connect("localhost","username");

Then, I'd verify the connection:

if (!$linkid){
print mysql_error();
exit;
}

That might give you some more information.

Also, have you tried logging into mysql directly from a DOS shell? Actually, I'd do THAT first.

BTW, I'm not sure why you are getting the warning about "-1 is not a mysql link index".

According to the docs you should never get a negative number on a connection attempt. 0 for failure or the link id which is a positive integer.

Curious....

Rod

Tony Peters
Junior Member
posted August 04, 1999 04:37 AM     Click Here to See the Profile for Tony Peters   Click Here to Email Tony Peters     Edit/Delete Message Reply w/Quote
Try updating to Winsock 2.
I had this problem, and that cured it.

The original version of Winsock with came with Win95 was buggy

All times are MST (US)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:

Contact Us | DevShed.com

Copyright © 1997-2000 ngenuity. All rights reserved.

Powered by: Ultimate Bulletin Board, Version 5.41a
© Infopop Corporation (formerly Madrona Park, Inc.), 1998 - 1999.