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
generation | login numbers and giving permissions | ||
create table/api | delete table/api | user management(register) and configuration editing | |
0 | 1 | 1 | 1 |
1 | 1 | 5<= | 8<= |
2 | 1 | 5×3<= | 8×3<= |
3 | 1 | 5×4<= | 8×4<= |
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;
type | explain | parameter name(i) | example phrase(ii) | default |
Upload file repository | executed SQL log file | fileuploadpath | “upload file path”… | repo |
executed sql log file | sqllogfile | executed SQL log file | sql.log | |
“SQL log file”… | sqllogfilesize | “sql log file size”… | 10 | |
log file name | logfile | “log name”… | log.log | |
file size of logfile[mb] | logfilesize | “log file size”… | 10 | |
logfile rotation start time | logfile_rotation_open | “rotation start”… | 00:00 | |
logfile rotation end time | logfile_rotation_close | “rotation end”… | 01:02 *Attention: the interval is 20 minutes | |
“db”, “database”… | selectlimit | “limit” | 10 | |
Current working database | user account database | jetelnadb | “default db”… | foo |
SQL test ‘limit’ number | dbtype | “PostgreSQL port” | foo | |
postgresql parameters | postgres available | pg_work | “postgresql run”… | false |
postgres post number | pg_port | “postgresql port” | 5432 | |
postgres host | pg_host | “postgresql host” | localhost | |
postgres database name | pg_dbname | Postgres database name | postgres | |
postgres access account | pg_user | “postgresql user”… | postgres | |
postgres access pwd | pg_password | “postgresql password”… | postgres | |
postgres ssl mode | pg_sslmode | “postgresql ssl”… | prefer | |
mysql parameters | mysql available | my_work | “mysql run”… | false |
mysql host | my_host | “mysql host” | localhost | |
mysql database name | my_dbname | “mysql db name”… | mysql | |
mysql port | my_port | “mysql port” | 3306 | |
mysql access account | my_user | “mysql user”… | user | |
mysql access pwd | my_password | “mysql password”… | userpasswd | |
mysql socket | my_unix_socket | “mysql unix socket”… | /var/run/mysqld/mysqld.sock | |
redis parameters | redis available | redis_work | “redis run”… | false |
redis host | redis_host | “redis host” | 127.0.0.1 | |
redis port | redis_port | “redis port” | 6379 | |
redis database name | redis_dbname | “redis db name”… | 0 | |
redis access pwd | redis_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?