ScanCore
Warning: This is little more that raw notes, do not consider anything here to be valid or accurate at this time. |
Installing
Database Setup
yum install -y postgresql postgresql-server postgresql-plperl postgresql-contrib postgresql-libs git
...
Complete!
DB config:
/etc/init.d/postgresql initdb
Initializing database: [ OK ]
Start
/etc/init.d/postgresql start
Starting postgresql service: [ OK ]
Set 'postgres' user password>
Configure access
cp /var/lib/pgsql/data/pg_hba.conf /var/lib/pgsql/data/pg_hba.conf.striker
vim /var/lib/pgsql/data/pg_hba.conf
diff -u /var/lib/pgsql/data/pg_hba.conf.striker /var/lib/pgsql/data/pg_hba.conf
--- /var/lib/pgsql/data/pg_hba.conf.striker 2015-01-16 15:24:38.985895621 -0500
+++ /var/lib/pgsql/data/pg_hba.conf 2015-01-16 15:26:42.611236927 -0500
@@ -65,9 +65,13 @@
# TYPE DATABASE USER CIDR-ADDRESS METHOD
+# dashboards
+host all all 10.20.4.0/24 md5
+# node servers
+host all all 10.20.70.0/24 md5
# "local" is for Unix domain socket connections only
-local all all ident
+local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 ident
# IPv6 local connections:
cp /var/lib/pgsql/data/postgresql.conf /var/lib/pgsql/data/postgresql.conf.striker
vim /var/lib/pgsql/data/postgresql.conf
diff -u /var/lib/pgsql/data/postgresql.conf.striker /var/lib/pgsql/data/postgresql.conf
--- /var/lib/pgsql/data/postgresql.conf.striker 2015-01-16 15:33:30.970370628 -0500
+++ /var/lib/pgsql/data/postgresql.conf 2015-01-16 15:34:16.603482692 -0500
@@ -56,6 +56,7 @@
# - Connection Settings -
+listen_addresses = '*'
#listen_addresses = 'localhost' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
/etc/init.d/postgresql reload
Create the striker user.
su - postgres -c "createuser --no-superuser --createdb --no-createrole striker"
# no output expected
Create DB:
su - postgres -c "createdb --owner striker scanner"
# no output expected
Now download the SQL files we're going to load.
git clone https://github.com/digimer/striker.git
Initialized empty Git repository in /root/striker/.git/
remote: Counting objects: 3602, done.
remote: Compressing objects: 100% (57/57), done.
remote: Total 3602 (delta 25), reused 0 (delta 0)
Receiving objects: 100% (3602/3602), 7.88 MiB | 1024 KiB/s, done.
Resolving deltas: 100% (2307/2307), done.
cd striker
git checkout scanner
Branch scanner set up to track remote branch scanner from origin.
Switched to a new branch 'scanner'
cd Scanner/SQL/
ls -lah
total 40K
drwxr-xr-x. 2 root root 4.0K Jan 16 15:18 .
drwxr-xr-x. 13 root root 4.0K Jan 16 15:18 ..
-rw-r--r--. 1 root root 3.3K Jan 16 15:18 01_create_node.sql
-rw-r--r--. 1 root root 3.3K Jan 16 15:18 02_create_alerts.sql
-rw-r--r--. 1 root root 2.5K Jan 16 15:18 03_create_alert_listeners.sql
-rw-r--r--. 1 root root 1.2K Jan 16 15:18 04_load_alert_listeners.sql
-rw-r--r--. 1 root root 3.3K Jan 16 15:18 05_create_random_agent.sql
-rw-r--r--. 1 root root 3.4K Jan 16 15:18 06_create_snm_apc_ups.sql
-rw-r--r--. 1 root root 3.3K Jan 16 15:18 07_create_ipmi.sql
-rw-r--r--. 1 root root 3.3K Jan 16 15:18 08_create_raid.sql
Load SQL files
These are currently hard-coded to 'alteeve' user, switch to the 'striker' user.
sed -i 's/alteeve/striker/' *
Any questions, feedback, advice, complaints or meanderings are welcome. | |||
Alteeve's Niche! | Enterprise Support: Alteeve Support |
Community Support | |
© Alteeve's Niche! Inc. 1997-2024 | Anvil! "Intelligent Availability®" Platform | ||
legal stuff: All info is provided "As-Is". Do not use anything here unless you are willing and able to take responsibility for your own actions. |