Introducing the BaseHead Database Server!
BaseHead now has the ability to access a centralized database with a custom version of cubeSQL. This allows you to share and edit the same database without file locking issues. This also gives you the ability to import new files and rename existing files at the same time with up to 10,000 concurrent connections all with user permissions.
Here’s some of what the cubeSQL server will allow you to do:
- Have Multiple Centralized Databases.
- Users Permissions are settable to allow some users to edit the database and lock others out. (Great for students or interns to prevent them for doing damage)
- Users can add files to the database and at the same time others could be editing [descriptions] while others are searching and playing without Database locking problems.
- Faster searching compared to just putting the Database on a server and selecting it since the client/server connection is compressed for speed benefits.
- You’ll see the Local DB’s and Server all in the DB Hotswap box for quick switching between them.
- Backup and Restore Features of the database with scheduling and Restore Points.
- Also, previously you couldn’t put a SQLite database on a network volume cuz it was painfully slow. This is fixed when using cubeSQL with BaseHead! … 8)
- Install the cubeSQL software on the server it will reside on and choose either the 32 or 64 bit version.
- Once cubeSQL is installed, launch it and use the default hostname:user:pass of localhost:admin:admin and press ‘Connect’
- Then go to the Server Menu and click on “Register Server” and enter in the Name and Key that was provided by BaseHead, LLC.
- Next…to import a database to the server first select the ‘Databases’ Tab in the Left Sidebar and then from the menu select Server/Upload Databases.
OR starting in BaseHead clients v2020.12 or higher Admins can use the ‘Upload Database to Server’ menu item inside the Database Menu. This allows you to shoot over the currently loaded Database to cubeSQL directly now.
Note: You can’t create a new DB on the server because it doesn’t not know the format used by BaseHead. You must create a database in BaseHead first then choose the option in BaseHead to upload to server, or use the upload database operation in cubeSQL and select the database created in BaseHead.
- The default account to login is admin:admin that you can use for testing to get you up and running quickly for testing, but you should probably change that later to something more secure once all setup at some point. 😉
- Next write down what I.P. of the server cuz you need it on the next step.
You can find it on the Status page.
- We are now done with the server side of things, so next head over to your BaseHead client machines.
- Next…launch BaseHead and connect to cubeSQL by going to the Options Page, and check “Enable” in the Server Section and then add in the I.P. address you just wrote down a minute ago and press ‘Connect’
(This Server section is only shown in Ultra by default, but a server addon can be purchased for the Standard and Lite Editions also now)
- If you haven’t made any other user accounts yet and just want to play then just use your default admin/admin account and press ‘Connect’ again and you should see this then:
Now you are ready to go! You should see all databases you loaded onto the server appear on bottom left the Database Hotswap box prefixed with a (S)
What are the best ways to set up my privileges?
Basically, you only need two to three users for everyone, but this is totally up to you and this will get you started at least. Your main admin one, a limited account for the interns and a standard account for the non-interns and everyone else. (see below image)
You could make a separate user for every user in your facility later if you think it’s needed.
And this is how you would set up the privileges for each.
TIP: You really want to deny those damn interns UPDATE and INSERT permissions the most to prevent them for doing damage to your database or files…haha
So….that should get you started hopefully, but you should also read the cubeSQL documentation included to learn everything this program can do. 😉
- If you are having trouble connecting, check your firewall settings.
You might need to open up port 4430.
- If you install cubeSQL on the same machine as BH for tests you can just use “localhost” for the I.P. instead.
Clients that can connect to the server:
The BaseHead Ultra Edition can connect out of the box.
BaseHead Standard and Lite can also connect to a BH Server Add-on license per seat.
Requirements: (Server side)
MacOS X: 10.8 or Higher
Linux: Linux Kernel 2.6.2 or Higher
Synology DiskStations can now also now run cubeSQL