public function run()
{
\App\Server::create(['id' => 1, 'scheme' => 'sftp', 'host' => '192.168.56.56']);
\App\Server::create(['id' => 2, 'scheme' => 'ftp', 'host' => '192.168.56.1']);
\App\Server::create(['id' => 3, 'scheme' => 'sftp', 'host' => 'unknown.local']);
\App\Server::create(['id' => 4, 'scheme' => 'sftp', 'host' => 'noconfig.local']);
}
public function run()
{
DB::table('servers')->delete();
Server::create(['name' => 'Web VM', 'ip_address' => '192.168.33.50', 'user' => 'vagrant', 'path' => '/var/www', 'project_id' => 1]);
Server::create(['name' => 'Cron VM', 'ip_address' => '192.168.33.60', 'user' => 'vagrant', 'path' => '/var/www', 'project_id' => 1]);
// Server::create([
// 'name' => 'DB VM',
// 'ip_address' => '192.168.33.70',
// 'user' => 'vagrant',
// 'path' => '/var/www',
// 'project_id' => 1
// ]);
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$this->validate($request, ['name' => 'required', 'host' => 'required', 'username' => 'required']);
$name = \Input::get('name');
$host = \Input::get('host');
$username = \Input::get('username');
$key_file_path = \Storage::disk('key_files')->getDriver()->getAdapter()->getPathPrefix();
$process = new Process("ssh-keygen -t rsa -b 2048 -f {$key_file_path}/{$host} -q -N '' ");
$process->run();
$ssh_key = \Storage::disk('key_files')->get($host . '.pub');
$server = Server::create(['name' => $name, 'host' => $host, 'username' => $username, 'ssh_key' => $ssh_key]);
return redirect()->route('server.index');
}
/**
* Run the database seeds.
* ags2
* *
* @return void
*/
public function run()
{
// production sql servers - bi
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'msb01sql', 'description' => 'Hosts many of the smaller SQL databases.', 'cname' => 'chameleon, dsj01sql', 'ip' => '10.100.8.18', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'govsql', 'description' => 'Hosts Govern SQL Production Database', 'cname' => 'governsql', 'ip' => '10.100.8.78', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'logos7sql', 'description' => 'Hosts Logos Production SQL DB. ', 'ip' => '10.100.8.66', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 1, 'group_id' => 6, 'name' => 'msb02sqla', 'ip' => '10.100.8.14', 'inactive_flag' => 0, 'production_flag' => 1]);
Server::create(['operating_system_id' => 1, 'group_id' => 6, 'name' => 'msb02sqlb', 'ip' => '10.100.8.15', 'inactive_flag' => 0, 'production_flag' => 1]);
// production sql servers - gis
Server::create(['operating_system_id' => 2, 'group_id' => 7, 'name' => 'sdesql10edit', 'description' => 'SDESQL10EDIT', 'ip' => '10.100.8.142', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2014-07-31']);
Server::create(['operating_system_id' => 2, 'group_id' => 7, 'name' => 'sdesql10', 'ip' => '10.100.8.149', 'inactive_flag' => 0, 'production_flag' => 1]);
// production report servers
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'logos7rpt', 'description' => 'Logos Reporting Server ', 'ip' => '10.100.8.67', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'msbsqlrpt', 'description' => 'Reporting server for govern ', 'ip' => '10.100.8.74', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-09-24']);
// dr sql servers
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'drgovsql', 'description' => 'Govern DB Replication Target. ', 'ip' => '10.126.1.46', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'drlogos7sql', 'description' => ' ', 'ip' => '10.126.1.44', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'drmsb01sql', 'description' => ' ', 'ip' => '10.126.1.45', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-09-24']);
// production app servers -- bi
Server::create(['operating_system_id' => 3, 'group_id' => 6, 'name' => 'abra-app', 'description' => 'Hosts the Abra application ', 'ip' => '10.100.8.33', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2014-09-11']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'actions2', 'description' => 'Secondary actions server? ', 'ip' => '10.100.8.69', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-07-23']);
Server::create(['operating_system_id' => 3, 'group_id' => 6, 'name' => 'actions-app', 'description' => 'Hosts the Actions Application.', 'cname' => 'actions, elections', 'ip' => '10.100.8.38', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-07-23']);
Server::create(['operating_system_id' => 3, 'group_id' => 6, 'name' => 'aims-app', 'description' => 'Ambulance Billing Server. Hosts the aims application. ', 'ip' => '10.100.8.42', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-07-23']);
Server::create(['operating_system_id' => 4, 'group_id' => 6, 'name' => 'bomgar', 'description' => 'Elizabeth Grigsby, Rod Hoskinson', 'ip' => '172.17.1.50', 'inactive_flag' => 0, 'production_flag' => 1]);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'esuite7', 'description' => 'Hosts the esuite application. ', 'ip' => '10.100.8.51', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-02-26']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'govapp', 'description' => 'Govern App Server. Contractor access and multimedia storage. ', 'ip' => '10.100.8.72', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'isupport', 'description' => 'Service Desk Management ', 'ip' => '10.100.8.58', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-10-08']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'logos7app', 'description' => 'Hosts Logos7 Production Application. ', 'ip' => '10.100.8.65', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'mpulse', 'description' => 'Hosts the Mpulse app ', 'ip' => '10.100.8.85', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-10-08']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'sympro', 'description' => 'Hosts the sympro app', 'ip' => '10.100.8.59', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-10-08']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'trim7', 'description' => 'Main Trim Workgroup Server', 'cname' => 'trim-app', 'ip' => '10.100.8.53', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'trim7event', 'description' => ' ', 'ip' => '10.100.8.44', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 1, 'group_id' => 6, 'name' => 'rmapp01', 'description' => 'HP Records Manager Primary App Server', 'ip' => '10.100.8.12', 'inactive_flag' => 0, 'production_flag' => 1]);
Server::create(['operating_system_id' => 1, 'group_id' => 6, 'name' => 'rmapp02', 'description' => 'HP Records Manager Secondary App Server', 'ip' => '10.100.8.13', 'inactive_flag' => 0, 'production_flag' => 1]);
// production app servers -- gis
Server::create(['operating_system_id' => 2, 'group_id' => 7, 'name' => 'cartegraph', 'description' => ' ', 'ip' => '10.100.8.77', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-10-08']);
// production app servers -- ti
Server::create(['operating_system_id' => 2, 'group_id' => 9, 'name' => 'commander', 'description' => 'Facility commander server', 'ip' => '10.100.8.19', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-11-09']);
// production web servers
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'webprod', 'description' => 'Production Web Server', 'ip' => '10.100.8.96', 'inactive_flag' => 0, 'production_flag' => 1]);
Server::create(['operating_system_id' => 4, 'group_id' => 6, 'name' => 'myPropApp', 'description' => 'myProperty Web Server', 'ip' => '172.17.1.23', 'inactive_flag' => 0, 'production_flag' => 1]);
Server::create(['operating_system_id' => 4, 'group_id' => 6, 'name' => 'msbwww2', 'description' => 'Primary Web Server', 'cname' => 'www', 'ip' => '172.17.1.36', 'inactive_flag' => 0, 'production_flag' => 1]);
Server::create(['operating_system_id' => 4, 'group_id' => 6, 'name' => 'msbwww1', 'description' => 'Secondary Web Server', 'cname' => 'ww2', 'ip' => '172.17.1.35', 'inactive_flag' => 0, 'production_flag' => 1]);
// production gis servers
Server::create(['operating_system_id' => 2, 'group_id' => 7, 'name' => 'ags2', 'description' => 'ArcGIS 10 Web Server', 'cname' => 'ags', 'ip' => '10.100.8.79', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2014-09-11']);
Server::create(['operating_system_id' => 2, 'group_id' => 7, 'name' => 'gis102ags', 'ip' => '10.100.8.133', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 2, 'group_id' => 7, 'name' => 'gis102geoproc', 'ip' => '10.100.8.134', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-08-27']);
Server::create(['operating_system_id' => 2, 'group_id' => 7, 'name' => 'gis102licmgr', 'ip' => '10.100.8.135', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 2, 'group_id' => 7, 'name' => 'gis102web', 'ip' => '10.100.8.136', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 2, 'group_id' => 7, 'name' => 'gis102sde', 'ip' => '10.100.8.137', 'inactive_flag' => 0, 'production_flag' => 1]);
// production sharepoint servers
Server::create(['operating_system_id' => 1, 'group_id' => 6, 'name' => 'spapp01', 'description' => 'Sharepoint Primary Application Server', 'ip' => '10.100.8.158', 'inactive_flag' => 0, 'production_flag' => 1]);
Server::create(['operating_system_id' => 1, 'group_id' => 6, 'name' => 'spowa01', 'description' => 'Sharepoint Office Web Apps Server', 'ip' => '10.100.8.161', 'inactive_flag' => 0, 'production_flag' => 1]);
Server::create(['operating_system_id' => 1, 'group_id' => 6, 'name' => 'spsql01', 'description' => 'Sharepoint SQL Production Server', 'ip' => '10.100.8.159', 'inactive_flag' => 0, 'production_flag' => 1]);
Server::create(['operating_system_id' => 1, 'group_id' => 6, 'name' => 'spsql02', 'description' => 'Sharepoint Production SQL Server Secondary', 'ip' => '10.100.8.160', 'inactive_flag' => 0, 'production_flag' => 1]);
Server::create(['operating_system_id' => 1, 'group_id' => 6, 'name' => 'spweb01', 'description' => 'Sharepoint Production Web Server 1', 'ip' => '10.100.8.162', 'inactive_flag' => 0, 'production_flag' => 1]);
Server::create(['operating_system_id' => 1, 'group_id' => 6, 'name' => 'spweb02', 'description' => 'Sharepoint Production Web Server 2', 'ip' => '10.100.8.163', 'inactive_flag' => 0, 'production_flag' => 1]);
// terminal servers
Server::create(['operating_system_id' => 3, 'group_id' => 9, 'name' => 'tserver1', 'description' => 'Terminal Server ', 'ip' => '10.100.8.36', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-08-13']);
// other production servers
Server::create(['operating_system_id' => 2, 'group_id' => 9, 'name' => 'dsjlicmgr', 'description' => 'License Manager Server', 'ip' => '10.100.8.49', 'inactive_flag' => 0, 'production_flag' => 1, 'last_windows_update' => '2015-08-27']);
Server::create(['operating_system_id' => 2, 'group_id' => 9, 'name' => 'dsjns1', 'description' => 'DNS Server', 'cname' => 'ns1', 'ip' => '172.17.1.20', 'inactive_flag' => 0, 'production_flag' => 1]);
Server::create(['operating_system_id' => 2, 'group_id' => 9, 'name' => 'dsjns2', 'description' => 'DNS Server', 'cname' => 'ns2', 'ip' => '172.17.1.21', 'inactive_flag' => 0, 'production_flag' => 1]);
Server::create(['operating_system_id' => 2, 'group_id' => 9, 'name' => 'dsjftp', 'description' => 'FTP Server', 'cname' => 'ftp', 'ip' => '172.17.1.12', 'inactive_flag' => 0, 'production_flag' => 1]);
// test sql servers - bi
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'govsqltst', 'description' => 'Govern Test SQL DB Server', 'cname' => 'governtst', 'ip' => '10.100.8.121', 'inactive_flag' => 0, 'production_flag' => 0, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'logossqltest', 'description' => 'Replacement server for logossqltst. ', 'ip' => '10.100.8.131', 'inactive_flag' => 0, 'production_flag' => 0, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'msbsqltst', 'description' => 'SQL test server', 'ip' => '10.100.8.107', 'inactive_flag' => 0, 'production_flag' => 0, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'sql2012dev', 'description' => 'SQL 2012 Development server', 'ip' => '10.100.8.123', 'inactive_flag' => 0, 'production_flag' => 0, 'last_windows_update' => '2015-09-24']);
// test sql servers - gis
Server::create(['operating_system_id' => 2, 'group_id' => 7, 'name' => 'sdesql10tst', 'description' => 'ArcGIS 10 Test Edit Server', 'ip' => '10.100.8.129', 'inactive_flag' => 0, 'production_flag' => 0, 'last_windows_update' => '2014-07-31']);
// test report servers
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'logosrpttest', 'description' => 'New logos reporting server to replace logosrpttst ', 'ip' => '10.100.8.130', 'inactive_flag' => 0, 'production_flag' => 0, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'sqlrpt', 'description' => ' ', 'ip' => '10.100.8.17', 'inactive_flag' => 0, 'production_flag' => 0, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'msbrpttst', 'description' => ' ', 'ip' => '10.100.8.124', 'inactive_flag' => 0, 'production_flag' => 0, 'last_windows_update' => '2015-01-15']);
// test app server
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'logostest', 'description' => 'Logos NextGen test server', 'ip' => '10.100.8.119', 'inactive_flag' => 0, 'production_flag' => 0, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'isupptst', 'description' => 'iSupport testing server', 'ip' => '10.100.8.125', 'inactive_flag' => 0, 'production_flag' => 0, 'last_windows_update' => '2015-10-15']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'trim7train', 'description' => 'Trim training server', 'ip' => '10.100.8.54', 'inactive_flag' => 0, 'production_flag' => 0, 'last_windows_update' => '2015-09-24']);
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'trim7test', 'ip' => '10.100.8.41', 'inactive_flag' => 0, 'production_flag' => 0, 'last_windows_update' => '2015-09-24']);
// test web servers
Server::create(['operating_system_id' => 2, 'group_id' => 6, 'name' => 'webdev', 'description' => 'Web development server', 'ip' => '10.100.8.73', 'inactive_flag' => 0, 'production_flag' => 0, 'last_windows_update' => '2015-10-08']);
// test gis servers
Server::create(['operating_system_id' => 2, 'group_id' => 7, 'name' => 'gis102agstst', 'ip' => '10.100.8.132', 'inactive_flag' => 0, 'production_flag' => 0, 'last_windows_update' => '2015-08-26']);
// test sharepoint servers
Server::create(['operating_system_id' => 1, 'group_id' => 6, 'name' => 'spapp01tst', 'description' => 'Sharepoint Test Application Server 1', 'ip' => '10.100.8.166', 'inactive_flag' => 0, 'production_flag' => 0]);
Server::create(['operating_system_id' => 1, 'group_id' => 6, 'name' => 'spsql01tst', 'description' => 'Sharepoint Test SQL Server 1', 'ip' => '10.100.8.167', 'inactive_flag' => 0, 'production_flag' => 0]);
Server::create(['operating_system_id' => 1, 'group_id' => 6, 'name' => 'spsql02tst', 'description' => 'Sharepoint Test SQL Server 2', 'ip' => '10.100.8.168', 'inactive_flag' => 0, 'production_flag' => 0]);
Server::create(['operating_system_id' => 1, 'group_id' => 6, 'name' => 'spweb01tst', 'description' => 'Sharepoint Test Web Server 2', 'ip' => '10.100.8.164', 'inactive_flag' => 0, 'production_flag' => 0]);
Server::create(['operating_system_id' => 1, 'group_id' => 6, 'name' => 'spweb02tst', 'description' => 'Sharepoint Test Web Server 2', 'ip' => '10.100.8.165', 'inactive_flag' => 0, 'production_flag' => 0]);
}
