OK, so I've installed Debian on a virtual machine, and I've managed to
get access to it from the host by setting the network adaptor to bridged
mode.
Apache works as does Postgres and after a few hicups managed to get
somewhere. (I had to reset the postgress passwords, allow access to
ledgersmb from other hosts than local hosts, then found I had to allow
access to the css files).
I now go from a screen which says:
Database Management Console
Next
Skip
(After selecting country code uk) to this:
Error!
*Internal Database Error
More information has been reported in the error logs
*
So where can I find the error logs? (Apache only says:
DBI connect('dbname=NewCoName','ledgersmb',...) failed: FATAL: database
"NewCoName" does not exist at LedgerSMB/Database.pm line 271
DBI connect('dbname=NewCoName','ledgersmb',...) failed: FATAL: database
"NewCoName" does not exist at LedgerSMB/Database.pm line 271
2014/03/02 15:02:21 - INFO - LedgerSMB::Scripts::setup::create_db --
create_and_load rc=1
DBD::Pg::st execute failed: ERROR: function
public.person__list_salutations() does not exist
LINE 1: SELECT * FROM "public"."person__list_salutations"()
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts. at LedgerSMB.pm line 828.
2014/03/02 15:02:40 - ERROR - LedgerSMB::dberror LedgerSMB.pm (1085) --
Logging SQL State 42883, error 7, string ERROR: function
public.person__list_salutations() does not exist
LINE 1: SELECT * FROM "public"."person__list_salutations"()
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
Issuing rollback() due to DESTROY without explicit disconnect() of
DBD::Pg::db handle dbname=NewCoName at /usr/share/ledgersmb/setup.pl line 8.
[Sun Mar 02 15:02:40 2014] [error] [client 192.168.0.125] Directory
index forbidden by Options directive: /usr/share/ledgersmb/css/,
referer: http://erp.newconame.co.uk/ledgersmb/setup.pl
Postgress provides: (Last error listed there is a lot in the log file
for the whole creation process)
2014-03-02 15:19:34 GMT STATEMENT: UPDATE account
SET tax = true
WHERE id
IN (SELECT account_id
FROM account_link
WHERE description LIKE '%_tax');
2014-03-02 15:19:34 GMT ERROR: function
public.person__list_salutations() does not exist at character 15
2014-03-02 15:19:34 GMT HINT: No function matches the given name and
argument types. You might need to add explicit type casts.
2014-03-02 15:19:34 GMT STATEMENT: SELECT * FROM
"public"."person__list_salutations"()
Are there specific ledgersmb logs, and is so, where?
Another thing, when installing on Debian, it does ask you to set up
users for postgress inlcuding a ledgersmb account which does not have
sufficient privalidges to add databases. Not a problem for me but may
put some people off.
Kind regards
Benedict White
------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
