apache/php upgrade problemi

martin at amadej.si martin at amadej.si
Fri Sep 20 17:16:00 CEST 2002


Oi!

Imel sem apacha 1.3.20 z PHP-jem in celim kupom stuffa zravn (gd, ftp, mssql,
mysql,.. supporta v php-ju).
Zarad varnostnih luken v apachu sem dons hotu upgrajdat na apache 1.3.26.
Apache se z mod_sslom lepo skompila in namesti.
Prav tako brez problema (ce izpustim imap support v php-ju) se prevede tudi php.
Ko je oboje namesceno se tud lepo pozene.
Prej sem imel php 4.1.2 zdej mam 4.2.3 al kater je ze zadnji.

Problem nastane ko z skriptami za access ki so take:
"
mysql_connect("localhost","user","pass")
select_db...al kaj je ze ;-)
"
dobim napako da se ne more povezat na bazo.
Zgleda takole:
"
Warning: Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (111) in
/home .. . . /access.php on line 2

Warning: MySQL Connection Failed: Can't connect to local MySQL server through
socket '/var/run/mysql/mysql.sock' (111) in
/home/ ... /access.php on line 2

Warning: Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (111) in
/home/ .... /access.php on line 3

Warning: MySQL Connection Failed: Can't connect to local MySQL server through
socket '/var/run/mysql/mysql.sock' (111) in
/home/ .... /access.php on line 3

Warning: MySQL: A link to the server could not be established in
/home/ .... /access.php on line 3
"

ce pozenem ta starega apcaha dela spet vse OK.
Z istim mysql-om skoz prizganim.

So se spet kake nastavitve v php.ini spremenile, tko kot za register globals, al
pa kej?

klele prilagam se php.ini relevanten del:
"
cat /usr/local/lib/php.ini | grep sql
;   extension=msql.dll
;   extension=msql.so
;extension=php_fbsql.dll
;extension=php_mssql.dll
;extension=php_pgsql.dll
sql.safe_mode = Off
mysql.allow_persistent = On
mysql.max_persistent = -1
mysql.max_links = -1
; Default port number for mysql_connect().  If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
mysql.default_port =
mysql.default_socket =
; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host =
; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =
; Default password for mysql_connect() (doesn't apply in safe mode).
; *Any* user with PHP access can run 'echo
cfg_get_var("mysql.default_password")
mysql.default_password =
msql.allow_persistent = On
msql.max_persistent = -1
msql.max_links = -1
pgsql.allow_persistent = On
pgsql.max_persistent = -1
pgsql.max_links = -1
mssql.allow_persistent = On
mssql.max_persistent = -1
mssql.max_links = -1
mssql.min_error_severity = 10
mssql.min_message_severity = 10
mssql.compatability_mode = Off
;mssql.textlimit = 4096
;mssql.textsize = 4096
;mssql.batchsize = 0
;fbsql.allow_persistant = On
;fbsql.autocommit = On
;fbsql.default_database =
;fbsql.default_database_password =
;fbsql.default_host =
;fbsql.default_password =
;fbsql.default_user = "_SYSTEM"
;fbsql.generate_warnings = Off
;fbsql.max_connections = 128
;fbsql.max_links = 128
;fbsql.max_persistent = -1
;fbsql.max_results = 128
;fbsql.mbatchSize = 1000
"

Sanja se mi ne kaj bi lahko bilo narobe in ZELO vesel bi bil vsakrsnega predloga.

Hvala in lep pozdrav.

-Martin




More information about the lugos-list mailing list