ServerKit is a lightweight, modern server control panel for managing web applications, databases, and services on your VPS or dedicated server. Built with Python/Flask backend and React frontend.
Python astracloudflarecontrol-panelcyberpaneldnsfablehosting-control-panelhosting-panelkimi-k3server-managementserverkitubuntu-web-panelwebserver
import { useEffect, useId, useState } from 'react';
import { Plus } from 'lucide-react';
import api from '../../services/api';
import Modal from '@/components/Modal';
import { Button } from '@/components/ui/button';
import { Input } from '@/components/ui/input';
import { Select, SelectTrigger, SelectContent, SelectItem, SelectValue } from '@/components/ui/select';
import CopyField from '@/components/CopyField';
import { EngineIcon } from '../icons/DatabaseBrands';
import { ENGINE_META } from './dbAdapter';
import { useTranslation } from 'react-i18next';
// Create / credentials modals for the explorer. Logic is unchanged from the
// original Databases page; the explorer wires them to its toolbar and tree.
// Each modal component is mounted only while open, so Modal `open` is constant.
// The submit button stays inside <form>, so actions live in the body (not the
// Modal footer slot).
// Radix Select items cannot carry an empty value; this stands for "none".
const NONE = '__none';
// "Grant privileges on database": a database name, or '' for none.
function DatabaseSelect({ id, databases, value, onChange }) {
const { t } = useTranslation();
return (
<Select value={value === '' ? NONE : value} onValueChange={(next) => onChange(next === NONE ? '' : next)}>
<SelectTrigger id={id}><SelectValue /></SelectTrigger>
<SelectContent>
<SelectItem value={NONE}>{t('app.modals.none', 'None')}</SelectItem>
{databases.map((db) => <SelectItem key={db.name} value={db.name}>{db.name}</SelectItem>)}
</SelectContent>
</Select>
);
}
function CredentialsResult({ title, rows, onDone }) {
const { t } = useTranslation();
return (
<Modal open onClose={onDone} title={title}>
<div className="credentials-box dbx-credentials">
<p>{t('app.modals.saveTheseCredentialsThePasswordWon', "Save these credentials. The password won't be shown again.")}</p>
{rows.map(([label, value, secret]) => (
<CopyField key={label} label={label} value={value} secret={Boolean(secret)} />
))}
</div>
<div className="modal-actions">
<Button onClick={onDone}>{t('common.actions.done', 'Done')}</Button>
</div>
</Modal>
);
}
// One "New database" modal for every engine the panel can create into, rather
// than one modal per engine. It adds two things the old pair never surfaced:
//
// * an engine picker, with a route out to the engine catalog when the engine
// you want isn't installed yet;
// * "Attach to application", which sends `application_id` — the create
// endpoints have always accepted it, the UI simply never offered it, so
// every database created here was born unowned.
//
// Only host MySQL / PostgreSQL accept a create call today. Engines installed
// from the catalog run as their own service and are reached through their own
// client, so listing them here as pickable would be a promise we can't keep.
const CREATABLE_ENGINES = ['mysql', 'postgresql'];
function EnginePicker({ value, onChange, status, onInstallEngine }) {
const { t } = useTranslation();
return (
<div className="dbx-eng-pick">
{CREATABLE_ENGINES.map((engine) => {
const running = Boolean(status?.[engine]?.installed && status?.[engine]?.running);
return (
<Button variant="unstyled"
key={engine}
type="button"
className={`dbx-eng-opt${value === engine ? ' is-on' : ''}`}
onClick={() => onChange(engine)}
disabled={!running}
title={running ? undefined : t('app.modals.isNotRunning', '{{label}} is not running', { label: ENGINE_META[engine].label })}
>
<span className={`dbx-eng-opt__ico is-${engine}`}>
<EngineIcon engine={engine} size={16} />
</span>
<span className="dbx-eng-opt__text">
<span className="dbx-eng-opt__name">{ENGINE_META[engine].label}</span>
<span className="dbx-eng-opt__sub">{running ? t('app.modals.running', 'running') : t('app.modals.notRunning', 'not running')}</span>
</span>
</Button>
);
})}
{onInstallEngine && (
<Button variant="unstyled"
type="button"
className="dbx-eng-opt dbx-eng-opt--ghost"
onClick={onInstallEngine}
>
<span className="dbx-eng-opt__ico"><Plus size={16} aria-hidden="true" /></span>
<span className="dbx-eng-opt__text">
<span className="dbx-eng-opt__name">{t('app.modals.installAnEngine', 'Install an engine')}</span>
<span className="dbx-eng-opt__sub">{t('app.modals.fromTheTemplateCatalog', 'from the template catalog')}</span>
</span>
</Button>
)}
</div>
);
}
export function CreateDatabaseModal({ engine: initialEngine = 'mysql', status, onClose, onCreated, onInstallEngine }) {
const { t } = useTranslation();
const fieldId = useId();
const [engine, setEngine] = useState(initialEngine);
const [formData, setFormData] = useState({
name: '', charset: 'utf8mb4', collation: 'utf8mb4_unicode_ci', encoding: 'UTF8', create_user: true,
});
const [applicationId, setApplicationId] = useState('');
const [apps, setApps] = useState([]);
const [appsLoading, setAppsLoading] = useState(true);
const [loading, setLoading] = useState(false);
const [error, setError] = useState('');
const [createdInfo, setCreatedInfo] = useState(null);
// Attaching is optional, so a failed app lookup must not block the create —
// the selector just stays empty.
useEffect(() => {
let cancelled = false;
api.getApps()
.then((d) => { if (!cancelled) setApps(d.apps || []); })
.catch(() => { if (!cancelled) setApps([]); })
.finally(() => { if (!cancelled) setAppsLoading(false); });
return () => { cancelled = true; };
}, []);
const isMySQL = engine === 'mysql';
async function handleSubmit(e) {
e.preventDefault();
setError('');
setLoading(true);
try {
const payload = isMySQL
? { name: formData.name, charset: formData.charset, collation: formData.collation, create_user: formData.create_user }
: { name: formData.name, encoding: formData.encoding, create_user: formData.create_user };
if (applicationId) payload.application_id = Number(applicationId);
const result = isMySQL
? await api.createMySQLDatabase(payload)
: await api.createPostgreSQLDatabase(payload);
if (result.success) {
if (result.password) setCreatedInfo({ database: formData.name, user: result.user, password: result.password });
else { onCreated(); onClose(); }
}
} catch (err) {
setError(err.message || 'Failed to create database');
} finally {
setLoading(false);
}
}
if (createdInfo) {
const attached = apps.find((a) => String(a.id) === String(applicationId));
return (
<CredentialsResult
title={t('app.modals.databaseCreated', 'Database created')}
rows={[
['Database', createdInfo.database],
['Username', createdInfo.user],
['Password', createdInfo.password, true],
...(attached ? [['Attached to', attached.name]] : []),
]}
onDone={() => { onCreated(); onClose(); }}
/>
);
}
return (
<Modal open onClose={onClose} title={t('app.modals.newDatabase', 'New database')}>
{error && <div className="error-message">{error}</div>}
<form onSubmit={handleSubmit}>
<div className="form-group">
<label>{t('app.modals.engine', 'Engine')}</label>
<EnginePicker
value={engine}
onChange={setEngine}
status={status}
onInstallEngine={onInstallEngine ? () => { onClose(); onInstallEngine(); } : null}
/>
</div>
<div className="form-group">
<label htmlFor={`${fieldId}-name`}>{t('app.modals.databaseName', 'Database name *')}</label>
<Input id={`${fieldId}-name`} type="text" value={formData.name} onChange={(e) => setFormData({ ...formData, name: e.target.value })} placeholder="my_database" required pattern="[a-zA-Z0-9_]+" autoFocus />
</div>
{isMySQL ? (
<div className="form-row">
<div className="form-group">
<label htmlFor="dbx-new-charset">{t('app.modals.characterSet', 'Character set')}</label>
<Select value={formData.charset} onValueChange={(value) => setFormData({ ...formData, charset: value })}>
<SelectTrigger id="dbx-new-charset"><SelectValue /></SelectTrigger>
<SelectContent>
<SelectItem value="utf8mb4">utf8mb4</SelectItem>
<SelectItem value="utf8">utf8</SelectItem>
<SelectItem value="latin1">latin1</SelectItem>
</SelectContent>
</Select>
</div>
<div className="form-group">
<label htmlFor="dbx-new-collation">{t('app.modals.collation', 'Collation')}</label>
<Select value={formData.collation} onValueChange={(value) => setFormData({ ...formData, collation: value })}>
<SelectTrigger id="dbx-new-collation"><SelectValue /></SelectTrigger>
<SelectContent>
<SelectItem value="utf8mb4_unicode_ci">utf8mb4_unicode_ci</SelectItem>
<SelectItem value="utf8mb4_general_ci">utf8mb4_general_ci</SelectItem>
<SelectItem value="utf8_general_ci">utf8_general_ci</SelectItem>
</SelectContent>
</Select>
</div>
</div>
) : (
<div className="form-group">
<label htmlFor="dbx-new-encoding">{t('app.modals.encoding', 'Encoding')}</label>
<Select value={formData.encoding} onValueChange={(value) => setFormData({ ...formData, encoding: value })}>
<SelectTrigger id="dbx-new-encoding"><SelectValue /></SelectTrigger>
<SelectContent>
<SelectItem value="UTF8">UTF8</SelectItem>
<SelectItem value="LATIN1">LATIN1</SelectItem>
<SelectItem value="SQL_ASCII">SQL_ASCII</SelectItem>
</SelectContent>
</Select>
</div>
)}
<div className="form-group">
<label htmlFor="dbx-attach-app">{t('app.modals.attachToApplication', 'Attach to service')}</label>
<Select
value={applicationId === '' ? NONE : String(applicationId)}
onValueChange={(value) => setApplicationId(value === NONE ? '' : value)}
disabled={appsLoading}
>
<SelectTrigger id="dbx-attach-app"><SelectValue /></SelectTrigger>
<SelectContent>
<SelectItem value={NONE}>{t('app.modals.none', 'None')}</SelectItem>
{apps.map((app) => <SelectItem key={app.id} value={String(app.id)}>{app.name}</SelectItem>)}
</SelectContent>
</Select>
<span className="form-help">
{appsLoading
? t('app.modals.loadingServices', 'Loading services…')
: t('app.modals.attachServiceHint', 'Optional. An attached database is listed on the service and is cleaned up with it.')}
</span>
</div>
<div className="form-group">
<label className="checkbox-label">
<input type="checkbox" checked={formData.create_user} onChange={(e) => setFormData({ ...formData, create_user: e.target.checked })} />
{t('app.modals.createUserWithSameNameAnd', 'Create user with same name and full privileges')}
</label>
</div>
<div className="modal-actions">
<Button type="button" variant="outline" onClick={onClose}>{t('common.actions.cancel', 'Cancel')}</Button>
<Button type="submit" disabled={loading}>{loading ? t('app.modals.creating', 'Creating…') : t('app.modals.createDatabase', 'Create database')}</Button>
</div>
</form>
</Modal>
);
}
export function CreateMySQLUserModal({ databases, onClose, onCreated }) {
const { t } = useTranslation();
const fieldId = useId();
const [formData, setFormData] = useState({ username: '', password: '', host: 'localhost', database: '', privileges: 'ALL' });
const [loading, setLoading] = useState(false);
const [error, setError] = useState('');
const [createdInfo, setCreatedInfo] = useState(null);
async function generatePassword() {
try {
const result = await api.generateDatabasePassword();
setFormData({ ...formData, password: result.password });
} catch (err) {
console.error('Failed to generate password:', err);
}
}
async function handleSubmit(e) {
e.preventDefault();
setError('');
setLoading(true);
try {
const result = await api.createMySQLUser(formData);
if (result.success) setCreatedInfo({ username: formData.username, password: result.password, host: formData.host });
} catch (err) {
setError(err.message || 'Failed to create user');
} finally {
setLoading(false);
}
}
if (createdInfo) {
return (
<CredentialsResult
title={t('app.modals.userCreated', 'User created')}
rows={[['Username', createdInfo.username], ['Password', createdInfo.password, true], ['Host', createdInfo.host]]}
onDone={() => { onCreated(); onClose(); }}
/>
);
}
return (
<Modal open onClose={onClose} title={t('app.modals.createMysqlUser', 'New MySQL user')}>
{error && <div className="error-message">{error}</div>}
<form onSubmit={handleSubmit}>
<div className="form-group">
<label htmlFor={`${fieldId}-username`}>{t('app.modals.username', 'Username *')}</label>
<Input id={`${fieldId}-username`} type="text" value={formData.username} onChange={(e) => setFormData({ ...formData, username: e.target.value })} placeholder="db_user" required autoFocus />
</div>
<div className="form-group">
<label htmlFor={`${fieldId}-password`}>{t('common.labels.password', 'Password')}</label>
<div className="input-with-button">
<Input id={`${fieldId}-password`} type="text" value={formData.password} onChange={(e) => setFormData({ ...formData, password: e.target.value })} placeholder={t('app.modals.leaveEmptyToAutoGenerate', 'Leave empty to auto-generate')} />
<Button type="button" variant="outline" size="sm" onClick={generatePassword}>{t('app.modals.generate', 'Generate')}</Button>
</div>
</div>
<div className="form-group">
<label htmlFor="dbx-mysql-user-host">{t('app.modals.host', 'Host')}</label>
<Select value={formData.host} onValueChange={(value) => setFormData({ ...formData, host: value })}>
<SelectTrigger id="dbx-mysql-user-host"><SelectValue /></SelectTrigger>
<SelectContent>
<SelectItem value="localhost">localhost</SelectItem>
<SelectItem value="%">{t('app.modals.anyHost', '% (any host)')}</SelectItem>
<SelectItem value="127.0.0.1">127.0.0.1</SelectItem>
</SelectContent>
</Select>
</div>
<div className="form-group">
<label htmlFor="dbx-mysql-user-db">{t('app.modals.grantPrivilegesOnDatabase', 'Grant privileges on database')}</label>
<DatabaseSelect
id="dbx-mysql-user-db"
databases={databases}
value={formData.database}
onChange={(value) => setFormData({ ...formData, database: value })}
/>
</div>
<div className="modal-actions">
<Button type="button" variant="outline" onClick={onClose}>{t('common.actions.cancel', 'Cancel')}</Button>
<Button type="submit" disabled={loading}>{loading ? t('app.modals.creating', 'Creating…') : t('app.modals.createUser', 'Create user')}</Button>
</div>
</form>
</Modal>
);
}
export function CreatePostgreSQLUserModal({ databases, onClose, onCreated }) {
const { t } = useTranslation();
const fieldId = useId();
const [formData, setFormData] = useState({ username: '', password: '', database: '' });
const [loading, setLoading] = useState(false);
const [error, setError] = useState('');
const [createdInfo, setCreatedInfo] = useState(null);
async function generatePassword() {
try {
const result = await api.generateDatabasePassword();
setFormData({ ...formData, password: result.password });
} catch (err) {
console.error('Failed to generate password:', err);
}
}
async function handleSubmit(e) {
e.preventDefault();
setError('');
setLoading(true);
try {
const result = await api.createPostgreSQLUser(formData);
if (result.success) setCreatedInfo({ username: formData.username, password: result.password });
} catch (err) {
setError(err.message || 'Failed to create user');
} finally {
setLoading(false);
}
}
if (createdInfo) {
return (
<CredentialsResult
title={t('app.modals.userCreated', 'User created')}
rows={[['Username', createdInfo.username], ['Password', createdInfo.password, true]]}
onDone={() => { onCreated(); onClose(); }}
/>
);
}
return (
<Modal open onClose={onClose} title={t('app.modals.createPostgresqlUser', 'New PostgreSQL user')}>
{error && <div className="error-message">{error}</div>}
<form onSubmit={handleSubmit}>
<div className="form-group">
<label htmlFor={`${fieldId}-username`}>{t('app.modals.username', 'Username *')}</label>
<Input id={`${fieldId}-username`} type="text" value={formData.username} onChange={(e) => setFormData({ ...formData, username: e.target.value })} placeholder="db_user" required autoFocus />
</div>
<div className="form-group">
<label htmlFor={`${fieldId}-password`}>{t('common.labels.password', 'Password')}</label>
<div className="input-with-button">
<Input id={`${fieldId}-password`} type="text" value={formData.password} onChange={(e) => setFormData({ ...formData, password: e.target.value })} placeholder={t('app.modals.leaveEmptyToAutoGenerate', 'Leave empty to auto-generate')} />
<Button type="button" variant="outline" size="sm" onClick={generatePassword}>{t('app.modals.generate', 'Generate')}</Button>
</div>
</div>
<div className="form-group">
<label htmlFor="dbx-pg-user-db">{t('app.modals.grantPrivilegesOnDatabase', 'Grant privileges on database')}</label>
<DatabaseSelect
id="dbx-pg-user-db"
databases={databases}
value={formData.database}
onChange={(value) => setFormData({ ...formData, database: value })}
/>
</div>
<div className="modal-actions">
<Button type="button" variant="outline" onClick={onClose}>{t('common.actions.cancel', 'Cancel')}</Button>
<Button type="submit" disabled={loading}>{loading ? t('app.modals.creating', 'Creating…') : t('app.modals.createUser', 'Create user')}</Button>
</div>
</form>
</Modal>
);
}