Advanced

Here is some information and instructions on how to change my configuration.

  • What is a user?
  • User management
  • Configuration parameters

  • What is a user?
    A user is a person who interacts with the system. In most computer systems, users can be categorized based on their roles, such as administrator or standard user, depending on the system’s permissions. While some users may be more experienced or frequent, others might be accessing the system for the first time.
    Security is important in any system. Problems usually occur due to user error, not the system itself. That’s why managing users and defining trusted access is essential. We, a computer system, do not do wrong at all; it is a human being who makes every bad thing.
    For example, in real life, you do not easily trust someone who visits your store just once. It takes repeated interaction to build trust. Similarly, I prefer to allow access only to users I consider trustworthy—those who use the system regularly and responsibly. See below
generationlogin numbers and giving permissions
create table/apidelete table/apiuser management(register) and configuration editing
0111
115<=8<=
215×3<=8×3<=
315×4<=8×4<=
How many login times to get my trust in you 🙂

What I am trying to say is that the user who is ‘generation 0’ is like an ‘admin’ and can handle all the functions. The ‘generation=0’ users are the first 10 users, who are registered for the very first time in setting with a login account ‘it is me’. I will never ignore them.

Other users are the ones referred by an upper-generation user. I mean ‘generation 1’ user is registered by ‘generation 0’ user, ‘generation 2’ user is registered by ‘generation 1’ user, etc. Just to be clear, the bigger generetation number you are, more options you have, due to how many times you have visited the site, e.g. one who is generation 1 user can create table from the first time they log in, but they can’t delete nor edit it until they have logged in for at least 5 times, or they can’t invite another user or change any configurations until they have logged in over 8 times; for other generations users, the rules are more strict.
You might think that logging in five times a day is easy. To compare, it would be rather suspicious if you went to the same restaurant five times in a day, just to become a regular customer. Because of that, your loggings are counted once a day, so you have to log in 5 days in a row to become a regular customer. This is a security policy for me.

  • user management
    Quick introduction on how to register a new user, very simple, type in ‘invite new user’,’ add new user’, and so on. Then I ask you for the new user’s name, and you type it. That’s all. I do not need any additional information or password. As you know, a user can log in only with the user name. I manage those who have some type of permission, according to their generation and login numbers.
    Update? No. There is no data for updating.
    Delete? No. No one can delete other users. I am the one doing it. Indeed, I will delete a user account if it has not logged in for 100 days.
    You may wonder how the going ‘path phrase is used in deleting api/dropping tables and so on. Of course, it can neither update nor remind. You know, this kind of keyword handling is a critical security hole. Even if I keep watching everything for 24 hours everywhere, you still have the possibility of leaking such information to others. No updating, no reminding is my choice to keep your secret. In other words, do not forget your path phrase.
  • configuration parameters
    As with other computer systems, you can modify my configurations to suit your computer environment. Of course, I don’t like it sometimes, but I can understand that you might have to do it by chance. Then, the changing process is as follows,
    1. typing ‘show parameter’,’ show me configuration’,’ show server parameter’, something like that
    2. I ask you, ‘Which parameter?’
    3. You tell me the parameter name that you wanna change.
    There are two ways to point to the parameter,
    1. Type the parameter name directly
    2. Type your phrase you think is related to it

    These are the changeable parameters;
typeexplainparameter name(i)example phrase(ii)default
Upload file repositoryexecuted SQL log filefileuploadpath“upload file path”…repo
executed sql log filesqllogfileexecuted SQL log filesql.log
“SQL log file”…sqllogfilesize“sql log file size”…10
log file namelogfile“log name”…log.log
file size of logfile[mb]logfilesize“log file size”…10
logfile rotation start timelogfile_rotation_open“rotation start”…00:00
logfile rotation end timelogfile_rotation_close“rotation end”…01:02
*Attention: the interval is 20 minutes
“db”, “database”…selectlimit“limit”10
Current working databaseuser account databasejetelnadb“default db”…foo
SQL test ‘limit’ numberdbtype“PostgreSQL port”foo
postgresql parameterspostgres availablepg_work“postgresql run”…false
postgres post numberpg_port“postgresql port”5432
postgres hostpg_host“postgresql host”localhost
postgres database namepg_dbnamePostgres database namepostgres
postgres access accountpg_user“postgresql user”…postgres
postgres access pwdpg_password“postgresql password”…postgres
postgres ssl modepg_sslmode“postgresql ssl”…prefer
mysql parametersmysql availablemy_work“mysql run”…false
mysql hostmy_host“mysql host”localhost
mysql database namemy_dbname“mysql db name”…mysql
mysql portmy_port“mysql port”3306
mysql access accountmy_user“mysql user”…user
mysql access pwdmy_password“mysql password”…userpasswd
mysql socketmy_unix_socket“mysql unix socket”…/var/run/mysqld/mysqld.sock
redis parametersredis availableredis_work“redis run”…false
redis hostredis_host“redis host”127.0.0.1
redis portredis_port“redis port”6379
redis database nameredis_dbname“redis db name”…0
redis access pwdredis_password“redis password”…

4. Type ‘change parameter’,’ update configuration ‘, and so on
5. Set your new parameter into the displayed input field
6. Then follow me

You know this process is as same as the first setting process with ‘it is me’. I show you the example below.

      you:                  me: 
'change parameter'  →  which config?
'postgresql port'   →  pg_port is '5432 so far
'change parameter'  →  Change this to =>
you set something   →  type 'send' for updating ..or 'cancel'
'send'              →  Done

Make sense?