Installation issues

[Benedict White <..hidden..>]

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

      General.sql     

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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users