How to Install Tania on NetBSD

Tania is an open-source, free, and private farm management software application. It helps you manage your farm operations and track your production data. In this tutorial, you'll learn how to install Tania on NetBSD, a BSD operating system.

Prerequisites

• A computer or virtual machine running NetBSD. You must have root-level access or sudo privileges.
• A terminal window to execute the commands.

Install Dependencies

1. Launch your terminal.
2. Run the following command to install required dependencies:

pkgin update
pkgin install nginx php73 php73-pdo_pgsql php73-fpm postgresql12-server tmux memcached

3. Once the installation completes, start the PostgreSQL server:

service postgresql onestart

Download and Configure Tania

1. Download the latest version of Tania from the official website: https://usetania.org/download
2. Extract the downloaded archive.

tar -xvf tania-x.x.x.tar.gz

3. Move the extracted files to the htdocs directory of nginx webserver:

mv tania-1.6.0 /usr/pkg/nginx/htdocs/tania

4. Create a new PostgreSQL database and user for Tania:

sudo -i -u postgres
createdb -E UTF8 tania_db
psql -c "CREATE USER tania_user WITH PASSWORD 'PASSWORD';"
psql -c "GRANT ALL PRIVILEGES ON DATABASE tania_db to tania_user;"
exit

5. Edit the Tania configuration file:

cd /usr/pkg/nginx/htdocs/tania
cp .env.example .env
vi .env

6. Find and update the following database configuration settings:

DB_CONNECTION=pgsql
DB_HOST=127.0.0.1
DB_PORT=5432
DB_DATABASE=tania_db
DB_USERNAME=tania_user
DB_PASSWORD=PASSWORD

7. Save and close the file.

Configure and Start nginx

1. Create a new virtual host configuration file for Tania:

cd /usr/pkg/nginx/conf/conf.d
vi tania.conf

2. Add the following configuration:

server {
    listen 80;
    server_name tania.example.com;

    index index.php;
    root /usr/pkg/nginx/htdocs/tania/public;

    access_log /var/log/nginx/tania_access.log;
    error_log /var/log/nginx/tania_error.log warn;

    location / {
        try_files $uri $uri/ /index.php?$query_string;
    }

    location ~* \.(gif|jpg|jpeg|png|svg|css|js|ico)$ {
        expires max;
        add_header Cache-Control "public, must-revalidate, proxy-revalidate";
        try_files $uri /index.php?s=$uri&$args;
    }

    location ~ \.php$ {
        fastcgi_pass unix:/var/run/php-fpm.sock;
        fastcgi_index index.php;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        fastcgi_param PATH_INFO $fastcgi_path_info;
        include fastcgi_params;
    }
}

Note: Replace tania.example.com with your server's domain name or IP address.

3. Save and close the file.
4. Restart nginx:

service nginx restart

Start Tania Services

1. Launch a new terminal window or tab.
2. Navigate to Tania's root directory:

cd /usr/pkg/nginx/htdocs/tania

3. Start the PHP server:

tmux new-session -s tania -d 'php -S 127.0.0.1:8080 -t public'

4. Start the Memcached server:

memcached -d -u root

5. Access Tania in your web browser by visiting http://tania.example.com.

Conclusion

Congratulations! You have successfully installed Tania on NetBSD. You can now start managing your farm operations and tracking your production data with Tania.