first congratulations for that cool programm, it has a very nicely graphical surface.
But my problem is the function db_query in the mysql.inc file. When I open the page with a browser, an errormessage 'Access denied for user: '@localhost' to database 'noderunner'' appears.
in the etc/nr.inc I defined both the $db and $dbuser as "noderunner" and with the phpMyAdmin i created the database and the user on my mysql on the localhost.
I use a Suse Linux 7.3 with php4.0.6 and mysql Ver 11.15 Distrib 3.23.41, for suse-linux (i686)
What could be wrong, why is the user-field in the errormessage above empty?
thanks,
Andreas
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It looks as if the "connect.php" file cannot access the variables from the nr.inc file. Check the connect.php file (under html dir) to make sure the $etcdir is pointing to the right place, AND that it has access to read the nr.inc file.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
the $etcdir = "../etc" which is correct and the program runs throught the nr.inc file. The variables from there are always accessable, as they are set to global in nr.inc.
The error happens in the function db_query in the file mysql.inc.
Maybe it is a version- problem. What versions of php do you use?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've been running our production box on 4.0.6, then 4.1.0RC3 (trying to troubleshoot a problem with the PHP folks), and I just upgraded to PHP 4.1.2 this morning to make sure everything works.
I wouldn't suggest running it on anything before 4.0.6 anymore, as the code is becoming increasingly dependent on 4.x.x or higher.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This may be your problem. The 'nr-mysql-setup.sql' is used to construct the tables (needed by NR) within your database.
You indicated that you are using phpMyAdmin, so you just need to go into phpMyAdmin, select the database you've created for NR, and find where it says [something like] "Run SQL query/queries on database mdotnetwork". You should be able to browse for a local file, so find the nr-mysql-setup.sql file, and click 'Go'. If the actual file is not accessible to phpMyAdmin, just cut and paste the whole .sql file into the textbox, and run that.
Once that is done, try it again, and let me know if you continue to have problems.
P.S. Perhaps I should expand the documentation for the next version..?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
everythig is working now after I ran the nr-mysql-setup.sql in the phpMyAdmin form.
But I recognized an false (?) entry in the /html/connect.php file on line 9. The
require ("etc/mysql.inc");
should be
require ("$etcdir/mysql.inc");
It would be good if you expand the docu for beginners like me.
Thank you,
Andreas
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
first congratulations for that cool programm, it has a very nicely graphical surface.
But my problem is the function db_query in the mysql.inc file. When I open the page with a browser, an errormessage 'Access denied for user: '@localhost' to database 'noderunner'' appears.
in the etc/nr.inc I defined both the $db and $dbuser as "noderunner" and with the phpMyAdmin i created the database and the user on my mysql on the localhost.
I use a Suse Linux 7.3 with php4.0.6 and mysql Ver 11.15 Distrib 3.23.41, for suse-linux (i686)
What could be wrong, why is the user-field in the errormessage above empty?
thanks,
Andreas
It looks as if the "connect.php" file cannot access the variables from the nr.inc file. Check the connect.php file (under html dir) to make sure the $etcdir is pointing to the right place, AND that it has access to read the nr.inc file.
the $etcdir = "../etc" which is correct and the program runs throught the nr.inc file. The variables from there are always accessable, as they are set to global in nr.inc.
The error happens in the function db_query in the file mysql.inc.
Maybe it is a version- problem. What versions of php do you use?
I've been running our production box on 4.0.6, then 4.1.0RC3 (trying to troubleshoot a problem with the PHP folks), and I just upgraded to PHP 4.1.2 this morning to make sure everything works.
I wouldn't suggest running it on anything before 4.0.6 anymore, as the code is becoming increasingly dependent on 4.x.x or higher.
another question: what is the nr-mysql-setup.sql file and do I have to run it by myself? If yes then what is the command for it?
This may be your problem. The 'nr-mysql-setup.sql' is used to construct the tables (needed by NR) within your database.
You indicated that you are using phpMyAdmin, so you just need to go into phpMyAdmin, select the database you've created for NR, and find where it says [something like] "Run SQL query/queries on database mdotnetwork". You should be able to browse for a local file, so find the nr-mysql-setup.sql file, and click 'Go'. If the actual file is not accessible to phpMyAdmin, just cut and paste the whole .sql file into the textbox, and run that.
Once that is done, try it again, and let me know if you continue to have problems.
P.S. Perhaps I should expand the documentation for the next version..?
everythig is working now after I ran the nr-mysql-setup.sql in the phpMyAdmin form.
But I recognized an false (?) entry in the /html/connect.php file on line 9. The
require ("etc/mysql.inc");
should be
require ("$etcdir/mysql.inc");
It would be good if you expand the docu for beginners like me.
Thank you,
Andreas
Glad to hear it's working now.
I'll make sure the 'connect.php' is fixed in the next release...thanks for the info.