Skip to content

Instantly share code, notes, and snippets.

@s5unty

s5unty/error.log

Created December 5, 2019 08:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save s5unty/8ec74d84ca0ae2274888e40a90debc2a to your computer and use it in GitHub Desktop.
Save s5unty/8ec74d84ca0ae2274888e40a90debc2a to your computer and use it in GitHub Desktop.
Download ZIP
sqlite 2 postgresql
Raw
error.log
mmonit=> INSERT INTO messageformat VALUES(
mmonit(> 1,
mmonit(> 'Default',
mmonit(> 'mmonit@verns-worktop',
mmonit(> 'M/Monit report ($HOST: $EVENT $SERVICE on $DATE)',
mmonit(> 'M/Monit report ($COUNT events)',
mmonit(> NULL,
mmonit(> replace('Date: $DATE\nHost: $HOST\nService: $SERVICE\nAction: $ACTION\nDescription: $DESCRIPTION\n\n','\n',char(10)),
mmonit(> replace('\nYour faithful employee,\nM/Monit','\n',char(10)),
mmonit(> replace('<html>\n <table style=''border-collapse:collapse;border:1px solid #eee; padding:5px;''>\n <tr>\n <th style=''border: 1px solid #eee; padding:5px;''><b>Date</b></th>\n <th style=''border: 1px solid #eee; padding:5px;''><b>Host</b></th>\n <th style=''border: 1px solid #eee; padding:5px;''><b>Service</b></th>\n <th style=''border: 1px solid #eee; padding:5px;''><b>Action</b></th>\n <th style=''border: 1px solid #eee; padding:5px;''><b>Description</b></th>\n </tr>\n','\n',char(10)),
mmonit(> replace(' <tr>\n <td style=''border: 1px solid #eee; padding:5px;''>$DATE</td>\n <td style=''border: 1px solid #eee; padding:5px;''>$HOST</td>\n <td style=''border: 1px solid #eee; padding:5px;''>$SERVICE</td>\n <td style=''border: 1px solid #eee; padding:5px;''>$ACTION</td>\n <td style=''border: 1px solid #eee; padding:5px;''>$DESCRIPTION</td>\n </tr>\n','\n',char(10)),
mmonit(> replace(' </table>\n <p>\n Your faithful employee,<br>\n M/Monit\n </p>\n</html>','\n',char(10)),
mmonit(> 2,
mmonit(> '1');
错误: 语法错误 在 ")" 或附近的
第8行... $ACTION\nDescription: $DESCRIPTION\n\n','\n',char(10)),
^
@s5unty
Copy link
Author

s5unty commented Dec 5, 2019

20191205_16-27-51

@s5unty
Copy link
Author

s5unty commented Dec 5, 2019 •
edited

%s/char(10)/chr(10)/g

$ ./mmonit/db/migrate_db.sh -t postgresql  > /tmp/dump
$ sed -i 's/char(10)/chr(10)/g' /tmp/dump
$ cat /tmp/dump | psql -h 127.0.0.1 -U mmonit mmonit

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment