topic Re: access alfresco through my php site in Alfresco Archive

access alfresco through my php site

cristianfrog — Tue, 13 Jan 2015 14:53:27 GMT

Hi all,I need to communicate with alfresco through a PHP client, in my case is a web site. My goal is to access the repository, get an HTML file and load it in my website, so basically I will use Alfresco as admin panel backend where I create my html pages.I know there is some material about this, I

Re: access alfresco through my php site

cristianfrog — Tue, 13 Jan 2015 15:58:00 GMT

I tried the apache chemistry php client and I successfully connected to the cmis.alfresco.com with this command:
php -f cmis_ls.php http://cmis.alfresco.com/service/api/cmis admin admin /

But it doesn't seem to work with my alfresco 5.0.b, why? the new alfresco doesn't allow connection through cmis anymore? how I can read the files then??

P.S. for my alfresco 5.0.b I tried all the urls but nothing working
[domain]/alfresco/api/-default-/public/cmis/versions/1.1/atom
[domain]/alfresco/api/-default-/public/cmis/versions/1.1/browser
[domain]/alfresco/api/-default-/public/cmis/versions/1.0/atom
[domain]/alfresco/cmisws/cmis?wsdl

Re: access alfresco through my php site

blacksylo — Wed, 14 Jan 2015 19:20:03 GMT

Hi cristianfrog, have you tried with http://localhost:8080/alfresco/cmisatom

Re: access alfresco through my php site

rjohnson — Thu, 15 Jan 2015 04:49:37 GMT

I have used CMIS and CURL to access Alfresco from PHP and it works well. We are using 4.2e.

Dependent upon need, I think that CURL is somewhat simpler to use. It limits you to calling webscripts but as the Alfresco API is largely REST then you can pretty much do anything you need that way and you can certainly retrieve document contents very easily. I do.

Are you familiar with CURL? I have a class I can share with you if you like.

Re: access alfresco through my php site

cristianfrog — Thu, 15 Jan 2015 14:42:38 GMT

@Blacksylo: I tried that one too but it doesn't work …

@rjohnson: Yes sure! it would be great if you can share with me the class and an example! you can attach it here or send it to me by PM

Re: access alfresco through my php site

rjohnson — Mon, 19 Jan 2015 10:53:48 GMT

As I can only attach txt files I have renamed all the .php to .txt.

Alfresco.txt is the class file. If you include this and have CURL installed then you can call any of the REST API.

A code snippet showing how you call this for a POST webscript is below


   $progress = $alfrescourl . "/alfresco/service/farthest-gate/fg-lga-progress-ticket?noderef=" . $row["noderef"];
   $payloaddata = array("newstate" => "full", "nextstate" =>"$nextstate","nextstatedate" =>"$nextstagedate","message" => "Full rate uplift"); 
   $payloaddataJSON = json_encode($payloaddata);
   if($noupdate == false) {
      $alfresco = new Alfresco($postUIDPWD, ALFRESCOURL."/share/page/dologin");
      $data = $alfresco->get();
      $headers = $alfresco->getHeaders();   
      if(!$alfresco->runpostwebscript($progress, $headers["JSESSIONID"], $getUIDPWD, $payloaddataJSON)) {
         die("Failed to progress ticket discount to full in Alfresco. Code: " . $alfresco->httpstatuscode . " Message: " . $alfresco->errorMessage . "\n");      
      }
      if($alfresco->httpstatuscode != 200) {
         die("Failed to progress ticket discount to full. Code: " . $alfresco->httpstatuscode . "\n");      
      }      
      echo "d2f: Progressed " . $row["ticketserialnumber"] . " with noderef " . $row["noderef"] . "\n";
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

$alfrescourl is a variable that holds the http://www……… that gets you to Alfresco

$postUIDPWD = sprintf("username=%s&password=%s",$repo_username, $repo_password);

For a Get


$alfresco = new Alfresco($postUIDPWD, $alfrescourl."/share/page/dologin");
$data = $alfresco->get();
$headers = $alfresco->getHeaders();
print $getMetaData = $alfrescourl . "/alfresco/service/api/metadata?shortQNames=true&nodeRef=" . $nodeRef;
print '<br/>';
if(!$alfresco->rungetwebscript($getMetaData, $headers["JSESSIONID"], $getUIDPWD)) {
die("Failed to get metadata from Alfresco. Code: " . $alfresco->httpstatuscode . " Message: " . $alfresco->errorMessage);
}
if($alfresco->httpstatuscode != 200) {
die("Failed to get metadata from Alfresco. Code: " . $alfresco->httpstatuscode);
}
$metadata = json_decode($alfresco->websrciptreponse);
‍‍‍‍‍‍‍‍‍‍‍‍‍‍

$getUIDPWD = sprintf("%s:%s",$repo_username, $repo_password);

Hope this helps

Re: access alfresco through my php site

cristianfrog — Mon, 19 Jan 2015 13:34:00 GMT

I would definetly try it and let you know, thank you very much!

Re: access alfresco through my php site

cristianfrog — Wed, 21 Jan 2015 11:19:35 GMT

I tried the class with the help of your snippet but it gives me errors:

Warning: array_merge(): Argument #2 is not an array in /web/htdocs/MY SITE/home/cris/alfresco.php on line 62

Fatal error: Uncaught exception 'Exception' with message 'No connection' in /web/htdocs/MY SITE/home/cris/alfresco.php:71 Stack trace: #0 /web/htdocs/MY SITE/home/cris/test.php(15): Alfresco->get() #1 {main} thrown in /web/htdocs/MY SITE/home/cris/alfresco.php on line 71

Here is my curl settings from phpinfo():


cURL support    enabled
cURL Information    7.19.7
Age    3
Features
AsynchDNS    No
CharConv    No
Debug    No
GSS-Negotiate    Yes
IDN    Yes
IPv6    Yes
krb4    No
Largefile    Yes
libz    Yes
NTLM    Yes
SPNEGO    No
SSL    Yes
SSPI    No
Protocols    tftp, ftp, telnet, dict, ldap, ldaps, http, file, https, ftps, scp, sftp
Host    x86_64-redhat-linux-gnu
SSL Version    NSS/3.16.2.3 Basic ECC
ZLib Version    1.2.3
libSSH Version    libssh2/1.4.2 
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Here is what my test.php contains:

<php>
<?php
include "alfresco.php";

$$alfrescourl = "http://MYALFRESCOURL.com:8080";

$repo_username = "admin";
$repo_password = "password123";
$postUIDPWD = sprintf("username=%s&password=%s",$repo_username, $repo_password);
$nodeRef = "workspace://SpacesStore/a6310747-e2a0-47c6-a571-ac6436f6afd3";

$alfresco = new Alfresco($postUIDPWD, $alfrescourl."/share/page/dologin");
$data = $alfresco->get();
$headers = $alfresco->getHeaders();
print $getMetaData = $alfrescourl . "/alfresco/service/api/metadata?shortQNames=true&nodeRef=" . $nodeRef;
print ' ';
if(!$alfresco->rungetwebscript($getMetaData, $headers["JSESSIONID"], $getUIDPWD)) {
die("Failed to get metadata from Alfresco. Code: " . $alfresco->httpstatuscode . " Message: " . $alfresco->errorMessage);
}
if($alfresco->httpstatuscode != 200) {
die("Failed to get metadata from Alfresco. Code: " . $alfresco->httpstatuscode);
}
$metadata = json_decode($alfresco->websrciptreponse);
?>
</php>

Any help?

Re: access alfresco through my php site

rjohnson — Wed, 21 Jan 2015 17:56:52 GMT

I don't know if the PHP is cut 'n paste or typed but….


$$alfrescourl = "http://MYALFRESCOURL.com:8080";
‍‍‍

is wrong as you are indirectly addressing a variable using a variable because of the $$ notation. You need


$alfrescourl = "http://MYALFRESCOURL.com:8080";
‍‍‍

This fits with the "No connection" as the content of $alfrescourl will not be "http://MYALFRESCOURL.com:8080" because of the $$ notation.

Re: access alfresco through my php site

cristianfrog — Thu, 22 Jan 2015 08:56:00 GMT

No the code is right I've just typed it wrong, the code is:

<php>
<?php
include "alfresco.php";

$alfrescourl = "http://doc.gruppofrog.it:8080";

$repo_username = "admin";
$repo_password = "2155753";
$postUIDPWD = sprintf("username=%s&password=%s",$repo_username, $repo_password);
$nodeRef = "workspace://SpacesStore/a6310747-e2a0-47c6-a571-ac6436f6afd3";

$alfresco = new Alfresco($postUIDPWD, $alfrescourl."/share/page/dologin");
$data = $alfresco->get();
$headers = $alfresco->getHeaders();
print $getMetaData = $alfrescourl . "/alfresco/service/api/metadata?shortQNames=true&nodeRef=" . $nodeRef;
print ' ';
if(!$alfresco->rungetwebscript($getMetaData, $headers["JSESSIONID"], $getUIDPWD)) {
die("Failed to get metadata from Alfresco. Code: " . $alfresco->httpstatuscode . " Message: " . $alfresco->errorMessage);
}
if($alfresco->httpstatuscode != 200) {
die("Failed to get metadata from Alfresco. Code: " . $alfresco->httpstatuscode);
}
$metadata = json_decode($alfresco->websrciptreponse);
?>
</php>

And giving the same error:

Warning: array_merge(): Argument #2 is not an array in /web/htdocs/MY SITE/home/cris/alfresco.php on line 62

Fatal error: Uncaught exception 'Exception' with message 'No connection' in /web/htdocs/MY SITE/home/cris/alfresco.php:71 Stack trace: #0 /web/htdocs/MY SITE/home/cris/test.php(12): Alfresco->get() #1 {main} thrown in /web/htdocs/MY SITE/home/cris/alfresco.php on line 71

Re: access alfresco through my php site

rjohnson — Fri, 23 Jan 2015 17:50:15 GMT

My guess is that the login is not working. do a print_r on $headers and see what in it. Sounds like its returned an error from the login call not an array.

Re: access alfresco through my php site

cristianfrog — Mon, 26 Jan 2015 12:30:00 GMT

I retested it on another server and it seems to "connect" now, but it gives me this error:
Failed to get metadata from Alfresco. Code: 401

The error is "Authorization required", are you sure this works without alf_ticket ??
Your script seems to send the JsessionID, but it seems not working… can you tell me how it authenticate and make it work?

Re: access alfresco through my php site

rjohnson — Tue, 27 Jan 2015 19:00:41 GMT

Because its a "get" you are sending the UID & PWD in the http request so you don't need alf_ticket as it uses the credentials passed in the URL. This is a standard mechanism for running a get request, you can do it from the browser.

I suspect your problem is that, so far as I can see, you are not setting $getUIDPWD to anything; it should be set to

$getUIDPWD = sprintf("%s:%s",$repo_username, $repo_password);

Re: access alfresco through my php site

cristianfrog — Wed, 28 Jan 2015 09:08:27 GMT

SOLVED! I was using the POST getUIDPWD, thank you very much!