I’m trying to add the MBS SQL extensions to a CubeSQLServer. The CubeSQLServer is not restarting after I copied the Linux Extension file to the cubesql plugin folder (file MBS64.so)
The installation file says:
[code]On Cube SQL Server
Copy the plugin file to the plugins directory from the server. You should find a cubesql folder in the places listed below and drop the plugin file into the plugins folder.
You can copy the MBS.cubesqlplugin file or the extension library file (MBS.dylib, MBS.so or MBS.dll), but not both.
As of version 1.3, we have 64bit support only on Mac and Windows. You can request it for other platforms. But until we work on that, you may simply use the 32bit version of cubesql.
MacOS: Copy MBS.dylib to /Library/cubesql/plugins.
Windows XP: Copy MBS32.dll to C:\Documents and Settings\All Users\Application Data\cubesql\Plugins.
Windows Vista/7: Copy MBS32.dll to C:\ProgramData\cubesql\Plugins.
Linux: Copy MBS32.so to /var/opt/cubesql/plugins.[/code]
I have Ubuntu Linux Server 18.04 with CubeSQLServer (5.7.2 64bit) running.
When I remove the MBS64.so file from the servers plugin folder, then I can restart cubesql, otherwise not.
[b]1) Are there other requirements for installation?
- In order to use the MBS SQL functions, will I also need the plugin in Xojo or is it sufficient to have the extension on the server?[/b]
For instance: Once the extension would be up and runnin on the cubesqlserver, could I send such sql statement from SQLiteManager, or would I need to install an extension locally as well? (select InstrRevMBS(“Hello World. World.”, “World”))
3) What and where is the licensefile? I have received an email with a registration procedure for Xojo, but no licensefile.
The documentation says:
[code]License
You can register by placing the Registration file in one of the locations in the list below (better on the server). Or you can register with calling the RegisterMBS function (better on local database).
The license file can be stored currently in this positons:
On MacOS here:
In the current directory.
/ (Root Folder)
/etc
/Library/Preferences
/System/Library/Preferences
On Linux here:
In the current directory.
/ (Root Folder)
/etc[/code]