New installation problem

39 views
Skip to first unread message

Jeannie

unread,
Jun 13, 2011, 6:32:04 PM6/13/11
to libstats
Hi. I posted this to the code.google.com/p/issues list 5 days ago.
Maybe I should have posted it here. I really need help. Here's what I
posted:

I have a hosted server, so don't have access to Apache files. But
other than that, I think I've followed the steps in the installation
guide (added "$pear_include_path" editing and admin info in init.php).
I can't get past the "I messed up and I'm sorry" page. I do get a
"refDB error" email each time the page is accessed. The rest of this
description is the text of the email. Please help.

Dump of REQUEST:
array(4) {
["__utma"]=>
string(54) "10723881.1769306528.1307120097.1307120097.1307122565.2"
["__utmz"]=>
string(69) "10723881.1307120097.1.1.utmcsr=(direct)|utmccn=(direct)|
utmcmd=(none)"
["PHPSESSID"]=>
string(26) "k0888vr72b8hsks68mhj5k26p3"
["db"]=>
object(DB_Error)#2 (8) {
["error_message_prefix"]=>
string(0) ""
["mode"]=>
int(1)
["level"]=>
int(1024)
["code"]=>
int(-24)
["message"]=>
string(24) "DB Error: connect failed"
["userinfo"]=>
string(127) " [nativecode=Access denied for user
'jcolson'@'localhost' (using password: YES)] ** mysql://jcolson:Lee_Admin@localhost/libstat"
["backtrace"]=>
array(7) {
[0]=>
array(6) {
["file"]=>
string(46) "/home2/leeedu/DB-1.7.14RC2/DB-1.7.14RC2/DB.php"
["line"]=>
int(966)
["function"]=>
string(10) "PEAR_Error"
["class"]=>
string(10) "PEAR_Error"
["type"]=>
string(2) "->"
["args"]=>
array(5) {
[0]=>
string(24) "DB Error: connect failed"
[1]=>
int(-24)
[2]=>
int(1)
[3]=>
int(1024)
[4]=>
string(80) " [nativecode=Access denied for user
'jcolson'@'localhost' (using password: YES)]"
}
}
[1]=>
array(7) {
["file"]=>
string(21) "/usr/lib/php/PEAR.php"
["line"]=>
int(564)
["function"]=>
string(8) "DB_Error"
["class"]=>
string(8) "DB_Error"
["type"]=>
string(2) "->"
["object"]=>
*RECURSION*
["args"]=>
array(4) {
[0]=>
int(-24)
[1]=>
int(1)
[2]=>
int(1024)
[3]=>
string(80) " [nativecode=Access denied for user
'jcolson'@'localhost' (using password: YES)]"
}
}
[2]=>
array(7) {
["file"]=>
string(53) "/home2/leeedu/DB-1.7.14RC2/DB-1.7.14RC2/DB/
common.php"
["line"]=>
int(1908)
["function"]=>
string(10) "raiseError"
["class"]=>
string(4) "PEAR"
["type"]=>
string(2) "->"
["object"]=>
object(DB_mysql)#1 (26) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
string(5) "4.2.0"
["numrows"]=>
bool(true)
["pconnect"]=>
bool(true)
["prepare"]=>
bool(false)
["ssl"]=>
bool(false)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
bool(false)
["dsn"]=>
array(9) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["username"]=>
string(7) "jcolson"
["password"]=>
string(9) "Lee_Admin"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(7) "libstat"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(0) ""
["fetchmode"]=>
int(1)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(0) ""
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(false)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
["args"]=>
array(7) {
[0]=>
NULL
[1]=>
int(-24)
[2]=>
NULL
[3]=>
NULL
[4]=>
string(80) " [nativecode=Access denied for user
'jcolson'@'localhost' (using password: YES)]"
[5]=>
string(8) "DB_Error"
[6]=>
bool(true)
}
}
[3]=>
array(7) {
["file"]=>
string(52) "/home2/leeedu/DB-1.7.14RC2/DB-1.7.14RC2/DB/
mysql.php"
["line"]=>
int(252)
["function"]=>
string(10) "raiseError"
["class"]=>
string(9) "DB_common"
["type"]=>
string(2) "->"
["object"]=>
object(DB_mysql)#1 (26) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
string(5) "4.2.0"
["numrows"]=>
bool(true)
["pconnect"]=>
bool(true)
["prepare"]=>
bool(false)
["ssl"]=>
bool(false)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
bool(false)
["dsn"]=>
array(9) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["username"]=>
string(7) "jcolson"
["password"]=>
string(9) "Lee_Admin"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(7) "libstat"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(0) ""
["fetchmode"]=>
int(1)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(0) ""
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(false)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
["args"]=>
array(5) {
[0]=>
int(-24)
[1]=>
NULL
[2]=>
NULL
[3]=>
NULL
[4]=>
string(66) "Access denied for user
'jcolson'@'localhost' (using password: YES)"
}
}
[4]=>
array(7) {
["file"]=>
string(46) "/home2/leeedu/DB-1.7.14RC2/DB-1.7.14RC2/DB.php"
["line"]=>
int(556)
["function"]=>
string(7) "connect"
["class"]=>
string(8) "DB_mysql"
["type"]=>
string(2) "->"
["object"]=>
object(DB_mysql)#1 (26) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
string(5) "4.2.0"
["numrows"]=>
bool(true)
["pconnect"]=>
bool(true)
["prepare"]=>
bool(false)
["ssl"]=>
bool(false)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
bool(false)
["dsn"]=>
array(9) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["username"]=>
string(7) "jcolson"
["password"]=>
string(9) "Lee_Admin"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(7) "libstat"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(0) ""
["fetchmode"]=>
int(1)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(0) ""
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(false)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
["args"]=>
array(2) {
[0]=>
array(9) {
["phptype"]=>
string(5) "mysql"
["dbsyntax"]=>
string(5) "mysql"
["username"]=>
string(7) "jcolson"
["password"]=>
string(9) "Lee_Admin"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(7) "libstat"
}
[1]=>
bool(false)
}
}
[5]=>
array(6) {
["file"]=>
string(43) "/home2/leeedu/public_html/libstats/Init.php"
["line"]=>
int(209)
["function"]=>
string(7) "connect"
["class"]=>
string(2) "DB"
["type"]=>
string(2) "::"
["args"]=>
array(1) {
[0]=>
string(43) "mysql://jcolson:Lee_Admin@localhost/libstat"
}
}
[6]=>
array(4) {
["file"]=>
string(49) "/home2/leeedu/public_html/libstats/Controller.php"
["line"]=>
int(5)
["args"]=>
array(1) {
[0]=>
string(43) "/home2/leeedu/public_html/libstats/Init.php"
}
["function"]=>
string(12) "require_once"
}
}
["callback"]=>
NULL
}
}


Dump of SESSION:
array(1) {
["loggedIn"]=>
bool(false)
}


Dump of rInfo:
<br />
<b>Notice</b>: Undefined variable: rInfo in <b>/home2/leeedu/
public_html/libstats/actions/PageErrorAction.php</b> on line <b>17</
b><br /> NULL

Nate Vack

unread,
Jun 14, 2011, 8:30:22 AM6/14/11
to libstats
On Mon, Jun 13, 2011 at 5:32 PM, Jeannie <vjco...@gmail.com> wrote:

Hi Jeannie,

This error:

>    string(127) " [nativecode=Access denied for user
> 'jcolson'@'localhost' (using password: YES)] ** mysql://jcolson:Lee_Admin@localhost/libstat"

suggests pretty strongly that your database settings aren't right.
PEAR errors would look different.

Make sure your database name, username, and password are all correct.
If you can, find another way to verify the connection works in
general.

Cheers,
-Nate

Reply all
Reply to author
Forward
0 new messages