/fksdb

Just FKSDB :)

Primary LanguagePHP

FKSDB logo

Lines of code GitHub commit activity
GitHub issues GitHub pull requests GitHub branch checks state

Installation

  • install PHP8.1 + extension
    • php8.1
    • php8.1-cli
    • php8.1-common
    • php8.1-curl
    • php8.1-json
    • php8.1-mbstring
    • php8.1-mysql
    • php8.1-opcache
    • php8.1-readline
    • php8.1-soap
    • php8.1-sqlite3
    • php8.1-xdebug
    • php8.1-xml
    • php8.1-xmlrpc
  • install composer
  • install MySQL/mariaDB

Initialization

0.1) Checkout branch master

0.2) Run git submodule init && git submodule update

0.3) Run composer install

Environment

  1. Create /etc/hosts entries for addresses db.fykos.local and auth.fykos.local.
127.0.0.1   fykos.local fykos.localen 
127.0.0.1   db.fykos.local db.fykos.localen
127.0.0.1   auth.fykos.local
  1. Configure virtual hosts in /etc/apache/sites-available with proper ServerName and ServerAlias (see domains above). Create a symlink to that file in /etc/apache/sites-enabled (You need only virtual host for FKSDB.)
<VirtualHost db.fykos.local auth.fykos.local>
	ServerAdmin webmaster@localhost
	DocumentRoot /absolute/path/to/fksdb/root/www/

	ErrorLog ${APACHE_LOG_DIR}/error-fksdb.log
        <Directory /absolute/path/to/fksdb/root/www/>
            Options FollowSymLinks
            AllowOverride All
            Require all granted
        </Directory>


        # Possible values include: debug, info, notice, warn, error, crit,
        # alert, emerg.
        LogLevel notice

        CustomLog ${APACHE_LOG_DIR}/access-fksdb.log combined
</VirtualHost>

Database

  1. Run sql/schema.sql and sql/initval.sql in your MySQL database.

  2. Run sql/views.sql in your MySQL database. May require two times execution due to bad sorting.

Configuration

  1. Copy app/config/config.local.neon.sample to app/config/config.local.neon and fill it with proper values (don't forget to add domain settings like: domain: cz: fykos.local org: fykos.localen tld: local

  2. Make directories temp/, log/ and upload/ writable by your Apache user.

Run

  1. Register yourself and then add superuser role to the created login.

Troubleshooting

  • make sure the path has the +x property, i.e. sudo chmod +x /home, sudo chmod +x /home/user, sudo chmod +x /home/user/fksdb_path