By doing:
chown www-data /tmp/ledgersmb as root, I was able to log in with the dbase
superuser and create the company database, create users, etc.
Is that the correct solution, or is there another better way to solve this
issue?
Thanks,
Jerry
On Fri, Sep 11, 2015 at 9:05 AM, JBash <bashve...@gmail.com> wrote:
> 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
