This topic is locked
[SOLVED]

 Warning: mysql_connect(): It is not safe to rely on the system's t

8/10/2011 3:02:35 AM
PHPRunner General questions
ffrinai author

php 5.3 build 7474
At the first execution of the project with connection to a server(linux) with mysql 4.1 existing schema I obtain:
Warning: mysql_connect(): It is not safe to rely on the system's timezone settings. You are required to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Paris' for '2.0/DST' instead in C:\progetti phprunner\fftest2\output\include\dbconnection.php on line 9 Warning: mysql_connect(): OK packet 6 bytes shorter than expected in C:\progetti phprunner\fftest2\output\include\dbconnection.php on line 9 Warning: mysql_connect(): It is not safe to rely on the system's timezone settings. You are required to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Paris' for '2.0/DST' instead in C:\progetti phprunner\fftest2\output\include\dbconnection.php on line 9 Warning: mysql_connect(): mysqlnd cannot connect to MySQL 4.1+ using old authentication in C:\progetti phprunner\fftest2\output\include\dbconnection.php on line 9 Warning: trigger_error(): It is not safe to rely on the system's timezone settings. You are required to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Paris' for '2.0/DST' instead in C:\progetti phprunner\fftest2\output\include\dbconnection.php on line 12 Fatal error: mysqlnd cannot connect to MySQL 4.1+ using old authentication in C:\progetti phprunner\fftest2\output\include\dbconnection.php on line 12
can someone help me ?

Thanks.

Fabio

Sergey Kornilov admin 8/10/2011

Google says you need to set timezone in php.ini file:
[Date]

date.timezone = "The appropriate time zone"
Find the list of available timezones at http://us2.php.net/manual/en/timezones.php

ffrinai author 8/11/2011



Google says you need to set timezone in php.ini file:
[Date]

date.timezone = "The appropriate time zone"
Find the list of available timezones at http://us2.php.net/manual/en/timezones.php


date.timezone [SOLVED], thanks
for the other problem:
Warning: mysql_connect(): OK packet 6 bytes shorter than expected in C:\progetti phprunner\fftest2\output\include\dbconnection.php on line 9 Warning: mysql_connect(): mysqlnd cannot connect to MySQL 4.1+ using old authentication in C:\progetti phprunner\fftest2\output\include\dbconnection.php on line 9 Fatal error: mysqlnd cannot connect to MySQL 4.1+ using old authentication in C:\progetti phprunner\fftest2\output\include\dbconnection.php on line 12
I suppose to update the MySql version in the Data Server !?

Sergey Kornilov admin 8/11/2011

Yes, I guess you need to update MySQL version on the server or update password.
See the first answer at http://stackoverflow.com/questions/1340488/mysql-php-incompatibility