From: Lee J. <lee...@jo...> - 2005-06-18 03:42:31
|
I have just installed the phpESP 1.7.5-rc1 under PHP Version 4.3.2, and about 50% of the time when I click on a link or button I get the following error: HTTP 503 Service Unavailable [ Connection to database failed. Please check configuration. ] [ 1045: Access denied for user: 'phpesp@localhost' (Using password: YES) ] If I then start hitting the browser's refresh button, I will usually be taken the the page I was trying to go to. Sometimes I have to hit refresh up for times before I will move past the 503 error. This is a new Red Hat system, so maybe I don't have things quite configured correctly, but the thing that gets me is the intermittent nature of this problem. FWIW, I have phpmyadmin installed and it is working properly. Below is the DEBUG info with some sensitive info replaced by comments in curly {braces} : Thanks for your help. Lee Joramo --DEBUG info-- SID 5567274f75c62abc80cd4d0527a1d918 SESSION acl|a:9:{s:8:"username";s:4:"root";s:9:"superuser";s:1:"Y";s: 4:"home";s:4:"/tmp";s:7:"pdesign";a:1:{i:0;s:9:"superuser";}s: 7:"pstatus";a:1:{i:0;s:9:"superuser";}s:5:"pdata";a:1:{i:0;s: 9:"superuser";}s:4:"pall";a:1:{i:0;s:9:"superuser";}s:6:"pgroup";a:1: {i:0;s:9:"superuser";}s:5:"puser";a:1:{i:0;s: 9:"superuser";}}username|s:4:"root";raw_password|s:3:"esp"; ACL username root superuser Y home /tmp pdesign [ superuser ] pstatus [ superuser ] pdata [ superuser ] pall [ superuser ] pgroup [ superuser ] puser [ superuser ] HTTP_SESSION_VARS acl [ root Y /tmp Array Array Array Array Array Array ] username root raw_password {password} ESPCONFIG proto http:// base_url http://{domain.name}/phpESP/ image_url http://{domain.name}/phpESP/images/ autopub_url http://{domain.name}/phpESP/public/survey.php css_url http://{domain.name}/phpESP/public/css/ js_url http://{domain.name}/phpESP/js/ db_host localhost db_user phpesp db_pass {db.password} db_name phpesp adodb_path /var/www/{domain.name}/html/phpESP/admin/include/lib/adodb/ adodb_database_type mysql adodb_dbpersist true adodb_pathto_db /var/www/{domain.name}/html/phpesp/scripts/db/esp.dbm allow_email 1 human_email 1 auth_design 1 auth_response 1 auth_type default ldap_server ldap://example.com ldap_port 389 ldap_dn dc=example,dc=com ldap_filter uid= signup_realm auto default_lang en_US charset ISO-8859-1 default_num_choices 10 main_bgcolor #FFFFFF link_color #0000CC vlink_color #0000CC alink_color #0000CC table_bgcolor #0099FF active_bgcolor #FFFFFF dim_bgcolor #3399CC error_color #FF0000 warn_color #FF0000 reqd_color #FF0000 bgalt_color1 #FFFFFF bgalt_color2 #EEEEEE DEBUG 1 name phpESP version 1.7.5-rc1 extension .inc auth_mode form handler /var/www/{domain.name}/html/phpESP//public/handler.php handler_prefix /var/www/{domain.name}/html/phpESP//public/handler- prefix.php tabs [ general questions preview order finish ] ME /phpESP/admin/manage.php style_sheet gettext 1 title phpESP, v1.7.5-rc1 include_path /var/www/{domain.name}/html/phpESP//admin/include/ css_path /var/www/{domain.name}/html/phpESP//public/css/ locale_path /var/www/{domain.name}/html/phpESP//locale/ unsupported [ cgi sapi ] access_table access designer_table designer question_table question question_choice_table question_choice question_type_table question_type realm_table realm respondent_table respondent response_table response response_bool_table response_bool response_date_table response_date response_multiple_table response_multiple response_other_table response_other response_rank_table response_rank response_single_table response_single response_text_table response_text survey_table survey lang en_US thank_head Thank You For Completing This Survey. thank_body Please do not use the back button on your browser to go back. Please click on the link below to return you to where you launched this survey. DEBUG_MERGE 1 DEBUG_RESULTS 1 adodb_conn HTTP_GET_VARS where manage HTTP_POST_VARS HTTP_SERVER_VARS UNIQUE_ID f4zzL0gD9YcAAEziKasAAAAI HTTP_HOST {domain.name} HTTP_USER_AGENT Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.7.5) Gecko/20041107 Firefox/1.0 HTTP_ACCEPT text/xml,application/xml,application/xhtml+xml,text/html; q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5 HTTP_ACCEPT_LANGUAGE en-us,en;q=0.5 HTTP_ACCEPT_ENCODING gzip,deflate HTTP_ACCEPT_CHARSET ISO-8859-1,utf-8;q=0.7,*;q=0.7 HTTP_KEEP_ALIVE 300 HTTP_CONNECTION keep-alive HTTP_REFERER http://{domain.name}/phpESP/admin/manage.php? where=results&test=1&sid=1 HTTP_COOKIE PHPSESSID=5567274f75c62abc80cd4d0527a1d918 PATH /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin: /usr/X11R6/bin:/home/{system.user.name}/bin SERVER_SIGNATURE <address>Apache/2.0.46 (Red Hat) Server at {domain.name} Port 80</address> SERVER_SOFTWARE Apache/2.0.46 (Red Hat) SERVER_NAME {domain.name} SERVER_ADDR {server.ip.address} SERVER_PORT 80 REMOTE_ADDR {remote.ip.address} DOCUMENT_ROOT /var/www/{domain.name}/html SERVER_ADMIN {email.address} SCRIPT_FILENAME /var/www/{domain.name}/html/phpESP/admin/manage.php REMOTE_PORT 50128 GATEWAY_INTERFACE CGI/1.1 SERVER_PROTOCOL HTTP/1.1 REQUEST_METHOD GET QUERY_STRING where=manage REQUEST_URI /phpESP/admin/manage.php?where=manage SCRIPT_NAME /phpESP/admin/manage.php PHP_SELF /phpESP/admin/manage.php PATH_TRANSLATED /var/www/{domain.name}/html/phpESP/admin/manage.php argv [ where=manage ] argc 1 HTTP_ENV_VARS HOSTNAME {host.name} TERM xterm-color SHELL /bin/bash HISTSIZE 1000 SSH_CLIENT {ip.addresses} SSH_TTY /dev/pts/0 USER {system.user.name} LS_COLORS no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01: cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32: *.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32: *.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01; 31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31: *.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01; 35:*.xpm=01;35:*.png=01;35:*.tif=01;35: MAIL /var/spool/mail/{system.user.name} PATH /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin: /usr/X11R6/bin:/home/{system.user.name}/bin INPUTRC /etc/inputrc PWD /etc/httpd/conf.sites LANG en_US.UTF-8 SHLVL 3 HOME /root LOGNAME {system.user.name} SSH_CONNECTION {ip.addresses} LESSOPEN |/usr/bin/lesspipe.sh %s G_BROKEN_FILENAMES 1 _ /usr/sbin/httpd |