cobi.wms:hana_proxy
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
cobi.wms:hana_proxy [2023/01/02 05:23] – [Update] tkammer | cobi.wms:hana_proxy [2023/11/21 19:55] (current) – tkammer | ||
---|---|---|---|
Line 2: | Line 2: | ||
The HANA Proxy is needed if you want the app to make direct database connections to HANA. For example, if you use HANA on-premises or in a private cloud and you want the app to connect to the [[Management Database]] that you created on the HANA server. | The HANA Proxy is needed if you want the app to make direct database connections to HANA. For example, if you use HANA on-premises or in a private cloud and you want the app to connect to the [[Management Database]] that you created on the HANA server. | ||
+ | |||
+ | **WARNING: | ||
The Proxy is a very small Java program with an accompanying systemd service unit to allow for easy installation as a service on a GNU/Linux distribution. | The Proxy is a very small Java program with an accompanying systemd service unit to allow for easy installation as a service on a GNU/Linux distribution. | ||
Line 12: | Line 14: | ||
<code bash> | <code bash> | ||
- | v=1.5.3 | + | version=1.7.0 # Don't forget to set this variable! It's used in the following commands. |
cd /root | cd /root | ||
- | wget https:// | + | wget https:// |
- | tar -xf hanaproxy-$v.tar | + | tar -xf hanaproxy-$version.tar |
- | ln -s hanaproxy-$v hanaproxy | + | ln -s hanaproxy-$version |
systemctl enable / | systemctl enable / | ||
+ | systemctl start hanaproxy | ||
</ | </ | ||
- | After that, you should | + | The '' |
<code bash> | <code bash> | ||
- | systemctl start hanaproxy | ||
systemctl status hanaproxy | systemctl status hanaproxy | ||
</ | </ | ||
- | The '' | + | The output |
===== Control / Monitor ===== | ===== Control / Monitor ===== | ||
Line 47: | Line 49: | ||
<code bash> | <code bash> | ||
- | v=1.5.3 | + | version=1.7.0 |
cd /root | cd /root | ||
- | wget https:// | + | wget https:// |
- | tar -xf hanaproxy-$v.tar | + | tar -xf hanaproxy-$version.tar |
rm hanaproxy | rm hanaproxy | ||
- | ln -s hanaproxy-$v hanaproxy | + | ln -s hanaproxy-$version |
systemctl daemon-reload | systemctl daemon-reload | ||
systemctl restart hanaproxy | systemctl restart hanaproxy | ||
</ | </ | ||
- | ===== Troubleshoot | + | ===== Troubleshooting |
- | If you suspect that HANA Proxy may not be working properly even though it is running, you can test a few things. | + | If you suspect that HANA Proxy may not be working properly even though it is running, you can test a few things. Note that some of these instructions are quite technical and require some IT knowledge. |
- | First of all see if it' | + | ==== TCP Port Probing ==== |
+ | |||
+ | First of all, test if HANA Proxy is reachable from another machine. | ||
<code bash> | <code bash> | ||
Line 67: | Line 71: | ||
</ | </ | ||
- | On MS Windows you could also use '' | + | On MS Windows, you could also use '' |
<code powershell> | <code powershell> | ||
Line 75: | Line 79: | ||
If the port doesn' | If the port doesn' | ||
- | Once you've made sure that the port itself is reachable, you can test if HANA Proxy can execute queries. | + | ==== Test Query ==== |
- | First copy the following HANA Proxy command into a text file, let's say '' | + | Once you've made sure that the port itself is reachable, you can test if HANA Proxy can execute queries. |
+ | |||
+ | **Note:** It's important that the '' | ||
+ | |||
+ | First, copy the following HANA Proxy command into a text file, let's say '' | ||
<code json> | <code json> | ||
Line 89: | Line 97: | ||
</ | </ | ||
- | (The host can be " | + | The host can be " |
- | Now you can send the command to HANA Proxy with the following command: | + | Now you can send the command to HANA Proxy with the following command, assuming that '' |
<code bash> | <code bash> | ||
Line 97: | Line 105: | ||
</ | </ | ||
- | The results of the query, or at least an error message, should be returned in JSON format. | + | Alternatively, |
+ | |||
+ | <code bash> | ||
+ | nc -N localhost 30075 < hptest.json | ||
+ | </ | ||
+ | When you execute the command, the results of the query (or at least an error message) should be returned in JSON format. |
cobi.wms/hana_proxy.1672633404.txt.gz · Last modified: 2023/01/02 05:23 by tkammer