I've installed workbench and can't seem to get access to the database. It goes though login.php and recognizes user admin, verifies his password but then won't give me anything more than guest privileges.
I can query the db from the command line and it all looks kosher but still no go. I installed everything as root and chmod'ed the .php files to 755. My php test tells me that php is up and running.
I'm sure it's something stupid. Any ideas?
Thanks,
Bugs12345
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, The reason you see the Guest Access page is because workbench thinks that you have not logged in, and obviously you have. Therefore after logging sessions are not being created correctly in your enviroment.
Please check your PHP configuration file (php.ini) for the following:
Session.cookie_path should be set to /
extension_dir should be set to the directory where PHP is installed. (eg c:\php or /usr/local/php)
doc_root should be set the Apache document root. (eg c:\Apache Group\Apache\htdocs or /usr/local/apache/htdocs)
session.save_path should be set to a valid directory where PHP can write session files (eg c:\winnt\temp or /tmp)
Please let me know if this does not help.
Thanks
Stuart
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2002-01-12
Stuart,
Thanks for responding...
I started with a stock RH7.2 install and my php.ini is set as you have indicated. I've upgraded php, curl and mysql to see if it was something simple.
Here is the (relevant) output from test.php. Sorry it looks so crappy but X11 cut and paste doesn't work well in this sourceforge email client...
Is there anything else I can try or read so as not to bother you...?
Mark
extension_dir /usr/lib/php4 /usr/lib/php4
doc_root /usr/local/www/html /usr/local/www/html
Session Support enabled
Directive Local Value Master Value
session.auto_start Off Off
session.cache_expire 180 180
session.cache_limiter nocache nocache
session.cookie_domain no value no value
session.cookie_lifetime 0 0
session.cookie_path / /
session.cookie_secure Off Off
session.entropy_file no value no value
session.entropy_length 0 0
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path /tmp /tmp
session.serialize_handler php php
session.use_cookies On On
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Mark, The session stuff above seems OK. Have you checked that the values of session.save_path, session.cookie_path, doc_root and extension_dir are correct?.
Please also check the configure information to see if it reads "--without-mysql" or "--with-mysql".
Thanks
Stuart
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2002-02-19
This seems to be a common theme, I'm having the same issue here.
I am running PHP on a Win 2000 Server and other projects seem fine. I have a funny feeling that the doc_root is whats messing me up. All the documentation that I can find on this variable seems to be more focused on anything but windows.
Can you lend a hand ?
Thanks,
Lee
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2002-02-20
FIXED IT ! ! !
I had each PHP application running on it's own virtual server, which ran fine until the doc_root needed to be completed.
I moved everything into folders under the wwwroot and pointed doc_root to the web root folder and all worked.
I now have proper access. By the way, now that I'm in here ... nice work on the application.
Lee
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am experiencing the same problem: I am unable to login as anyone but the guest user after closing the browser window instead of logging out of a previous session. Deleting all session cookies fixes this problem.
According to the author of workbench, this is not an application problem, but a configuration problem. Has anyone got a suggestion what I might
change?
I am using workbench 0.10, php 4.2.0 and Windows 2000. Session variables are all set correctly, as far as I can see (and sessions work with several other php applications), and my workbench folder is in the document root directory.
Regards
Michael Burschik
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
register_globals was set to "On". As soon as I set it to "Off", I experienced a most curious problem: the login page was no longer found, and I received a 404 error. Other pages in the same directory were still found. Resetting register_globals to "On" fixed this new problem.
Is this due to Windows or PHP or even Apache?
Regards
Michael Burschik
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Unfortunately, workbench is fine for me on my Win2k PHP 4.2.0 system. I have installed PHP as an apache module though, not the CGI. I then set the following in php.ini: session.save_path (C:\WINNT\Temp), extension_dir (C:\php), doc_root (C:\Apache\htdocs), register_globals (off), track_vars (on).
And it all worked. I am sorry I cannot help anymore than this. I wish I could, and I hope someone can suggest a solution.
Cheers
Stuart
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks for your help. I am also using the apache module, so that should not be the problem. The "Spotty 404" thread might be connected to my problem, which I consider rather bizarre.
Regards
Michael Burschik
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
All,
I've installed workbench and can't seem to get access to the database. It goes though login.php and recognizes user admin, verifies his password but then won't give me anything more than guest privileges.
I can query the db from the command line and it all looks kosher but still no go. I installed everything as root and chmod'ed the .php files to 755. My php test tells me that php is up and running.
I'm sure it's something stupid. Any ideas?
Thanks,
Bugs12345
Hi, The reason you see the Guest Access page is because workbench thinks that you have not logged in, and obviously you have. Therefore after logging sessions are not being created correctly in your enviroment.
Please check your PHP configuration file (php.ini) for the following:
Session.cookie_path should be set to /
extension_dir should be set to the directory where PHP is installed. (eg c:\php or /usr/local/php)
doc_root should be set the Apache document root. (eg c:\Apache Group\Apache\htdocs or /usr/local/apache/htdocs)
session.save_path should be set to a valid directory where PHP can write session files (eg c:\winnt\temp or /tmp)
Please let me know if this does not help.
Thanks
Stuart
Stuart,
Thanks for responding...
I started with a stock RH7.2 install and my php.ini is set as you have indicated. I've upgraded php, curl and mysql to see if it was something simple.
Here is the (relevant) output from test.php. Sorry it looks so crappy but X11 cut and paste doesn't work well in this sourceforge email client...
Is there anything else I can try or read so as not to bother you...?
Mark
extension_dir /usr/lib/php4 /usr/lib/php4
doc_root /usr/local/www/html /usr/local/www/html
Session Support enabled
Directive Local Value Master Value
session.auto_start Off Off
session.cache_expire 180 180
session.cache_limiter nocache nocache
session.cookie_domain no value no value
session.cookie_lifetime 0 0
session.cookie_path / /
session.cookie_secure Off Off
session.entropy_file no value no value
session.entropy_length 0 0
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path /tmp /tmp
session.serialize_handler php php
session.use_cookies On On
Hi Mark, The session stuff above seems OK. Have you checked that the values of session.save_path, session.cookie_path, doc_root and extension_dir are correct?.
Please also check the configure information to see if it reads "--without-mysql" or "--with-mysql".
Thanks
Stuart
This seems to be a common theme, I'm having the same issue here.
I am running PHP on a Win 2000 Server and other projects seem fine. I have a funny feeling that the doc_root is whats messing me up. All the documentation that I can find on this variable seems to be more focused on anything but windows.
Can you lend a hand ?
Thanks,
Lee
FIXED IT ! ! !
I had each PHP application running on it's own virtual server, which ran fine until the doc_root needed to be completed.
I moved everything into folders under the wwwroot and pointed doc_root to the web root folder and all worked.
I now have proper access. By the way, now that I'm in here ... nice work on the application.
Lee
I am experiencing the same problem: I am unable to login as anyone but the guest user after closing the browser window instead of logging out of a previous session. Deleting all session cookies fixes this problem.
According to the author of workbench, this is not an application problem, but a configuration problem. Has anyone got a suggestion what I might
change?
I am using workbench 0.10, php 4.2.0 and Windows 2000. Session variables are all set correctly, as far as I can see (and sessions work with several other php applications), and my workbench folder is in the document root directory.
Regards
Michael Burschik
Hi Michael,
Have you checked that register_globals is set to "Off" and track_vars is set to "On" in your php.ini file.
Cheers
Stuart
register_globals was set to "On". As soon as I set it to "Off", I experienced a most curious problem: the login page was no longer found, and I received a 404 error. Other pages in the same directory were still found. Resetting register_globals to "On" fixed this new problem.
Is this due to Windows or PHP or even Apache?
Regards
Michael Burschik
Hi Michael,
Unfortunately, workbench is fine for me on my Win2k PHP 4.2.0 system. I have installed PHP as an apache module though, not the CGI. I then set the following in php.ini: session.save_path (C:\WINNT\Temp), extension_dir (C:\php), doc_root (C:\Apache\htdocs), register_globals (off), track_vars (on).
And it all worked. I am sorry I cannot help anymore than this. I wish I could, and I hope someone can suggest a solution.
Cheers
Stuart
Thanks for your help. I am also using the apache module, so that should not be the problem. The "Spotty 404" thread might be connected to my problem, which I consider rather bizarre.
Regards
Michael Burschik