Skip to content

VitexSoftware/DEBs-to-SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

91 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

DEBs-to-SQL

SQL Database of debian packages and its contents indexer

Project Logo

Installation

You can use our repo:

sudo apt install lsb-release wget
echo "deb http://repo.vitexsoftware.cz $(lsb_release -sc) main" | sudo tee /etc/apt/sources.list.d/vitexsoftware.list
sudo wget -O /etc/apt/trusted.gpg.d/vitexsoftware.gpg http://repo.vitexsoftware.cz/keyring.gpg
sudo apt update
sudo apt install debs2sql

Configuration

edit /etc/debs2sql/.env :

APP_DEBUG=true
EASE_LOGGER=syslog|console  see  
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=debs2sql
DB_USERNAME=debs2sql
DB_PASSWORD=debs2sql
EMAIL_FROM=debs2sql@localhost
SEND_INFO_TO=admin@localhost
REPO_DIR=/home/vitex/WWW/repo.vitexsoftware.cz/

See https://github.com/VitexSoftware/php-ease-core for EASE_LOGGER options See https://github.com/VitexSoftware/php-ease-fluentpdo for DB_CONNECTION options

and run debs2sql-phinx to prepare database structure

Usage

simply run

debs2sql

to index all new packages into database

Results