Projet

Général

Profil

RIPE » Historique » Version 81

Sebastien Badia, 24/08/2015 21:06
howto DB du RIPE

1 2 Laurent GUERBY
{{>toc}}
2 2 Laurent GUERBY
3 1 Laurent GUERBY
h1. RIPE
4 1 Laurent GUERBY
5 63 Laurent GUERBY
h2. Devenir LIR
6 63 Laurent GUERBY
7 77 Sebastien Badia
tetaneutral.net doit devenir LIR pour récupérer son /22 = 1024 IPv4 et un /29 IPv6 (renuméroter et rendre a fullsave 2a01:6600:8000::/40)
8 63 Laurent GUERBY
9 1 Laurent GUERBY
Mail : [AIDE] Devenir LIR pour tetaneutral.net => 1024 IPv4 et	/29 IPv6
10 77 Sebastien Badia
* http://lists.tetaneutral.net/pipermail/technique/2015-August/001924.html
11 77 Sebastien Badia
12 81 Sebastien Badia
h3. HowTo
13 81 Sebastien Badia
14 77 Sebastien Badia
* HowTo d'Evolix (comment devenir LIR): http://trac.evolix.net/infogerance/wiki/HowtoRIPE
15 81 Sebastien Badia
* Gestion des objets dans la DB du RIPE: http://wikilulu.net/doku.php?id=tech:maintenance-whois
16 81 Sebastien Badia
* Billet de blog, intro à la DB du RIPE: http://www.guiguishow.info/2014/04/18/decouvrons-la-ripe-database/
17 66 Laurent GUERBY
18 67 Laurent GUERBY
Support RIPE :
19 67 Laurent GUERBY
20 63 Laurent GUERBY
* https://www.ripe.net/participate/member-support/info/faqs/faq-joining
21 63 Laurent GUERBY
* https://www.ripe.net/participate/member-support/become-a-member
22 63 Laurent GUERBY
* https://www.ripe.net/ripe/docs/service-agreement
23 63 Laurent GUERBY
* https://www.ripe.net/ripe/docs/charging
24 65 Laurent GUERBY
* https://www.ripe.net/participate/member-support/info/billing/billing-procedure-and-fee-schedule-2015
25 63 Laurent GUERBY
26 63 Laurent GUERBY
L'objectif est de documenter toute la procédure etape par etape pour les autres associations, incluant la demande IPv4 et la premiere allocation.
27 63 Laurent GUERBY
28 68 frederic zulian
Bénévoles :
29 68 frederic zulian
30 72 Matthieu Herrb
# Frédéric Zulian
31 72 Matthieu Herrb
# Hugo Simancas
32 72 Matthieu Herrb
# Matthieu Herrb
33 74 Raphaël Durand
# Solarus
34 72 Matthieu Herrb
# ...
35 1 Laurent GUERBY
36 73 Matthieu Herrb
Le formulaire de demande d'adhésion se présente en 6 parties: 
37 73 Matthieu Herrb
38 73 Matthieu Herrb
> Membership Application Form
39 73 Matthieu Herrb
> # Membership options
40 73 Matthieu Herrb
> # Organisation details
41 73 Matthieu Herrb
> # Billing information
42 73 Matthieu Herrb
> # Communication preferences
43 73 Matthieu Herrb
> # Public profile
44 73 Matthieu Herrb
> # Confirm
45 73 Matthieu Herrb
46 80 Raphaël Durand
Demande effectuée : Your application to join the RIPE NCC is now being processed. Your ticket number is NCC#2015083906.
47 80 Raphaël Durand
A confirmation was emailed to ripe-contact@tetaneutral.net.
48 80 Raphaël Durand
49 73 Matthieu Herrb
Voici en trois morceaux une copie d'écran de la partie "Organisation details"  du formulairee à remplir. Pas trop dur, mais il faut que Laurent fournisse le document d'enregistrement (SIRENE/SIRET). On ne peut pas avancer à la page suivante (infos bancaires) sans cela. 
50 1 Laurent GUERBY
51 79 Matthieu Herrb
--> Prevoir un atelier avec Laurent pour remplir le formulaire à plusieurs. Framadate: -https://framadate.org/hkw1uh1luzq73vre-
52 1 Laurent GUERBY
53 79 Matthieu Herrb
--> Atelier programmé lundi 24/8 à 19h30 chez Matthieu
54 79 Matthieu Herrb
55 75 Laurent GUERBY
attachment:lir-form-1.png
56 75 Laurent GUERBY
attachment:lir-form-2.png
57 75 Laurent GUERBY
attachment:lir-form-3.png
58 75 Laurent GUERBY
59 76 Laurent GUERBY
* Le SIRENE : attachment:tetaneutral-siret-20130129.pdf
60 76 Laurent GUERBY
* Le Mel : ripe-contact AT tetaneutral.net
61 1 Laurent GUERBY
* Le tel : +33 6 43 09 45 15
62 79 Matthieu Herrb
63 79 Matthieu Herrb
64 63 Laurent GUERBY
65 59 Laurent GUERBY
h2. Statistiques
66 59 Laurent GUERBY
67 59 Laurent GUERBY
statistiques allocations : http://pad.tetaneutral.net/p/ripe
68 59 Laurent GUERBY
69 1 Laurent GUERBY
1800 HT/an pour 1024 donc 0.18 EUR TTC/mois/IPv4 (avec x2 = 0.38 si tu amortis les 2000 HT en 1 an)
70 64 Laurent GUERBY
71 64 Laurent GUERBY
En 2015 : 1600 HT/an donc 0.15625 EUR TTC/mois/IPv4, setup a 2000 HT
72 59 Laurent GUERBY
73 60 Laurent GUERBY
http://www.ripe.net/internet-coordination/ipv4-exhaustion/ipv4-available-pool-graph
74 60 Laurent GUERBY
IPv4 : 24Sep2012 16.64e6 19May2014 13.54e6 07Jul2014 15.65e6
75 60 Laurent GUERBY
entre le 24sep2012 et 19may2014 ca fait 5200 IPv4 allouées/jour (602 jours) a ce rythme la reste ~ 3000 jours = 8 ans
76 60 Laurent GUERBY
77 61 Laurent GUERBY
http://www.potaroo.net/ispcol/2015-01/addressing2014.html
78 60 Laurent GUERBY
79 24 Laurent GUERBY
h2. IPv4
80 24 Laurent GUERBY
81 25 Laurent GUERBY
tetaneutral.net a actuellement un /23 PI IPv4, et arrive presque au bout, reste autour de 40-50 IPv4. Pour pouvoir continuer a etendre le reseau il nous faut des IPv4, on peut en obtenir via :
82 25 Laurent GUERBY
83 25 Laurent GUERBY
# Devenir membre du RIPE donc PA /22 (et /29 IPv6, possibilité de transferer le PI et l'AS depuis fullsave) : 2000 HT de frais acces = 2400 TTC (incluant 2x400 HT de ticket RIPE meeting qu'on peut eventuellement faire financer par des adherents) et 1800 HT/an soit 180 TTC/mois
84 24 Laurent GUERBY
# Demande de PA au LIR gitoyen /24 parent annoncé en BGP
85 24 Laurent GUERBY
# Demande de PA au LIR opdop  /24 parent non annoncé
86 24 Laurent GUERBY
87 1 Laurent GUERBY
Via un LIR : simple formalité administrative (extrait decla prefecture), autour de 100 a 200/an. Gitoyen serait content de faire des tests entre le parent et le /24 annoncé par ttnn.
88 24 Laurent GUERBY
89 25 Laurent GUERBY
Devenir LIR : mange un mois ou deux de tresorerie donc ralentissement ou gel des deploiements.
90 24 Laurent GUERBY
91 26 Laurent GUERBY
Avis des adhérent(e)s :
92 26 Laurent GUERBY
# TODO
93 26 Laurent GUERBY
94 55 Laurent GUERBY
h2. opdop
95 55 Laurent GUERBY
96 55 Laurent GUERBY
/23 alloué a tetaneutral.net, parent /18 non annoncé
97 55 Laurent GUERBY
98 62 Matthieu Herrb
Vendredi 13 juin 2014 a midi puis apres-midi 25 rue moufetard Paris organisé par Spyou
99 62 Matthieu Herrb
https://www.opdop.net/scic-statuts.pdf
100 62 Matthieu Herrb
https://www.opdop.net/scic-preambule.pdf
101 62 Matthieu Herrb
https://www.opdop.net/lir.php
102 55 Laurent GUERBY
103 57 Laurent GUERBY
http://lists.tetalab.org/pipermail/tetaneutral/2014-June/002353.html
104 57 Laurent GUERBY
105 55 Laurent GUERBY
Remarques
106 55 Laurent GUERBY
# Autre
107 55 Laurent GUERBY
108 58 Laurent GUERBY
Virement 50*8 = 400 EUR de parts sociales pour tetaneutral.net fait le 20140619
109 58 Laurent GUERBY
110 55 Laurent GUERBY
h2. gitoyen
111 55 Laurent GUERBY
112 55 Laurent GUERBY
/24 alloué a tetaneutral.net, parent annoncé
113 55 Laurent GUERBY
114 55 Laurent GUERBY
http://gitoyen.net
115 26 Laurent GUERBY
116 16 Laurent GUERBY
h2. API whois
117 16 Laurent GUERBY
118 21 Laurent GUERBY
https://labs.ripe.net/Members/mirjam/introducing-ripe-ncc-roadmap
119 16 Laurent GUERBY
https://labs.ripe.net/ripe-database/database-api/api-documentation
120 18 Laurent GUERBY
ftp://ftp.ripe.net/ripe/dbase/ripe.db.gz
121 19 Laurent GUERBY
<pre>
122 19 Laurent GUERBY
20130101
123 19 Laurent GUERBY
223M	ripe.db.gz
124 19 Laurent GUERBY
3.8G    ripe.db
125 19 Laurent GUERBY
</pre>
126 16 Laurent GUERBY
127 22 Laurent GUERBY
http://www.ripe.net/data-tools/support/documentation/update-ref-manual
128 22 Laurent GUERBY
129 54 Laurent GUERBY
ftp://ftp.ripe.net/ripe/stats/membership/alloclist.txt
130 2 Laurent GUERBY
h2. Prix 
131 1 Laurent GUERBY
132 1 Laurent GUERBY
https://www.ripe.net/ripe/docs/ripe-499
133 2 Laurent GUERBY
134 20 Laurent GUERBY
h2. database object documentation
135 20 Laurent GUERBY
136 20 Laurent GUERBY
http://www.ripe.net/data-tools/support/documentation/upd-ref-manual
137 20 Laurent GUERBY
138 17 Laurent GUERBY
h2. IP temporaires
139 17 Laurent GUERBY
140 17 Laurent GUERBY
http://www.ripe.net/ripe/docs/ripe-526
141 17 Laurent GUERBY
Temporary Internet Number Assignment Policies
142 17 Laurent GUERBY
143 13 Laurent GUERBY
h2. Meeting
144 13 Laurent GUERBY
145 13 Laurent GUERBY
https://ripe65.ripe.net/
146 13 Laurent GUERBY
RIPE 65 will take place from 24-28 September 2012 in the Okura Hotel in Amsterdam.
147 14 Laurent GUERBY
A RIPE Meeting is a five-day event that brings together hundreds of people from the global Internet community to discuss industry best practices and to network with peers in Europe, the Middle East and beyond
148 14 Laurent GUERBY
Monday-Friday
149 1 Laurent GUERBY
150 14 Laurent GUERBY
https://ripe65.ripe.net/help/how-much-does-it-cost/
151 14 Laurent GUERBY
Full Week Attendance Option
152 14 Laurent GUERBY
The regular meeting fee is EUR 400. However, you can get a EUR 50 discount if you register and pay by Friday, 21 September at 15:00 UTC.
153 1 Laurent GUERBY
154 14 Laurent GUERBY
Day Ticket Option
155 14 Laurent GUERBY
Day tickets cost EUR 125 per day. We offer these tickets as an alternative to the regular week ticket, they are meant for those who are unable to attend the full week. The pre-payment discount does not apply to the day ticket.
156 14 Laurent GUERBY
157 14 Laurent GUERBY
Student Discount
158 14 Laurent GUERBY
A student ticket costs EUR 175 and covers your attendance for all sessions throughout the week. You must show a valid international student card upon arrival at the meeting. We do not offer any student discount for day tickets or for the RIPE Dinner.
159 14 Laurent GUERBY
160 14 Laurent GUERBY
Free Tickets for New LIRs 
161 14 Laurent GUERBY
To bring new members together with existing ones and the RIPE community, all new LIRs will receive two free RIPE Meeting tickets. The tickets cover the cost of registration only. The RIPE Dinner is not included. You will have to take care of your own transport and accommodation
162 14 Laurent GUERBY
163 14 Laurent GUERBY
164 13 Laurent GUERBY
http://www.ripe.net/ripe/meetings/ripe-meetings
165 1 Laurent GUERBY
166 14 Laurent GUERBY
https://ripe64.ripe.net/
167 23 Laurent GUERBY
RIPE 64 took place from 16 – 20 April 2012 at the Grand Union Hotel in Ljubljana
168 14 Laurent GUERBY
169 14 Laurent GUERBY
https://ripe63.ripe.net/
170 14 Laurent GUERBY
RIPE 63 took place from 31 October-4 November 2011 at the Hilton am Stadtpark in Vienna. With 465 people checked in, RIPE 63 was the biggest RIPE Meeting so far
171 14 Laurent GUERBY
172 14 Laurent GUERBY
https://ripe62.ripe.net/
173 14 Laurent GUERBY
RIPE 62 took place from 2-6 May 2011 at the NH Grand Hotel Krasnapolsky in Amsterdam. With 464 people checked in, RIPE 62 was the biggest RIPE Meeting so far.
174 14 Laurent GUERBY
175 14 Laurent GUERBY
https://ripe61.ripe.net/
176 14 Laurent GUERBY
15-19 Nov 2010 Rome, Italy With 430 people checked in, RIPE 61 was the biggest RIPE Meeting so far. It was a packed and successful week.
177 14 Laurent GUERBY
178 14 Laurent GUERBY
179 13 Laurent GUERBY
h2. Working Group
180 1 Laurent GUERBY
181 1 Laurent GUERBY
http://www.ripe.net/ripe/mail/wg-lists
182 14 Laurent GUERBY
183 14 Laurent GUERBY
h2. Policy
184 14 Laurent GUERBY
185 14 Laurent GUERBY
http://www.ripe.net/ripe/policies
186 14 Laurent GUERBY
http://www.ripe.net/ripe/docs/ripe-553/
187 1 Laurent GUERBY
http://www.ripe.net/lir-services/member-support/become-a-member/becoming-a-member-of-the-ripe-ncc
188 23 Laurent GUERBY
189 23 Laurent GUERBY
190 23 Laurent GUERBY
https://www.ripe.net/ripe/docs/ripe-599
191 23 Laurent GUERBY
IPv4 Address Allocation and Assignment Policies for the RIPE NCC Service Region
192 23 Laurent GUERBY
193 23 Laurent GUERBY
https://www.ripe.net/ripe/policies/proposals/2013-05
194 23 Laurent GUERBY
No Restrictions on End User Assignments in Intra-RIR Transfers
195 13 Laurent GUERBY
196 11 Laurent GUERBY
h2. Listes
197 1 Laurent GUERBY
198 1 Laurent GUERBY
http://www.ripe.net/ripe/mail/archives/members-discuss/
199 12 Laurent GUERBY
https://www.ripe.net/lir-services/member-support/info/membership-mailing-lists
200 13 Laurent GUERBY
201 13 Laurent GUERBY
202 3 Laurent GUERBY
203 3 Laurent GUERBY
charging scheme task force 
204 5 Laurent GUERBY
205 5 Laurent GUERBY
* july 2012 http://www.ripe.net/lir-services/ncc/gm/september-2012/charging-scheme-model-proposal
206 4 Laurent GUERBY
* april 2012 https://www.ripe.net/lir-services/ncc/gm/april-2012/supporting-documents
207 1 Laurent GUERBY
** https://www.ripe.net/lir-services/ncc/gm/april-2012/supporting-documents/report-of-the-charging-scheme-task-force
208 5 Laurent GUERBY
* nov 2011
209 5 Laurent GUERBY
** https://www.ripe.net/lir-services/ncc/executive-board/minutes/2011/draft-minutes-of-the-79th-executive-board-meeting
210 6 Laurent GUERBY
** voting results http://www.ripe.net/ripe/mail/archives/members-discuss/2011-November/000707.html
211 6 Laurent GUERBY
<pre>
212 6 Laurent GUERBY
Voting Results
213 6 Laurent GUERBY
b) The General Meeting adopts the RIPE NCC Charging Scheme 2012.
214 6 Laurent GUERBY
No 148
215 6 Laurent GUERBY
Yes 102
216 6 Laurent GUERBY
Abstain 11
217 6 Laurent GUERBY
</pre>
218 8 Laurent GUERBY
* october 2011 grosse discussion charging scheme 2012
219 15 Laurent GUERBY
** http://www.ripe.net/lir-services/ncc/gm/november-2011/documents/draft-ripe-ncc-charging-scheme
220 8 Laurent GUERBY
** http://www.ripe.net/ripe/mail/archives/members-discuss/2011-October/date.html
221 9 Laurent GUERBY
** http://www.ripe.net/ripe/mail/archives/members-discuss/2011-October/000538.html
222 9 Laurent GUERBY
<pre>
223 9 Laurent GUERBY
           2011    2012
224 9 Laurent GUERBY
3XS about   82       -
225 9 Laurent GUERBY
2XS about   66       -
226 9 Laurent GUERBY
XS  about 1567    1601
227 9 Laurent GUERBY
S   about 1440    4201
228 9 Laurent GUERBY
M   about 1458    1525
229 9 Laurent GUERBY
L   about 2222     304
230 9 Laurent GUERBY
XL  about  538      75
231 9 Laurent GUERBY
2XL about  208       -
232 9 Laurent GUERBY
3XL about  126       -
233 9 Laurent GUERBY
4XL about   18       -
234 9 Laurent GUERBY
----------------------
235 9 Laurent GUERBY
           7725    7725
236 9 Laurent GUERBY
</pre>
237 9 Laurent GUERBY
** http://www.ripe.net/ripe/mail/archives/members-discuss/2011-October/000525.html
238 9 Laurent GUERBY
*** https://www.ripe.net/lir-services/ncc/gm/november-2010/ChargingSchemeslides.pdf
239 10 Laurent GUERBY
** http://www.ripe.net/ripe/mail/archives/members-discuss/2011-October/000531.html
240 10 Laurent GUERBY
*** http://www.ripe.net/ripe/docs/ripe-507
241 5 Laurent GUERBY
annual reports history
242 5 Laurent GUERBY
http://www.ripe.net/internet-coordination/press-centre/publications/annual-reports
243 3 Laurent GUERBY
244 7 Laurent GUERBY
<pre>
245 7 Laurent GUERBY
Top 5 countries in             Top 5 countries
246 7 Laurent GUERBY
terms of members               in terms of new
247 7 Laurent GUERBY
overall at end of              members in
248 7 Laurent GUERBY
2011:                          2011:
249 7 Laurent GUERBY
                                               1. UK 137
250 7 Laurent GUERBY
                   1. RU 1,040
251 7 Laurent GUERBY
                                               2. FR 98
252 7 Laurent GUERBY
                   2. UK 878
253 7 Laurent GUERBY
                                               3. DE 93
254 7 Laurent GUERBY
                   3. DE 780
255 7 Laurent GUERBY
                                               4. RU 92
256 7 Laurent GUERBY
                   4. IT 487
257 7 Laurent GUERBY
                                               5. ES 81
258 7 Laurent GUERBY
                   5. FR 418
259 7 Laurent GUERBY
260 7 Laurent GUERBY
7,795 members
261 7 Laurent GUERBY
262 7 Laurent GUERBY
voting 200 to 300
263 1 Laurent GUERBY
</pre>
264 10 Laurent GUERBY
265 10 Laurent GUERBY
budget 2012
266 10 Laurent GUERBY
http://www.ripe.net/ripe/docs/ripe-544
267 11 Laurent GUERBY
268 11 Laurent GUERBY
* http://www.ripe.net/ripe/mail/archives/members-discuss/2011-August/000407.html
269 11 Laurent GUERBY
** august 2011 New RIPE NCC Charging Scheme Models: Feedback Required
270 11 Laurent GUERBY
** https://www.ripe.net/lir-services/ncc/gm/november-2011/ripe-ncc-proposed-new-charging-scheme-2012
271 11 Laurent GUERBY
272 11 Laurent GUERBY
273 7 Laurent GUERBY
274 2 Laurent GUERBY
h2. Documentation
275 2 Laurent GUERBY
276 2 Laurent GUERBY
http://www.ripe.net/db/docs.html
277 2 Laurent GUERBY
278 2 Laurent GUERBY
http://www.ripe.net/data-tools/support/documentation/ripe-database-fast-facts
279 2 Laurent GUERBY
http://www.ripe.net/data-tools/support/documentation/ripe-database-query-reference-manual
280 2 Laurent GUERBY
http://www.ripe.net/data-tools/support/documentation/update-ref-manual
281 2 Laurent GUERBY
282 2 Laurent GUERBY
http://www.ripe.net/internet-coordination/ipv4-exhaustion/faq
283 2 Laurent GUERBY
http://www.ripe.net/lir-services/resource-management/faq/resource-request
284 2 Laurent GUERBY
http://www.ripe.net/ripe/docs/ipv4-policies.html
285 2 Laurent GUERBY
http://www.ripe.net/lir-services/resource-management/contact/ipv4-evaluation-procedures
286 2 Laurent GUERBY
287 2 Laurent GUERBY
http://www.ripe.net/lir-services/resource-management/number-resources/ipv6
288 2 Laurent GUERBY
http://www.ripe.net/lir-services/resource-management/number-resources/ipv4
289 2 Laurent GUERBY
http://www.ripe.net/lir-services/resource-management/number-resources/as-numbers
290 2 Laurent GUERBY
http://www.ripe.net/data-tools/dns/reverse-dns