How to setup the server including OS installation, third party software and components installations.
- OS and 3rd-Party Software Installation
- #Variations Variations Administration User Account Creation
- Install your choice of Linux distribution.
Indiana University currently runs Variations on Red Hat Enterprise Linux 6 (RHEL 6). Derivatives of it such as Centos or White Box will be very similar, but for other distributions, the filenames and/or procedures may be different. The instructions below are tailored to RHEL6.
- Select "Software Development Workstation" when asked about selecting a software set.
- When creating the first user, this can be the "dmlserv" user that is required further on in the installation. ( #Variations Variations Administration User Account Creation )
- Set up your RedHat Network subscription, and update to latest release:
- Install needed packages
yum install gd-devel gdbm-devel
- Ensure that hostname -i returns the numeric IP address and not the host name.
- If hostname -i returns the IP and 127.0.0.1, edit /etc/hosts so that the ::1 entry has only the values localhost6.localdomain6 and localhost6.
- If hostname -i returns the host name, edit /etc/hosts to put the IP and hostname in a separate line entry.
Code Block title Example /etc/hosts
# Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 localhost.localdomain localhost 129.12.345.67 taishan.dlib.indiana.edu taishan ::1 localhost6.localdomain6 localhost6
- MySql has internal parameters specifying how long to keep a stale connection before dropping it. For interactive logons this is interactive_timeout and for non-interactive it is wait_timeout. Note that wait_timeout is set from interactive_timeout when the login is interactive. The default setting for these parameters is 8 hours (specified in seconds). After this time, the connection is dropped and cannot be reestablished without restarting the server. To fix this problem set both wait_timeout and interactive_timeout to 24 hours (86,400 seconds) in the MySql configuration file /etc/my.cnf under both the mysqld and mysqld_safe sections.
The default minimum length for words used in fulltext indexes is 4. This means that searches for words less than 4 characters will fail (e.g., "U2" or "Yes"). It is probably a good idea to reset this to 1 in the /etc/my.cnf file under both the mysqld and mysqld_safe sections. Also, MySQL has a default stopword file that excludes certain words from the text index, and it may exclude words that users might reasonably want to search on. Therefore, it may be best to turn this off by setting ft_stopword_file to "". For a list of MySQL default stop words, see http://dev.mysql.com/doc/refman/5.1/en/fulltext-stopwords.html. One can also set ft_stopword_file to the name of a file that contains a custom list of stop words.
wait_timeout=86400 interactive_timeout=86400 character_set_client=utf8 character_set_server=utf8 default-storage-engine=INNODB
- Set mysql to start automatically at boot:
chkconfig mysqld on
- Start the server now:
service mysqld start
- Download MySQL Connector/J database driver for Java (version 5.1 or later).
- Expand the archive and put the file mysql-connector-java-5.1.1617-bin.jar in the location _/usr/local/lib/_you can put this file in another location but will need to update the configuration file later.