집에쓰던 LG NAS를 ssh접속하기 위해 권한을 얻기위해 검색하던중 여러사이트들을 보게 됨
https://www.zen-tech.info/2012/08/acces-ssh-sur-les-nouveaux-firmwares-des-nas-lg-n1t1/
http://dandylife.net/blog/archives/63
https://www.clien.net/service/board/lecture/2609323
http://reshout.com/?p=4229
https://m.blog.naver.com/PostView.naver?isHttpsRedirect=true&blogId=tomynymph&logNo=167602052
내 나스 모델이 N1T1인줄 알았으나..
어떻게 해도. 뭘 마줘도.. 파일이 맞지 않는다고 나왔으니.
알고보니 N1A1이었음 -_-; 헐...
그외에는 같은대로 맞춰하면 잘돌아감 개짜증
그레이로그 버전업 후 생긴 문제점
(2.0.3 -> 3.3.3)
message에 따라서 Aggregation을 하는데.. (파이차트 등.)
상위버전에서 message, full_message 항목에 대해서 index를 잡지 않는 상태가 되어 통계를 쓸수 없게 되었다.
fielddata를 true로 하라는 개떡 같은 메시지가 있었으나.
엘라스틱서치에 대한 설정이었으며
curl -X GET '설정IP:9200/_template/graylog-internal?pretty'
명령어로 내부에 설정된 것을 확인했을때.
아래 message에 fielddata:false가 되어 있음을 확인
curl -X GET '설정IP:9200/graylog_deflector/_mapping?pretty'
현재 매핑된녀석들을 볼수 있으며
message가 어찌되어있는지 확인을 해보면 좋음;
custom인덱스를 이용하기로 마음을 먹었고
curl -X PUT "설정IP:9200/_template/graylog-custom-mapping?pretty" -H 'Content-Type: application/json' -d'
{
"template": "graylog_*",
"mappings" : {
"message" : {
"properties" : {
"message" : {
"type" : "text",
"analyzer" : "standard",
"fielddata": true,
"fields": {
"keyword": {
"type": "keyword"
}
}
}
}
}
}
}
}'
추가하였음;
curl -X GET '설정IP:9200/graylog_deflector/_mapping?pretty'
를 해보았는데.. 여전히 fielddata에 대한 부분이 설정이 안되어 있는 것을 확인
추가해도 안먹히는 이유는 기존인덱스에는 당연히 적용이 안되어있어서 여전히 표현이 안되는 것이고.
GraylogWeb에서 Indices -> default index set -> Maintenance -> Rotate active write index
하게 되면 graylog_* -> 다음것으로 바뀌게 되며 graylog_deflector했을때.. 내가 설정한 커스텀 값이 적용되는 것을 볼수 있으나.
여전히 검색할때 안먹히는 이유는 기존에 생성된 graylog_0 같은 인덱스에는.. 적용이 안되었기 때문임
그냥 기존것 가볍게 삭제.. -_-; 하고나서 잘됨.
입력했던 커스텀을 삭제하고 싶으면
curl -X DELETE "설정IP:9200/_template/graylog-custom-mapping?pretty"
이런것을 때리면 됨;
참고했던것
https://docs.graylog.org/en/3.3/pages/configuration/elasticsearch.html
GRANT
priv_type [(column_list)]
[, priv_type [(column_list)]] ...
ON [object_type] priv_level
TO user_specification [, user_specification] ...
[REQUIRE {NONE | ssl_option [[AND] ssl_option] ...}]
[WITH with_option ...]
object_type:
TABLE
| FUNCTION
| PROCEDURE
priv_level:
*
| *.*
| db_name.*
| db_name.tbl_name
| tbl_name
| db_name.routine_name
user_specification:
user [IDENTIFIED BY [PASSWORD] 'password']
ssl_option:
SSL
| X509
| CIPHER 'cipher'
| ISSUER 'issuer'
| SUBJECT 'subject'
with_option:
GRANT OPTION
| MAX_QUERIES_PER_HOUR count
| MAX_UPDATES_PER_HOUR count
| MAX_CONNECTIONS_PER_HOUR count
| MAX_USER_CONNECTIONS count
| Privilege | Meaning and Grantable Levels |
|---|---|
ALL [PRIVILEGES] | Grant all privileges at specified access level except GRANT OPTION |
ALTER | Enable use of ALTER TABLE. Levels: Global, database, table. |
ALTER ROUTINE | Enable stored routines to be altered or dropped. Levels: Global, database, procedure. |
CREATE | Enable database and table creation. Levels: Global, database, table. |
CREATE ROUTINE | Enable stored routine creation. Levels: Global, database. |
CREATE TEMPORARY TABLES | Enable use of CREATE TEMPORARY TABLE. Levels: Global, database. |
CREATE USER | Enable use of CREATE USER, DROP USER, RENAME USER, and REVOKE ALL PRIVILEGES. Level: Global. |
CREATE VIEW | Enable views to be created or altered. Levels: Global, database, table. |
DELETE | Enable use of DELETE. Level: Global, database, table. |
DROP | Enable databases, tables, and views to be dropped. Levels: Global, database, table. |
EVENT | Enable use of events for the Event Scheduler. Levels: Global, database. |
EXECUTE | Enable the user to execute stored routines. Levels: Global, database, table. |
FILE | Enable the user to cause the server to read or write files. Level: Global. |
GRANT OPTION | Enable privileges to be granted to or removed from other accounts. Levels: Global, database, table, procedure. |
INDEX | Enable indexes to be created or dropped. Levels: Global, database, table. |
INSERT | Enable use of INSERT. Levels: Global, database, table, column. |
LOCK TABLES | Enable use of LOCK TABLES on tables for which you have the SELECT privilege. Levels: Global, database. |
PROCESS | Enable the user to see all processes with SHOW PROCESSLIST. Level: Global. |
REFERENCES | Not implemented |
RELOAD | Enable use of FLUSH operations. Level: Global. |
REPLICATION CLIENT | Enable the user to ask where master or slave servers are. Level: Global. |
REPLICATION SLAVE | Enable replication slaves to read binary log events from the master. Level: Global. |
SELECT | Enable use of SELECT. Levels: Global, database, table, column. |
SHOW DATABASES | Enable SHOW DATABASES to show all databases. Level: Global. |
SHOW VIEW | Enable use of SHOW CREATE VIEW. Levels: Global, database, table. |
SHUTDOWN | Enable use of mysqladmin shutdown. Level: Global. |
SUPER | Enable use of other administrative operations such as CHANGE MASTER TO, KILL, PURGE BINARY LOGS, SET GLOBAL, and mysqladmin debug command. Level: Global. |
TRIGGER | Enable trigger operations. Levels: Global, database, table. |
UPDATE | Enable use of UPDATE. Levels: Global, database, table, column. |
USAGE | Synonym for “no privileges” |
SHOW COLUMNS SyntaxSHOW [FULL] COLUMNS {FROM | IN} tbl_name [{FROM | IN} db_name]
[LIKE 'pattern' | WHERE expr]
SHOW CREATE TABLE SyntaxSHOW CREATE TABLE tbl_name
SHOW VARIABLES SyntaxSHOW [GLOBAL | SESSION] VARIABLES
[LIKE 'pattern' | WHERE expr]