Kestrel2 Server

Google Cloud Platform

Bond Service instances

Instance 1

• Host Name: kestrel-bond-services1
• VM: 1 vCPU, 7.25 GB memory
• DNS: kestrel-bond-services1.aqaix.com

Instance 2

• Host Name: kestrel-bond-services2
• VM: 1 vCPU, 7.25 GB memory
• DNS: kestrel-bond-services2.aqaix.com

Install node.js and npm

From here: https://linuxize.com/post/how-to-install-node-js-on-centos-7/

curl -sL https://rpm.nodesource.com/setup_11.x | sudo bash -
sudo yum install nodejs
node --version
npm --version

Configure the Services

Main Services for APIs

sudo vi /usr/lib/systemd/system/kestrel2-bond.service

Insert the following lines:

[Unit]
Description=kestrel2-bond

[Service]
ExecStart=/bin/bash /opt/aqaix/kestrel2-server/start.sh
Restart=on-failure
RestartSec=60s

[Install]
WantedBy=multi-user.target

Start the service:

sudo systemctl start kestrel2-bond

Monitor service standard out:

sudo journalctl -u kestrel2-bond -f

Import Ipreo Service

sudo vi /usr/lib/systemd/system/kestrel-import-ipreo.service

Insert the following lines:

[Unit]
Description=kestrel-import-ipreo

[Service]
ExecStart=/bin/bash /opt/aqaix/kestrel-bond-services/start-import-ipreo.sh
Restart=on-failure
RestartSec=60s

[Install]
WantedBy=multi-user.target

Start the service:

sudo systemctl start kestrel-import-ipreo

Monitor service standard out:

sudo journalctl -u kestrel-import-ipreo -f

Configure MySQL Server to Handle Large Packets

Add max_allowed_packet setting to the my.cnf file:

sudo vi /etc/my.cnf[mysqld]
[mysqld]
max_allowed_packet=500M

Restart the server

sudo service mysql restart

Increase Number of MySQL Connections

Both the OS and MySQL need to be configured.

Assuming Cent OS 7 or Cent OS 8:

sudo vi /etc/security/limits.conf At the end of the file add these two lines:

mysql hard nofile 65535
mysql soft nofile 65535

Then update the MySQL Configuration:

sudo vi /etc/my.cnf

 [mysqld]
 max_connections = 512

sudo systemctl restart mysqld

Questions for Kestrel

1. Ask aboubt "Other Finance Team contacts: Bond Counsel, Municipal advisor, or underwriter Phone, email (need room to add 3 or 4)" 3 or 4 of what?

2. Reporting frequency units?

Kestrel Meeting Tuesday, May 7th 2019

They added two new questions (yes/no) intake regarding social bonds - will email us that. There can be multiple underwriters 3 - 4

Reporting units: quarterly annually only two units.

Private - don't release publicly - confidential - might apply to uplodaed documents.

IPREO Integration Notes

 https://identity.cas.ipreo.com/connect/token
 -d 'grant_type=client_credentials&scope=deals-read%20permissions-read%0A%0A&client_id=<client_id>&client_secret=<client_secret>''
 ClientId: api-kestrel-consulting.client
 Secret: 710ce008-1932-424e-8212-7b8140bcf24f
curl https://identity.cas.ipreo.com/connect/token -X POST -d 'grant_type=client_credentials&scope=deals-read%20permissions-read%0A%0A&client_id=api-kestrel-consulting.client&client_secret=710ce008-1932-424e-8212-7b8140bcf24f'
 this one works
curl -v -H "Authorization: Bearer $ACCESS_TOKEN" 'https://api.cas.ipreo.com/book-building/deals/v1/deals/fixed-income/municipal?accessType=Public'
curl -g -v -H "Authorization: Bearer $ACCESS_TOKEN" 'https://api.cas.ipreo.com/book-building/deals/v1/deals/fixed-income/municipal?accessType=Public&criteria=[{"field":"SaleDate.Date","operator":">=","value":"2020-05-04"}]' | python -m json.tool