Difference between revisions of "Regify provider appliance tech"
Line 34: | Line 34: | ||
You can find information about the SMS gateway at the [http://www.regify.com/?PageID=sms_gateway regify homepage]. | You can find information about the SMS gateway at the [http://www.regify.com/?PageID=sms_gateway regify homepage]. | ||
− | == Database | + | == Database hints == |
=== Direct access using SSH === | === Direct access using SSH === | ||
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: |
Revision as of 11:16, 29 July 2014
Contents
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 hints
Direct access using SSH
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!
Backup and recovery
Sometimes we encounter problems with character encoding. This solution managed it to export on a regify-provider and import the data on Windows machine:
Export:
mysqldump -uroot --opt --quote-names --skip-set-charset --default-character-set=latin1 regify > backup_dump.sql
Import:
mysql -uroot -ppassword mysql> create database regify; mysql> quit mysql -uroot -pregify --default_character_set utf8 regify < backup_dump.sql
Install VMWare Tools
1) Please respect the licence and support information about third party software on the regify provider appliance. You can find this information in your regify appliance manual. In short words, you are not allowed to install anything except software that is essentially needed for running the appliance on a virtual environment. No other RPM repositories allowed!
2) Chose to install or update VMWare tools for your virtual machine. This will create a new CD rom device for the regify provider software appliance.
3) Enter in terminal:
mkdir /mnt/cdrom mount /dev/cdrom /mnt/cdrom cp /mnt/cdrom/VMwareTools-*.tar.gz /tmp umount /mnt/cdrom tar -zxf /tmp/VMwareTools-*.tar.gz -C /tmp cd / ./tmp/vmware-tools-distrib/vmware-install.pl --default rm -f /tmp/VMwareTools-*.tar.gz rm -rf /tmp/vmware-tools-distrib
Sometimes, you might need to mount /dev/sr0 instead of /dev/cdrom.
4) Check if the VMWare tools are running:
/etc/init.d/vmware-tools status
Manually run the updates
In order to manually run the updates for the provider and regigate without SSH GUI, simply execute
yum upgrade