On 2 Mar 2019 at 21:07, Jaromir Talir wrote:
> ...
> As mentioned in installation guide where there is fred-dbmanager call
> for installation fred db schemar, you should run this tool with
> postgres user i.e.:
> su - postgres -c "/usr/sbin/fred-dbmanager upgrade"
> ...
Jaromir,
I did a DROP on the old fred database, a CREATE fred database, restored the FRED
database from our .mw registry dump and then run this command as you recommended to
upgrade as you can see here below
This command fails earlier on the list of upgrade SQL files with the following error:
[root@ngoli2 paulos]#
[root@ngoli2 paulos]# su - postgres -c "/usr/sbin/fred-dbmanager upgrade"
/usr/sbin/fred-dbmanager: line 225: /tmp/aaa: Permission denied
2.15.0-2.16.0-ddl.sql Failed (check /tmp/aaa)
[root@ngoli2 paulos]#
[root@ngoli2 paulos]# cat /tmp/aaa
psql: FATAL: role "root" does not exist
[root@ngoli2 paulos]#
What next can I or should I do ?
Regards,
Paulos
======================
Dr Paulos B Nyirenda
NIC.MW & .mw ccTLD
http://www.registrar.mw
On 2 Mar 2019 at 21:07, Jaromir Talir wrote:
> On Sat, 2019-03-02 at 16:10 +0200, Dr P Nyirenda wrote:
> > On 15 Feb 2019 at 19:42, Jaromir Talir wrote:
> >
> > > Hi,
> > >
> > > we have updated documentation with currently available OS versions
> > > which are Ubuntu 16.04, CentOS/RHEL 7, Fedora 28 and 29. I just
> > > uploaded RPM packages fro CentOS/RHEL/Fedora and tested
> > > installation
> > > for this OS is working fine:
> > > https://fred.nic.cz/documentation/html/AdminManual/Installation/BinsFedora.html
> > >
> > > These RPMs contain fix for the issue mentioned by Paulos.
> >
> > We at the Malawi .mw registry have tested this FRED installation on
> > Fedora 29. The basic
> > installation went well without any errors and the FRED registry
> > servers started well without
> > any problems with successful operations for both web interfaces for
> > admin and whois
>
> Thanks a lot for testing installation and confirmation it's working.
>
> > However, when we tried to load out registry configuration and
> > database we faced 2 problems
> > as follows:
> >
> > 1. httpd failed to reload complaining about a read denied AVC error
> > on certificate files in
> > /usr/share/fred-mod-eppd/ssl - a search on this error showed that it
> > was being caused by
> > selinux - the error went away when we set selinux to permissive
>
> I believe that you should be able to fix this even without disabling
> selinux. You can try this command:
> semanage fcontext -a -t httpd_sys_content_t "/usr/share/fred-mod-eppd/ssl(/.*)?"
>
> > 2. fred-dbmanager upgrade failed at
> > 2.34.0-2.35.0-02-superuser-dump-table.sql Failed (check /tmp/aaa)
> > and
> > # cat /tmp/aaa
> > gives
> > psql: FATAL: role "root" does not exist
> >
> > It would be great if NIC.CZ could finalise the database upgrade phase
> > so that we can load
> > our database successfully.
>
> As mentioned in installation guide where there is fred-dbmanager call
> for installation fred db schemar, you should run this tool with
> postgres user i.e.:
> su - postgres -c "/usr/sbin/fred-dbmanager upgrade"
>
> Regards,
> Jaromir
>
> > I hope this helps.
> >
> > Regards,
> >
> > Paulos
> > ======================
> > Dr Paulos B Nyirenda
> > NIC.MW & .mw ccTLD
> > http://www.registrar.mw
> >
> >
> > > There is a small issue with configuration of one package for Ubuntu
> > > that will be resolved at the beginning of next week. I will post
> > > more
> > > information about this FRED version after Ubuntu installation is
> > > without issues.
> > >
> > > Regards,
> > > Jaromir
> > >
> > > On Mon, 2019-02-11 at 10:12 +0200, Dr P Nyirenda wrote:
> > > > On 7 Feb 2019 at 15:23, Johan Olsson wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > I want to install FRED but would like some guidance when it
> > > > > comes to which Linux Distro I
> > > > > should use.
> > > > >
> > > > > According to the documentation I could use Ubuntu 16.04 LTS
> > > > > (Xenial Xerus), Fedora 24, Fedora
> > > > > 25, RHEL 7 or CentOS 7 but if I don´t have any special
> > > > > preferences which one is most fitting for
> > > > > the latest stable version of FRED?
> > > > >
> > > > > Would be eternally thankful if any helpful soul could point
> > > > > me
> > > > > in the right direction.
> > > >
> > > > At the Malawi .mw registry we are running FRED on the Fedora
> > > > Linux
> > > > platform since 2015
> > > > and so far it is working very well.
> > > >
> > > > However, we have faced a few issues upgrading to Fedora 28 where
> > > > the
> > > > current FRED
> > > > repository package is giving error during installation and
> > > > operation,
> > > > the database upgrade
> > > > script gives errors, uwsgi crashes etc ... it seems NIC.CZ needs
> > > > to
> > > > resolve a few issues for
> > > > this platform.
> > > >
> > > > We received indications from NIC.CZ that these would be resolved
> > > > by
> > > > end of this month but
> > > > we are yet to get an update.
> > > >
> > > > Regards,
> > > >
> > > > Paulos
> > > > ======================
> > > > Dr Paulos B Nyirenda
> > > > NIC.MW & .mw ccTLD
> > > > http://www.registrar.mw
> > > > http://www.nic.mw
> > > >
> > > > > Best regards
> > > > > Johan Olsson
> > > > >
> > > >
> > > > ---
> > > > This email has been checked for viruses by AVG.
> > > > https://www.avg.com
> > > >
> > > >
> > >
> > > _______________________________________________
> > > fred-users mailing list
> > > fred-users@lists.nic.cz
> > > https://lists.nic.cz/cgi-bin/mailman/listinfo/fred-users
> >
> >
--
This message has been scanned for viruses and
dangerous content by
MailScanner, and is
believed to be clean.
