resources/views/install/database.blade.php
@extends('layouts.install')
@section('content')
<div class="row">
<div class="col-12">
<div class="card mb-2">
<div id="db-form-header"
class="card-header h6"
data-toggle="collapse"
href="#db-form-container"
aria-expanded="@if($valid_credentials) false @else true @endif"
>
<span id="credential-status">
@if($valid_credentials === null)
<i class="fa-solid fa-lg fa-square-question text-muted"></i>
@elseif($valid_credentials)
<i class="fa-solid fa-lg fa-square-check text-success"></i>
@else
<i class="fa-solid fa-lg fa-rectangle-xmark text-danger"></i>
@endif
</span>
{{ __('install.database.credentials') }}
<span class="float-right"><i class="fa-solid fa-lg fa-chevron-down rotate-if-collapsed"></i></span>
</div>
<div id="db-form-container" class="card-body collapse @if(!$valid_credentials) show @endif">
<form id="database-form" class="form-horizontal" role="form" method="post" action="{{ route('install.acton.test-database') }}">
@csrf
<div class="form-row pb-3">
<label for="host" class="col-4 col-form-label text-right">{{ __('install.database.host') }}</label>
<div class="col-6">
<input type="text" class="form-control" name="host" id="host" value="{{ $host ?? 'localhost' }}" placeholder="{{ __('install.database.host_placeholder') }}">
</div>
</div>
<div class="form-row pb-3">
<label for="port" class="col-4 col-form-label text-right">{{ __('install.database.port') }}</label>
<div class="col-6">
<input type="text" class="form-control" name="port" id="port" value="{{ $port ?? 3306 }}" placeholder="{{ __('install.database.port_placeholder') }}">
</div>
</div>
<div class="form-row pb-3">
<label for="unix_socket" class="col-4 col-form-label text-right">{{ __('install.database.socket') }}</label>
<div class="col-6">
<input type="text" class="form-control" name="unix_socket" id="unix_socket" value="{{ $unix_socket ?? '' }}" placeholder="{{ __('install.database.socket_placeholder') }}">
</div>
</div>
<div class="form-row pb-3">
<label for="username" class="col-4 col-form-label text-right">{{ __('install.database.username') }}</label>
<div class="col-6">
<input type="text" class="form-control" name="username" id="username" value="{{ $username ?? 'librenms' }}">
</div>
</div>
<div class="form-row pb-3">
<label for="password" class="col-4 col-form-label text-right">{{ __('install.database.password') }}</label>
<div class="col-6">
<input type="password" class="form-control" name="password" id="password" value="{{ $password ?? '' }}">
</div>
</div>
<div class="form-row pb-3">
<label for="database" class="col-4 col-form-label text-right">{{ __('install.database.name') }}</label>
<div class="col-6">
<input type="text" class="form-control" name="database" id="database" value="{{ $database ?? 'librenms' }}">
</div>
</div>
<div class="row">
<div class="col-12">
<button type="submit" class="btn btn-primary float-right">{{ __('install.database.test') }}</button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
<div id="migrate-step" class="row" @if(!$valid_credentials) style="display: none" @endif>
<div class="col-12">
<div class="card">
<div id="db-form-header"
class="card-header h6"
data-toggle="collapse"
href="#migrate-container"
aria-expanded="@if($migrated) false @else true @endif"
>
<span id="migrate-status">
@if($migrated === null)
<i class="fa-solid fa-lg fa-square-question text-muted"></i>
@elseif($migrated)
<i class="fa-solid fa-lg fa-square-check text-success"></i>
@else
<i class="fa-solid fa-lg fa-rectangle-xmark text-danger"></i>
@endif
</span>
{{ __('install.migrate.migrate') }}
<span class="float-right"><i class="fa-solid fa-lg fa-chevron-down rotate-if-collapsed"></i></span>
</div>
<div id="migrate-container" class="card-body collapse @if(!$migrated) show @endif">
<div class="row">
<div class="col-md-8">
<div id="migrate-warning" class="alert alert-warning">{{ __('install.migrate.building_interrupt') }}</div>
</div>
<div class="col-md-4 text-right">
<button id="migrate-btn" type="button" class="btn btn-primary mt-1 mb-4">
{{ __('install.migrate.migrate') }}
</button>
</div>
</div>
<textarea readonly id="db-update" class="form-control" rows="20" placeholder="{{ __('install.migrate.wait') }}"></textarea>
</div>
</div>
</div>
</div>
@endsection
@section('scripts')
<script>
$('#database-form').on("submit", function (event) {
event.preventDefault();
$('#credential-status>i').attr('class', 'fa-solid fa-lg fa-spinner fa-spin');
$('#error-box').empty();
$.ajax({
type: 'POST',
dataType: "json",
url: $('#database-form').attr('action'),
data: $('#database-form').serialize(),
success: function (response) {
if (response.result === 'ok') {
$('#credential-status>i').attr('class', 'fa-solid fa-lg fa-square-check text-success');
$('#migrate-step').show();
$('#db-form-container').collapse('hide')
} else {
$('#credential-status>i').attr('class', 'fa-solid fa-lg fa-rectangle-xmark text-danger')
if (response.message) {
$('#error-box').append($('<div class="alert alert-danger">' + response.message + '</div>'))
}
}
checkStepStatus();
},
});
});
$('#migrate-btn').on("click", function () {
$('#migrate-warning').show()
$('#migrate-status>i').attr('class', 'fa-solid fa-lg fa-spinner fa-spin');
$('#error-box').empty();
$('#migrate-btn').prop('disabled', true).addClass('disabled')
var output = document.getElementById("db-update");
var xhr = new XMLHttpRequest();
xhr.open("GET", "{{ route('install.action.migrate') }}", true);
xhr.setRequestHeader('X-Requested-With', 'XMLHttpRequest');
xhr.withCredentials = true;
xhr.onprogress = function (e) {
output.innerHTML = e.currentTarget.responseText;
output.scrollTop = output.scrollHeight - output.clientHeight; // scrolls the output area
if (output.innerHTML.indexOf('Error!') !== -1) {
// if error word in output, show the retry button
$('#migrate-warning').hide();
$('#migrate-status>i').attr('class', 'fa-solid fa-lg fa-rectangle-xmark text-danger')
$('#migrate-btn').prop('disabled', false).removeClass('disabled').text('{{ __('install.migrate.retry') }}')
$('#error-box').append($('<div class="alert alert-danger">{{ __('install.migrate.error') }}</div>'));
}
};
xhr.timeout = 240000; // if no response for 4m, allow the user to retry
xhr.ontimeout = function (e) {
$('#migrate-warning').hide();
$('#error-box').append($('<div class="alert alert-danger">{{ __('install.migrate.timeout') }}</div>'));
};
xhr.onreadystatechange = function () {
if (xhr.readyState === XMLHttpRequest.DONE && xhr.status === 200) {
$('#migrate-warning').hide();
checkStepStatus(function (status) {
if (status.database.complete) {
$('#migrate-status>i').attr('class', 'fa-solid fa-lg fa-square-check text-success');
$('#migrate-container').collapse('hide');
}
});
}
};
xhr.send();
});
</script>
@endsection
@section('style')
<style type="text/css">
#db-update {
resize: vertical;
}
#migrate-warning {
display: none;
}
</style>
@endsection