Topic: sql-ledger

[mhiggins]

We are trying to get sql-ledger working again, we had this working in the same config but we rebuilt the box (for some reason that sounded like a good idea 24 hours ago) & now we can’t get sql-ledger running again.

We originally used this howto; http://no.longer.valid/phpwiki/index.php/How%20to%20install%20SQL-Ledger%20on%20SME%207.0

but this must be broken or have moved because we get this error when we try to access it.

Forbidden
You don't have permission to access /phpwiki/index.php/How to install SQL-Ledger on SME 7.0 on this server.

Does anyone have a copy of this HowTo archived somewhere?

Without this we have been working with the original forum posting http://forums.contribs.org/index.php?topic=30542.0

Everything seemed to be working OK right up until here where we are installing the database drivers
The HowTo line reads
“cpan> install DBD:g “

 cpan> install DBD

results in;
Warning: Cannot install DBD, don't know what it is.
Try the command
    i /DBD/
to find objects with matching identifiers.

We pushed on with the rest of the HowTo which all seemed OK but when we try to access http://<your-server>/sql-ledger/admin.pl I get;
Error!
No Database Drivers available!

We went back & retraced all the cpan steps. I think we buggered up the preceding line  “cpan> install DBI”   because instead of saying “DBI is up to date (1.56)” it gave an error. We restarted & it subsequently installed.

Looking around the web we thought we had nutted it &  the command should have be;
cpan> install DBD::mysql
but this looks like it is doing a heap of stuff  then it fails with
install DBD::mysql
Running install for module 'DBD::mysql'
Running make for C/CA/CAPTTOFU/DBD-mysql-4.004.tar.gz
  Checksum was ok
DBD-mysql-4.004/
DBD-mysql-4.004/ChangeLog
DBD-mysql-4.004/constants.h
DBD-mysql-4.004/dbdimp.c
DBD-mysql-4.004/dbdimp.h
DBD-mysql-4.004/eg/
DBD-mysql-4.004/eg/prepare_memory_usage.pl
DBD-mysql-4.004/eg/proc_example1.pl
DBD-mysql-4.004/eg/proc_example2.pl
DBD-mysql-4.004/eg/proc_example3.pl
DBD-mysql-4.004/INSTALL.html
DBD-mysql-4.004/lib/
DBD-mysql-4.004/lib/Bundle/
DBD-mysql-4.004/lib/Bundle/DBD/
DBD-mysql-4.004/lib/Bundle/DBD/mysql.pm
DBD-mysql-4.004/lib/DBD/
DBD-mysql-4.004/lib/DBD/mysql/
DBD-mysql-4.004/lib/DBD/mysql/GetInfo.pm
DBD-mysql-4.004/lib/DBD/mysql/INSTALL.pod
DBD-mysql-4.004/lib/DBD/mysql.pm
DBD-mysql-4.004/Makefile.PL
DBD-mysql-4.004/Makefile.PL.embedded
DBD-mysql-4.004/MANIFEST
DBD-mysql-4.004/MANIFEST.SKIP
DBD-mysql-4.004/META.yml
DBD-mysql-4.004/myld
DBD-mysql-4.004/mysql.xs
DBD-mysql-4.004/README
DBD-mysql-4.004/t/
DBD-mysql-4.004/t/00base.t
DBD-mysql-4.004/t/10connect.t
DBD-mysql-4.004/t/20createdrop.t
DBD-mysql-4.004/t/30insertfetch.t
DBD-mysql-4.004/t/35limit.t
DBD-mysql-4.004/t/35prepare.t
DBD-mysql-4.004/t/40bindparam.t
DBD-mysql-4.004/t/40bindparam2.t
DBD-mysql-4.004/t/40blobs.t
DBD-mysql-4.004/t/40catalog.t
DBD-mysql-4.004/t/40listfields.t
DBD-mysql-4.004/t/40nulls.t
DBD-mysql-4.004/t/40numrows.t
DBD-mysql-4.004/t/41bindparam.t
DBD-mysql-4.004/t/41blobs_prepare.t
DBD-mysql-4.004/t/42bindparam.t
DBD-mysql-4.004/t/50chopblanks.t
DBD-mysql-4.004/t/50commit.t
DBD-mysql-4.004/t/60leaks.t
DBD-mysql-4.004/t/70takeimp.t
DBD-mysql-4.004/t/75supported_sql.t
DBD-mysql-4.004/t/80procs.t
DBD-mysql-4.004/t/insertid.t
DBD-mysql-4.004/t/lib.pl
DBD-mysql-4.004/t/multi_statement.t
DBD-mysql-4.004/t/mysql.dbtest
DBD-mysql-4.004/t/param_values.t
DBD-mysql-4.004/t/prepare_noerror.t
DBD-mysql-4.004/t/texecute.t
DBD-mysql-4.004/t/utf8.t
DBD-mysql-4.004/TODO
Could not make: Unknown error
Running make test
  Can't test without successful make
Running make install
Make had returned bad status, install seems impossible

INSTALL SEEMS IMPOSSIBLE... now that is how we feel!

We are running an current  uptodate  SME Server 7.1.3 box.

We have installed vtiger 5.0.2 installed via the vtigercrm-5.0.2-1.sme7.0.i386rpm & Groupoffice installed via the smeserver-groupeoffice-2.16.11-3.noarch.rpm.

Would really some appreciate help with this.

[cjensen]

Does anyone have a copy of this HowTo archived somewhere?

The new place being populated with contrib docs is
http://wiki.contribs.org/Category:Contrib
Contributors are asked to create pages for their packages there.  I do not know where the howtos and references which were at contribs.org/phpwiki have ended up.  There were several for SME 7 at the old location.  I have a how-to which is from SME 5 & 6 but this would likely not be helpful?

Craig

[jester]

That line should be:

Code: [Select]

cpan> install DBD::Pg

But a ":" and a "P" put together will become a "" if the BBCode option is not switched off (there is an option for that when making a post).

EDIT:
Oh, btw SQL-ledger has some security issues, you might want to have a look at Ledger-SMB: http://www.ledgersmb.org and http://sourceforge.net/projects/ledger-smb

[mhiggins]

cpan> install DBD::Pg

worked perfectly, thankyou.