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

Re: Install 1.3.15 on Centos 6, and upgrade from 1.2 question

On Tue, 24 Apr 2012 19:06:37 +0200
Håvard Sørli wrote:

> Witch user do you try to login with?
> postgres ?


> This is from the ledgersmb.spec file:  Can you do this:
> 38 	To finalize the ledgersmb installation:
> 39 	
> 40 	Enable local password autentication in PosgreSQL, leaving ident 
> login for the
> 41 	postgres user:
> 42 	- Start PostgreSQL to create database instance (service postgres
> start) 43 	- Let /var/lib/pgsql/data/pg_hba.conf start with:
> 44 	local all postgres ident sameuser

ident sameuser doesn't work with postgresql 8.4 as shown on this webpage:


It is my understanding that simply using "ident" alone is now the correct way
to accomplish this.

However, in an attempt to eliminate problems on that end I have made everything
"trust" as follows:

local   all     postgres                trust
local   all     all                     trust
host    all     postgres        ::1/128         trust
host    all     all    trust
host    all     all     ::1/128         trust

I have also removed the ipv6 line from /etc/hosts that started with

::1         localhost localhost.localdomain servername

leaving just the line, thinking that maybe having two
localhost.localdomain lines might be confusing things and I'm not using ipv6
anyway.  It didn't solve any problems or change anything, though.

> 49 	- log in via psql, ALTER USER postgres WITH PASSWORD 'yada';

I have run and re-run that line numerous times.  I always get the response
ALTER ROLE so I assume that it worked.

This is the process that I've been using to do this:

# su postgres
bash-4.1$ psql
could not change directory to "/home/frankcox"
psql (8.4.9)
Type "help" for help.

postgres=# ALTER USER postgres WITH PASSWORD 'yada';

> If that do not work create a new db admin user with psql and give it a 
> password.
> Follow the "Technical solution:" in this guide:
> Login to several companies with one user?
> http://www.ledgersmb.org/node/468533

# su postgres
bash-4.1$ psql
could not change directory to "/home/frankcox"
psql (8.4.9)
Type "help" for help.

postgres=# ALTER USER postgres WITH PASSWORD 'yada';
postgres=# CREATE USER ledgersmbdbadm WITH superuser password 'somepassword';
postgres=# CREATE USER your_100_db_user_name WITH password 'somepassword';

After this, going to localhost/ledgersmb/setup.pl and entering ledgersmbdbadm
in the Super-user login window, somepassword the password window, and testing
in the database window very quickly flashes a "would you like to save this
password" window that I assume is generated by firefox, and it goes away on its
own in less than a second, to be replaced by the firefox "A username and
password are being requested by localhost..." popup window.

I'm wondering if I have a problem in the httpd.conf file that's causing the
password entry to be mis-directed somehow.

> > selinux is disabled.
> When you get LedgerSMB up an running, can you help us to get the right 
> SELinux settings in to the .rpm? (audit2allow )

What I'm thinking that I would like to do here is to get the program going and
find out why it hasn't been working.  After that I will re-format the computer
and do a new install of Centos 6 on it again, then install ledgersmb on it while
writing a short article documenting every step.  I would like to do this both
for my own future reference (if I have to set this up again at some point) and
also to help others who want install it on Centos 6.  I really don't like stuff
that's a one-shot "I have no idea why this is working" thing, so I want to nail
an exact procedure down, which is why I plan to set it up all over again once
I've got it working the first time while I still have some idea of how it works.

I've never used audit2allow before, but as part of this process I can certainly
give it a try.  This time around I set selinux to disabled to eliminate that
completely as the reason why this isn't working.

I'll be pleased to do what I can to contribute to this project.

> > I installed ledgersmb-1.3.15-1.noarch.rpm that I downloaded from the website
> No errors in the install process ?  All dependencies installed ?

Yum didn't report any errors on the console when I did the installation.

No problems reported in /var/log/yum.log:

Apr 18 17:43:03 Installed: perl-Class-Std-0.0.8-5.el6.noarch
Apr 18 17:43:04 Installed: perl-Config-Std-0.900-1.el6.rf.noarch
Apr 18 17:43:04 Installed: perl-Smart-Comments-1.0.4-1.el6.rf.noarch
Apr 18 17:45:01 Installed: perl-Params-Validate-0.92-3.el6.x86_64
Apr 18 17:45:02 Installed: perl-DBI-1.609-4.el6.x86_64
Apr 18 17:45:03 Installed: perl-IO-Compress-Base-2.020-119.el6_1.1.x86_64
Apr 18 17:45:03 Installed: perl-IO-String-1.08-9.el6.noarch
Apr 18 17:45:04 Installed: perl-URI-1.40-2.el6.noarch
Apr 18 17:45:04 Installed: perl-File-BaseDir-0.03-1.el6.rf.noarch
Apr 18 17:45:05 Installed: perl-Compress-Raw-Zlib-2.023-119.el6_1.1.x86_64
Apr 18 17:45:05 Installed: perl-List-MoreUtils-0.22-10.el6.x86_64
Apr 18 17:45:06 Installed: perl-IO-Compress-Zlib-2.020-119.el6_1.1.x86_64
Apr 18 17:45:06 Installed: perl-Compress-Zlib-2.020-119.el6_1.1.x86_64
Apr 18 17:45:07 Installed: perl-File-DesktopEntry-0.04-1.el6.rf.noarch
Apr 18 17:45:07 Installed: perl-File-MimeInfo-0.15-1.el6.rf.noarch
Apr 18 17:45:08 Installed: perl-DBD-Pg-2.15.1-3.el6.x86_64
Apr 18 17:45:09 Installed: perl-Math-BigInt-GMP-1.24-5.el6.x86_64
Apr 18 17:45:09 Installed: perl-YAML-Syck-1.07-4.el6.x86_64
Apr 18 17:45:11 Installed: perl-Date-Manip-6.24-1.el6.noarch
Apr 18 17:45:12 Installed: 1:perl-TimeDate-1.16-11.1.el6.noarch
Apr 18 17:45:12 Installed: perl-MailTools-2.04-4.el6.noarch
Apr 18 17:45:13 Installed: perl-CGI-Simple-1.113-1.el6.noarch
Apr 18 17:45:13 Installed: perl-IO-stringy-2.110-10.1.el6.noarch
Apr 18 17:45:14 Installed: perl-Email-Date-Format-1.002-5.el6.noarch
Apr 18 17:45:14 Installed: perl-HTML-Tagset-3.20-4.el6.noarch
Apr 18 17:45:15 Installed: perl-HTML-Parser-3.64-2.el6.x86_64
Apr 18 17:45:15 Installed: perl-libwww-perl-5.833-2.el6.noarch
Apr 18 17:45:16 Installed: perl-XML-Parser-2.36-7.el6.x86_64
Apr 18 17:45:16 Installed: perl-Params-Util-1.00-3.el6.x86_64
Apr 18 17:45:19 Installed: dejavu-lgc-sans-mono-fonts-2.30-2.el6.noarch
Apr 18 17:45:20 Installed: rrdtool-1.3.8-6.el6.x86_64
Apr 18 17:45:20 Installed: rrdtool-perl-1.3.8-6.el6.x86_64
Apr 18 17:45:21 Installed: perl-MIME-Types-1.28-2.el6.noarch
Apr 18 17:45:21 Installed: perl-MIME-Lite-3.027-2.el6.noarch
Apr 18 17:45:22 Installed: perl-Class-Singleton-1.4-6.el6.noarch
Apr 18 17:45:23 Installed: 1:perl-DateTime-0.5300-1.el6.x86_64
Apr 18 17:45:24 Installed: perl-Clone-0.31-3.1.el6.x86_64
Apr 18 17:45:25 Installed: perl-PPI-1.206-4.el6.noarch
Apr 18 17:45:25 Installed: perl-Pod-POM-0.25-2.el6.noarch
Apr 18 17:45:25 Installed: perl-XML-RegExp-0.03-7.el6.noarch
Apr 18 17:45:26 Installed: perl-XML-DOM-1.44-7.el6.noarch
Apr 18 17:45:26 Installed: perl-Mail-Sendmail-0.79-12.el6.noarch
Apr 18 17:45:27 Installed: 1:perl-Error-0.17015-4.el6.noarch
Apr 18 17:45:27 Installed: perl-Mail-Sender-0.8.16-3.el6.noarch
Apr 18 17:45:28 Installed: perl-Log-Dispatch-2.27-1.el6.noarch
Apr 18 17:45:28 Installed: perl-Log-Dispatch-FileRotate-1.19-4.el6.noarch
Apr 18 17:45:29 Installed: perl-Log-Log4perl-1.30-1.el6.noarch
Apr 18 17:45:30 Installed: perl-YAML-0.70-4.el6.noarch
Apr 18 17:45:30 Installed: perl-AppConfig-1.66-6.el6.noarch
Apr 18 17:45:31 Installed: perl-Template-Toolkit-2.22-5.el6.x86_64
Apr 18 17:45:32 Installed: perl-Locale-Maketext-Lexicon-0.82-1.el6.noarch
Apr 18 17:45:33 Installed: ledgersmb-1.3.15-1.noarch
Apr 18 17:46:13 Installed: djvulibre-3.5.22-1.el6.rf.x86_64

> example:
> rpm -q perl-Error
> should return version number

# rpm -q perl-Error

MELVILLE THEATRE ~ Real D 3D Digital Cinema ~ www.melvilletheatre.com

Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Ledger-smb-users mailing list