(solved sort of)Problems with upgrade 1.5.2 - 1.5.3

[inode]

First post: Hi all.

I'm using PHP 5.2.6. mysql -V reports mysql  Ver 14.12 Distrib 5.0.51a, for portbld-freebsd6.2 (i386) using  5.0. phpinfo() doesn't report the actual version of apache I'm sorry to say. This is a shared server environment.

I was running 1.5.2 on 2 different hosts (different companies). I upgraded both by untarring the full-diff file, copying new files over the top of the old. On one server, I cannot log in to the admin control panel. It is not a userid/password problem. In fact if I deliberately put in a wrong password it is reported as an error. With the correct password I am simply loop back to the login page. I have checked the following and these are all set at my end.
   1.  Cookies must be enabled in your browser
   2. Javascript must be enabled in your browser
   3. Popup windows must be allowed for the following address:

I have found that by setting permissions on config.php (on this site only) to 440, then I get the following message in the browser when accessing site or admin page.

Database Connection Failed
Error: Can't connect to local MySQL server through socket '/var/db/mysql/mysql.sock' (2) (2002)
Function Performed: CONNECT
Host/DB: localhost/cms
Database Type: mysql

Prior to the upgrade the permissions on config.php were 440. I also noted on the server that /var/db/mysql does not exist. By setting permissions back 444, (userid/group is auscadmn/auscadmn), I can see the site again and the admin login page. Of course I still can't log in.

Site 2 works perfectly fine.

Any ideas would be very welcome.

Patrick

[inode]

Here is most of the contents of phpinfo(). I've snipped module details out because of word wrap and it exceeded 20k characters.

Code: Select all

PHP Version 5.2.6

System 	FreeBSD bsd15.qnetau.com 6.2-RELEASE-p11 FreeBSD 6.2-RELEASE-p11 #0: Wed Apr 9 06:27:18 UTC 2008 
Build Date 	Jun 26 2008 15:41:31
Configure Command 	'./configure'
Server API 	Apache
Virtual Directory Support 	disabled
Configuration File (php.ini) Path 	/hsphere/local/config/httpd/php5
Loaded Configuration File 	/hsphere/local/config/httpd/php5/php.ini
Scan this dir for additional .ini files 	/hsphere/local/config/httpd/php5/php.d
additional .ini files parsed 	<snip>

PHP API 	20041225
PHP Extension 	20060613
Zend Extension 	220060519
Debug Build 	no
Thread Safety 	disabled
Zend Memory Manager 	enabled
IPv6 Support 	enabled
Registered PHP Streams 	php, file, data, compress.bzip2, compress.zlib, https, ftps, tftp, ftp, telnet, dict, ldap, http
Registered Stream Socket Transports 	tcp, udp, unix, udg, ssl, sslv3, sslv2, tls
Registered Stream Filters 	string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, bzip2.*, zlib.*, convert.iconv.*

Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
    with the ionCube PHP Loader v3.1.32, Copyright (c) 2002-2007, by ionCube Ltd., and
    with Zend Extension Manager v1.2.2, Copyright (c) 2003-2007, by Zend Technologies
    with Zend Optimizer v3.3.0, Copyright (c) 1998-2007, by Zend Technologies

PHP Credits
Configuration
PHP Core
Directive	Local Value	Master Value
allow_call_time_pass_reference	Off	Off
allow_url_fopen	On	On
allow_url_include	Off	Off
always_populate_raw_post_data	On	On
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	Off	Off
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	/hsphere/local/var/httpd/logs/php_error.log	/hsphere/local/var/httpd/logs/php_error.log
error_prepend_string	no value	no value
error_reporting	6135	6135
expose_php	On	On
extension_dir	/hsphere/shared/apache/libexec/php5ext/	/hsphere/shared/apache/libexec/php5ext/
file_uploads	On	On
highlight.bg	#FFFFFF	#FFFFFF
highlight.comment	#FF9900	#FF9900
highlight.default	#0000BB	#0000BB
highlight.html	#000000	#000000
highlight.keyword	#007700	#007700
highlight.string	#DD0000	#DD0000
html_errors	Off	Off
ignore_repeated_errors	Off	Off
ignore_repeated_source	Off	Off
ignore_user_abort	Off	Off
implicit_flush	Off	Off
include_path	.:/hsphere/shared/apache/libexec/php5ext/php/	.:/hsphere/shared/apache/libexec/php5ext/php/
log_errors	On	On
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_nesting_level	64	64
max_input_time	60	60
memory_limit	48M	48M
open_basedir	/hsphere/local/home/auscadmn:/usr:/tmp:/var/tmp:/hsphere/shared/apache/libexec/php5ext	no value
output_buffering	4096	4096
output_handler	no value	no value
post_max_size	8M	8M
precision	14	14
realpath_cache_size	16K	16K
realpath_cache_ttl	120	120
register_argc_argv	On	On
register_globals	Off	On
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	On	On
safe_mode_include_dir	no value	no value
sendmail_from	no value	no value
sendmail_path	/usr/sbin/sendmail -t -i	/usr/sbin/sendmail -t -i
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	10M	2M
upload_tmp_dir	no value	no value
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

apache
APACHE_INCLUDE 	no value
APACHE_TARGET 	no value
Apache Version 	Apache
Apache Release 	10339100
Apache API Version 	19990320
Hostname:Port 	ausc.com.au:80
User/Group 	httpd(100)/1001
Max Requests 	Per Child: 500 - Keep Alive: on - Max Per Connection: 100
Timeouts 	Connection: 300 - Keep-Alive: 15
Server Root 	/hsphere/shared/apache
Loaded Modules 	

Directive	Local Value	Master Value
child_terminate	0	0
engine	1	1
last_modified	0	0
xbithack	0	0

Apache Environment
Variable	Value
DOCUMENT_ROOT 	/hsphere/local/home/auscadmn/ausc.com.au
HTTP_ACCEPT 	text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_CHARSET 	ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING 	gzip,deflate
HTTP_ACCEPT_LANGUAGE 	en-gb,en;q=0.5
HTTP_CONNECTION 	keep-alive
HTTP_COOKIE 	MOODLEID_<snip>
HTTP_HOST 	www.ausc.com.au
HTTP_KEEP_ALIVE 	300
HTTP_USER_AGENT 	Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.9.0.6) Gecko/2009012700 SUSE/3.0.6-0.1 Firefox/3.0.6
PATH 	<snip>
REMOTE_ADDR 	121.45.200.231
REMOTE_PORT 	21085
SCRIPT_FILENAME 	/hsphere/local/home/auscadmn/ausc.com.au/phpinfo.php
SERVER_ADDR 	202.146.214.110
SERVER_ADMIN 	webmaster@ausc.com.au
SERVER_NAME 	www.ausc.com.au
SERVER_PORT 	80
SERVER_SIGNATURE 	no value
SERVER_SOFTWARE 	Apache
GATEWAY_INTERFACE 	CGI/1.1
SERVER_PROTOCOL 	HTTP/1.1
REQUEST_METHOD 	GET
QUERY_STRING 	no value
REQUEST_URI 	/phpinfo.php
SCRIPT_NAME 	/phpinfo.php

HTTP Headers Information
HTTP Request Headers
HTTP Request 	GET /phpinfo.php HTTP/1.1
Accept 	text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Charset 	ISO-8859-1,utf-8;q=0.7,*;q=0.7
Accept-Encoding 	gzip,deflate
Accept-Language 	en-gb,en;q=0.5
Connection 	keep-alive
Cookie 	<snip>
Host 	www.ausc.com.au
Keep-Alive 	300
User-Agent 	Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.9.0.6) Gecko/2009012700 SUSE/3.0.6-0.1 Firefox/3.0.6
HTTP Response Headers
X-Powered-By 	PHP/5.2.6
Keep-Alive 	timeout=15, max=100
Connection 	Keep-Alive
Transfer-Encoding 	chunked
Content-Type 	text/html

cURL support 	enabled
cURL Information 	libcurl/7.15.3 OpenSSL/0.9.7e zlib/1.2.3

date
date/time support 	enabled
"Olson" Timezone Database Version 	2008.2
Timezone Database 	internal
Default timezone 	UTC

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

fileinfo
fileinfo support	enabled


gd
GD Support 	enabled
GD Version 	bundled (2.0.34 compatible)
FreeType Support 	enabled
FreeType Linkage 	with freetype
FreeType Version 	2.2.1
GIF Read Support 	enabled
GIF Create Support 	enabled
JPG Support 	enabled
PNG Support 	enabled
WBMP Support 	enabled
XBM Support 	enabled

mysql
MySQL Support	enabled
Active Persistent Links 	0
Active Links 	0
Client API version 	5.0.45
MYSQL_MODULE_TYPE 	external
MYSQL_SOCKET 	/var/db/mysql/mysql.sock
MYSQL_INCLUDE 	-I/usr/local/include/mysql
MYSQL_LIBS 	-L/usr/local/lib/mysql -lmysqlclient

Directive	Local Value	Master Value
mysql.allow_persistent	Off	Off
mysql.connect_timeout	60	60
mysql.default_host	localhost	localhost
mysql.default_password	no value	no value
mysql.default_port	3306	3306
mysql.default_socket	/var/db/mysql/mysql.sock	/var/db/mysql/mysql.sock
mysql.default_user	no value	no value
mysql.max_links	Unlimited	Unlimited
mysql.max_persistent	Unlimited	Unlimited
mysql.trace_mode	Off	Off

mysqli
MysqlI Support	enabled
Client API library version 	5.0.45
Client API header version 	5.0.45
MYSQLI_SOCKET 	/var/db/mysql/mysql.sock

Directive	Local Value	Master Value
mysqli.default_host	localhost	localhost
mysqli.default_port	3306	3306
mysqli.default_pw	no value	no value
mysqli.default_socket	/var/db/mysql/mysql.sock	/var/db/mysql/mysql.sock
mysqli.default_user	no value	no value
mysqli.max_links	Unlimited	Unlimited
mysqli.reconnect	Off	Off


tokenizer
Tokenizer Support 	enabled

Zend Optimizer
Optimization Pass 1 	enabled
Optimization Pass 2 	enabled
Optimization Pass 3 	enabled
Optimization Pass 4 	enabled
Optimization Pass 9 	enabled
Zend Loader 	enabled
License Path 	no value
Obfuscation level 	3

Environment
Variable	Value
USER 	root
HOME 	/root
LOGNAME 	root
PATH 	
SHELL 	/bin/sh

PHP Variables
Variable	Value
_REQUEST["MOODLEID_"]	%ED%C3%1CC%B7d
_REQUEST["CMSSESSIDdc6010c2"]	lsd8026a81fnunj1rm0gncd6j5
_REQUEST["MoodleSession"]	62gn47i911vl261m3srdrl7ng6
_REQUEST["MoodleSessionTest"]	rSqCYwFrBN
_COOKIE["MOODLEID_"]	%ED%C3%1CC%B7d
_COOKIE["CMSSESSIDdc6010c2"]	lsd8026a81fnunj1rm0gncd6j5
_COOKIE["MoodleSession"]	62gn47i911vl261m3srdrl7ng6
_COOKIE["MoodleSessionTest"]	rSqCYwFrBN
_SERVER["DOCUMENT_ROOT"]	/hsphere/local/home/auscadmn/ausc.com.au
_SERVER["HTTP_ACCEPT"]	text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
_SERVER["HTTP_ACCEPT_CHARSET"]	ISO-8859-1,utf-8;q=0.7,*;q=0.7
_SERVER["HTTP_ACCEPT_ENCODING"]	gzip,deflate
_SERVER["HTTP_ACCEPT_LANGUAGE"]	en-gb,en;q=0.5
_SERVER["HTTP_CONNECTION"]	keep-alive
_SERVER["HTTP_COOKIE"]	
_SERVER["HTTP_HOST"]	www.ausc.com.au
_SERVER["HTTP_KEEP_ALIVE"]	300
_SERVER["HTTP_USER_AGENT"]	Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.9.0.6) Gecko/2009012700 SUSE/3.0.6-0.1 Firefox/3.0.6
_SERVER["PATH"]	
_SERVER["REMOTE_ADDR"]	121.45.200.231
_SERVER["REMOTE_PORT"]	21085
_SERVER["SCRIPT_FILENAME"]	/hsphere/local/home/auscadmn/ausc.com.au/phpinfo.php
_SERVER["SERVER_ADDR"]	202.146.214.110
_SERVER["SERVER_ADMIN"]	webmaster@ausc.com.au
_SERVER["SERVER_NAME"]	www.ausc.com.au
_SERVER["SERVER_PORT"]	80
_SERVER["SERVER_SIGNATURE"]	no value
_SERVER["SERVER_SOFTWARE"]	Apache
_SERVER["GATEWAY_INTERFACE"]	CGI/1.1
_SERVER["SERVER_PROTOCOL"]	HTTP/1.1
_SERVER["REQUEST_METHOD"]	GET
_SERVER["QUERY_STRING"]	no value
_SERVER["REQUEST_URI"]	/phpinfo.php
_SERVER["SCRIPT_NAME"]	/phpinfo.php
_SERVER["PATH_TRANSLATED"]	/hsphere/local/home/auscadmn/ausc.com.au/phpinfo.php
_SERVER["PHP_SELF"]	/phpinfo.php
_SERVER["REQUEST_TIME"]	1236900434
_SERVER["argv"]	

Array()

_SERVER["argc"]	0
_ENV["USER"]	root
_ENV["HOME"]	/root
_ENV["LOGNAME"]	root
_ENV["PATH"]	/hsphere/shared/bin:/hsphere/shared/sbin:/hsphere/local/var/vpopmail/bin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin:/bin
_ENV["SHELL"]	/bin/sh

[inode]

Contents of config.php. I've not manually changed anything, so this is pretty much 'out of the box'. If anyone can help .... please. I want to start template and content changes soon as this company is going live early April.

Code: Select all

<?php

$config['php_memory_limit'] = '';


$config['process_whole_template'] = true;


$config['debug'] = false;


$config['output_compression'] = false;


$config['dbms'] = 'mysqli';
$config['db_hostname'] = 'mysqlxx.quadrahosting.com.au';
$config['db_username'] = 'ausc_admn';
$config['db_password'] = '*****';
$config['db_name'] = 'ausc_csm';


$config['db_prefix'] = '';


$config['persistent_db_conn'] = false;


$config['use_adodb_lite'] = true;


$config['root_url'] = 'http://www.ausc.com.au';
if(isset($_SERVER['HTTPS']) && $_SERVER['HTTPS']=='on')
{
$config['root_url'] = str_replace('http','https',$config['root_url']);
}


$config['root_path'] = '/hsphere/local/home/ausc/ausc.com.au';


$config['admin_dir'] = 'admin';


$config['previews_path'] = '/hsphere/local/home/ausc/ausc.com.au/tmp/cache';


$config['uploads_path'] = '/hsphere/local/home/ausc/ausc.com.au/uploads';


$config['uploads_url'] = $config['root_url'] . '/uploads';



$config['max_upload_size'] = 10000000;


$config['default_upload_permission'] = '664';


$config['use_smarty_php_tags'] = false;


$config['auto_alias_content'] = true;


$config['assume_mod_rewrite'] = false;


$config['page_extension'] = '';


$config['internal_pretty_urls'] = false;


$config['use_hierarchy'] = false;


$config['query_var'] = 'page';


$config['image_manipulation_prog'] = 'GD';
$config['image_transform_lib_path'] = '/usr/bin/ImageMagick/';

$config['image_uploads_path'] = '/hsphere/local/home/ausc/ausc.com.au/uploads/images';
$config['image_uploads_url'] = $config['root_url'] . '/uploads/images'; 

$config['locale'] = '';

$config['default_encoding'] = '';
$config['admin_encoding'] = 'utf-8';

$config['old_stylesheet'] = false;

$config['wiki_url'] = 'http://wiki.cmsmadesimple.org/index.php/User_Handbook/Admin_Panel';

$config['backwards_compatible'] = false;

$config['disable_htmlarea_translation'] = false;
$config['use_Indite'] = true;
?>

[alby]

$config['dbms'] = 'mysqli';
$config['db_hostname'] = 'mysqlxx.quadrahosting.com.au';

Database Connection Failed
Error: Can't connect to local MySQL server through socket '/var/db/mysql/mysql.sock' (2) (2002)
Function Performed: CONNECT
Host/DB: localhost/cms
Database Type: mysql

In a first config you have mysql driver and localhost, in second mysqli and un mysql server host .....
you have something of strange in configuration ....

Alby

[inode]

Thanks for replying Alby. I didn't notice that difference in the error message. I guess is should read Host/DB mysqlxx...... /ausc_csm. The only change I make to reproduce the error is to remove read permission to "others" from config.php. Before the upgrade, 'others" did not have read permission, now they need it for the site to work.

The other and main part of my problem is I can no longer log in to the admin control panel. As I mentioned, it loops back to the login page. The config.php file has not modified since I first installed 1.5.1 and it has been upgraded to 1.5.2 then 1.5.3 (which has problems).

As a last resort, I will try to reinstall using 1.5.3 and see if I get the same problem but I'd like to avoid this.

[inode]

In the 1.5.3 package, there are 2 files in /install/schema, initial.sql and extra.sql. There are no instructions in upgrade.txt to suggest these files should be run against the database. Should they?

regards

[alby]

In the 1.5.3 package, there are 2 files in /install/schema, initial.sql and extra.sql. There are no instructions in upgrade.txt to suggest these files should be run against the database. Should they?

Are necessary for new installation.
For 1.5.3 (from 1.5.2) there is not db update

Alby

[inode]

I gave up trying to fix this, so I reinstalled. Interestingly, the line in config.php, $config['dbms'] = 'mysqli'; now reads
$config['dbms'] = 'mysql'; I wonder why the difference. To test if I could recreate the problem I changed mysql to mysqli and refreshed the browser but no difference (I'm sort of sorry to say).

So the web site and the admin pages now work. So I guess this is solved but I would have liked a root cause.

cheers and thanks for the help alby.