8 Čen
2020
8 Čen
'20
12:21
On 08.06.2020 12:11, Dr P Nyirenda wrote:
On 8 Jun 2020 at 11:31, Jan Horak wrote:
One of the possible options is to have a dedicated DB user with only SELECT granted. Then
this user
account could be used to run a SQL script executed by cron and the results could be
e-mailed to the
registrars as a CSV attachment. Could be FTP as well.
It's not about giving registrars access to PostgreSQL, it's only about giving them
access to the
results of a crafted script.
If really needed. Because I still think they should be doing that using EPP and keep the
records of
their domains.
Thank you
Piotr
Hello,
In FRED is perfect that have EPP function for this (ofc available via CLI)
As we have been moving from 2R to 3R at .mw we already know and use CLI to generate
such data ... we even have scripts that do this ... but my query was whether we should be
doing this for registrars ... I was looking for a best practice
If you want provide CSV to FTP or in your
webinterface to registrars,
The way I understand FRED, there is no web interface for registrars or is there an update
that I have missed, is there ?
you can generate it directly from SQL :)
How ... show an SQL command ?
I know that SQL is the ultimate hack for the FRED database but it appears not to be a
safe
way to run the registry, and, registrars do not and should not have access to SQL on the
registry, should they?
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
-----
Best Regards, Jan Horak
CEO, Gransy s.r.o.
ICANN Accredited Registrar
8. 6. 2020 v 10:56, Dr P Nyirenda
<paulos(a)sdnp.org.mw>mw>:
On 5 Jun 2020 at 14:35, Jan Horak wrote:
Hello,
If i´m correct FRED is only one registry software what has function
for get list domains via EPP extension - its a very simply for any
automation.
Other registries (mainly gtld, cocca based, etc .) provide data in CSV
or table under registrar GUI, or they do export to FTP accounts for
registrars (Verisign, Afilias, ..) by our experiences
Mmmm ... so this is certainly useful for registrars ... is it ?
May be we could recommend that the developers of FRED could consider including this as a
revision in their next release.
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
-----
Best Regards, Jan Horak
CEO, Gransy s.r.o.
ICANN Accredited Registrar
> 5. 6. 2020 v 14:00, Piotr Przybyl <piotr(a)przybyl.org>rg>:
>
> On 05.06.2020 13:49, Dr P Nyirenda wrote:
>>
>> 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.
>>
>
> Hello
>
> I'd go one step back and ask about the roles and responsibilities of the registry
and the registrars.
> IMHO the registry is not the database for the registrars. They should be handling
their books
> properly. And if they fail to do so, they can always use the mentioned solution, plus
info command.
> Or even whois...
>
> Unless they keep their records in real paper books/notepads, not a DB.
> In my perception FRED is about automation, introducing technology and automation, but
others might
> see things in a different way. EPP was created for a reason...
>
> Thank you
> Piotr
> _______________________________________________
> fred-users mailing list
> fred-users(a)lists.nic.cz
> https://lists.nic.cz/mailman/listinfo/fred-users
--
This email has been checked for viruses by AVG.
https://www.avg.com