Migration to GLOBAL

Title

Cannot close yet: Close all activities before closing this item.

Status

Due

Scheduled

Context

Project

View Mission PIN code - Migration to GLOBAL project

Category

Notes Saved

Supports Markdown: bold, italics, code, lists, links. Auto-saves.

AI Notes - managed by Claude

## Migration Journal Summary (v0.10 - 2026-06-09)

### Servers
| Role | New hostname | IP |
|------|-------------|-----|
| Primary | telrad-p-db-01.global.un.org | 10.130.72.21 |
| Secondary | telrad-r-db-01.global.un.org | 10.130.200.11 |

Old servers: dfs-telrad-02.dpko.un.org / dfs-telrad-52.dpko.un.org

### Completed
- Phase 1: FreeRADIUS installed on both new GLOBAL servers
- Phase 2: raddb config migrated from old servers
- Phase 3: MariaDB 10.5 installed, data dir on /data LVM volume, my.cnf configured
- Phase 4: DB dump (~14G) imported on both servers; users recreated from hash replay
- Phase 5: Master-master replication active (both directions clean)
- Phase 6: radiusd -XC passing on both servers (rlm_sql_mysql.so extracted from InkBridge RPM)
- Phase 6b: UNAMI, UNITAD, UNUKR decommissioned - DBs dropped, config files removed

### Open items
- Phase 7: Start radiusd + firewall rules (1812/udp, 1813/udp, 3306/tcp) + SELinux + radtest
- Frontend (PHP): waiting on Fulvio - PHP version incompatibility on new servers
- Confirm new frontend hostnames for Netscaler cutover
- Confirm eBilling team contact + notification process
- Schedule maintenance window + lower DNS TTL 2h before cutover
- Handover to RMS (Zvonco)

### Key learnings
- RHEL 9: /etc/my.cnf.d/mariadb-server.cnf overrides /etc/my.cnf - both must be updated
- Do NOT restore mysql system DB across major MariaDB versions (corrupts system tables)
- freeradius-mysql not in RHEL 9 repos - use rpm2cpio to extract rlm_sql_mysql.so from InkBridge RPM
- Hostname resolution broken between old/new servers and between the two new servers - always use IPs
- Custom RADIUS attributes peer-id (3118) and fac-digits (3119) must be in /etc/raddb/dictionary

📂 Activities for this Item

Drag using ⇅ to reorder; saves automatically.

➕ Add Activity

Open Activities

⇅

Wait for Fulvio Next

Today: 0:00
⇅

Migration to GLOBAL

Today: 0:00
⇅

Prepare cutover

Today: 0:00
⇅

Prepare PRE with Zvonco

Today: 0:00

Closed Activities

No closed activities.

Service Requests / Work Orders

RFS-1-12962069407

Service Request

WO-RFS-1-12962069413

Normalized time tracking

Last 30 days

Logged: 8:01 · Normalized: 9:00

2026-06-18

Day total: 1:00

Normalized (1) · 1:00

Migration to GLOBAL
Logged: 0:30

1:00

Time entries 0:30

Manual log

Migration to GLOBAL
Manual log

0:30 · 09:47

2026-06-09

Day total: 3:30

Normalized (1) · 3:30

Migration to GLOBAL
Logged: 3:00

3:30

Time entries 3:00

Finished installing and configuring MariaDB and Radius. Coordination with development team about detected issues in frontend side.

Migration to GLOBAL
Finished installing and configuring MariaDB and Radius. Coordination with development team about detected issues in frontend side.

3:00 · 10:01

2026-06-08

Day total: 4:30

Normalized (1) · 4:30

Migration to GLOBAL
Logged: 4:31

4:30

Time entries 4:31

Perform installation and initial setup of FreeRadius service
Work on installation and setup of Radius service and MariaDB in GLOBAL servers

Migration to GLOBAL
Perform installation and initial setup of FreeRadius service

1:00 · 08:45
Migration to GLOBAL
Work on installation and setup of Radius service and MariaDB in GLOBAL servers

3:31 · 08:59

Meeting Notes (Project / Context)

Select a meeting to preview details.

iNeed Text

Title

Description

Mission Pin Code - Migration to GLOBAL
Assign to Carlos Rodrigo - AOM DS

Asset#

Defined per context on the Taxonomy page.

Templates

Change Title

Change Description

Change Steps

Template Notes

Communications

Label

Order

Subject

Email Body

Attachments

No attachments yet.