Deployment Readiness

SMARTS system setup

This page checks the configured MySQL connection, confirms that the SQL package exists, and can install the required SMARTS tables and seed accounts into the configured database.

Current Status

Installation checks

MySQL serverUnavailable
SQL packageFound
Database readyNo
Configured DBsmarts_db
Configured host127.0.0.1:3306
Configured userroot
Database server connection failed: Access denied for user 'root'@'localhost' (using password: YES)
SQL file: /home/isucauayanopac/public_html/smarts.isucauayan-opac.online/database/smarts_schema.sql
Password in current config: ****

Install Database

First-time setup

The installer will create the configured database if your MySQL account has permission, import database/smarts_schema.sql, and make sure the runtime upload and storage folders exist.

Open login
If your host does not expose environment variables, copy config/local.example.php to config/local.php and enter the real database credentials before running the installer.

Online Hosting Notes

What to configure after upload

Writable pathsuploads/, storage/
Rewrite supportApache .htaccess enabled
Upload limits50M or higher
Base URLSet in config/local.php if hosted in a subfolder