Bad Customer : How to Kill his VPS db connexion ?

[Abaksoft]

Hi friends,

- Assume we have 10 customers on 10 Folders on a VPS.

- Each Customer has his own database :  

  ...\Customer_1\Base1.fdb

  ...\Customer_2\Base2.fdb

  ...\Customer_3\Base3.fdb

 

- Assume Customer 2 don't want to paye his annual subscription !

 

So, Is there a tip to disconnect only Base2.fdb from the VPS Server ?

(The others db must be run.  I am using FireBird)

 

______

PS :  assume Base2.fdb  is always connected 24h/24 from the customer2. So renaming the file Base2.fdb is not a good way.

 

THX.

 

[molla2005b]

hi.

you can close(Block) his port or create a uniGui Tools to stop and start Customer2 service 

[Abaksoft]

Hi Majori,

 

Oh...a good idea !

 

1. > ...you can close(Block) his port

How can I give a special port for each customer ?  FireBird has only one port ?!

 

2. >... to stop and start Customer2 service 

How can I do this ?

 

Thank you very much...

[adragan]

Why don't you create a "master" database that makes the login ?

You store there customer information, payd fees, connection parameters etc in it.

If he pays you send him to  /customer_n.fdb, if he does not pay , at login you send him fishing !

[molla2005b]

hi

if u use One layer system (Customer Direct Connect to Firebird) take a lock to this link

but if u use UniGUi it will be easy to

[Abaksoft]

Thank you very much majori : that's what i was looking for.

Thank you adragan for your very nice solution.

 

All the Best for all unigui members...