Difference between revisions of "Regify provider appliance tech"
| Line 37: | Line 37: | ||
In order to access the regify provider database directly, we recommend the following: | In order to access the regify provider database directly, we recommend the following: | ||
| − | # Use [http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html PuTTy] to access the system (like accessing the provider appliance menu). Please configure your PuTTY connection to create a port forwarding tunnel like in the screenshot. This is to tunnel the remote systems port 3306 to your local client machines port 3306. | + | # Use [http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html PuTTy] to access the system (like accessing the provider appliance menu). Please configure your PuTTY connection to create a port forwarding tunnel like in the screenshot. This is to tunnel the remote systems port 3306 to your local client machines port 3306. |
| − | # Use a tool like [http://www.heidisql.com/ HeidiSQL] to access the now local available MySQL database. | + | # Use a tool like [http://www.heidisql.com/ HeidiSQL] to access the now local available MySQL database. |
| + | # '''PLEASE BE CAREFUL!''' You now have full control over the database! | ||
| + | |||
| + | <gallery> | ||
| + | File:PuTTY_SQL.png|Configure MySQL tunnel in PuTTY | ||
| + | File:HeidiSQL.png|Setup HeidiSQL to access local database | ||
| + | </gallery> | ||
Revision as of 09:20, 3 July 2013
PostFix
The regify Provider Appliance runs a PostFix server as MTA or SmartHost. You can use the following tricks to get a closer look:
To see the queue status:
> mailq
To flush the mailqueue (maybe, after you changed something)
> postqueue -f
To show mail log (continuously):
> tail -f /var/log/maillog
Logfiles
You can find most logs in
> /var/log/ > /var/log/httpd/
Additionally, the regify-provider does its own daily logging about provider business:
> /opt/provider/REGIFY_LOGS/
Certificates
The installed certificates are located at
/etc/pki/tls/certs /etc/pki/tls/private
While installing SSL certificates by using the applicance SSH menu, please ensure that you copy the complete certificate chain including the root CA and the private key. The order of the entries does not matter.
Appliance
If you like to turn off the regify Provider Appliance, exit the appliance menu, login as root and enter
> shutdown -h now
It may be you need to use sudo, if you only logged in using 'regify' or you used the 'drop to shell' option.
SMS gateway
You can find information about the SMS gateway at the regify homepage.
Database access
In order to access the regify provider database directly, we recommend the following:
- Use PuTTy to access the system (like accessing the provider appliance menu). Please configure your PuTTY connection to create a port forwarding tunnel like in the screenshot. This is to tunnel the remote systems port 3306 to your local client machines port 3306.
- Use a tool like HeidiSQL to access the now local available MySQL database.
- PLEASE BE CAREFUL! You now have full control over the database!
Configure MySQL tunnel in PuTTY
Setup HeidiSQL to access local database
