fred-users

fred-users@lists.nic.cz

413 discussions

Re: help with mail_template database backup problem

by Jaromir Talir

Hi Paulos, if you are doing restore of database, you should probably do this into empty database or if you have "create database" as part of dump, you can remove database at the destination system completely. Regards, Jaromir On Tue, 2021-03-23 at 10:28 +0200, Dr Paulos Nyirenda wrote: > On 19 Mar 2021 at 14:06, Jaromir Talir wrote: > > > Hi Paulos, > > > > I'm not sure if I got it right. There are two scenarios: > > > > 1/ You do DUMP + RESTORE and information in restored tables is > > different than in original table. > > > > This would be weird. I can only imagine that DUMP failed or was > > incomplete but otherwise there should be no issue > > This is the issue. When we do a DUMP and RESTORE, the mail_template > on the system on > which we do a restore remains the same, it is not updated from the > restore in the DUMP. > > As such we have to manually edit it again to get it updated. > > > 2/ You do DUMP + modification + RESTORE and modification is not in > > restored tables. > > We do not do a modification after doing the DUMP. > > > This is also correct since modifications are not included in DUMP. > > I > > suggest to make backup via DUMP after modification of those tables. > > After a bit of reading and when I get the time, I am now going to try > to do a data only dump of > the mail_template table with the data that we want and then see if I > canm restore that data > only after the restore using the aproach suggested in the attached > advice, would that work ? > > Regards, > > Paulos > ============================= > Dr Paulos B Nyirenda > NIC.MW & .mw ccTLD > http://www.nic.mw > SDNP: http://www.sdnp.org.mw > Tel: +265-(0)-882 089 166 > Cell: +265-(0)-888-824787 > WhatsApp: +265-(0)-887386433 > > > > > > Regards, > > Jaromir > > > > On Thu, 2021-03-18 at 15:39 +0200, Dr Paulos Nyirenda wrote: > > > > > > Good afternoon, > > > > > > I am having trouble maintaing my English version of mail_template > > > table in the FRED database backup and restore, can you help ? > > > > > > I often need to backup the FRED registry system database and I am > > > using > > > #pg_dump -U fred fred > fred-backup-file.sql > > > > > > To restore that database I use > > > #sudo -u postgres psql > > > #DROP DATABASE fred; > > > #CREATE DATABASE fred; > > > #\q > > > #psql -U fred -d fred -f fred-backup-file.sql > > > > > > However, I find in almost all cases that I lose any updates that > > > I > > > made on mail_template table when I restore this way on the new > > > restoration. > > > > > > Is there a way that I can keep the most resent mail_template > > > updates > > > between backup and restore? > > > > > > I have tried to save the mail_template using a dump like > > > #pg_dump -U fred fred -t mail_template > fred-mail_template- > > > bkp.sql > > > but I am unable to restore this because I get the error that > > > there > > > are too many dependencies on mail_template when I try to drop the > > > table and then use pg_restore -t. > > > > > > So, what is the best way of moving with my desired mail_template > > > in > > > FRED? > > > > > > Can I do this even between different schemas of backup and > > > restore ? > > > > > > Regards, > > > > > > Paulos > > > ============================= > > > Dr Paulos B Nyirenda > > > NIC.MW & .mw ccTLD > > > http://www.nic.mw > > > SDNP: http://www.sdnp.org.mw > > > Tel: +265-(0)-882 089 166 > > > Cell: +265-(0)-888-824787 > > > WhatsApp: +265-(0)-887386433 > > > > > > > > > > > > > The following section of this message contains a file attachment > prepared for transmission using the Internet MIME message format. > If you are using Pegasus Mail, or any other MIME-compliant system, > you should be able to save it or view it from within your mailer. > If you cannot, please ask your system administrator for assistance. > > ---- File information ----------- > File: postgreSQL-backup and restore-table-data- > makandracards.pdf > Date: 18 Mar 2021, 16:58 > Size: 285252 bytes. > Type: Unknown

5 let, 7 měsíců

.BA uses FRED

by Zdeněk Brůna

Dear FRED users! We are excited to welcome another registry in our "FRED family". The national domain registry of Bosnia and Herzegovina started using FRED at the beginning of this year and handled the transition very smoothly. We would also like to use this opportunity to invite all the other FRED users who have not yet informed us that they are using FRED to let us know. It would be great to know about their experience and add another red point to the map on https://fred.nic.cz/en/. Kind regards, Zdenek Bruna. -- Zdeněk Brůna technický ředitel / Chief Technical Officer ------------------------------------------- CZ.NIC, z.s.p.o. -- .cz domain registry Milešovská 5, 130 00 Praha 3, Czech Republic mailto:zdenek.bruna@nic.cz https://nic.cz/ -------------------------------------------

5 let, 7 měsíců

will updating SSL break FRED ?

by Dr P Nyirenda

Hello, One of our treasured old machines needs TLS version upgraded particularly to avoid SMTP handshake failures that have started to crop up. This machine also runs FRED registry operations that we use for many activities like training, whois, invoicing, etc. I would hence really like to find out in advance if upgrading TLS version will break FRED. Will upgrading openssl break FRED ? Regards, Paulos ============================= Dr Paulos B Nyirenda NIC.MW & .mw ccTLD http://www.nic.mw SDNP: http://www.sdnp.org.mw Tel: +265-(0)-882 089 166 Cell: +265-(0)-888-824787 WhatsApp: +265-(0)-887386433 -- This email has been checked for viruses by AVG. https://www.avg.com

5 let, 7 měsíců

FRED installation over Ubuntu 18.04 or 20.04

by Kelvin Truong

Happy new year everyone, We have been successfully developing FRED 2.40.3 over Ubuntu 16.04 which is the documented deployment libraries’ OS requirement. For our final deployment, we are looking at the possibility of deploying over a higher version of Ubuntu (either 18.04 or 20.04) because Ubuntu 16.04 is scheduled for EOL in April 2021. (https://ubuntu.com/about/release-cycle). Before we go down the hairy path of testing internally, we would like to know if any issues have been reported about installing FRED over Ubuntu 18.04 or 20.04? Or if anyone can testify that it has worked for them? Thanks and regards, Kelvin

5 let, 9 měsíců

New FRED 2.42 release

by Miroslav Jindra

Dear FRED users, we are happy to announce that a new version of the FRED system (2.42) has been released. You can find information about the release at the FRED website <https://fred.nic.cz/en/news/version-2-42-released/> or more details in the release notes <https://fred.nic.cz/documentation/html/ReleaseNotes/releases-2-42.html>. Yours Sincerely, the FRED team -- Miroslav Jindra Technical Writer CZ.NIC, z. s. p. o. Milešovská 1136/5 130 00 Praha 3

5 let, 10 měsíců

past credit balance query from a registrar

by Dr P Nyirenda

Hello, Hope this finds you well in these troubled times. We have a persistent request from a registrar asking us to "confirm what our balance was on the 1st of December 2019" ... about 12 montsh ago. We have repeatedly told the registrar that by the nature of EPP transactions on a registry running FRED, we do not keep such balances on the registry on a day to day basis except in regular backups of the database. I would like to hear what you think about such a request from a registrar which connects to a registry running the FRED registry system and how you would respond to it. Is there an easier way of dealing with such a request other than by remounting a whole FRED database on a test server from a previous FRED backup of that date ? Remounting a FRED database backup is a major task and we have told them that if they insist then we would raise a fee or charge for it. Any help? Regards, Paulos ============================= Dr Paulos B Nyirenda NIC.MW & .mw ccTLD http://www.nic.mw SDNP: http://www.sdnp.org.mw Tel: +265-(0)-882 089 166 Cell: +265-(0)-888-824787 WhatsApp: +265-(0)-887386433 -- This email has been checked for viruses by AVG. https://www.avg.com

5 let, 11 měsíců

FRED in Docker perhaps?

by Piotr Przybył

Hello FRED team I've skimmed the FRED docs and AFAICT there's no distribution in form of Docker image(s). Does anyone have plans "dockerizing" FRED? (Please don't get me wrong, I'm not trying to make any sort of pressure that anyone has to do something, I'm just asking and that's it.) Thank you Piotr

6 let, 3 měsíce

help test - GDPR compliance test phase on .mw domains - invitation

by Dr P Nyirenda

.mw Registrar, GDPR compliance test phase on .mw - invitation ======================================== I am pleased to advise that the Malawi .mw ccTLD registry on FRED has started a test phase for compliance on GDPR compliance for all and we would like to invite you to assist us to test. We have now mounted a test server to handle both EPP and WHOIS on ngoli3.sdnp.org.mw that you can test right away. A WHOIS query for any of your existing domains will show that we are now hiding details on the e-mail, phone, fax and other details while showing name, organisation, address, DNS servers. The database on the test server is that of 24 July 2020. You can compare the following: 1. Current WHOIS at: http://www.registrar.mw/whois-intro.php 2. Current command line WHOIS: $whois domains.mw -h ngoli.sdnp.org.mw 3. GDPR compliant test : http://ngoli3.sdnp.org.mw/whois 4. GDPR compliant command line test: $whois domains.mw -h ngoli3.sdnp.org.mw You can also test creating a new contact using EPP and you will find that the default is "hide" on the above details and it is up to the registrar to toggle this to "disclose" as needed. Please make sure that your EPP client is capable of handling the .mw GDPR complaint environment as you continue to conduct your business using the .mw registry. We will have this test phase running for at least two week from 1 August 2020 after which we will make a decision to move this test phase to the production environment. All modifications that you make on the test environment will be deleted and lost from ngoli3 at the end of the test phase, so, you can test as much as you need to without charge. Please let me know if you face any problems using the new GDPR compliant test .mw registry on EPP, WHOIS or any other service. These steps are very important to us. Regards, Dr Paulos B Nyirenda NIC.MW & .mw ccTLD http://www.nic.mw Tel: +265-(0)-882 089 166 Cell: +265-(0)-888-824787 WhatsApp: +265-(0)-887386433 -- This email has been checked for viruses by AVG. https://www.avg.com

6 let, 3 měsíce

HOW : query from registrar asking registry to list domains with expiry dates

by Dr P Nyirenda

Hello, As our list of registrars has grown, we are regularly getting a request from a registrar to "Please send me a list of domains under our registrar account with their expiry dates" As a registry using FRED registry, how do you handle such requests? We have so far just directed them to use the command list_domains under fred-client BUT we would like to here if others are handling this in a different or better way. Many of our new registrars are at the point of learning how to be a good registrar and so they often ask us for help like this. Regards, Paulos ====================== Dr Paulos B Nyirenda NIC.MW & .mw ccTLD http://www.registrar.mw Tel: +265-(0)-882 089 166 Cell: +265-(0)-888-824787 WhatsApp: +265-(0)-887386433 -- This email has been checked for viruses by AVG. https://www.avg.com

6 let, 4 měsíce

Domains Stuck at "To be deleted"

by Moeketsi Maphoi

Hi everyone, Our domains that expired in February and March are stuck in "to be deleted" state, they never get deleted. On manual deletion or renewal the output is: Error: ObjectStatusProhibitsOperation Manual run of '/usr/sbin/fred-admin --object_regular_procedure' executes but doesn't give any output. Zones are still being generated with such 'to be deleted' domains excluded. The timezone is set to UTC in postregsql.conf Enum_parameters are as follows: expiration_notify_period -30 expiration_dns_protection_period 30 expiration_letter_warning_period 34 validation_notify1_period -30 validation_notify2_period -15 regular_day_procedure_period 0 object_registration_protection_period 6 handle_registration_protection_period 0 regular_day_outzone_procedure_period 14 outzone_unguarded_email_warning_period 25 enum_validation_continuation_window 14 regular_day_procedure_zone Africa/Johannesburg expiration_registration_protection_period 61 What could be the cause of this? Regards. Moeketsi

6 let, 6 měsíců

← Newer
1
...
5
6
7
8
9
10
11
...
42
Older →

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

fred-users