Skip to content

Connecting to a database

BacBuster saves plates to a MySQL or MariaDB server, where Baclan, ExpManager and other instruments reach them too. The database in use is named on the toolbar, in yellow - for example /labserver/lab/bardot: server labserver, user lab, database bardot.

Choosing a database

Click the yellow label. The Database Connection window lists the servers, the users on each, and the databases each user can see.

The Database Connection window

Button Does
Add/Change Opens the Connection Editor for a new server, or for the one selected
Create New Database Makes a database with the name in the box beside it, for the selected server and user, with the tables BacBuster and Baclan need
Remove Forgets the selected server or user, after asking. The databases stay on the server
Refresh Asks the servers again which databases each user can see
Ok Uses the selected database. A double-click does the same
Close Leaves things as they were

The Connection Editor asks for the server's Host (name or address), its Port (usually 3306), the User and Password, and optionally a Host Short Name to show in place of the address. Test tries the connection; Ok adds it to the list.

The list is shared with Baclan and ExpManager on the same computer: a server added in one is there in the others.

Passwords are stored

The connections, passwords included, are kept in %APPDATA%\BaclAn\Servers.dat, so that BacBuster can connect by itself at start-up. Use accounts with no more rights than they need.

At start-up

BacBuster connects to the database on the label when it starts. If it cannot - no database chosen, server down, network gone - the red warning button appears on the toolbar with the hint Default Database Is NOT Set or Connection is lost. Plates can still be scanned and saved to files; click the label to choose a database that works, and click the warning button to dismiss it.

Database Options

Database Options on the Options tab opens the Manager, for whoever looks after the server. It logs in as the server's root user:

Control Does
Host, Port, Root Password, Connect Log in to the server
Users, Global Privileges The server's accounts and the selected one's rights
New User Name, Password With Create Read Only User or Create Full Access User: make an account
Change Password, Delete User For the selected user
Databases Read Only, Databases Full Access Tick databases and click Read Only or Full Access to give the selected user those rights
Init Recreates Service Table. Does NOT erase data.
Apply Updates (Full Access List) Brings the ticked databases up to the current table structure
Update Colony Thumbs Makes the small colony pictures in the ticked databases; Stop Update stops it

Warning

Back the server up before changing the structure of its databases.