Page History
...
9. How does SQL DM for MySQL store its data?
A: Except for two plain text files: the MONyog.log file and a very small .ini file (that contains information about the port on which SQL DM for MySQL listens, The SQL DM for MySQL administrator password and the path to the data folder), everything is kept in high-performance database files (SQLite format).
...
10. Can I move a SQL DM for MySQL installation to another computer while keeping the data stored in SQL DM for MySQL database?
A: Yes, this is quite simple actually. Just install SQL DM for MySQL on the 2nd machine. After install stop the running MONyog(SQL DM for MySQL) service and copy the ..\MONyog\Data folder from the old installation. You may also copy the MONyog.log if you want. All the connection configuration and the data will be in 'data' directory. The error log is MONyog.log and setting are stored in 'MONyog.ini' and 'preferences.config'. If you have made any changes to monitors they will be stored in 'Counters.def' and for CSO's in 'udo.def'. Copy all of them from your old installation onto new PC. After that start the service again.
...
11. Can SQL DM for MySQL be configured as a virtual host in my 'ordinary' Apache webserver?
A: Yes... at least with Apache this is possible. In your Apache configuration file (httpd.conf) add something like this (where 'ip1.ip2.ip3.ip4' is the IP address you reserve for SQL DM for MySQL).
| Code Block | ||
|---|---|---|
|
...
<VirtualHost *:80> |
...
ServerName monyog.mydomain.com |
...
ServerAlias http://monyog.mydomain.com |
...
Redirect permanent / |
...
https://monyog.mydomain.com |
...
</VirtualHost> |
...
...
NameVirtualHost *:443 |
...
<VirtualHost *:443> |
...
ServerName monyog.mydomain.com |
...
ProxyPreserveHost On |
...
|
...
ProxyPass / http://127.0.0.1:<MONyog-Port>/ |
...
ProxyPassReverse / |
...
http://127.0.0.1:<MONyog-Port>/ |
...
SSLEngine On ...
SSLEngine On SSLCertificateFile <path-to-ssl-certificate.crt> |
...
SSLCertificateKeyFile <path-to-ssl-key.key> |
...
</VirtualHost> |
And run the following command on the machine running apache server:
...
| Code Block | ||
|---|---|---|
| ||
/usr/sbin/setsebool httpd_can_network_connect=1 |
After changing the configuration, restart the apache server.
...
12. How can I access SQL DM for MySQL pages proxying through other webservers?
A: We can also access SQL DM for MySQL using Apache proxy. You need to follow these simple steps to configure your Apache server to support proxy.
...
- Please check whether you have libxml2 installed in your system.
- Download mod_proxy_html.c from http://apache.webthing.com/
- Now build mod_proxy_html with apxs, apxs -c -I/usr/include/libxml2 -i mod_proxy_html.c
You need to load the following modules, so add the following entries in [/etc/httpd/conf/httpd.conf].
- Add the following configuration in your Apache configuration file [/etc/httpd/conf/httpd.conf]
...
Code Block theme Confluence LoadModule proxy_module modules/mod_proxy.so
...
...
LoadModule proxy_http_module modules/mod_proxy_http.so
...
...
LoadModule headers_module modules/mod_headers.so
...
...
LoadModule deflate_module modules/mod_deflate.so
...
...
LoadFile /usr/lib/libxml2.so
...
LoadModule proxy_html_module modules/mod_proxy_html.so
- Add the following configuration in your Apache configuration file [/etc/httpd/conf/httpd.conf]
ProxyRequests Off
...
| Code Block | ||
|---|---|---|
| ||
<Proxy *> |
...
...
|
...
|
...
Order deny, allow Allow from all |
...
</Proxy> |
...
ProxyHTMLExtended On |
...
ProxyPass /monyog/ |
...
http://<ip-system-B>:5555/ |
...
ProxyHTMLURLMap http://<ip-system-B>:5555/ /monyog/ |
...
<Location /monyog/ |
...
ProxyPassReverse / SetOutputFilter proxy-html ProxyHTMLURLMap / /monyog/ RequestHeader unset Accept-Encoding...
> ProxyPassReverse / SetOutputFilter proxy-html ProxyHTMLURLMap / /monyog/ RequestHeader unset Accept-Encoding </Location> |
13. How can I access SQL DM for MySQL pages proxying through nginx?
...