Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Mahmood Al-Yousif on July 29, 2002, 05:47:24 PM

Title: DBD/DBI Installation on 5.5
Post by: Mahmood Al-Yousif on July 29, 2002, 05:47:24 PM

I've successfully installed Postgresql on SME 5.5. I intend to use the installation to run the sql-ledger software (http://www.sql-ledger.com) which seems worth investigating.

I've gotten sql-ledger to work as far as displaying the admin page etc is concerned, but am facing a problem in that the page links result in error 500's.

On investigating in the /var/log/httpd/error-log I get the following messages which relate to DBD and DBI installations (no rpms availalbe for the versions that I want and I don't know how to create RPMs (yet!)):
[Mon Jul 29 15:24:25 2002] [error] [client 192.168.0.11] Premature end of script headers: /home/e-smith/files/ibays/ledger/html/admin.pl
install_driver(Pg) failed: Can't locate loadable object for module DBD::Pg in @INC (@INC contains: /usr/lib/perl5/5.6.1/i386-linux /usr/lib/perl5/5.6.1 /usr/lib/perl5/site_perl/5.6.1/i386-linux /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0 /usr/lib/perl5/site_perl .) at (eval 6) line 3
Compilation failed in require at (eval 6) line 3.
Perhaps a module that DBD::Pg requires hasn't been fully installed
 at SL/User.pm line 198
Compilation failed in require at /home/e-smith/files/ibays/ledger/html/admin.pl line 89.

I did install the "DBD-Pg-0.73-1" rpm (rpmfind) however the version required by the software is more recent (1.13) and that is available only on source, as SME does not have the "make" program I cannot compile it locally.

Has anyone installed DBD and DBI (latest or recent versions) or at least can point me to a How-To build an RPM on a remote system then install them on SME?

Many thanx
Mahmood

Title: Re: DBD/DBI Installation on 5.5
Post by: guestHH on July 29, 2002, 06:29:04 PM

Hi Mahmood,

I succesfully installes sql-ledger 2 weeks ago. I installed both DBD and DBI without problems. I'm changing the current how-to for installation on SME 5.5 (or are you..?)


All the files needed are here:
http://www.star-support.com/downloads/mitel/contrib/sql-ledger/

Demo can be found here:
https://www.star-support.com/accountant/login.pl
user: demo
pass: demo

Have fun.

Regards,
RequestedDeletion
httpd

Title: Re: DBD/DBI Installation on 5.5
Post by: C.K. Kung on July 29, 2002, 10:41:19 PM

Hi,

My websit
http://www.hklinux.no-ip.com/SQL-Ledger/

Title: Re: DBD/DBI Installation on 5.5
Post by: Mahmood Al-Yousif on July 30, 2002, 10:53:03 AM

Thanks for that. No please go ahead and complete the how-to as you've started it and this is my first experience with both sql-ledger and postgresql.

regards
Mahmood

Title: Re: DBD/DBI Installation on 5.5
Post by: Mahmood Al-Yousif on July 30, 2002, 10:53:34 AM

Thank you. Those files are just what were needed!

Title: Re: DBD/DBI Installation on 5.5
Post by: Tony on August 04, 2002, 04:07:33 PM

I have followed the instructions in the install.htm until I create the custom template directory, then I cannot find the files I need to copy into it.

Could someone please point me in the direction of these files or mail them to me?

Thankyou

Tony

Title: Re: DBD/DBI Installation on 5.5
Post by: guestHH on August 04, 2002, 04:34:35 PM

Hi,

cp 50DirectoryIndex00 /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/
cp 50DirectoryIndex00PHP /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/
cp 80AddHandler00 /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/
cp 90e-smithAccess40ibays /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/

The above command will copy the template fragments from /etc/e-smith/templatesetc/httpd/conf/httpd.conf/ to the new custom template.

You have to change to dir /etc/e-smith/templates/etc/httpd/conf/httpd.conf/ and then execute the commands.

Regards,
guestHH

Title: Re: DBD/DBI Installation on 5.5
Post by: Tony on August 04, 2002, 05:07:14 PM

Thank you, I never thought to look there!

Tony

Title: Re: DBD/DBI Installation on 5.5
Post by: Tony on August 04, 2002, 06:40:56 PM

OK

I did everything as per the instructions. When I try to access:

http://account/admin.pl

I get "this page cannot be displayed"

http://tbcomputing.com/account/admin.pl

I get "you are not authorised to view this page"

http://account/

I get "this page cannot be displayed"

http://tbcomputing.com/account/

I get "index of /account"

Any help please

Tony

Title: Re: DBD/DBI Installation on 5.5
Post by: guestHH on August 04, 2002, 09:29:40 PM

Hi,

http://www.yourdomain.com/account/admin.pl doesn't work ?

HFW

Title: Re: DBD/DBI Installation on 5.5
Post by: C.K. Kung on August 04, 2002, 09:42:16 PM

Hi,

Sorry about my website PHP index cannot show the file 50DirectoryIndex00 ...
Now you can get all file from my website.

http://hklinux.no-ip.com/SQL-Ledger/

Title: Re: DBD/DBI Installation on 5.5
Post by: Tony on August 04, 2002, 11:04:09 PM

No

It does not work.

do I need to upgrade PHP

I am running SME 5.1.2

Any other ideas please

Thanks to C K Kung for posting the files.

Tony

Title: Re: DBD/DBI Installation on 5.5
Post by: C.K. Kung on August 04, 2002, 11:41:58 PM

Tony,

My server is same of you. 5.12.
What problem you have?

Title: Re: DBD/DBI Installation on 5.5
Post by: guestHH on August 05, 2002, 12:15:49 AM

YFYI

I made a backup of C.K. Kung's file here:
http://www.star-support.com/downloads/mitel/contrib/sql-ledger/

among some other sqlledger related files.

Thanks C.K.

Regards,
guestHH

Title: Re: DBD/DBI Installation on 5.5
Post by: C.K. Kung on August 05, 2002, 12:45:10 AM

Hi,

Note: my server's sql-ledger-1.8.4.1.tar.gz file is 1.84 + patch

Title: Re: DBD/DBI Installation on 5.5
Post by: Tony Bennett on August 05, 2002, 11:36:46 AM

OK

Its working on 5.5 after a lot of work.

I will do it again on a clean box and write a howto.

Tony