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 ----- Best Regards, Jan Horak CEO, Gransy s.r.o. ICANN Accredited Registrar

On 5 Jun 2020 at 15:14, Mark Elkins wrote: We at the .mw registry are happy with FRED, so, if possible may be you could finalise writing your EPP client system to accommodate FRED. You can also use the open testing environment at https://www.nic.cz/page/744/registration-system/ You can then may be allow others to use or access your system. This is similar to what we are encouraging our registrars in Malawi to do but they are finding this tough going even after introducing them to fred-client 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 On 5 Jun 2020 at 15:14, Mark Elkins wrote: > I agree. Once a Registrar has more than say 50 domains - they really > ought to invest into some sort of management system. This makes it > easier for them to potentially delegate control of services to their > clients (for the more adventurous clients). Sneakily - this off-loads > the support that Registrars need to supply. Systems like C-Panel > provide a lot of this functionality (might need an EPP module for FRED > - which I've found to have a different flavour of EPP). I presume if > one searches around - there may be free versions of software like > C-Panel. Perhaps others can comment? > > Registrars should find a system that caters for multiple, different > EPP dialects (for .africa, Cocca - etc). They can then properly > support the hosting of domains, e-mail, web sites - etc. It always > pains me when I hear comments like - I don't trust my ccTLD, I prefer > to use Gmail. > > Personally, I wrote my own system (https://vweb.co.za) years ago > before C-Panel existed. It supports most EPP Registry systems - except > for FRED. I started adding FRED but gave up as its EPP is somewhat > different and I had no customers looking for FRED based domains. It > also supports DNSSEC, SSL Certificates (automated with Let's Encrypt), > DANE and IDN (non-ascii) Domain names (Universal acceptance). > > > On 2020/06/05 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 > > ----- > 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 > > > > > _______________________________________________ > fred-users mailing list > fred-users(a)lists.nic.cz > https://lists.nic.cz/mailman/listinfo/fred-users > > -- > > Mark James ELKINS - Posix Systems - (South) Africa > mje(a)posix.co.za Tel: +27.826010496 > For fast, reliable, low cost Internet in ZA: https://ftth.posix.co.za -- This email has been checked for viruses by AVG. https://www.avg.com

Hello, In FRED is perfect that have EPP function for this (ofc available via CLI) If you want provide CSV to FTP or in your webinterface to registrars, you can generate it directly from SQL :) ----- Best Regards, Jan Horak CEO, Gransy s.r.o. ICANN Accredited Registrar

On 08.06.2020 12:11, Dr P Nyirenda 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