#1  
Old 23rd September 2021, 12:10 AM
a.pfau a.pfau is offline
Junior Member
 
Join Date: Jun 2021
Posts: 20
Post NexusDB Server - automated Setup

At the moment we don't really have an automated setup for our software in place. At new customers we copy a files of our software, empty/default database files and the nxserver software, install the services by hand and configure the db user and the db alias.

For smaller "Solutions" I want to automate the setup process, so that our customer can choose the install location and the setup procedure does the rest. Copying our files and installing our services is easy enough, but I'm at a complete loss regarding nxServer.
I think it doesnt' matter if I write a custom script, program a custom program or use something like inno Setup.
I find a lot of seemingly outdated information regarding a nxserver.init file.
I found https://www.nexusdb.com/support/inde...verfromthe.htm which looks newer and an example https://www.nexusdb.com/support/index.php?q=example.htm but I can't see user stuff and the parameters are hard to map to those I know from the web UI. Is it possible to export this file from an existing configuration, so I have a good starting point?

Is there some better/more concise guide on how to automate the setup of nxServer?
  #2  
Old 23rd September 2021, 01:57 AM
David Rose
 
Posts: n/a
Default Re: NexusDB Server - automated Setup

On 22/09/2021 14:10, a.pfau wrote:
> At the moment we don't really have an automated setup for our software
> in place. At new customers we copy a files of our software,
> empty/default database files and the nxserver software, install the
> services by hand and configure the db user and the db alias.
>
> For smaller "Solutions" I want to automate the setup process, so that
> our customer can choose the install location and the setup procedure
> does the rest. Copying our files and installing our services is easy
> enough, but I'm at a complete loss regarding nxServer.
> I think it doesnt' matter if I write a custom script, program a custom
> program or use something like inno Setup.
> I find a lot of seemingly outdated information regarding a nxserver.init
> file.
> I found https://tinyurl.com/ygr9y63k which looks newer and an example
> https://www.nexusdb.com/support/index.php?q=example.htm but I can't see
> user stuff and the parameters are hard to map to those I know from the
> web UI. Is it possible to export this file from an existing
> configuration, so I have a good starting point?
>
> Is there some better/more concise guide on how to automate the setup of
> nxServer?
>
>


If you do a search of these forums for Inno, I'm sure I uploaded my
Server install script some time ago.

David
  #3  
Old 7th October 2021, 09:57 PM
a.pfau a.pfau is offline
Junior Member
 
Join Date: Jun 2021
Posts: 20
Default

Quote:
Originally Posted by David Rose View Post
If you do a search of these forums for Inno, I'm sure I uploaded my
Server install script some time ago.
I think I found it.
https://nexusdb.com/forums/showthread.php?t=21123

But it goes a bit over my head. (Initially) Installing the service should be easy, it looks like the script takes care of upgrades if the service already exists, etc. I can take care of that later.
Trouble is I still don't understand how to configure the necessary Server settings (users, alias, server engine settings). I found https://www.nexusdb.com/support/index.php?q=node/26893
It's still a bit confusing when to use the nxserver.init file and when to use the nxServer.nxdbworksettings file.
Am I right that I can create a nxserver.init file from the example https://www.nexusdb.com/support/index.php?q=example.htm store it in the executable directory and then istall the nxserver via
Code:
nxserver.exe /SILENT /INSTALL /LOCALSYSTEMACCOUNT /ALLOWSYSTEM /RESET /START
and have the service install with the provided settings and have the service start? I have to setup a new VM and try this out.
  #4  
Old 12th October 2021, 07:25 AM
a.pfau a.pfau is offline
Junior Member
 
Join Date: Jun 2021
Posts: 20
Default

Quote:
Originally Posted by a.pfau View Post
Am I right that I can create a nxserver.init file from the example https://www.nexusdb.com/support/index.php?q=example.htm store it in the executable directory and then istall the nxserver via
Code:
nxserver.exe /SILENT /INSTALL /LOCALSYSTEMACCOUNT /ALLOWSYSTEM /RESET /START
and have the service install with the provided settings and have the service start?.
This seemed to work - sort of.
I'm not 100% sure what happened, this command installed the service, configured it and replaced the nxserver.init with a new file, better formatted and - at least it looks like - with more settings.

I can add an alias this way, but I'm still not sure how to configure Users and Server Engine Settings. I want to activate ForceFailSafe,CloseAllWhenInactive and when I find out how to create users IsSecure.

Is there a way to configure the server via the config website and then export a nxServer.init from there?
  #5  
Old 12th October 2021, 11:25 AM
Eivind Bakkestuen
 
Posts: n/a
Default Re: NexusDB Server - automated Setup

> Is there a way to configure the server via the config website and then
> export a nxServer.init from there?


No, but if you have a look at the nxServerForm unit in the \Server
folder, there is a "Save Settings to..." menu item under the main
Settings menu that can be set to Visible. Then, run nxServer from the
IDE and use the menu item to save settings to a text file on disk.

--

Eivind [NX]
  #6  
Old 5th January 2022, 01:06 AM
a.pfau a.pfau is offline
Junior Member
 
Join Date: Jun 2021
Posts: 20
Default

Quote:
Originally Posted by Eivind Bakkestuen View Post
>
No, but if you have a look at the nxServerForm unit in the \Server
folder, there is a "Save Settings to..." menu item under the main
Settings menu that can be set to Visible.
Thanks, after I commented out "$DEFINE FancyServer" I could compile it.

After some try and error and diffing the resulting files I think all relevant settings are there and I understand how they are structured.
Except for the users. I need to add a user for my application and there is no example in https://www.nexusdb.com/support/index.php?q=example.htm and without it in the "saved settings" it's impossible for me to know how...
  #7  
Old 5th January 2022, 11:45 AM
Eivind Bakkestuen
 
Posts: n/a
Default Re: NexusDB Server - automated Setup

> After some try and error and diffing the resulting files I think all
> relevant settings are there and I understand how they are structured.
> Except for the users. I need to add a user for my application and
> there is no example in
> https://www.nexusdb.com/support/index.php?q=example.htm and without
> it in the "saved settings" it's impossible for me to know how...


Have a look at the \Examples\Delphi\SecurityMonitor example; there's an
API for user management now.

--

Eivind [NX]
  #8  
Old 10th January 2022, 09:30 PM
a.pfau a.pfau is offline
Junior Member
 
Join Date: Jun 2021
Posts: 20
Default

Quote:
Originally Posted by Eivind Bakkestuen View Post
Have a look at the \Examples\Delphi\SecurityMonitor example; there's an
API for user management now.
Thank you, that works.
I wrote a small program "SetupHelper.exe" that I call during the installation, after I installed the service.

Code:
[Run]
Filename: "{app}\nxserver\nxserver.exe"; Parameters: "/SILENT /INSTALL /LOCALSYSTEMACCOUNT /ALLOWSYSTEM /RESET /START";StatusMsg: "Installiere DB" 
Filename: "{app}\SetupHelper.exe";StatusMsg: "DB einrichten"


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
OT: automated testing Dave Sellers nexusdb.public.discussions 3 17th August 2012 10:30 PM
How to setup multiple companies (databases) using NexusDB client/server Paul Coshott nexusdb.public.support 4 9th June 2010 12:36 PM
ANN: RealThinClient SDK subscriptions > Now also *without* automated annual billing Danijel Tkalcec nexusdb.public.support.thirdparty 0 1st March 2010 07:45 AM
server setup? for three users accessing two apps on two pcs Peter Sanders nexusdb.public.support 0 5th January 2007 02:59 PM
slightly OT: NexusDB and Inno setup Peter Sanders nexusdb.public.support 6 12th November 2005 10:12 PM


All times are GMT +11. The time now is 01:54 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.