[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Fwd: Installation question - database connection



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



------------------------------------------------------------------------------
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users