Installed myDBR on my windows 2003 server. Went through the installation process and all was OK until I submit the DB server/credentials. When I submit the information, I get a blank screen and nothing happens. Thought that this might be a problem saving to the cfg file so I manually input the information but that still didn't work. Any ideas.
Larry McDowell
windows 2003 IIS 6.0
PHP 5.1.4
MYSQL 5.0.21
There are few things you might want to check out first:
1) File permissions. Check that web server is able to read all files in myDBR-directory and it's subdirectories
2) Web server log. See if you have any messages there.
3) Try out the database test connection script found at mydbr/user/trobleshoot/mysql.php (edit the file to enter your credentials).
--
myDBR Team
I ran the connection script and got this as a result.
"mysqli is not installed in php"
Is this an extension that I need to install?
I enabled the mysqli extenstion and got to the point where I'm told I need to create objects in the db. I tell the installation program to create objects and then I'm at the blank screen again.
The mysqli-extension allows PHP to talk to MySQL database. You do need that installed.
Check if any objects is created in the database. The blank screen may indicate that the server is timing out for some reason. What are the credentials you are using to create the objects?
--
myDBR Team
I enabled mysquli but was still unable to create the objects via the install program. I then created the objects via the command line as suggested in the installation steps. The mydbr objects were created successfully without error.
But, I now get this error:
Fatal error: Call to undefined function mysqli_set_charset() in E:\www\helpdesk.ppboces.org\mydbr\lib\db_utils.php on line 53
HI,
looks like that your mysqli is not active or is somehow broken. mysqli_set_charset is part of the mysqli-extension and your PHP install did not see one. myDBR does check that the needed extensions are installed, but something in your system makes it think otherwise.
You did restart your web server after enabling the mysqli-extension?
Please use the mydbr/user/trobleshoot/mysql.php script to see that your connection is good.
--
myDBR Team
I used the mysql.php script in the troubleshooting directory and it tested out fine. no errors. I did restart my web server after enabling the mysqli-extension.
Larry
The mysqli extension is not active because before I loaded the extension, I was unable to have a successful test and proceed on the installation. It seems to me that this particular error has happened to other people in the php 5.x release/beta. Do I need a newer version of PHP for this to work. What are the minimum requirements?
Your mysqli extension might be too old. Check the version by accessing a PHP-file containing:
<?php phpinfo(); ?>
Look for mysqli section and Client API library version. In Windows you need MySQL client library version 4.1.11 or newer.
Updating your PHP should bring you newer versions.
--
myDBR Team
I moved the installation of mydbr to a server with an updated version of php and the installation was successful. So the problem was the version of PHP I had. I then try to login to mydbr using the dbr username and password and I got the following error and I wasn't able to login.
Undefined index: challenge in C:\Inetpub\report\apps_v\login_v.php on line 72
Any ideas on what might cause that?
Thank you
Looks like you might have problems with sessions. Check if you have any errors in PHP's error log.
The missing session variable is part of challenge-response authentication protocol which myDBR uses in login.
--
myDBR
Here is what the error log said: same error as stated above.
[19-Feb-2010 15:37:47] PHP Notice: Undefined index: challenge in C:\Inetpub\report\apps_v\login_v.php on line 72
I have a sessions folder created and I see that mydbr is creating files in that folder when I try to login.
Your session is now lost for some reason.
What is the URL you are using to access myDBR? The base of the URL is stored in a cookie, so also please check that you do have cookies enabled.
--
myDBR Team
Cookies are enabled and the URL is just the IP address(local/internal). That should work too or does it need a DNS name?
IP address is just fine.
The reason for asking for the URL is that your symptom points to the fact that myDBR's cookie is not written or is written incorrectly. Same behavior can be seen if cookies are disabled. The challenge-variable's session's id is stored in the cookie. In your case this is not happening, therefore the error message.
What is the path used in myDBR's cookie (mydbr-id)? Does that match your URL?
--
myDBR Team
The path used for the cookies is just c:\temp. We are referring to the php.ini, correct? The session file created has a prefix of "sess_" and the rest seems like random characters. Example below:
sess_n8vbkr50dgpud9oue195akokq0
When you say cookies enabled, you meant on the browser? I'm thinking that was it because once I switched to a different browser to test, I was able to login. Thanks for the help.
Worked in camino and safari but not firefox.
Simply enable the cookies in Firefox to use myDBR. Disabling the cookies seldom gives any good results.
In Firefox, you'll find the cookie setting in Preferences->Privacy.
--
myDBR Team
You must log in to post.