Mysql e IIS... come?

[saucer]

Come posso installare MySql su IIS?

Call to undefined function mysql_connect()

Help Pls!!

[Threepwood]

sul freephp.it trovi guide a proposito...

cmq sono 2 cose che non centrano fra loro : IIS è il servizio che fa girare un sito web, mysql un database.

se ti da quell'errore è perchè hai installato male mysql.

scarica da www.mysql.com l'ultima versione di mysql, ne trovi una autoinstallante

In alternativa controlla se nel PHP.ini è configurato bene mysql e se è abilitato il modulo

[saucer]

Ciao, sono stato un po' frettoloso.....

Allora ripeto un po' il tutto per far capire un po' a che punto sono con l'installazione di Php e MySql.

Avevo installato EasyPhp 1.8, ma ho pensato che non mi conviene far convivere IIS e Apache su una macchina soprattutto se Apache mi serve solo per il Php.

Ho cosi disinstallato EasyPhp e ho scaricato i singoli pacchetti ( stamani ) di Php dal sito www.php.net e di MySql da www.mysql.org (se non erro).

Ho installato il pacchetto autoestraente di Php e mi son trovato in IIS l'estensione .php configurata.
Ho installato il pacchetto Setup.exe di Mysql e ho creato le prime tabelle con Mysql Administrator senza problemi.

A questo punto, ho fatto una paginetta test.php dove scrivo semplicemente <? echo phpinfo(); ?> e lo carico da browser con localhost/test.php ( tutto ok! )

Ho tolto quella riga dal file test.php ed ho scritto :
<?
$connessione = mysql_connect("localhost", "mionomeutente", "miapassword")
or die("Connessione non riuscita: " . mysql_error());
print ("Connesso con successo");
mysql_close($connessione);
?>

ricarico la pagina e ottento :

Fatal error: Call to undefined function mysql_connect() in...

Come posso risolvere?
Dove devo guardare nel php.ini? ( e dove lo trovo che non lo vedo? )

[Threepwood]

Far convivere IIS e Apache è una sfida contro i mulini a vento.. si ostacolano l'un l'altro.
Non che non sia del tutto possibile, ma lo sconsiglierei a priori.

Quel messaggio vuole dire che MYSQL_CONNECT (funzione base di mysql per php) non esiste.
In questo caso IIS non credo centri nulla perchè non interferisce con mysql

Vuole dire che php non capisce che su quella macchina c'è mysql(cosa + unica che rara...)

spara giu il php info, magari capiamo cosa è... probabilmente (almeno spero) è qualche valore da cambiare nel php.ini

[Threepwood]

su php in genere viene abilitato di default il modulo di mysql.
se così non fosse prova a cercare su php.ini

;extension=php_mysql.dll

e a modificarlo con

extension=php_mysql.dll (decommentalo, togli il ';')

... e riavvia i vari servizi

[saucer]

Allora.... saro' sintetico.
1) Avevo Apache. Ora non piu'
2) Ho installato il Php versione CGI
3) Non ho neanche il php.ini ( ora sto scaricando la versione zip e vedo di installare quella :/ )

miii com'e' difficile....

( vi faro' sapere )

[saucer]

Allora ho provveduto ad eliminare il ; ma dice che non riesce a trovare il moduli ./php_mysql.dll che ho correttamente installato su c:\php5\ext .

Posto il codice del mio phpinfo.

Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference On On
allow_url_fopen On On
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
auto_prepend_file no value no value
browscap no value no value
default_charset no value no value
default_mimetype text/html text/html
define_syslog_variables Off Off
disable_classes no value no value
disable_functions no value no value
display_errors On On
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl On On
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting 2047 2047
expose_php On On
extension_dir ./ ./
file_uploads On On
highlight.bg #FFFFFF #FFFFFF
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors On On
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .;C:\php5\pear .;C:\php5\pear
log_errors Off Off
log_errors_max_len 1024 1024
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.force_extra_parameters no value no value
max_execution_time 30 30
max_input_time 60 60
open_basedir no value no value
output_buffering no value no value
output_handler no value no value
post_max_size 8M 8M
precision 12 12
register_argc_argv On On
register_globals Off Off
register_long_arrays On On
report_memleaks On On
report_zend_debug On On
safe_mode Off Off
safe_mode_exec_dir no value no value
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from me@localhost.com me@localhost.com
sendmail_path no value no value
serialize_precision 100 100
short_open_tag On On
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir C:\PHP\uploadtemp C:\PHP\uploadtemp
user_dir no value no value
variables_order EGPCS EGPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.ze1_compatibility_mode Off Off


bcmath
BCMath support enabled


calendar
Calendar support enabled


dom
DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.6.11
HTML Support enabled
XPath Support enabled
XPointer Support enabled
Schema Support enabled
RelaxNG Support enabled


odbc
ODBC Support enabled
Active Persistent Links 0
Active Links 0
ODBC library Win32

Directive Local Value Master Value
odbc.allow_persistent On On
odbc.check_persistent On On
odbc.default_db no value no value
odbc.default_pw no value no value
odbc.default_user no value no value
odbc.defaultbinmode return as is return as is
odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes
odbc.max_links Unlimited Unlimited
odbc.max_persistent Unlimited Unlimited


session
Session Support enabled
Registered save handlers files user sqlite
Registered serializer handlers php php_binary wddx

Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 On On
session.bug_compat_warn On On
session.cache_expire 180 180
session.cache_limiter nocache nocache
session.cookie_domain no value no value
session.cookie_lifetime 0 0
session.cookie_path / /
session.cookie_secure Off Off
session.entropy_file no value no value
session.entropy_length 0 0
session.gc_divisor 100 100
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.hash_bits_per_character 4 4
session.hash_function 0 0
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path C:\PHP\sessiondata C:\PHP\sessiondata
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies Off Off
session.use_trans_sid 0 0


SimpleXML
Simplexml support enabled
Revision $Revision: 1.139.2.4 $
Schema support enabled


SPL
SPL support enabled
Interfaces RecursiveIterator, SeekableIterator
Classes ArrayIterator, ArrayObject, CachingIterator, CachingRecursiveIterator, DirectoryIterator, FilterIterator, LimitIterator, ParentIterator, RecursiveDirectoryIterator, RecursiveIteratorIterator, SimpleXMLIterator


SQLite
SQLite support enabled
PECL Module version 2.0-dev $Id: sqlite.c,v 1.146.2.7 2005/06/07 15:38:37 dmitry Exp $
SQLite Library 2.8.14
SQLite Encoding iso8859

Directive Local Value Master Value
sqlite.assoc_case 0 0


standard
Regex Library Bundled library enabled
Dynamic Library Support enabled
Internal Sendmail Support for Windows enabled

Directive Local Value Master Value
assert.active 1 1
assert.bail 0 0
assert.callback no value no value
assert.quiet_eval 0 0
assert.warning 1 1
auto_detect_line_endings 0 0
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.83 90.83
date.sunset_zenith 90.83 90.83
default_socket_timeout 60 60
safe_mode_allowed_env_vars PHP_ PHP_
safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH
url_rewriter.tags a=href,area=href,frame=src,input=src,form=,fieldse t= a=href,area=href,frame=src,input=src,form=,fieldse t=
user_agent no value no value


tokenizer
Tokenizer Support enabled


wddx
WDDX Support enabled
WDDX Session Serializer enabled


xml
XML Support active
XML Namespace Support active
libxml2 Version 2.6.11


zlib
ZLib Support enabled
Compiled Version 1.2.3
Linked Version 1.2.3

Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value


Additional Modules
Module Name


Environment
Variable Value
ALLUSERSPROFILE C:\Documents and Settings\All Users
CommonProgramFiles C:\Programmi\File comuni
COMPUTERNAME PRG-MAURIZIO
ComSpec C:\WINDOWS\system32\cmd.exe
CONTENT_LENGTH 0
FP_NO_HOST_CHECK NO
GATEWAY_INTERFACE CGI/1.1
HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/msword, application/vnd.ms-powerpoint, */*
HTTP_ACCEPT_LANGUAGE it,en-us;q=0.5
HTTP_CONNECTION Keep-Alive
HTTP_HOST localhost
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50215)
HTTPS off
INSTANCE_ID 1
LOCAL_ADDR 127.0.0.1
NUMBER_OF_PROCESSORS 1
OS Windows_NT
Path C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32 \Wbem;C:\Programmi\Microsoft SQL Server\80\Tools\BINN;C:\Programmi\File comuni\GTK\2.0\bin;C:\Programmi\Symantec\pcAnywher e\;C:\Programmi\File comuni\Adobe\AGL;C:\Programmi\Microsoft Visual Studio 8\Team Tools\Performance Tools\;
PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE x86
PROCESSOR_IDENTIFIER x86 Family 6 Model 10 Stepping 0, AuthenticAMD
PROCESSOR_LEVEL 6
PROCESSOR_REVISION 0a00
ProgramFiles C:\Programmi
REMOTE_ADDR 127.0.0.1
REMOTE_HOST 127.0.0.1
REQUEST_METHOD GET
SCRIPT_NAME /test.php
SERVER_NAME localhost
SERVER_PORT 80
SERVER_PORT_SECURE 0
SERVER_PROTOCOL HTTP/1.0
SERVER_SOFTWARE Microsoft-IIS/5.1
SystemDrive C:
SystemRoot C:\WINDOWS
TEMP C:\WINDOWS\TEMP
TMP C:\WINDOWS\TEMP
USERPROFILE C:\Documents and Settings\LocalService
VS80COMNTOOLS C:\Programmi\Microsoft Visual Studio 8\Common7\Tools\
windir C:\WINDOWS
ORIG_PATH_TRANSLATED c:\inetpub\wwwroot\test.php
ORIG_PATH_INFO /test.php
ORIG_SCRIPT_NAME /test.php
SCRIPT_FILENAME c:\inetpub\wwwroot\test.php


PHP Variables
Variable Value
_SERVER["ALLUSERSPROFILE"] C:\Documents and Settings\All Users
_SERVER["CommonProgramFiles"] C:\Programmi\File comuni
_SERVER["COMPUTERNAME"] PRG-MAURIZIO
_SERVER["ComSpec"] C:\WINDOWS\system32\cmd.exe
_SERVER["CONTENT_LENGTH"] 0
_SERVER["FP_NO_HOST_CHECK"] NO
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/msword, application/vnd.ms-powerpoint, */*
_SERVER["HTTP_ACCEPT_LANGUAGE"] it,en-us;q=0.5
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["HTTP_HOST"] localhost
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50215)
_SERVER["HTTPS"] off
_SERVER["INSTANCE_ID"] 1
_SERVER["LOCAL_ADDR"] 127.0.0.1
_SERVER["NUMBER_OF_PROCESSORS"] 1
_SERVER["OS"] Windows_NT
_SERVER["Path"] C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32 \Wbem;C:\Programmi\Microsoft SQL Server\80\Tools\BINN;C:\Programmi\File comuni\GTK\2.0\bin;C:\Programmi\Symantec\pcAnywher e\;C:\Programmi\File comuni\Adobe\AGL;C:\Programmi\Microsoft Visual Studio 8\Team Tools\Performance Tools\;
_SERVER["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
_SERVER["PROCESSOR_ARCHITECTURE"] x86
_SERVER["PROCESSOR_IDENTIFIER"] x86 Family 6 Model 10 Stepping 0, AuthenticAMD
_SERVER["PROCESSOR_LEVEL"] 6
_SERVER["PROCESSOR_REVISION"] 0a00
_SERVER["ProgramFiles"] C:\Programmi
_SERVER["REMOTE_ADDR"] 127.0.0.1
_SERVER["REMOTE_HOST"] 127.0.0.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["SCRIPT_NAME"] /test.php
_SERVER["SERVER_NAME"] localhost
_SERVER["SERVER_PORT"] 80
_SERVER["SERVER_PORT_SECURE"] 0
_SERVER["SERVER_PROTOCOL"] HTTP/1.0
_SERVER["SERVER_SOFTWARE"] Microsoft-IIS/5.1
_SERVER["SystemDrive"] C:
_SERVER["SystemRoot"] C:\WINDOWS
_SERVER["TEMP"] C:\WINDOWS\TEMP
_SERVER["TMP"] C:\WINDOWS\TEMP
_SERVER["USERPROFILE"] C:\Documents and Settings\LocalService
_SERVER["VS80COMNTOOLS"] C:\Programmi\Microsoft Visual Studio 8\Common7\Tools\
_SERVER["windir"] C:\WINDOWS
_SERVER["ORIG_PATH_TRANSLATED"] c:\inetpub\wwwroot\test.php
_SERVER["ORIG_PATH_INFO"] /test.php
_SERVER["ORIG_SCRIPT_NAME"] /test.php
_SERVER["SCRIPT_FILENAME"] c:\inetpub\wwwroot\test.php
_SERVER["PHP_SELF"] /test.php
_SERVER["argv"] Array
(
)


_SERVER["argc"] 0
_ENV["ALLUSERSPROFILE"] C:\Documents and Settings\All Users
_ENV["CommonProgramFiles"] C:\Programmi\File comuni
_ENV["COMPUTERNAME"] PRG-MAURIZIO
_ENV["ComSpec"] C:\WINDOWS\system32\cmd.exe
_ENV["CONTENT_LENGTH"] 0
_ENV["FP_NO_HOST_CHECK"] NO
_ENV["GATEWAY_INTERFACE"] CGI/1.1
_ENV["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/msword, application/vnd.ms-powerpoint, */*
_ENV["HTTP_ACCEPT_LANGUAGE"] it,en-us;q=0.5
_ENV["HTTP_CONNECTION"] Keep-Alive
_ENV["HTTP_HOST"] localhost
_ENV["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50215)
_ENV["HTTPS"] off
_ENV["INSTANCE_ID"] 1
_ENV["LOCAL_ADDR"] 127.0.0.1
_ENV["NUMBER_OF_PROCESSORS"] 1
_ENV["OS"] Windows_NT
_ENV["Path"] C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32 \Wbem;C:\Programmi\Microsoft SQL Server\80\Tools\BINN;C:\Programmi\File comuni\GTK\2.0\bin;C:\Programmi\Symantec\pcAnywher e\;C:\Programmi\File comuni\Adobe\AGL;C:\Programmi\Microsoft Visual Studio 8\Team Tools\Performance Tools\;
_ENV["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
_ENV["PROCESSOR_ARCHITECTURE"] x86
_ENV["PROCESSOR_IDENTIFIER"] x86 Family 6 Model 10 Stepping 0, AuthenticAMD
_ENV["PROCESSOR_LEVEL"] 6
_ENV["PROCESSOR_REVISION"] 0a00
_ENV["ProgramFiles"] C:\Programmi
_ENV["REMOTE_ADDR"] 127.0.0.1
_ENV["REMOTE_HOST"] 127.0.0.1
_ENV["REQUEST_METHOD"] GET
_ENV["SCRIPT_NAME"] /test.php
_ENV["SERVER_NAME"] localhost
_ENV["SERVER_PORT"] 80
_ENV["SERVER_PORT_SECURE"] 0
_ENV["SERVER_PROTOCOL"] HTTP/1.0
_ENV["SERVER_SOFTWARE"] Microsoft-IIS/5.1
_ENV["SystemDrive"] C:
_ENV["SystemRoot"] C:\WINDOWS
_ENV["TEMP"] C:\WINDOWS\TEMP
_ENV["TMP"] C:\WINDOWS\TEMP
_ENV["USERPROFILE"] C:\Documents and Settings\LocalService
_ENV["VS80COMNTOOLS"] C:\Programmi\Microsoft Visual Studio 8\Common7\Tools\
_ENV["windir"] C:\WINDOWS
_ENV["ORIG_PATH_TRANSLATED"] c:\inetpub\wwwroot\test.php
_ENV["ORIG_PATH_INFO"] /test.php
_ENV["ORIG_SCRIPT_NAME"] /test.php
_ENV["SCRIPT_FILENAME"] c:\inetpub\wwwroot\test.php

[Threepwood]

non mi pare di vedere nulla che parli di mysql in questo PHP_info... mi sa che il problema sta proprio nell'installazione o di PHP o di mysql..

ti conviene togliere tutto e rifare da zero