2012/11/12 Vincenzo Romano <vincenzo.rom...@notorand.it>: > 2012/11/10 Robert J. Clay <rjc...@gmail.com>: >> On Sat, Nov 10, 2012 at 11:05 AM, Vincenzo Romano >> <vincenzo.rom...@notorand.it> wrote: >>> 2012/11/10 Robert J. Clay <rjc...@gmail.com>: >>>> 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. ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_nov _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
