Name, Address and Identity of a 602SQL Server

Name and Address of a Server when a Client is Connecting to

A client can access servers that:

are either registered on the client's computer,
or the client finds the servers running in his network segment on the default port.

Usually a client only registers servers he wants to work with. You can see the state overview of registered server (bold font) and servers found in the local segment (normal font) in the Control Panel of the 602 Development Client. There are also two cases when a server may be accessible even if it's not indicated in the Control Panel:

if a registered server is running on the specified address but has a different name;
if more servers run on the same IP address, then in some operating system there's only one server indicated in the Control Panel.

Renaming the Server

Server can be renamed both locally and remotely from the Control Panel's System / Tools section. The Rename server action however requires the configuration administrator privileges and also user access privileges to the registry (on Windows) or to the /etc/602sql file (on Linux). Server cannot be renamed if a name duplicity would occur on the server computer, or on the client computer that does do renaming.

Renaming a server doesn't restrict client access for clients that have this server already registered under its IP address. It only disables client access that connect to the server using only its original name.

It's necessary to restart the server after renaming.

The registration of a server (on a computer that is running the server) is decisive for its name - if the database file is moved to another computer or the server registration is changed, the database is accessible under the new server name.

Server UUID

Each server has a unique UUID identifier, that represents its identity for connecting clients.

The server UUID can be changed in the same way as the server's name. However all access passwords turn invalid by doing so. It's therefore recommended to change UUID only for newly created databases with anonymous user still in the administrator groups. The method of transferring users to new server can be found in the Export and import of all users chapter.

For verifying that a client is accessing the correct server use the server certificate.

SQL Server Operation on Linux

SQL Server Operation

Server Runtime Controlling and Runtime Restrictions