Management System / Public Website / Signup / Account Manager

From JCWiki
Revision as of 18:01, 15 January 2013 by Support (talk | contribs)
Jump to navigation Jump to search

Overview

These systems are all running under the same apache instance on the mail server.
The main ingredients are: apache 1.x, mysql, perl, mod_perl and template toolkit.

The webserver can be stopped with: 

apachectl stop

and must be started with: 

apachectl startssl

If you run apachectl start none of the ssl-enabled pages will work.

The database may be stopped and started as follows: /usr/local/etc/rc.d/mysql-server.sh stop (stop) /usr/local/etc/rc.d/mysql-server.sh start (start)


web

This server hosts the johncompanies public website, including the ordering system, management system and account manager. Apache/1.3.31 is listening on 69.55.230.9 ports 80 and 443

  • webroot: /usr/local/www/
  • config: /usr/local/etc/apache/
  • logs: /var/log/httpd-error.log /var/log/httpd-access.log
  • control: apachectl stop (stop), apachectl startssl (start)

Web components:

public site

signup

management (mgmt)

account manager (AM)

mrtg

All configuration is done via *.cfg files. The main load graph is found in mrtg1.cfg All other config files are for various switches. Switch config files are rebuilt out of a cron jobs running on mail. This ensures if we change a port name (desc) that the mrtg we look at has the latest info. So if you want to change port naming, please do it in the switch itself. If you have problems getting new devices setup or change existing devices you may need to change permissions on the cfg file as well as the data file in /usr/local/www/mgmt/mrtg/data, including removal of the rrd file if necessary.


Public Website (jcpub)

Signup (signup)

Management System (mgmt)

It is installed under /usr/local/www/

Errors

"Lock wait timeout exceeded"

delete error - Can't delete a2206e24: DBD::mysql::st execute failed: Lock wait timeout exceeded; try restarting transaction [for Statement "DELETE FROM invoice WHERE inv_ref=? "] at /usr/local/lib/perl5/site_perl/5.6.1/DBIx/ContextualFetch.pm line 51. at /usr/local/www/mgmt/Plugin/Billing.pm line 1934

This is the result of an unclean submit/commit. Usually from an error or a double click on something that should have been single click. To clear this up, restart the database: 

mail /usr/local/www/scripts# /usr/local/etc/rc.d/mysql-server.sh stop
mysqldmail /usr/local/www/scripts#

It takes a minute to shutdown. I keep running the command until it says it isn't running, then I start it: 

mail /usr/local/www/scripts# /usr/local/etc/rc.d/mysql-server.sh stop
 mysqldmail /usr/local/www/scripts# /usr/local/etc/rc.d/mysql-server.sh stop
 mysqldmail /usr/local/www/scripts# /usr/local/etc/rc.d/mysql-server.sh stop
mysql-server isn't running
mail /usr/local/www/scripts# /usr/local/etc/rc.d/mysql-server.sh start
 mysqldmail /usr/local/www/scripts#
Retrieved from "https://wiki.jcihosting.com/index.php?title=Management_System_/_Public_Website_/_Signup_/_Account_Manager&oldid=660"