Re: postgresql settings in fedora 18? The power of logic!

[ario <..hidden..>]

On Thu, 5 Dec 2013 06:13:39 -0800
Chris Travers <..hidden..> wrote:

> On Thu, Dec 5, 2013 at 5:58 AM, ario <..hidden..>
> wrote:
> 
> > This is strange!
> > While I was reasoning in my other reply to turtle, I noticed that
> > the file /etc/httpd/conf.d/ledgersmb.conf doesn't contain any
> > indication of what to do with a request on port 5432, but does have
> > rewrite rules for /ledgersmb to /ledgersmb/login.pl
> > So I thought: "Let's do something unexpected and see what a request
> > for ledgersmb/ does on port 80."
> > And YES: I get in the login page with
> > http://127.0.0.1:80/ledgersmb !!
> >
> > I think the remark in /var/lib/pgsql/data/postgresql.conf:
> > #port = 5432                            # (change requires restart)
> > # Note: In RHEL/Fedora installations, you can't set the port number
> > here;
> > # adjust it in the service file instead.
> >
> > should be taken seriously.
> > Leaves me with the question: what the h... (heck, I mean :) ) do
> > 'they' mean by 'service file'??
> >
> 
> The service file is the file that systemd reads before starting the
> service: /usr/lib/systemd/system/postgresql.service

That's odd, it says:
# Port number for server to listen on
Environment=PGPORT=5432

# Location of database directory
Environment=PGDATA=/var/lib/pgsql/data

> 
> >
> > Anyway, I leave the rest of the debugging magic to the developers
> > and will try to see if I can get the password straightened out.

By the way, is there a default password for the postgres user?

regards,
ario


> >
> > regards,
> > ario
> >
> > P.S. Due to my migration from KVM to Qubes-OS I won't be able to
> > run a CentOS instance anymore, which means that unfortunately I
> > won't be able to submit any CentOS rpm rebuilds anymore. Sorry
> > about that.
> >
> 
> No problem.  I think we are going to start working on real Fedora
> RPM's (hopefully getting into extras, etc) fairly soon in the hopes
> that we can get into RHEL directly that way.
> 
> Best Wishes,
> Chris Travers
> 
> >
> >
> >
> >
> > On Thu, 5 Dec 2013 02:52:34 +0000
> > ario <..hidden..> wrote:
> >
> > > Hi, trying to get it working.
> > >
> > > I found a postgresql.conf file in three directories:
> > > /usr/lib/tmpfiles.d/postgresql.conf
> > > /usr/share/pgsql/postgresql.conf.sample
> > > /var/lib/pgsql/data/postgresql.conf
> > >
> > > I guess I don't have to bother about the first one.
> > > The presence of the second (.sample) one suggests this file needs
> > > to be copied (to postgresql.conf) within the same dir and edited
> > > properly.
> > >
> > > Which one is finally used by pgsql,
> > > the /usr/share/pgsql/postgresql.conf or
> > > the /var/lib/pgsql/data/postgresql.conf one?
> > >
> > >
> > >
> > > Especially the 'listen to' entry asks for attention here, as it
> > > says:
> > >
> > > #port = 5432                          # (change requires
> > > restart) # Note: In RHEL/Fedora installations, you can't set the
> > > port number here; # adjust it in the service file instead.
> > >
> > > As this is a fedora install I would need to know what 'they' mean
> > > by 'service file'.
> > >
> > >
> > > Was the postgresql.conf file not assumed to be configured during
> > > ledgersmb install? In that case something would have gone wrong
> > > there.
> > >
> > >
> > > regards,
> > > ario
> > >
> > >
> > >
> > >
> > ------------------------------------------------------------------------------
> > > Sponsored by Intel(R) XDK
> > > Develop, test and display web and hybrid apps with a single code
> > > base. Download it for free now!
> > >
> > http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
> > > _______________________________________________
> > > Ledger-smb-users mailing list
> > > ..hidden..
> > > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> >
> >
> >
> > ------------------------------------------------------------------------------
> > Sponsored by Intel(R) XDK
> > Develop, test and display web and hybrid apps with a single code
> > base. Download it for free now!
> >
> > http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
> > _______________________________________________
> > Ledger-smb-users mailing list
> > ..hidden..
> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> >
> 
> 
> 


------------------------------------------------------------------------------
Sponsored by Intel(R) XDK 
Develop, test and display web and hybrid apps with a single code base.
Download it for free now!
http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users