mysql set up problem - MySQL Database

Sheldon

Hi,

I have a mysql setting problem that is driving me mad. Hopefully someone can
give some advice:

On the local network I have windows 2000/iis5 machine running our intranet
site, with php and mysql working ok. Anonymous access is disabled, and root
has been assigned a password and given full access to all tables from all
hosts (i reliase this isn't secure but its only temporary for testing)

The local intranet site which uses php/mysql works fine accross the company
network, and i can use mysql administrator software sucessfully on any pc
without problems. In short, everying great working fine.

We also have an internet webserver. Same setup, windows 2003/iis6, same php
and mysql versions, in fact everything is indecital even the mysql user
setup. only difference between two servers is physical location, ip address
and some ntfs permissions. I can connect to the server fine from anywhere
using mysql administrator, and the php site runs fine but nothing using
mysql works either when running the site on the server itself using
//localhost/index.php or accessing it remotly over the internet using
ip.add.re.ss/index.php. Other stuff works fine on the intenet webserver, its
just accessing mysql through php.

The only difference i can see is the ntfs permissions, but I have made
changes to them without success and other stuff on the sever does work fine.

Any advice/suggestions would be greatly appreciated.

Cheers
Sheldon

Jul 20 '05 #1

Subscribe Reply

2519

Aggro

Sheldon wrote:

using mysql administrator, and the php site runs fine but nothing using
mysql works either when running the site on the server itself using
//localhost/index.php or accessing it remotly over the internet using
ip.add.re.ss/index.php.

What php command doesn't work, and what is the error message?

Jul 20 '05 #2

Sheldon

"Aggro" <sp**********@y ahoo.com> wrote in message
news:XX******** *******@read3.i net.fi...

Sheldon wrote:
using mysql administrator, and the php site runs fine but nothing using
mysql works either when running the site on the server itself using
//localhost/index.php or accessing it remotly over the internet using
ip.add.re.ss/index.php.

What php command doesn't work, and what is the error message?

I can't connect to the mysql database using the pconnect command. Although I
can connect to the database using mysql administrator.

I think it may be either a compatibility issue with iis6 or a ntfs
permissions problem.

Mysql version is 4.0.20a, and php version is 4.3.7

Jul 20 '05 #3

Aggro

Sheldon wrote:

I can't connect to the mysql database using the pconnect command. Although I
can connect to the database using mysql administrator.

AFAIK there is no pconnect() function in php. There is mysql_pconnect( ),
perhaps you mean that? But you didn't tell what the error message is
that you are receiving, or are you even checking the error message? Do
you know how to see it?

Jul 20 '05 #4

Sheldon

"Aggro" <sp**********@y ahoo.com> wrote in message
news:Wt******** *******@read3.i net.fi...

Sheldon wrote:
I can't connect to the mysql database using the pconnect command. Although I can connect to the database using mysql administrator.

AFAIK there is no pconnect() function in php. There is mysql_pconnect( ),
perhaps you mean that? But you didn't tell what the error message is
that you are receiving, or are you even checking the error message? Do
you know how to see it?

Perhaps my original post wasn't clear or was too complicated for you.

Server 1: Win2000/IIS5 - Everything works fine
Server 2: Win2003/IIS6 - Connecting to MySQL through PHP doesn't work
Both servers have identical PHP/MySQL setups.

This is NOT a coding issue since the code works fine on the W2K server. It
looks like a problem with either IIS6 or NTFS permissions since the default
NTFS permissions on Win2003 are stricter than Win2000.

Anyone else expericed similar problem on WIN2003 with MySQL?

Jul 20 '05 #5

Marc Hoeve

IIS6 on Win2003 has a very different setup compared to IIS5 in Windows 2000.
See the site http://s92192454.onlinehome.us./PHP_...under_IIS.html
for more details about configuring PHP and MySQL for IIS6...

Hope this site contains a solution for you...

Marc

"Sheldon" <sh************ ***@yahoo.co.uk > schreef in bericht
news:RC5yc.128$ ec4.60@newsfe5-win...

"Aggro" <sp**********@y ahoo.com> wrote in message
news:Wt******** *******@read3.i net.fi...
Sheldon wrote:
I can't connect to the mysql database using the pconnect command. Although I can connect to the database using mysql administrator.
AFAIK there is no pconnect() function in php. There is mysql_pconnect( ),
perhaps you mean that? But you didn't tell what the error message is
that you are receiving, or are you even checking the error message? Do
you know how to see it?

Perhaps my original post wasn't clear or was too complicated for you.

Server 1: Win2000/IIS5 - Everything works fine
Server 2: Win2003/IIS6 - Connecting to MySQL through PHP doesn't work
Both servers have identical PHP/MySQL setups.

This is NOT a coding issue since the code works fine on the W2K server.

It looks like a problem with either IIS6 or NTFS permissions since the default NTFS permissions on Win2003 are stricter than Win2000.

Anyone else expericed similar problem on WIN2003 with MySQL?

Jul 20 '05 #6

Aggro

Sheldon wrote:

Perhaps my original post wasn't clear or was too complicated for you.

Server 1: Win2000/IIS5 - Everything works fine
Server 2: Win2003/IIS6 - Connecting to MySQL through PHP doesn't work
Both servers have identical PHP/MySQL setups.

This is NOT a coding issue since the code works fine on the W2K server.

Example 1:
- Sir could you tell me what does the error message say?
- Of course, the error message says xxx xxx
- Okay, the problem is xxx and the solution would be to xxx

Example 2:
- Sir could you tell me what does the error message say?
- No way, didn't you understand, this doesn't work!
- I can't help you if you don't tell me error message.
- Are you stupid? I said that this doesn't work.
- The error message might provide important information about why the
connection fails. Getting error message doesn't mean that you must have
an error in your php code, it can also mean that php doesn't fail the
server socket, or there is problem with privileges or even that there is
not enough memory to commit the action. That's why reading and
understanding the error message helps a lot more rather than using a
crystal ball and trying to guess what might be wrong.
- [ to be continued ]

I might not be able to help even if I see the error message, but without
it, I'm sure that I won't be able to help. I hope that you know what I
mean with the error message?

For example you might have code that looks a little like this:
----------------------------------
<?
$link = mysql_connect(" localhost", "username", "password")
or die("Could not connect");
....
----------------------------------

And if you go to web page, you would get error message that looks like this:
----------------------------------
Warning: mysql_connect() : Access denied for user: 'username@local host'
(Using password: YES) in /home/php/database.ph on line 2
Could not connect
----------------------------------

Now, in this case, I would instantly see that there is no user called
"username" with given password, in database. So problem would be with
privileges. Then I could easily tell how to fix the problem, by using
grant-command to add privileges.

If you fail to connect to the database, you should get somekind of error
message that helps locating the problem.

Jul 20 '05 #7

Sheldon

"Aggro" <sp**********@y ahoo.com> wrote in message
news:7Q******** ****@read3.inet .fi...

Sheldon wrote:

Server 1: Win2000/IIS5 - Everything works fine
Server 2: Win2003/IIS6 - Connecting to MySQL through PHP doesn't work
Both servers have identical PHP/MySQL setups.

The error I get when trying to use the mysql_pconnect( ) function is:

Warning: mysql_pconnect( ): Can't create TCP/IP socket (10041)

Again, all code and mysql/php settings/versions are the same. Tested it
using php.exe through the command line and the output was ok. So that
narrows things down a bit.

Jul 20 '05 #8

Aggro

Sheldon wrote:

The error I get when trying to use the mysql_pconnect( ) function is:

Warning: mysql_pconnect( ): Can't create TCP/IP socket (10041)

-----------------------------
WSAEPROTOTYPE (10041)
Protocol wrong type for socket.
A protocol was specified in the socket function call that does not
support the semantics of the socket type requested. For example, the
ARPA Internet UDP protocol cannot be specified with a socket type of
SOCK_STREAM.
-----------------------------

That error message looks very strange. I think it could even be a bug in
php or php is just not fully supported by iis6 or iis6 is not supported
by php. I'm pretty sure it has nothing to do with the MySQL server
anyway, because it seems to fail to create the socket, so connection to
database is not even attempted to be created.

You could ask this question in some php related newsgroup by attaching
the error message + the error explanation in this message. Perhaps they
could tell whether that is the problem with the php or with the iis server.

Good luck

Jul 20 '05 #9

Sheldon

"Aggro" <sp**********@y ahoo.com> wrote in message
news:YG******** *******@read3.i net.fi...

Sheldon wrote:
The error I get when trying to use the mysql_pconnect( ) function is:

Warning: mysql_pconnect( ): Can't create TCP/IP socket (10041)
-----------------------------
WSAEPROTOTYPE (10041)
Protocol wrong type for socket.
A protocol was specified in the socket function call that does not
support the semantics of the socket type requested. For example, the
ARPA Internet UDP protocol cannot be specified with a socket type of
SOCK_STREAM.
-----------------------------

That error message looks very strange. I think it could even be a bug in
php or php is just not fully supported by iis6 or iis6 is not supported
by php. I'm pretty sure it has nothing to do with the MySQL server
anyway, because it seems to fail to create the socket, so connection to
database is not even attempted to be created.

You could ask this question in some php related newsgroup by attaching
the error message + the error explanation in this message. Perhaps they
could tell whether that is the problem with the php or with the iis

server.
Good luck

Thanks very much for your help. I'll give your suggestions a try and also
try an earlier version of PHP.

Jul 20 '05 #10

Similar topics

6528

DBD:mysql doesn't read mysql option file /etc/my.cnf file

by: JL | last post by:

Platform: Linux Red Hat RHEL 3 (and red hat 9) Installed MySQL from source. As a matter of fact, installed all LAMPS from source, and the mysql socket file was arranged in a place other than /tmp/mysql.sock. Let's say, /opt/mysql_root/sock/mysql.sock. Installed DBI without any problem. In /etc/my.cnf there are lines as ----- ----- -----

Perl

3527

MySQL 4.0.14 has been released

by: Lenz Grimmer | last post by:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, MySQL 4.0.14, a new version of the popular Open Source/Free Software Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites.

MySQL Database

1641

mysql on mandrake 10 problems

by: Kirk Soodhalter | last post by:

Hi, This started as a phpmyadmin problem, but has somehow morphed into a mysql problem. I don't know how to fix it. I am posting the conversation from a php newsgroup since it started there. Thanks for any help you might be able to give. -Kirk Ok, in the midst of fixing this problem I have somehow managed to create

MySQL Database

519

MySQL 4.0.18 on Dual AMD64 Opteron causing thread zombie even when timeout is set to 60 seconds

by: Plymouth Acclaim | last post by:

Hi guys, We have a problem with Dual AMD64 Opteron/MySQL 4.0.18/Mandrake 10 for a very high volume site. We are evaluating the performance on our new server AMD64 and it seems it's slow compared to Dual Xeon/MySQL 4.0.15/RedHat8 and Dual Xeon/MySQL 4.0.18/Mandrake 10. And it seems there are zombie threads. 570 threads in 1 hour and we didn't even use JDBC connection pooling at all. These threads are supposed to be gone within 60...

MySQL Database

3825

Installing DBD::mysql - missing mysql.h - how to get it known tocygwin/perl?

by: Alex Hunsley | last post by:

I am trying to install the DBD::mysql perl module. However, it claims I need mysql.h: cpan> install DBD::mysql CPAN: Storable loaded ok Going to read /home/alex/.cpan/Metadata Database was generated on Mon, 29 Nov 2004 16:01:05 GMT Running install for module DBD::mysql Running make for R/RU/RUDY/DBD-mysql-2.9004.tar.gz CPAN: Digest::MD5 loaded ok

MySQL Database

3642

Mysql-DBD Perl module Installation Problem in HPUX

by: smsabu2002 | last post by:

Hi, I am facing the build problem while installing the DBD-MySql perl module (ver 2.9008) using both GCC and CC compilers in HP-UX machine. For the Build using GCC, the compiler error is produced due to the unknown GCC compiler option "+DAportable". For the Build using CC, the preprocessor error is produced due to the recursive declration of macro "PerlIO" in perlio.h file.

MySQL Database

4857

MySQL 5.0, FULL-TEXT Indexing and Search Arabic Data, Unicode

by: jrs_14618 | last post by:

Hello All, This post is essentially a reply a previous post/thread here on this mailing.database.myodbc group titled: MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode I was wondering if anybody has experienced the same issues

PHP

110

10625

MyISAM engine: worst case scenario in case of crash (mysql, O/S,hardware, whatever)

by: alf | last post by:

Hi, is it possible that due to OS crash or mysql itself crash or some e.g. SCSI failure to lose all the data stored in the table (let's say million of 1KB rows). In other words what is the worst case scenario for MyISAM backend? Also is it possible to not to lose data but get them corrupted?

MySQL Database

5869

Mysql database in UTF8, PHP shows latin1 (iso-8859-1)

by: alex | last post by:

I've converted a latin1 database I have to utf8. The process has been: # mysqldump -u root -p --default-character-set=latin1 -c --insert-ignore --skip-set-charset mydb mydb.sql # iconv -f ISO-8859-1 -t UTF-8 mydb.sql mydb_utf8.sql mysqlCREATE DATABASE mydb_utf8 CHARACTER SET utf8 COLLATE utf8_general_ci;

PHP

1821

php 5 and mysql failure

by: Caffeneide | last post by:

I'm using a php script which performs three xml queries to other three servers to retrieve a set of ids and after I do a query to mysql of the kind SELECT * FROM table WHERE id IN ('set of ids'); Although I'm sure the connection to the database is ok, I sometimes get an error of this kind: *Warning*: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in ... This does not happen every time i run the script, only...

PHP

9568

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9398

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10007

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9951

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8831

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7378

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5275

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3531

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2805

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General