This project is read-only.

Failed to connect LA(M)P to SSRS 2008

Aug 26, 2010 at 5:27 AM

LAMP : x86_64-redhat-linux-gnu : Apache/2.2.3 (CentOS) : MS SQL 2008 : PHP Version 5.1.6

SSRS is on SQL server. PHP can access SQL. SSRS can access SQL. Lynx can access SSRS.

PHP cannot access SSRS.

I've read all the posts on this but still get:

    [errorDescription] => Failed to connect to Reporting Service
 Make sure that the url (http://Rep1/ReportServer/) and credentials are correct!
 array (
  0 => 'HTTP/1.1 401 Unauthorized',
  1 => 'Content-Length: 0',
  2 => 'WWW-Authenticate: Negotiate',
  3 => 'WWW-Authenticate: Basic realm="Rep1"',
  4 => 'Date: Thu, 26 Aug 2010 03:51:56 GMT',
  5 => 'Connection: close',
)

I added this to line 200 of  SSRSReport.php: . var_export( $http_response_header, true ) . " <br/>" );

The url, UID & PWD are correct as confirmed by: lynx -auth=<UID>:<PWD> http://Rep1/ReportServer

Any suggestions ?


Aug 27, 2010 at 5:44 AM

Fixed. Error was PHP version dependant.

Replaced ( SSRSReport.php, line 168 )

        $stream_conext_params = array( 'http' =>
                                         array('header' =>
                                          array($credentials->getBase64Auth())));
 With

        $stream_conext_params = array( 'http' =>
                                         array('header' =>
                                                   $credentials->getBase64Auth()));

Works fine now.

Aug 27, 2010 at 5:57 AM

Glad to see that you were able to fix the problem.

The PHP version you are using seems to be an older version. Is it a common version used on linux machines?

I'm trying to determine we should fix this issue in the library.

Claudio

Aug 30, 2010 at 12:29 AM

We’re running redhat RPMs and PHP 5.1.6 is their “current” version!

From: claudioc [mailto:notifications@codeplex.com]
Sent: Friday, 27 August 2010 2:58 PM
To: phayward@aconex.com
Subject: Re: Failed to connect LA(M)P to SSRS 2008 [ssrsphp:224873]

From: claudioc

Glad to see that you were able to fix the problem.

The PHP version you are using seems to be an older version. Is it a common version used on linux machines?

I'm trying to determine we should fix this issue in the library.

Claudio

Read the full discussion online.

To add a post to this discussion, reply to this email (ssrsphp@discussions.codeplex.com)

To start a new discussion for this project, email ssrsphp@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com

Mar 1, 2011 at 9:55 PM

Thanks PHayward23!  

Same issue on Debian Lenny running php 5.2.6.