how to install letodms in linux

[sappu]

i put your php program inside letodms dir.its running sucessfully..here is out put
(mysql): select * from employees

Array
(
[0] => Array
(
[0] => maa
[name] => maa
[1] => maakaladala
[email] => maakaladala
[2] => 12j2j2
[phone] => 12j2j2
[3] =>
[document] =>
[4] => 1
[id] => 1
[5] => 0000-00-00 00:00:00
[created] => 0000-00-00 00:00:00
[6] =>
[upload] =>
[7] =>
[path] =>
[8] =>
[fs] =>
)

[1] => Array
(
[0] => aa
[name] => aa
[1] => adf
[email] => adf
[2] => 333
[phone] => 333
[3] => FEEDBK-REPORT.ods
[document] => FEEDBK-REPORT.ods
[4] => 2
[id] => 2
[5] => 0000-00-00 00:00:00
[created] => 0000-00-00 00:00:00
[6] =>
[upload] =>
[7] =>
[path] =>
[8] => FEEDBK-REPORT.ods
[fs] => FEEDBK-REPORT.ods
)

can you tell me how to load libphp-adodb

[IAmTurok]

Hi Sappu,

That's good. To confirm the package is available, you can do it two ways:
- Use Add/Remove software, look for php-adodb, tick and install it.
- Command line: sudo yum install php-adodb

The version I have installed is:
php-adodb-4.95-1.a.el6.noarch

When I was installing, I also noticed a file created:
- {apacheroot}/letodms/install/php_errors.log

Does this file exist, and if you tail the file to show the last entries, what does it say?

IAT.

...

[sappu]

i also install this php-adodb

no i didnot find php_errors.log now what to do

[IAmTurok]

And did you restart Apache, as most changes do not take effect until you do so:

command line: sudo /sbin/service httpd restart

What happens now when you do http://localhost/letodms/ in a web browser?

Also, in Firefox, before running hitting Apply in install.php, open up the Error console (Firefox -> Tools -> Error Console) and see what that says also.

IAT.

i also install this php-adodb

no i didnot find php_errors.log now what to do

[sappu]

i restarted service but still not solved....

[IAmTurok]

Hi,

I hate to suggest this (the equivalent of turning off and on again, but if you have made (understandably) a number of changes, then time for a clean install again.

Assuming that apache root is /var/www/html, do again these steps in a clean directory:
- Restart CentOS.
- Unzip Letodms latest into /var/www/html/letodms
- Ditto Core and Lucene, as in, /var/www/html/letodms/Core and /var/www/html/letodms/Lucene
- adodb, /var/www/html/letodms/adodb

Other commands:
- touch /var/www/html/letodms/conf/ENABLE_INSTALL_TOOL
- chown -R apache:apache /var/www/html/letodms

- Create the directories needed for Content directory, Directory for full text index, and Directory for partial uploads, /opt/letodms, /opt/letodms/lucene, /opt/letodms/staging, and make sure they are accessible by Apache (sudo chown -R apache:apache /opt/letodms).

- Using phpMyAdmin (or similar) create a new letodms user and password), and create a database called letodms also. If already there, delete them and do again.

- Now start the installation: http://localhost/letodms/install/install.php

- Update all fields as they should be, the three above for /opt/letodms, the rest are: /var/www/html/letodms/ for Core, Lucene and ADOdb. Update the MySQL password also, and tick create tables.

What happens? is there:
- File exist: install/php_errors.log?
- In phpMyAdmin: have tables been created?
- Run the previous test.php on the letodms database, use tblCategory instead of employees in your file?
- Was file created: conf/settings.xml?

IAT.

i restarted service but still not solved....

---

Hi again,

If a clean install is not desirable, also try this. To ensure PHP finds ADOdb no matter where, check for the folder:
/user/share/php/adodb

Does it exist? If not, create it from the download of adodb.

Once there, check:

/etc/php.ini

Does the line include_path have at a minimal:
include_path = ".;/usr/share/php/adodb"

If not, do so, restart Apache again, and install again.

IAT.

i restarted service but still not solved....

---

Oh, and for the clean install, just making sure all other utulities are there:
- yum install php-mbstring
- yum install php-pear
- pear install Log
- pear install --alldeps MDB2#MySQL
- pear install --alldeps MDB2#MySQLi
- pear install channel://pear.php.net/HTTP_WebDAV_Server-1.0.0RC6

As always, restart Apache before running install.php.

IAT.

Hi,

I hate to suggest this (the equivalent of turning off and on again, but if you have made (understandably) a number of changes, then time for a clean install again.

Assuming that apache root is /var/www/html, do again these steps in a clean directory:
- Restart CentOS.
- Unzip Letodms latest into /var/www/html/letodms
- Ditto Core and Lucene, as in, /var/www/html/letodms/Core and /var/www/html/letodms/Lucene
- adodb, /var/www/html/letodms/adodb

Other commands:
- touch /var/www/html/letodms/conf/ENABLE_INSTALL_TOOL
- chown -R apache:apache /var/www/html/letodms

- Create the directories needed for Content directory, Directory for full text index, and Directory for partial uploads, /opt/letodms, /opt/letodms/lucene, /opt/letodms/staging, and make sure they are accessible by Apache (sudo chown -R apache:apache /opt/letodms).

- Using phpMyAdmin (or similar) create a new letodms user and password), and create a database called letodms also. If already there, delete them and do again.

- Now start the installation: http://localhost/letodms/install/install.php

- Update all fields as they should be, the three above for /opt/letodms, the rest are: /var/www/html/letodms/ for Core, Lucene and ADOdb. Update the MySQL password also, and tick create tables.

What happens? is there:
- File exist: install/php_errors.log?
- In phpMyAdmin: have tables been created?
- Run the previous test.php on the letodms database, use tblCategory instead of employees in your file?
- Was file created: conf/settings.xml?

IAT.

[sappu]

Thanks for helping me .but i still didnot resolve it....iam continously following your solution...
now iam going to fresh install.

[IAmTurok]

Hi Sappu,

Happy to help.

Let me know how you get on. If you're interesting, I can suggest one more workaround: WARNING, I have not done these steps myself, simply making some assumptions about how LetoDMS works!

So, conf/settings.xml is created after installation, so try using my copy (see pasted below between >>> and <<<).

Steps again:
- Clean install as before, but this time, do not run the install.php
- XTerm: Create mySQL tables: mysql -u letodms -p letodms < install/create_tables.sql
- rm -rf conf/ENABLE_INSTALL_TOOL
- gedit conf/settings.xml (edit-paste text from attached file).
- Update any directory or MySQL fields as appropriate to your setup. This setup assumes /var/www/html/letodms as the main folder.
- if you do not have /opt/letodms folder, as a test, you could change this to /var/www/html/letodms (/lucene /staging) for the 3 ContentDir fields. It's not recommended, but for now, it's simply to try get it running.
- Zend Framework is not configured in this example, but again, if it works, that could be revisited and updated.
- Try to run LetoDMS.

Again, I've not tried this myself, but assuming settings.xml is correct, the rest should work. It's not ideal, but might work!

Today I'm looking at LetoDMS on Windows, so for now, continuing to mess around with it and happy to answer any further questions.

IAT.

conf/settings.xml
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<site>
<display siteName="letoDMS" footNote="letoDMS free document management system - www.letodms.com" printDisclaimer="true" language="English" theme="clean">
</display>
<edition strictFormCheck="false" viewOnlineFileTypes=".txt;.text;.html;.htm;.pdf;.gif;.png;.jpg;.jpeg" enableConverting="true" enableEmail="true" enableUsersView="true" enableFullSearch="true" enableFolderTree="true" expandFolderTree="1">
</edition>
<calendar enableCalendar="true" calendarDefaultView="y" firstDayOfWeek="0">
</calendar>
</site>
<system>
<server rootDir="/var/www/html/letodms/" httpRoot="/letodms/" contentDir="/opt/letodms/" stagingDir="/opt/letodms/staging/" luceneDir="/opt/letodms/lucene/" logFileEnable="true" logFileRotation="d" enableLargeFileUpload="true" partitionSize="2000000">
</server>
<authentication enableGuestLogin="false" enablePasswordForgotten="false" restricted="true" enableUserImage="false" disableSelfEdit="false">
<connectors>
<connector enable="false" type="ldap" host="ldaps://ldap.host.com" port="389" baseDN="">
</connector>
<connector enable="false" type="AD" host="ldap.example.com" port="389" baseDN="" accountDomainName="example.com">
</connector>
</connectors>
</authentication>
<database ADOdbPath="/var/www/html/letodms/" dbDriver="mysql" dbHostname="localhost" dbDatabase="letodms" dbUser="letodms" dbPass="letodms">
</database>
<smtp smtpServer="localhost" smtpPort="25" smtpSendFrom="letodms@localhost"/>
</system>
<advanced>
<display siteDefaultPage="" rootFolderID="1" titleDisplayHack="true">
</display>
<authentication guestID="2" adminIP="">
</authentication>
<edition enableAdminRevApp="false" versioningFileName="versioning_info.txt">
</edition>
<server coreDir="/var/www/html/letodms/" luceneClassDir="/var/www/html/letodms/" contentOffsetDir="1048576" maxDirID="0" updateNotifyTime="86400" maxExecutionTime="30">
</server>
</advanced>
</configuration>

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Thanks for helping me .but i still didnot resolve it....iam continously following your solution...
now iam going to fresh install.

[IAmTurok]

Hi Sappu,

Quelle surprise on Windows, it too shows a blank screen after hitting Apply during the installer (so far, only Ubuntu worked with no problems). In this case, the web console shows an error 500, not very helpful, but most likely it's hiding a DB error.

Anyway, my workaround of loading the SQL tables manually, and creating the settings.xml file manually works on Windows! That's how I got it to work.

Good luck with doing so your end.

Cheers,

IAT.

[sappu]

after all these long hard work on installing on centos .. i decided to install it on ubantu machine...on centos its just waste of time.with no output.
i reteired my self installing letodms on centos.
now will try on ubantu.

thanks for helping me and with me in solving ....
well did u know any good DMS application for linux raither then letodms.
which really works.