libtransport.git Files · docs/guide/mysql.textile

Files @ d11fdaf3e279

Branch filter:

Location: libtransport.git/docs/guide/mysql.textile

d11fdaf3e279 881 B text/plain Show Annotation Show as Raw Download as Raw

Sebastian Krzyszkowiak

systemd: wait for network-online.target and add WantedBy=multi-user.target

Thanks to that, "systemctl enable spectrum2" does what expected, that is
makes Spectrum2 start on boot. Also, network.target doesn't tell anything
meaningful - it's just that the network stack is available.
Adding network-online.target makes sure that the network interfaces are up
before starting Spectrum2.

h2. 1. Editing the configuration file

To configure Spectrum 2 to use MySQL database, you have to edit following options in database section:

|_. Section |_. Key |_. Type |_. Change to value |_. Description |
| database| type | string | mysql | Database type - "none", "mysql", "sqlite3", "pqxx". |
| database| database | string | Name of the already create empty database | Database used to store data. |
| database| server | string | Database server | Database server. |
| database| user | string | MySQL user. | MySQL user. |
| database| password | string | MySQL Password. | MySQL Password. |
| database| prefix | string | | Prefix of tables in database. |

h2. 2. Creating the database

Spectrum 2 will create the database on the first execution. Once the database is created, you can remove the CREATE TABLE permissions to the MySQL database user you use to connect the SQL.