Tim

Migrating from DBISAM to ElevateDB, the resource of disable/enable login has gone.

Are there any plans to put it back again or add something similar (I do not know what)  ?

Regards

Eduardo

Jose


I never used the DBISAM server so I'm guessing as to what it did/was used for.

I don't know of anything specific but as always it depends on what you're trying to do, and wether you want it to be settable whilst the server is running.

There's the LicensedSessions, altering the port the server listens on, tweaking the users password as first thoughts.

Roy Lambert

Roy

The idea here is the following:

I have some application that handle a lot of users (more than 200) and when the support channel "say", stay out of the application for maintenance some users stay and others don´t. Sometimes I need to access the application to perform the maintenance while the other users stay out. If I stop the server even myself can´t access the application.

Also, the message "Client can´t connect to the server" is different than "The application is in maintenance mode  wait some minutes".

This is not a huge thing, of course I can live without it but at least for me it is a useful feature.

Eduardo

Jose

You have a fourfold problem:

1. get people off the system without causing data problems
2. keep them off the system until you're finished
3. inform users why they can't log in
4. let them know its OK to go back in.

2 is easy - close the server and reopen using a different port 1, 3 & 4 are the difficult bits. Its the sort of question that's been asked a few times but I don't think anyone's come up with a good answer.

Back when I was running my small recruitment company it was easy - walk around and threaten violence if they didn't come out and stay out until I said it was OK to go back in <vng>

The only solution I can think of is if you have the source and are willing to hack the server code. I don't otherwise I might have a go at it just for "fun"

Hmmm. Just thinking about it you could probably do something with a couple of small programs. One (lets call it ProgA) on the server which would, when run, broadcast a "please log off the system" to all users which would be picked up by the second small program on client PCs and display the message to the users. ProgA would monitor the connections on the server and when it dropped to 1 (ie itself) would log off itself and close the server and alter the port it listens on, restart the server and then broadcast a message at intervals saying "system not available". Ultimately, when told to do so ProgA would close the server, alter the port, restart the server and broadcast a message saying "back in business"

Roy Lambert

On 12/10/2018 3:53 AM, Jose Eduardo Helminsky wrote:
> I have some application that handle a lot of users (more than 200) and when the support channel "say", stay out of the application for maintenance some users stay and others don´t. Sometimes I need to access the application to perform the maintenance while the other users stay out. If I stop the server even myself can´t access the application.

One option but requires customization
- have a "maintenance in progress" flag in a table that you can set to
true/false
- use a OnServerSessionLogin event to write a handler that checks
whether flag is set or not and sets the AllowLogin var parameter
- handler could also allow login for your special username with flag set

AFAIK this does not allow showing special message for client side though
- just "login failed"

Raul

Jose


Whilst walking the dog I thought look at how on-line banks etc manage it - stick up a notice along the lines of "not available from ... to ... due to whatever" and at the appropriate time just turn the server off. Make sure you give yourself plenty of time to do whatever it was and restart the server at the advertised time.

Roy Lambert

Eduardo,

<< Migrating from DBISAM to ElevateDB, the resource of disable/enable login has gone.

Are there any plans to put it back again or add something similar (I do not know what)  ? >>

I'll have to check to see what's involved, but I should be able to do something for you.

Tim Young
Elevate Software
www.elevatesoft.com

We're comming from Advantagedatabaseserver and there was such a option but not in ElevateDB. Thus we have extended our tmxAdsConnection which is not a tEdbSession and overwritten the Connect.

it does a connect + opens a databasetable, in our case mxdbsystem database with config table where we have for each Database a online/offline flag with a info-field for reason.

Having the db offline, the user gets the message from the info field. Thats all and working very good.

Yusuf Zorlu
MicrotronX

I wanted to say, "... which is now(!) a tmxAdsConnection ..."