quinta-feira, 27 de agosto de 2020

DICAS 3053 - WINDEV TUTORIAL 76 - HYPERFILE GERENCIANDO SERVIDOR - PARTE C - 03-09-2020 16Hrs



https://youtu.be/3_6FkPGy8dw






Bom Dia/Boa Tarde/Boa Noite

Esse Ao Vivo vai estrear as 16:00 do dia 03/09/2020 

DICAS 3053 - WINDEV TUTORIAL 76 - HYPERFILE GERENCIANDO SERVIDOR - PARTE C - 03-09-2020 16Hrs

ASSUNTOS

O QUE VAMOS APRENDER 
APRESENTACAO 
CONFIGURACAO DA ESTACAO DE TRABALHO
O CENTRO DE CONTROLE HFSQL
ENTRANDO CONTROLE ATRAVEZ DO WINDEV 
ENTRANDO NA TABELA CLIENTE E FAZENDO CONEXAO
ENTRANDO NA TABELA PEDIDO E MOSTRANDO PROPRIEDADES
CRIAR UMA CONTA DE USUARIO NO HFSQL 
COMO ENTRAR NO CONTROL CENTER 
CRIADO O USUARIO E EXPLICADO ALGUMAS OPCOES
DAR DIREITO DE CONECTAR AO BANCO DE DADOS 
DAR DIREITO SOBRE UMA TABELA NO CASO CLIENTE 
ENTRANDO NO USUARIO TESTE 
MOSTRANDO BACKUP
DANDO OPINIAO




Video original da Franca

https://youtu.be/iuMiIxXze3Q


Playlist Windev TUTORIAL

PlayList Hyperfile

https://windevdesenvolvimento.blogspot.com/2020/01/dicas-2617-windev-webdev-mobile.html




https://youtu.be/3DshsXJ8I2M

https://youtu.be/EqnYJFpvPAI








DICAS 2978 - WINDEV TUTORIAL 1 - 1.1B - WINDEV TEMA ESCURO E IDIOMA DO AMBIENTE
DICAS 2979 - WINDEV TUTORIAL 2 - 1.2- CRIAR JANELA E INSERIR TEXTO E EXIBIR
DICAS 2980 - WINDEV TUTORIAL 3 - 2.1- VARIAVEIS PARTE 1
DICAS 2981 - WINDEV TUTORIAL 4 - 2.2- VARIAVEIS ESCOPO - PARTE 2
DICAS 2982 - WINDEV TUTORIAL 5 - 2.1- VARIAVEIS OPERADORES PARTE 3
DICAS 2983 - WINDEV TUTORIAL 6 - 2.1.D - VARIAVEIS STRINGS PARTE 4
DICAS 2984 - WINDEV TUTORIAL 7 - 2.1.E - VARIAVEIS ARRAYS PARTE 5
DICAS 2985 - WINDEV TUTORIAL 8 - 2.2.A - CONDICOES IF-SWITCH PARTE 1
DICAS 2986 - WINDEV TUTORIAL 9 - 2.2.B - CONDICOES PARTE 2
DICAS 2987 - WINDEV TUTORIAL 10 - 2.3.A - LOOP PARTE 1
DICAS 2988 - WINDEV TUTORIAL 11 - 2.3.B - LOOP EXEMPLOS PARTE 2
DICAS 2989 - WINDEV TUTORIAL 12 - Lesson 2.4. The procedures - PARTE 1
DICAS 2990 - WINDEV TUTORIAL 13 - Leçon 2.4.b. Procedures Parametros - PARTE 2
DICAS 2991 - WINDEV TUTORIAL 14 - PROCEDURES REFERENCIA - PARTE 3
DICAS 2992 - WINDEV TUTORIAL 15 - PROCEDURES OPCIONAIS OU OBRIGATORIAS - PARTE 4
DICAS 2993 - WINDEV TUTORIAL 16 - PROCEDURES EXEMPLOS - PARTE 5
DICAS 2994 - WINDEV TUTORIAL 17 - PERGUNTAS E RESPOSTA - PARTE 1
DICAS 2995 - WINDEV TUTORIAL 18 - PERGUNTAS E RESPOSTA - PARTE 2
DICAS 2996 - WINDEV TUTORIAL 19 - WINDEV E OS BANCOS DE DADOS
DICAS 2997 - WINDEV TUTORIAL 20 - PROJETO E ANALISE - CRIACAO
DICAS 2998 - WINDEV TUTORIAL 21 - PROJETO E ANALISE - ARQUIVOS DADOS CLIENTE - PARTE 2
DICAS 2999 - WINDEV TUTORIAL 22 - PROJETO E ANALISE - ARQUIVOS DADOS CRIACAO ARQUIVO PEDIDO - PARTE 3
DICAS 3000 - WINDEV TUTORIAL 23 - PROJETO E ANALISE - IMPORTANDO CVS-ARQUIVO TEXTO - PARTE 4
DICAS 3001 - WINDEV TUTORIAL 24 - PROJETO E ANALISE - IMPORTANDO ARQUIVO PRODUTO - PARTE 5
DICAS 3002 - WINDEV TUTORIAL 25 - PROJETO E ANALISE - LINK - PARTE 6
DICAS 3003 - WINDEV TUTORIAL 26 - RAD COMPLETO
DICAS 3004 - WINDEV TUTORIAL 27 - VISAO GERAL
DICAS 3005 - WINDEV TUTORIAL 28 - Adicionar e Modificar Janelas PRODUTOS - PARTE A
DICAS 3006 - WINDEV TUTORIAL 29 - Adicionar e Modificar Janelas PRODUTOS Formulario - PARTE B
DICAS 3007 - WINDEV TUTORIAL 30 - Adicionar e Modificar Janelas PRODUTOS ALINHAR CAMPOS - PARTE C


------------------ INDICE HYPERFILE

Blog - HyperFile - Instalar - 1/...
Blog - HyperFile - Configurar - 2/...
Blog - Hyperfile - Conexao - 3/...
Blog - Hyperfile - Conversões - 4/...
Blog - Hyperfile - Liberar Porta 4900 - Acesso Rede - Parte 5/...
Blog - Hyperfile - Log / Automatic Id - parte 6/...
Blog - Hyperfile - Configurar Servidor Txt - parte 7/...  
Blog - Hyperfile - Modificar Estrutura Arquivo Parte 8/...
Blog - Hyperfile - Consideraçoes Wladimir - Parte 9/...
Blog - Hyperfile - Backup/Restore - Parte 10/...
Blog - Hyperfile - Backup Por Programação - Parte 11/..
Blog - Hyperfile - Provider HyperFile Classic - Parte 12/... - Com banco ou sem Banco 
Blog - Hyperfile - /013/... HListFile -> Mostrar Tabelas Analise Programação
Blog - Hyperfile - /014/... HListItem - HListKey - HListLink Mostrar Campos/Chaves
Blog - Hyperfile - /015/ ... Conexao Classic - Mobile 
Blog - HyperFile - /016/ ... HyperFile - Alterar Senha 
Blog - HyperFile - /017/... FireWall - Problema Conexão - Wizard Conexao 
Blog - HyperFile - /018/... Instalcao Linux Por Adriano - Hyperfile 
Blog - HyperFile - /019/... Expaind
Blog - HyperFile - /020/... Criar Pastas analise
Blog - HyperFile - /021/... - Registro - HNbRec - Quantidades Registros
Blog - HyperFile - /022/... - Backup - Programada - Automatica
Blog - HyperFile - /023/... - Quantidade Registros e Progresso - HnbRec/Gauge
Blog - HyperFile - /024/... - Alterado - Ver se Registro foi Alterado - MyWindow..modified
Blog - HyperFile - /025/... - Erro HyperFile - Manta Erro 2
Blog - HyperFile - /026/... - HInfoServer
Copia Programada - WinDev Hyperfile 027/...
HSendMessageToClient - WINDEV HYPERFILE 028/.. AULA 1212
HDisconnectClient - DESCONECTAR BANCO - HYPERFILE 029/... AULA 1213
HServerMaintenance - MANUTENCAO HYPERFILE - HYPERFILE 030 / AULA 1214
Manutençao no Hfsql Control Center - HYPERFILE 031 - AULA 1215
NOVO REGISTRO - NEW RECORD - HYPERFILE 032 - AULA 1235
DICAS 2296 WINDEV WEBDEV MOBILE HYPERFILE 39 Filter
DICAS 2303 WINDEV WEBDEV MOBILE HYPERFILE 40 BACKUP
DICAS 2551 WINDEV WEBDEV MOBILE HYPERFILE 41 COPIA PROGRAMADA
DICAS 2601 WINDEV WEBDEV MOBILE Hyperfile Refazendo aulas
DICAS 2605 WINDEV WEBDEV MOBILE Hyperfile Refazendo aulas parte 2
DICAS 2608 WINDEV WEBDEV MOBILE Hyperfile Refazendo aulas parte3
DICAS 2611 WINDEV WEBDEV MOBILE Hyperfile Refazendo aulas parte 4
DICAS 2614 WINDEV WEBDEV MOBILE Hyperfile Refazendo aulas parte 5
DICAS 2617 WINDEV WEBDEV MOBILE Hyperfile Refazendo aulas parte 6 Final
DICAS 3051 - WINDEV TUTORIAL 74 - HYPERFILE CONCEITO INSTALACAO PARTE A







Lesson 5.3. Managing a Client/Server database
This lesson will teach you the following concepts
  • The HFSQL Control Center.
  • Creating a user in the HFSQL Control Center.
  • Saving the database.
Lesson duration

Estimated time: 20 mn
Previous LessonTable of contentsNext Lesson
Overview
Now that we know how to create and/or adapt an application so that it operates in HFSQL Client/Server, let's see how to manage the associated database.
Indeed, a Client/Server database requires:
  • a specific configuration of computers (setup of an HFSQL server, etc.).
  • a management performed via the HFSQL Control Center.
Configuring the computers
To use an HFSQL Client/Server database, an HFSQL server must be installed on the server. Several HFSQL servers that use different ports can be installed on the same computer. One or more databases can be installed on each server.
For example, a test HFSQL server, with a test database and a production HFSQL server that use a different port, can be installed on the same computer.
The HFSQL Control Center
The HFSQL Control Center is used to perform all management operations on the HFSQL Client/Server servers and databases.
We are going to present the most important features.
First of all, we are going to start the HFSQL Control Center from the WINDEV project.
  • To start the HFSQL Control Center and to access data:
    1. In the WINDEV menu, on the "Tools" pane, in the "Database" group, click "HFSQL". The HFSQL Control Center is displayed.
    2. The home window of HFSQL Control Center is displayed. The analysis of current project is automatically selected.
      Home window
    3. Validate the screen. The HFSQL Control Center is displayed. This mode allows you to see the different files linked to the analysis of the current project.
    4. Click the vertical tab named "HFSQL C/S" if necessary. The list of data files in HFSQL Client/Server format is displayed.
      List of data files
      The Control Center lists the Client/Server data files found in the analysis linked to the current project. No connection is established: the data files appeared grayed.
    5. To see the data found in the files, double-click one of the data files in the list on the left ("Orders" for example). If the HFSQL Control Center does not recognize all connection parameters, a connection window is used to perform the effective connection to the HFSQL Client/Server server used. If this window is displayed, specify the password and validate.
    6. The information about the selected data file that uses this connection is displayed in a new "Orders" pane. This pane presents this information in several vertical tabs:
      Information on the data file
      • The "Description" tab gives information about the data files (data file items, etc.).
      • The "Content" tab displays the records found in the data files.
The entire HFSQL Client/Server database can be managed from the HFSQL Control Center.
Creating a user account in the HFSQL Control Center
A single user account is created when installing an HFSQL server and when creating a database: the administrator account ("Admin" login without password).
Using a user account allows you to secure the access to data. Indeed, all application users are not administrators. Specific rights can be granted to each user (or group of users).

Caution!

The user rights specified in the HFSQL Control Center are granted for the database (and not for the application).
Do not confuse the management of rights for the Client/Server databases with the user groupware.
Some users may not have the rights to write into some data files for example.
To run a simple test, we are going to create a user and allow this user to see the records in the Customer data file.
  • To directly connect to the database found on the server:
    1. Expand the Control Center menu menu at the top left of the HFSQL Control Center and select "Connect to an HFSQL server".
    2. The home window of HFSQL Control Center is displayed.
      Home window
    3. The option "Connect to an HFSQL server" is selected by default. Specify the characteristics of the server that was installed in the previous lesson and validate.
    4. The characteristics of HFSQL server are displayed:
      • the name of HFSQL server as well as the list of databases found on this server are displayed in the left panel.
      • in the right section of the screen, a new tab allows you to see the characteristics of HFSQL server.
        HFSQL Server characteristics
    5. In the right section of the screen, select the "Users" tab. This tab is used to manage the server users.
    6. Only the "Admin" user exists at this time.
      Management of users
    7. To create a new user, in the ribbon, in the "Users" group, click the "New" button. The window used to define the user characteristics is displayed.
    8. Type the following information:
      Properties of a user
      (use "Test" as password for example).

      Remark

      Several characteristics can be noticed:
      • Super User: The users defined as "Super user" are allowed to perform all types of actions on the server, on the databases and on all the data files.
      • Account enabled: If this option is not checked, the user exists but he is not enabled (users on holiday for example).
      • Password expiration: You can specify a password valid for a limited number of days. (configurable).
    9. Validate the user creation. By default, no rights are granted to this user.
We are now going to grant rights to the user: the "Test" user can connect to the database and read the Customer data file.
  • To grant rights to connect to the database:
    1. In the HFSQL Control Center, double-click the "WD Full Application" database.
    2. On the "WD Full Application" pane, in the "Rights" group, click "Management of rights".
    3. Select the "Test" user in the list of users.
    4. In the list of rights, for the action named "Rights to connect to the server (encrypted and unencrypted connection)", click in the "Defined rights" column and select the green checkmark.
      Rights of a user on the database
    5. Click "Apply" at the bottom of window. The rights become effective.
    6. Close the window for managing rights.
  • To grant rights to read the Customer data file:
    1. In the HFSQL Control Center, expand the "WD Full Application" database and double-click the Customer data file (on the left of the screen).
    2. On the "Customer" pane, in the "Rights" group, click "Management of rights".
    3. Select the "Test" user in the list of users.
    4. In the list of rights, for the action named "Rights to read the records of a file", click the "Defined rights" column and select the green checkmark.
      Rights of a user on a data file
    5. Click "Apply" at the bottom of window. The rights become effective.
    6. Close the window for managing rights.
Similarly, rights can be defined:
  • on the HFSQL server
  • on the database
  • on the database files.
In our example, the "Test" user can only browse the records in the Customer data file. If this user tries to perform another action, a message will be displayed: "The Test user has no sufficient rights to XXXX" (where XXXX corresponds to the action performed).
Once the account is created, it can be used when the application connects to the server (when HOpenConnection is used).

Remark

The users and their rights can also be managed by programming with the WLanguage functions.
See Functions for HFSQL Client/Server management for more details.
Make a backup copy of the database
To make a backup copy of the database:
  1. Go to the tab corresponding to the "WD Full Application" database.
  2. Select the vertical tab named "Backups".
  3. In the menu, in the "Backups" group, expand "New backup" and select "New hot backup".
    Remark: This button is accessible in the "Backups" group:
    • on the tab corresponding to the HFSQL server,
    • on the tab corresponding to the database.
      Remark: The wizard can also be used to save a selection of data files.
  4. Validate the backup.
Conclusion
The HFSQL Control Center is a tool for managing databases, allowing you to:
  • stop or restart a server if a problem occurs,
  • manage the users and their rights,
  • reindex the data files if necessary,
  • perform database backups.
The HFSQL Control Center is a redistributable tool that can be installed on the computers of users who are working with HFSQL Client/Server databases. The HFSQL Control Center must be used by the database administrator.


Nenhum comentário:

Postar um comentário

Teste

Teste
teste