http://3.86.49.49/ 2026-04-17T11:52:27+00:00 http://3.86.49.49/ http://3.86.49.49/lib/tpl/docnavwiki/images/favicon.ico text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:accessing_visual_vm&rev=1624612196&do=diff Accessing Visual VM Author: Cathal O'Keeffe & Michelle McCausland Introduction Visual VM is a tool used to monitor server activities such as Process Performance And Memory. The tool also allows you to take and display thread dumps. It can be downloaded from the following link: text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:atc_aws_access&rev=1624612196&do=diff American Tower AWS Access In order to access the American Tower servers which are hosted via Amazon Web Services, the login process is as follows: Retrieve the .pem file from the errigal shared dropbox: cd ~/Dropbox/Errigal Shared Documents/Amazon EC2/dev keys text/html 2021-10-08T14:16:10+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:aws_cli_access&rev=1633698970&do=diff AWS CLI Configuration for command line activitities Guide : AWS CLI Configure quickstart Example aws configure --profile developer and answer the questions similar to * Anthonys-MacBook-Pro:~ anthonyryan$ aws configure --profile developer * AWS Access Key ID [None]: AKIA4XUWDV65NAIK6L4E text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:aws_ec2_maintenance&rev=1624612196&do=diff Managing AWS EC2 Maintenance Author: Padraig O Neill Introduction This page was created to provide a resource which documents the process involved in managing upcoming scheduled maintenance of an EC2 instance with AWS. This page was written post the work on ATC-996430. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:aws_login&rev=1624612196&do=diff AWS Login Author: Sophie Renshaw As part of SUPPORT-248 and the need to test some changes before making them widespread across our AWS account I have created three new users that should now be used to access the AWS console. Ideally we should never have to use the root account (ec2@errigal.com) anymore. I imagine there will be some things that will need tweaking with these accounts but once we have them set in stone the Admin account will take the place of the root account. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:aws_resize_ebs_volume&rev=1624612196&do=diff AWS EBS Resizing Volumes Resize AWS Volume * In the AWS console select the relevant volumes * Under actions select modify volume * Choose New Size/Volume Type * Wait for Volume to finish resizing in the AWS Console * Use lsblk to check new volume size is there text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:backing_up_a_table&rev=1624612196&do=diff Backing Up A Table Author: Michelle McCausland * In the command line or in putty navigate to the home/scotty level of a database. (In this instance I am on Errigal QA - qadb2.err). * It is important to back up tables on the slave system as opposed to the master to prevent any load/locking issues. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:compare_database_schema_pre_post_release&rev=1624612196&do=diff Compare database schema pre/post release Author: Colum Foskin Initial Setup Steps * The first thing to do is to find out where to source the correct database schema - for pre and post release (Ask a dev to clarify this) * Dump the databases for each application - Ensure to use the flag text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:database_views&rev=1624612196&do=diff Database Views Author: Michelle McCausland Views are static tables created, for example, on Crown Castle's databases to allow for more efficient querying of data. Views are static and will only be accurate to the values present at the time of the view creation. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:db_triggers&rev=1624612196&do=diff DB Triggers Author: Milos Zubal Introduction * The following trigger has been created to support investigation of SUPPORT-371. * It is supposed to log modification of the thread_config.is_active field, because the problem is that we don't know who and when modifies it. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:dns_service&rev=1624612196&do=diff The DNS Service Objective The host files (/etc/hosts) deployed on Errigal machines and blade servers has got larger over time. The hosts file on QAAPPS1 contained 102 entries, of which there were 5 duplicates, and keeping all the hosts files on all the machines up to date is becoming unmanageable, it is time to deploy a Errigal domain name system ( text/html 2025-08-08T09:29:33+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:domain_verification&rev=1754641773&do=diff Domain Ownership Verification Author: Eoin Hearne. Date: 13-Jul-20. This wiki covers how to verify that we own a domain before GoDaddy will issue an SSL certificate. GoDaddy GoDaddy will email support with the verification request and steps. Contained in this email is a unique ID which will be required for this process. Copy this ID from the email body. text/html 2023-05-16T10:41:20+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:enigma_nginx_config&rev=1684230080&do=diff Enigma's Nginx Configuration ## # You should look at the following URL's in order to grasp a solid understanding # of Nginx configuration files in order to fully unleash the power of Nginx. # https://www.nginx.com/resources/wiki/start/ # https://www.nginx.com/resources/wiki/start/topics/tutorials/config_pitfalls/ # https://wiki.debian.org/Nginx/DirectoryStructure # # In most cases, administrators will remove this file from sites-enabled/ and # leave it as refere… text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:factory_rest_router&rev=1624612196&do=diff Factory Reset Juniper Router How To * Push and HOLD pinhole with thin wire.  The Status LED will turn to a “blinking amber'.  Keep holding, and when it turns to 'blinking green', immediately release the pinhole.  * After 1 second, push and HOLD the pinhole again.  The Status LED will turn to a “blinking red”.  Keep holding, and when the Status LED turns to 'solid amber' or 'solid green', immediately release the pinhole and wait. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:install_cron&rev=1624612196&do=diff Install cron on a Server - REHL 6.6 Author: Yanjun Wang Introduction The cron is a time-based job scheduler. People who set up and maintain software environments use cron to schedule jobs to run periodically at fixed times, dates, or intervals. It typically automates system maintenance or administration. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:install_mysql&rev=1624612196&do=diff Install Mysql v5.1.73 on REHL 6.6 Introduction This page describes the process of installing mySQL v5.1.73 on REHL 6.6 ---------- Install Steps You will find the 2 files you need in Google Driver -> MySQL -> Install Mysql on REHL 6.6 copy : mysql-server-5.1.73-3.el6_5.x86_64.rpm and perl-DBD-MySQL-4.013-3.el6.x86_64.rpm text/html 2022-01-25T17:48:08+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:kumu_networks&rev=1643132888&do=diff Kumu is an on-boarding customer. We have 1 lab relay and 3 production relays. There is an AWS instance that is running our production trial environment. * kumuapps1.err * kumuapps2.err * kumuesk1.err * kumulb.err * kumulbdbrmq.err * kumuoat1.err text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:log_rotation&rev=1624612196&do=diff Log Rotation - Setting up log rotation on a server Author: Michelle McCausland Introduction Log rotation is setup as a bash script that manages the log files on the server to ensure older logs are deleted and that logs are zipped up to save space. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:mysqluser&rev=1624612196&do=diff How to Create a User in Mysql and Grant Permission grant select on *.* to ‘reader’@’10.5.5.%’ identified by ‘<YOUR PASSWORD>’; This creates a user called reader who can connect from a machine with an ip address that starts with 10.5.5. reader's password in this case is PASSWORD text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:network_outage&rev=1624612196&do=diff Network Outage Troubleshooting Author: Patrick Gary Introduction The following wiki entry will step through troubleshooting process for a generic network outage at the Sacramento data center (QTS). Network Outage Reported * Team reports “Sacramento” is unreachable text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:new_server_cluster&rev=1624612196&do=diff Everything A New Server Cluster Needs Author: Cathal O'keeffe Here we'll give a brief overview of everything a brand new server cluster needs to install to get a full installation of our applications suite. This is a checklist rather than a guide, specific installation instructions should be linked to rather than added here. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:openvpn3&rev=1624612196&do=diff openvpn3 install A playbook exists in <https://bitbucket.org/errigal/server-configuration/src/master/openvpn3.yml> Example use: ansible-playbook openvpn3.yml -i ../env-configuration/telnet/hosts.ini -e action=install Openvpn3 routing Example IP rules added for telnet, modify and run them before establishing a connection so that your session persists and other internal connections stay intact: text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:open_vpn_install&rev=1624612196&do=diff Open VPN install on Ubuntu 16 The following tutorial gives a very in-depth tutorial on how to do this so I recommend just following that : <https://www.digitalocean.com/community/tutorials/how-to-set-up-an-openvpn-server-on-ubuntu-16-04> The only extra items I did were: * create rules on the Netgear Router to allow port forward of 1194 (default Open VPN port) to comeragh text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:open_vpn_install_18&rev=1624612196&do=diff Before Your Start If you are looking for adding user (or yourself) to OpenVPN for support purposes, check out Setup Open VPN User 2018 Edition Ubuntu 18.04 Open VPN Full installation as performed on on CA Server (AWS Northern California: Errigal CA - DO NOT DELETE) and Open VPN Server (olympus.err) text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:partitioning_a_server_with_lvm&rev=1624612196&do=diff Partitioning Logical Volumes on a Server # View the partitions lvdisplay # Set the parition size - https://www.centos.org/docs/5/html/Cluster_Logical_Volume_Manager/LV_create.html lvresize --size 0.5T -r /dev/vg_hpeproliant/lv_home # This leave 0.4T left # Create the volume lvcreate -L 1T -n lv_mysql_data vg_hpeproliant lvcreate -L 1T -n lv_backup vg_hpeproliant # Create the file system - https://unix.stackexchange.com/questions/275129/cannot-mount-newly-created-logical-volume mkfs.ext4 /dev… text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:ppoe_on_router&rev=1624612196&do=diff Set up PPPoE Information on Juniper 5GT 101 --- Colm Carew 2017/08/18 01:44 How To Note for the Waterford Setup all Password and Information should be located inside the password safe - look for PPPoE This is for if the VDSL router has been changed to modem mode and we need to enter the VDSL info onto the juniper 5GT 101 text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:renewing_signal_seeker_licences&rev=1624612196&do=diff Renewing Signal Seeker (Iris) Licenses A request may come in from a customer to renew their signal seeker license. All you need to do this is their IMEI number and access to Iris. * Navigate to <https://www.errigal-iris.com/> * Login credentials in password safe * Click on Manage Licenses text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:replica_restore&rev=1624612196&do=diff Replica Database Restore The below steps are confirmed to work and have been performed on EXTDB2, after the server restarted and the replication was in an uncoverable state. Tmux To ensure all of the lengthy processes run without the session disconnecting and in result terminating the process, use tmux. After logging into the server simply run: text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:restarting_application_container&rev=1624612196&do=diff Restarting An Application Container Author: Sophie Renshaw Introduction In various cases, such as in the event of an outage, or during an upgrade, it is necessary to restart (bounce) an application container. This page describes the process of restarting an application container successfully. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:router_config&rev=1624612196&do=diff Router Configuration --- Colm Carew 2017/08/14 07:14 Creating Backup of Config File This is relatively easy and should be done once every week or two or before and after changes are made to the router : * Login to the UI : <https://10.5.5.1/index.html> * Click Configuration -> Update text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:server_file_maintenance&rev=1624612196&do=diff Server File Maintenance Author: Michelle McCausland Background These guidelines are documented here to ensure the files we add and work with on the servers are named and stored accordingly and removed when unnecessary to avoid confusion and build up of space. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:server_management&rev=1624612196&do=diff Server Management This sheet is deprecated and changes are now being managed on this Google Doc: Server Management System Data and Releases System Hostname Data Release SNMP Manager Ticketer NOC Portal Reporting Manager Support Page CAS Alarm Cache eBonding text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:slave_dns_on_redhat&rev=1624612196&do=diff Setup RedHat as DNS Slave SSH to server as scotty * sudo yum install bind * sudo yum bind-utils * sudo cp /etc/named.conf /etc/named.conf.backup * sudo nano /etc/named.conf options { listen-on port 53 { 127.0.0.1; 192.168.123.222;}; listen-on-v6 port 53 { ::1; }; directory "/var/named"; dump-file "/var/named/data/cache_dump.db"; statistics-file "/var/named/data/named_stats.txt"; memstatistics-file "/var/named/data/named_mem_stats.txt"; … text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:ssh_through_putty&rev=1624612196&do=diff Connecting by SSH through PuTTY Author: Eoin Joy On Windows, you can use PuTTY to SSH to a server. * By default you can enter an IP address in the “Host Name (or IP Address)” field and click open and you will be prompted in the CLI for a username to connect as and that user's password. text/html 2022-06-14T10:56:32+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:ssl_configuration&rev=1655200592&do=diff SSL Configuration Author: Anna Dowling Introduction The following wiki entry will step through the loading of a customers CA cert and bundle cert file into apache and java. CSR Generation Before you can order an SSL Certificate, you must first generate a CSR (Certificate Signing Request) for your server. text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:ssl_renewal&rev=1624612196&do=diff Iris (Signal Seeker) SSL Renewal Author: Michelle McCausland Introduction The steps outlined here describe how to update an ssl cert for errigal-iris. ---------- Initial Steps * Login to godaddy, check the errigal-iris cert * Go to <https://www.errigal-iris.com/> and check the cert information (inspect element> security> view certificate) text/html 2023-05-17T11:33:08+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:start&rev=1684319588&do=diff Database, Server and Network Management This section of the Wiki contains information & guides relevant to database, server & network management type tasks e.g. backing up a table, router config, server management, restarting an application etc. * text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:static_ip_on_redhat&rev=1624612196&do=diff Set Static IP on RedHat * # check the connected interface - usually eth0 but could be eth1, this affects what file we want to edit * ifconfig * # backup the config file of that interface * sudo cp /etc/sysconfig/network-scripts/ifcfg-eth0 /home/scotty/backup/ifcfg-eth0.backup text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:ups_install_and_manage&rev=1624612196&do=diff UPS Install and Management Install on Ubuntu This is the UPS : <https://www.amazon.co.uk/APC-Smart-UPS-SMC-Uninterruptible-Interactive/dp/B00DYP6HPA/ref=sr_1_1?ie=UTF8&qid=1487846959&sr=8-1&keywords=APC+Smart-UPS+1500> It is SMC1500I. As of 2017-04-24, the latest apcupsd from apt-get repo does not support it so we have to compile it from source. The link to download the tar.gz file is here : <https://sourceforge.net/projects/apcupsd/files/apcupsd%20-%20Stable/> The link to install it is : text/html 2021-06-25T10:09:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:useful_commands&rev=1624612196&do=diff Useful Commands File Search locate SnmpManagerConfig.groovy Will search for the file and display its directory. ---------- Tailing Logs * It is possible to tail the logs in real time using the following command: tail -f NameOfLogFile.log * text/html 2023-05-16T10:33:17+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:wiki_installation&rev=1684229597&do=diff Wiki Installation NEW WIKI See wiki repo on bitbucket. <https://bitbucket.org/errigal/wiki/src/master/> Author: Padraig O Neill based on <https://docs.google.com/document/d/1lw3Rkdxvos6O3JgvvQkFhqPJGy7LcUX-2TMMFa7HjZY/edit#heading=h.rbeemfk5xiqz> by Andrey) Introduction This page was created to provide document details of the current dokuwiki installation. ---------- Location Access Information * text/html 2023-05-17T11:38:46+00:00 Anonymous (anonymous@undisclosed.example.com) http://3.86.49.49/doku.php?id=databaseandnetworkmanagement:wiki_upgrading&rev=1684319926&do=diff Updating the wiki First you want to ssh onto the server. There is a wiki directory there This wiki dir is the wiki repo, you can find it here <https://bitbucket.org/errigal/wiki/> The wiki is run on a docker container managed by docker compose. There is a cronjob on this server that will back up all of the wiki contents to the repo.