Thanks Erik,
Last night I was able to make some progress. To answer your question, I
was getting an invalid user / password dialog. After setting the password
for the superuser, I was able to get to the point where it asked if it
should create and configure the database. I agreed, and then I got the
following error:
Error!
Base schema failed to load at LedgerSMB/Database.pm line 621.
dbversion: 1.4.15, company:
Running a second time seems to indicate that the database was created:
DBD::Pg::db do failed: ERROR: database "cj2015" already exists at
LedgerSMB/Database.pm line 535.
dbversion: 1.4.15, company:
but, as the first message indictates, without the proper schema.
I checked the apache error logs and found these messages when the first
attempt was made: (cj2016 was the name of the company/database I'd
entered.)
2015/09/11 01:05:44 - ERROR - LedgerSMB::dberror LedgerSMB.pm (770) --
Logging SQL State 42883, error 7, string ERROR: function
public.setting_get(unknown) does not exist
LINE 1: SELECT * FROM "public"."setting_get"('ignore_version')
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
2015/09/11 01:05:44 - ERROR - LedgerSMB::_error LedgerSMB.pm (648) --
Internal Database Error
More information has been reported in the error logs at LedgerSMB.pm line
773.
2015/09/11 01:05:44 - ERROR - LedgerSMB::_error LedgerSMB.pm (649) --
dbversion: 1.4.15, company: postgres
2015/09/11 01:05:44 - ERROR - LedgerSMB::_error LedgerSMB.pm (648) -- exit
at LedgerSMB.pm line 662.
2015/09/11 01:05:44 - ERROR - LedgerSMB::_error LedgerSMB.pm (649) --
dbversion: 1.4.15, company: postgres
exit at LedgerSMB.pm line 662.
Compilation failed in require at /usr/share/ledgersmb-1.4.15/login.pl line
8.
DBI connect('dbname=cj2016','ledgersmb',...) failed: FATAL: database
"cj2016" does not exist at LedgerSMB/Database.pm line 459.
DBI connect('dbname="cj2016"','ledgersmb',...) failed: FATAL: database
"cj2016" does not exist at LedgerSMB/Database.pm line 113.
DBI connect('dbname="cj2016"','ledgersmb',...) failed: FATAL: database
"cj2016" does not exist at LedgerSMB/Database.pm line 113.
sh: 1: cannot create /tmp/ledgersmb/dblog_2015-09-11T050553_8053_stderr:
Permission denied
The last line indicates permission denied, so I wonder if I have set /
change permissions for that directory(?) .. (but it's in a tmp directory).
It's currently owned by root.
Thank you again for your help.
Jerry
On Fri, Sep 11, 2015 at 3:48 AM, Erik Huelsmann <ehu...@gmail.com> wrote:
> Hi Jerry,
>
>
>> I am installing legersmb for the first time. I'm currently running it on
>> Ubuntu 14.04. I've downloaded 1.4.15 and have gotten Apache2 configured to
>> display it locally (using a virtual host).
>>
>> I'm now stuck connecting to and configuring the database. I have
>> postgres 9.4 installed, and have created a user with superuser, create
>> role, and create database privileges.
>>
>
> Ok. Any user which has 'superuser' has all the other roles too, by
> definition, but adding them doesn't hurt. Did you set the new super user's
> password?
>
>
>> I've also created a database owned by this user.
>>
>
> This step is too quick: the setup programs will create the database for
> you and create the schema inside it which makes it a LedgerSMB company
> administration.
>
>
>> When I direct the browser to the website/setup.pl, using the database
>> user, password, and database, I am not able to connect. (I also added the
>> line 'host all all 127.0.0.1/32 md5', as indicated in the INSTALL file).
>>
>
> What error are you getting? Are you unable to connect to setup.pl? Or are
> you unable to connect to the database through setup.pl?
>
> I've also tried the script supplied in the ./tools directory to configure
>> the company database. Ie.,
>> sudo sh prepare-company-database.sh --company testinc --pgsql-contrib
>> /usr/share/postgresql/9.4/extension/
>> In this case, I get a message that "* These arguments don't have a
>> default, but are required'
>>
>
> I only see two options with asterisks, so am not sure which other
>> arguments I need to specify.
>>
>
> Maybe, at the top, before all else, there's an error message specifying
> what the problem is; from reading the script, that's what should be
> happening. The setup.pl way is the tried and true way to create a new
> database for new users, though, due to the fact that the
> prepare-company-database.sh script needs to run as 'root' and also uses
> 'su' itself.
>
> Hope that helps!
>
> --
> Bye,
>
> Erik.
>
> http://efficito.com -- Hosted accounting and ERP.
> Robust and Flexible. No vendor lock-in.
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
------------------------------------------------------------------------------
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
