Re: Installation woes on Ubuntu

[Vincenzo Romano <..hidden..>]

2012/11/12 Vincenzo Romano <..hidden..>:
> 2012/11/10 Robert J. Clay <..hidden..>:
>> On Sat, Nov 10, 2012 at 11:05 AM, Vincenzo Romano
>> <..hidden..> wrote:
>>> 2012/11/10 Robert J. Clay <..hidden..>:
>>>> Did you create a user for the company db you created?
>>>> And use that for the logon.pl page? Also, how did you do
>>>> the install?
>>
>>> I followed in some way the article at howtoforge
>>>(http://goo.gl/aXGMn).
>>
>>    Ah, yes;  that's a bit out of date, particularly since LedgerSMB is
>> now included directly in Ubuntu.   LedgerSMB 1.3.18 is what is
>> currently in Ubuntu 12.10 and v1.3.23 is in what will be 13.04
>> (raring).   (I plan to back port the newer versions of LedgerSMB to at
>> least the current Ubuntu LTS versions...)
>>
>>> I had to make some minor changes (<10%) as I am running Kubuntu 12.10.
>>
>>    Any particular reason why you're not using the packages already in
>> Ubuntu?   The package doesn't configure the 'ledgersmb' db user   like
>> I want it to yet (an issue with the packaging, not with LedgerSMB
>> itself), but that's easily corrected manually.
>>
>>
>>> I'm not sure I've caught the many username/password I have
>>> to set and provide in order to have the application working ...
>>
>>    For normal ops (i.e.;  login.pl), at least one company database
>> user that has access to that company and sufficient rights to either
>> do everything him or herself, or has the access to add the necessary
>> users for the work to be done.
>>
>>    For the 'setup.pl' login;  a (IIRC, separate from the above company
>> db user) postgresql database user with superuser rights.
>>
>>
>>> But yes, I first created a database with the PGSQL administrative
>>> user (postgres)
>>
>>     Wasn't there a company db user created during that process?   Note
>> that the initial password for that user expires after 24 hours...
>>
>> .
>>> There I also created a LedgerSMB administrative user.
>>> I used the latter in order to login ... well, to try to.
>>
>>    What are you thinking of as being the "LedgerSMB Administrative
>> user"?  The one that comes to my mind for that phrase is the DB
>> superuser used for creating company databases and the initial users
>> for them.   That's not the same thing as a company db user that has
>> admin rights on a particular company db...
>
> OK.
> I started on a fresly installed Kubuntu 12.10 machine.
> I installed "ledgersmb" and answered to
> 1. Username and password for the administration
> 2. A password to access the database (also freshly installed)
> Password in #1 and #2 were different, to try to understand.
>
> Once installation got declared "finished" I pointed my browser to
> http://127.0.0.1/ledgersmb/setup.pl
> I got asked for Username/password/database.
> I put there the credentials at point #1.
> Then I god an HTTP authentication request where I put "ledgersmb" as
> user and the password for point #2.
> Then I got a database creation page. I asked to create it.
> Finally I got an "Internal Server Error" page with the following as error.log:
> ########
> Mon Nov 12 18:44:56 2012 Sysconfig.pm created tempdir /tmp/ledgersmb rc=0
> DBI connect('dbname=template1','ledgersmb',...) failed: FATAL:
> password authentication failed for user "ledgersmb"
> FATAL:  password authentication failed for user "ledgersmb" at
> LedgerSMB.pm line 981
> DBI connect('dbname=uno','ledgersmb',...) failed: FATAL:  database
> "uno" does not exist at LedgerSMB/Database.pm line 271
> DBD::Pg::db do failed: ERROR:  permission denied to create database at
> LedgerSMB/Database.pm line 413.
> DBD::Pg::db do failed: ERROR:  permission denied to create database at
> LedgerSMB/Database.pm line 413.
> Compilation failed in require at /usr/share/ledgersmb/setup.pl line 8.
> [Mon Nov 12 18:45:22 2012] [error] [client 127.0.0.1] Premature end of
> script headers: setup.pl, referer: http://127.0.0.1/ledgersmb/setup.pl
> [Mon Nov 12 18:45:22 2012] [error] [client 127.0.0.1] File does not
> exist: /var/www/favicon.ico
> ########
>
> I have checked my PgSQL server is hosting two databases: ledgersmb and postgres.
> Both seem to be empty.
> I attach here two screenshots for the above steps.
> This is why I was not installing the DEB packege. Apart of the fact
> that it's slightly outdated.
>
> Any further idea?

Soem extra details.
I rised the log level of PgSQL. I found this:

2012-11-12 19:04:32 CET ERROR:  permission denied to create database

This could be the root cause of my issues.