Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for RAD Studio 10.4 (Delphi Win64) » Using DBISAM » Server Administration |
Method | Description |
GetServerConfig | This method retrieves the global database server settings for maximum allowed connections, connection timeouts, dead session settings, the temporary files directory, and authorized and blocked IP addresses. |
ModifyServerConfig | This method modifies the global database server settings. |
GetServerLogCount | This method retrieves the total number of log records present in the current log file. Calling this method triggers the TDBISAMEngine OnServerLogCount event. If an event handler is defined for this event, then it is called to retrieve the count from whatever storage medium is being used for the log file. |
GetServerLogRecord | This method retrieves the Nth log record from the current log file. Calling this method triggers the TDBISAMEngine OnServerLogRecord event. If an event handler is defined for this event, then it is called to retrieve the specified log record from whatever storage medium is being used for the log file. |
StartAdminServer | This method causes the database server to begin listening for administrative connections on the IP address and port specified by the TDBISAMEngine ServerAdminAddress and ServerAdminPort properties. |
StopAdminServer | This method causes the database server to stop listening for administrative connections. |
StartMainServer | This method causes the database server to begin listening for regular data connections on the IP address and port specified by the TDBISAMEngine ServerMainAddress and ServerMainPort properties. Calling this method triggers the TDBISAMEngine OnServerStart event. |
StopMainServer | This method causes the database server to stop listening for regular data connections. Calling this method triggers the TDBISAMEngine OnServerStop event. |
GetServerUTCDateTime | This method retrieves the current date and time from the server in UTC (Coordinated Universal Time). |
GetServerUpTime | This method retrieves the total up time of the database server in seconds. |
GetServerMemoryUsage | This method has been deprecated and always returns 0 as of version 4.17 of DBISAM and the introduction of the new memory manager used in the DBISAM database server. Please see the Replacement Memory Manager topic for more information. |
GetServerSessionCount | This method retrieves the total number of sessions present on the database server at the time of the method call. This count does not include administrative sessions, only regular sessions.
|
GetServerConnectedSessionCount | This method retrieves the total number of sessions on the database server that are currently connected at the time of the method call. This count does not include administrative sessions, only regular sessions.
|
GetServerSessionInfo | This method retrieves information about the specified session such as its unique session ID, when it was created, when it was last connected, the user name, the IP address of the user, and whether the connection is encrypted. This method does not return information about administrative sessions, only regular sessions.
|
DisconnectServerSession | This method disconnects the specified session, but does not remove the session from the database server. Once the session is disconnected it is considered to be a dead session. This method cannot be used on administrative sessions, only regular sessions.
|
RemoveServerSession | This method removes the specified session completely from the database server. This method cannot be used on administrative sessions, only regular sessions.
|
GetServerUserNames | This method will retrieve a list of user names that are currently defined on the database server. |
GetServerUser | This method will retrieve information about a specific user, including the user's password, a description of the user, and whether the user is an administrator for this server. |
AddServerUser | This method will add a new user. |
ModifyServerUser | This method will modify a user's information. |
ModifyServerUserPassword | This method will modify only a user's password. |
DeleteServerUser | This method will delete a user. |
GetServerDatabaseNames | This method will retrieve a list of database names that are currently defined on the database server. |
GetServerDatabase | This method will retrieve information about a specific database, including the database's description and the actual physical path to the database tables. All database server physical path information for databases defined on the server are interpreted relative to the drives, directories, etc. available to the database server.
|
AddServerDatabase | This method will add a new database. |
ModifyServerDatabase | This method will modify a database's information. |
DeleteServerDatabase | This method will delete a database. |
GetServerDatabaseUserNames | This method will retrieve a list of users that are assigned rights to a specific database. |
GetServerDatabaseUser | This method will retrieve the user rights of a user for a specific database. |
AddServerDatabaseUser | This method will add user rights for a specific user to a specific database. |
ModifyServerDatabaseUser | This method will modify the user rights of a user for a specific database. |
DeleteServerDatabaseUser | This method will delete the user rights of a user for a specific database. |
GetServerProcedureNames | This method will retrieve a list of server-side procedure names that are currently defined on the database server. |
GetServerProcedure | This method will retrieve information about a specific server-side procedure, specifically the server-side procedure's description. |
AddServerProcedure | This method will add a new server-side procedure. |
ModifyServerProcedure | This method will modify a server-side procedure's information. |
DeleteServerProcedure | This method will delete a server-side procedure. |
GetServerProcedureUserNames | This method will retrieve a list of users that are assigned rights to a specific server-side procedure. |
GetServerProcedureUser | This method will retrieve the user rights of a user for a specific server-side procedure. |
AddServerProcedureUser | This method will add user rights for a specific user to a specific server-side procedure. |
ModifyServerProcedureUser | This method will modify the user rights of a user for a specific server-side procedure. |
DeleteServerProcedureUser | This method will delete the user rights of a user for a specific server-side procedure. |
GetServerEventNames | This method will retrieve a list of scheduled event names that are currently defined on the database server. |
GetServerEvent | This method will retrieve information about a specific scheduled event, specifically the scheduled event's description and scheduling parameters. |
AddServerEvent | This method will add a new scheduled event. |
ModifyServerEvent | This method will modify a scheduled event's information. |
DeleteServerEvent | This method will delete a scheduled event. |
Property | Setting |
SessionType | This property must be set to stRemote. |
RemoteEncryption | This property must be set to True. |
RemoteEncryptionPassword | This property must be set to the same password as the ServerEncryptionPassword property of the TDBISAMEngine component that the session is connecting to. |
RemoteAddress | This property must be set to the IP address of the database server as it appears to remote machines. You may optionally use the RemoteHost property if there is DNS information available for the database server that you are connecting to. |
RemotePort | This property must be set to the administrative port as it appears to remote machines. You may optionally use the RemoteService property if there is service information available for the database server administrative port that you are connecting to. There is an important distinction to make here. The IP address and port specified for a remote session is not always the same as the IP address and port specified in the ServerAdminAddress and ServerAdminPort properties of the TDBISAMEngine component that the session is connecting to. This is because network routers can use port forwarding and other techniques to forward network traffic destined for a specific public IP address and port to a private, internal LAN IP address and port.
|
RemoteUser | This property must be set to the name of a valid administrator user for the database server that you are connecting to. |
RemotePassword | This property must be set to the proper password for the user name specified by the RemoteUser property. |
begin with MyDBISAMSession do begin SessionType:=stRemote; RemoteEncryption:=True; { Assume the default encryption password in use } RemoteAddress:='192.168.0.1'; RemotePort:=12006; RemoteUser:='Admin'; RemotePassword:='DBAdmin'; Open; try AddRemoteUser('Test','Test123456','Test User',False); AddRemoteDatabaseUser('AccountingDB','Test', [drRead,drInsert,drUpdate,drDelete]); finally Close; end; end; end;
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |