Re: workbench login/app issues
Ryan Brainard
Thank you for your interest in installing Workbench. First to answer
your config questions:
-It sounds like the Web Developer Server Suite already added PHP to
your system path, so no need to append anything additionally
-You would want to use the path actually with your PHP installation
-I'm not really sure you mean by "put online" so might be something
specific with wampserver. As long as you can view a page, which it
sounds like you are viewing login.php, Apache should be working fine.
From your description, it sounds like it is coming from either an
issue with the PHP soapclient (a core PHP library used to working with
the Salesforce API), the SSL libraries, and a PHP configuration issue.
Since the page is blank, it is probably that the PHP settings are
configured to not display errors to users (which is a generally a good
thing in production environments, but not when trying to get things
setup). Hopefully, it is writing the errors to a log, so you can look
in the PHP error logs, which are usually in the Apache logs folder,
but it can vary for each installation. If you can't find the logs or
there is nothing there, edit your php.ini file to enable logging and
note where the logs are being written to. Look for the section called
"Error handling and logging" and the "error_log" item specifies where
the logs are written and the "error_reporting" item specifies detail
level (there should be examples above it) and "display_errors" tells
PHP to show the errors directly to end users. If you make changes to
the php.ini, restart the server, try logging in with Workbench again,
and check the log file again (or should have been displayed if
display_errors is On). Hopefully there will be something useful in the
logs and it might be obvious that can be fixed right away. If not,
feel free to send me the logs and I can take a look. In addition,
please send me the following (and some extra things to try):
-What is the URL of the blank page? Is it still on login.php or or
something else?
-Can you navigate to the Settings, Help, and About pages? If you try
to go to something that requires a login, like Query, are you kicked
back to login.php? (just trying to see if Apache/PHP are working in
general)
-What happens if you use different options on the "Jump to" selection
at login (including leaving it blank)?
-Does Salesforce record an API login (Setup | Manage Users | Login
History) when you attempt to login with Workbench?
-If you go to Advanced login do you have any better luck? If not,
while on Advanced login, try changing the protocol of the Server URL
from https:// to http:// (make sure that you have "Require secure
connections (https)"
in Saleforce disabled under Setup | Security Controls | Session
Settings)
-If it is still not working, please send me your php.ini and output
from phpinfo().
Thanks,
Ryan
On Mar 12, 2009, at 11:12 PM, Darcy wrote:
> Hi, I'm having trouble with logging in. I have followed the
> installation instructions verbatim (using Web Developer Server Suite).
> I get the login screen, and when I enter my credentials and submit the
> page, the page goes blank. I've tried this in Firefox, IE and Chrome.
> Have you ever seen this issue? I've obviously configured it wrongly.
> Some specific questions I have that I think may be affecting the
> installation/configuration are...
>
> * when adding the PHP directory to the system path, I see the
> instructions show to add ";c:\php" - but I see the path from my
> installation is "C:\www\php5" - would I still want to provide path in
> the instructions?
> * when editing the "extension_dir" in php.ini, would I want to provide
> my exact path to the php extensions (extension_dir = "C:\www
> \php5\ext"), or exactly as specified in the notes (extension_dir = "/
> ext/")
> * for apache settings, is there setting for putting it online.... I
> ask this because I initially installed wampserver, and it had an
> option to go "online" as well as an option to "start services"
>
> I thought it might be a firewall issue, but still did not work after
> turning off the firewall.
>
> I have tested the app out from the test site, and it looks like such a
> great tool that I am so eager to start using it.
>
> Thanks so much for your time.
> -Darcy
Ryan Brainard
Thanks for trying that out and providing that information. Looking at your logs and configuation, the issue is that the PHP SoapClient extension is being loaded correctly, so the login is not successful (the Workbench needs the SoapClient to talk to the Salesforce API) and a blank page is displayed because your php.ini is set for "display_errors = Off." So, the question now is why the SoapClient is not being loaded correctly.
The first thing that seemed a little strange is that I am not sure if the php.ini file you sent is the one actually used by the phpinfo.php page because the "extension_dir" sections don't match up. The php.ini actually being used is in your C:\WINDOWS\ directory. If I remember correctly, the Web Developer Server Suite installs two php.ini files, with one in the C:\www folder and another in c:\windows (which can be confusing), but the latter is the one that is actually being used by PHP. So, you might want to check your C:\WINDOWS\php.ini file and make sure that soap, curl, and openssl are being loaded (the way you did it in the php.ini file you sent me looks good).
The second thing to check is that the extension files are actually in the extensions folder. Your php.ini has this set to "./" and your phpinfo.php reports it being at "C:/www/php5/ext" (which is the descepancy I was talking about above), but where you end up setting it and adjusting the php.ini as explained above, make sure that the actual files are in the directory reported by phpinfo.php. If it is not there, you can download php_soap.dll for 5.2.0 here:
http://dllcentral.com/php_soap.dll/5.2.0.0/
Also check for php_curl.dll and php_openssl.dll, and here are the links to download them if not:
http://dllcentral.com/php_curl.dll/5.2.0.0/
http://dllcentral.com/php_openssl.dll/5.2.0.0/
Try this out and make sure to restart Apache each time you make a config change and then try logging in again.
If it is still not working, you can try a more manual route of just installing Apache and PHP separately instead of using the Web Developer Server Suite. They each have installers that are relatively painless and you can choose which extension you want to install in the installation wizard. Actually, I am thinking of changing the Workbench installation instructions like this so they will be more straightforward, even if a little more manual.
If it is still not working, let me know, and I can try to offer more suggestions. I'm cc'ing the group so everyone can benefit from these tips if they are having similar issues.
Thanks,
Ryan
Hi Ryan,
Thanks for the quick response. I am new to development concepts, so I'm afraid I'm not solid on some of these. So, I'm just providing you with the answers to your questions and hopefully that will give you enough to go on.
-What is the URL of the blank page? Is it still on login.php or or something else?
The URL doesn't change when I submit the page: http://localhost/workbench/login.php
-Can you navigate to the Settings, Help, and About pages? If you try to go to something that requires a login, like Query, are you kicked back to login.php? (just trying to see if Apache/PHP are working in general)
I can navigate to the Settings, Help and About links successfully. For the others (Describe, Insert, Upsert, etc), the url remains the same (http://localhost/workbench/login.php).
-What happens if you use different options on the "Jump to" selection at login (including leaving it blank)?
Nothing changes if I select a "Jump to" option or if I leave it blank... the page goes blank but the url remains the same (http://localhost/workbench/login.php)
-Does Salesforce record an API login (Setup | Manage Users | Login History) when you attempt to login with Workbench?
Salesforce does not record a login for my attempt
-If you go to Advanced login do you have any better luck? If not, while on Advanced login, try changing the protocol of the Server URL from https:// to http:// (make sure that you have "Require secure connections (https)" in Saleforce disabled under Setup | Security Controls | Session Settings)
It still goes blank with the same url when changing the server url to http://
-If it is still not working, please send me your php.ini and output from phpinfo().
I've attached my php.ini file and the output of the phpinfo() page and the error log for my recent login attempt
Thanks again for all your help with this!
-Darcy
Darcy Young
Ryan Brainard
Glad to hear you got it working with a different WAMP package. These PHP Notices are nothing to be concerned about, but they have been something I have been trying to clean up (slowly) in each release. Just make sure you have "display_errors" set to "Off" so you don't see these in the browser. The only one you might want to fix is the "PHP Fatal error: Maximum execution time of 30 seconds exceeded". To do so, you can increase the value of "max_execution_time" in your php.ini.
Hope you enjoy using Workbench!
-Ryan