http://wiki.stardothosting.com/ 2012-05-17T23:02:02-04:00 http://wiki.stardothosting.com/ http://wiki.stardothosting.com/lib/tpl/default/images/favicon.ico text/html 2009-02-26T10:58:37-04:00 http://wiki.stardothosting.com/doku.php?id=add_a_user_manually&rev=1235663917&do=diff Add user manually or set password manually If for instance phpmyadmin is mysqltor, make sure you get the phpmyadmin ip address for the hostname setting : i.e. 172.16.33.3 set password : SET PASSWORD FOR 'user'@'hostname' = PASSWORD('passwordhere'); text/html 2009-02-26T12:37:09-04:00 http://wiki.stardothosting.com/doku.php?id=basic_mail_troubleshooting&rev=1235669829&do=diff The purpose of this document is to describe how mail gets from one users email client to another users mailbox. Each action that takes place can be tested and verified by an some level of admin with a few exceptions. After going through this document you should understand what takes place when a user sends email or has email sent to them. text/html 2009-04-21T18:46:16-04:00 http://wiki.stardothosting.com/doku.php?id=billing_questions&rev=1240353976&do=diff What will my credit card be billed as? Your credit card will be billed as Star Dot Hosting. How do I update my billing information? Simply open a support ticket through our support area. Provide the billing information you wish to change within the ticket. text/html 2009-02-26T16:41:40-04:00 http://wiki.stardothosting.com/doku.php?id=bind_slave_secondary_dns_server_howto&rev=1235684500&do=diff How to create a BIND Slave DNS server Create the named.conf file (touch /etc/named.conf) and add: options { directory "/var/named"; fetch-glue no; recursion no; allow-query { 000.000.000/24; 127.0.0/8; }; allow-transfer { 000.000.000.1; }; transfer-format many-answers; }; // These files are not specific to any zone zone "." in { type hint; file "db.cache"; }; zone "0.0.127.in-addr.arpa" in { type master; file "db.127.0.0"; }; // These … text/html 2009-02-26T16:36:27-04:00 http://wiki.stardothosting.com/doku.php?id=bind_zone_example&rev=1235684187&do=diff BIND Zone file example This file (pri.example.com) is the standard sample zone file used throughout this Chapter and has the following characteristics. NOTE: Both externally visible (public) services and internal hosts are defined in this file. 1. Two name servers are used one internal (ns1) and one external (ns2) to the domain text/html 2009-02-26T12:44:07-04:00 http://wiki.stardothosting.com/doku.php?id=building_a_transparent_bridging_firewall_with_pf&rev=1235670247&do=diff The Goal: A way to transparently protect a set of servers as well as monitor the inbound and outbound traffic to said servers. Solution: The end solution was to install FreeBSD 6.2 or 7.0 Release on a server and utilize packet filter (pf) as a transparent bridge to meet the IP addressing requirements. text/html 2009-02-26T12:38:39-04:00 http://wiki.stardothosting.com/doku.php?id=bulk_mail_tips&rev=1235669919&do=diff People who send bulk mail out to the internet from their dedicated servers may want to register with the larger mail servers to insure they aren’t throttled, or worse blocked from sending mail to their services. All ISP’s have slightly different rules of how to get on these lists and how much protection they offer – but it’s a good idea to register on them BEFORE you start sending bulk email (often it’s much harder to get on the bulk list if you already have strikes against you). text/html 2009-02-26T10:57:17-04:00 http://wiki.stardothosting.com/doku.php?id=check_and_repair_tables&rev=1235663837&do=diff Stage 1: Checking your tables Run: myisamchk *.MYI or myisamchk -e *.MYI if you have more time. Use the -s (silent) option to suppress unnecessary information. If the mysqld server is stopped, you should use the --update-state option to tell myisamchk to mark the table as “checked.” text/html 2009-04-21T23:24:08-04:00 http://wiki.stardothosting.com/doku.php?id=common_gateway_interface_cgi_questions&rev=1240370648&do=diff How does Star Dot Hosting provide for CGI services? A /cgi-bin/ is available to run any CGI programs written in Perl or C. It is not necessary to check with Star Dot Hosting when uploading a CGI to the server. Your /cgi-bin/ is available to run most scripts, so long as the script is not malicious to the machine, bandwidth, users, or other as determined by Star Dot Hosting administrators. text/html 2009-02-26T12:45:04-04:00 http://wiki.stardothosting.com/doku.php?id=creating_a_jail_in_freebsd&rev=1235670304&do=diff Those familiar with Java recognize the security concept of a sandbox. For those that aren't, it's the concept that everyone gets a unique, well-equipped sandbox to play in, and a person in one sandbox isn't allowed into anyone else's sandbox, not even to share anything with anyone else. On FreeBSD, jails implement this concept — they keep processes in their own part of the system, denying access to anything else. A jail requires its own dedicated IP address, though, which can make life difficult… text/html 2009-04-21T23:33:44-04:00 http://wiki.stardothosting.com/doku.php?id=direct_admin_usage_questions&rev=1240371224&do=diff How to change your email password without logging in If you would like to be able to change your own email passwords without having to login to the control panel, simply go to this link: http://www.domain.com:2222/CMD_CHANGE_EMAIL_PASSWORD Where www.domain.com is either your domain, hostname, or IP address. text/html 2009-02-26T12:51:30-04:00 http://wiki.stardothosting.com/doku.php?id=display_the_default_gateway&rev=1235670690&do=diff Display default gateway in FreeBSD Type the following command $ cat /etc/mygat Output: 75.126.68.49 75.126.68.49 is the router IP address. You can also type any one of the following command to display router IP address: $ route show OR $ netstat -rn text/html 2009-04-21T23:23:11-04:00 http://wiki.stardothosting.com/doku.php?id=domain_name_questions&rev=1240370591&do=diff What is a domain name? This is the “address” of your website - the name that visitors type in to the location window of their browser to get to your homepage. We can register for you a unique domain name of your choice in .com .net .org .info .biz .us Such unique address makes your web presence more professional and more memorable to your visitors. text/html 2009-02-26T11:00:52-04:00 http://wiki.stardothosting.com/doku.php?id=export_the_database_schema_only&rev=1235664052&do=diff Export the DB Schema ONLY To dump the database SCHEMA only, without dumping any actual data : mysqldump --no-data --tables -u YOUR_USER_NAME -p DATABASE_YOU_WANT_SCRIPTED >> FILENAME.sql Actual example: mysqldump --no-data --tables -u larry -p contacts >> contacts.sql If you want the data to be exported, omit the ”--no-data” portion. text/html 2009-04-21T23:26:32-04:00 http://wiki.stardothosting.com/doku.php?id=ftp_questions&rev=1240370792&do=diff What is FTP and how do I get it? The method by which files are transferred to the web server is called “FTP” (File Transfer Protocol). FTP is designed to provide you with access 24 hours a day. As such, you can create and maintain your web pages on your own computer and upload files to your Website at your leisure. text/html 2009-02-26T12:52:44-04:00 http://wiki.stardothosting.com/doku.php?id=hardware_troubleshooting&rev=1235670764&do=diff Troubleshooting / Getting information about your hardware in FreeBSD Sometimes you need to determine what card is on which PCI bus, as well as whether or not there are any problems with installed hardware (i.e. driver not registering, or other hardware problems). To do some basic troubleshooting, you can do the following : text/html 2009-02-26T12:41:09-04:00 http://wiki.stardothosting.com/doku.php?id=how_to_change_the_timezone&rev=1235670069&do=diff How to Change the Timezone in Linux Most modern Linux distributions have user-friendly programs to set the timezone, often accessible through the program menus or right-clicking the clock in a desktop environment such as KDE or GNOME. Failing that it's possible to manually change the system timezone in Linux in a few short steps. text/html 2009-02-26T16:50:10-04:00 http://wiki.stardothosting.com/doku.php?id=how_to_properly_rotate_apache_logs&rev=1235685010&do=diff Rotating Apache logs There are two ways that can be utilized to accomplish this. Rotating the apache logs via CUSTOMLOG rotatelogs is a simple program for use in conjunction with Apache's piped logfile feature. For example: CustomLog "|bin/rotatelogs /var/logs/logfile 86400" common This creates the files /var/logs/logfile.nnnn where nnnn is the system time at which the log nominally starts (this time will always be a multiple of the rotation time, so you can synchronize cron scripts with it).… text/html 2009-02-26T16:45:29-04:00 http://wiki.stardothosting.com/doku.php?id=how_to_setup_apache_mod-rewrite_rules&rev=1235684729&do=diff Establishing mod-rewrite rules within Apache First ensure apache was compiled with mod_rewrite, httpd.conf should have the following (or similar) line : LoadModule rewrite_module libexec/apache22/mod_rewrite.so The following example shows the apache rewrite syntax that affect several different domains and re-write them as a single domain : text/html 2009-02-26T10:53:08-04:00 http://wiki.stardothosting.com/doku.php?id=install_from_source&rev=1235663588&do=diff Installing MySQL from Source Get the source code tar -xzf mysql-5.0.XX.tar.gz % cd mysql-5.0* % ./configure \ --enable-thread-safe-client \ --with-big-tables \ --with-fast-mutexes \ --with-extra-charsets=all \ --with-innodb \ and if you want some more engines text/html 2009-02-26T10:57:49-04:00 http://wiki.stardothosting.com/doku.php?id=list_processes_and_statuses&rev=1235663869&do=diff mysqladmin proc stat <- list mysql process statuses mysqladmin processlist <--- list all mysql processes text/html 2009-04-21T23:30:46-04:00 http://wiki.stardothosting.com/doku.php?id=mail_account_questions&rev=1240371046&do=diff Where can I manage my mail account? Our control panel (Direct Admin) allows the client to perform several email administration functions. Direct Admin uses the exim system to help you to set up email account and services. Protection services such as Anti-Spam and Anti-Virus are built into the system for your convenience. You can find all information, concerning mail managing in the Client Direct Admin Manual. text/html 2009-02-26T12:49:33-04:00 http://wiki.stardothosting.com/doku.php?id=mount_an_iso_to_cdrom&rev=1235670573&do=diff How to mount an ISO to CDROM in FreeBSD # mdconfig -a -t vnode -f <ISO filename> -u 0 # mount -t cd9660 /dev/md0 <mount destination> eg.: # mdconfig -a -t vnode -f /home/steven/5.4-RELEASE-i386-disc1.iso -u 0 # mount -t cd9660 /dev/md0 /var/ftp/pub/freebsd-5.4/ text/html 2009-02-26T10:59:28-04:00 http://wiki.stardothosting.com/doku.php?id=mysql_dump_specific_databases&rev=1235663968&do=diff mysqldump -u root -p mysql_database_name > database.sql <-- dump database to a file mysql -u root -p , show databases; <-- show all databases mysql -u root -p database_name < databasefile.sql text/html 2009-02-26T11:06:33-04:00 http://wiki.stardothosting.com/doku.php?id=mysql_query_log&rev=1235664393&do=diff The General Query Log The general query log is a general record of what mysqld is doing. The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from clients. The general query log can be very useful when you suspect an error in a client and want to know exactly what the client sent to mysqld. text/html 2009-02-26T10:59:52-04:00 http://wiki.stardothosting.com/doku.php?id=mysql_replication&rev=1235663992&do=diff SYNOPSIS This documentation assumes two functional MySQL servers that are new enough to support replication. Links to some binary/source RPM packages for RedHat Linux can be found here. It is preferred that your MySQL servers be identical versions. text/html 2009-04-21T18:44:12-04:00 http://wiki.stardothosting.com/doku.php?id=pre-sales_questions&rev=1240353852&do=diff Pre-Sales Questions What is "VPS" , "SHARED" or "DEDICATED"? “VPS” Stands for “Virtual Private Server”. It is one of the services we provide as a hosting company. Virtual private servers allow for better security, flexibility and performance (compared to shared hosting solutions) without the price tag of a “dedicated” server solution. text/html 2009-02-26T11:01:23-04:00 http://wiki.stardothosting.com/doku.php?id=reset_the_mysql_root_password&rev=1235664083&do=diff Reset MYSQL root password Simple steps to reset the mysql root password if you have forgotten it. 1. Stop the mysqld daemon process. 2. Start the mysqld daemon process with the '--skip-grant-tables' option. 3. Start the mysql client with the -u root option. text/html 2009-02-26T12:54:13-04:00 http://wiki.stardothosting.com/doku.php?id=server_monitoring&rev=1235670853&do=diff Free & Paid External Server Monitoring <http://www.siteuptime.com> - Free Monitoring (paid for more than 1 host) <http://www.webhostingstuff.com> - Free Monitoring <http://www.pingdom.com> - Paid monitoring service <http://site24x7.com> - Free website monitoring service, includes keyword and other content change monitoring. Optional SMS alerts (which incur a per alert charge). text/html 2009-02-26T12:45:57-04:00 http://wiki.stardothosting.com/doku.php?id=set_up_flash_with_firefox_in_freebsd&rev=1235670357&do=diff I used graphics/gnash and www/firefox. Be sure not to check “GSTREAMER” on the gnash port configuration ncurses window: it didn’t work for me. To watch YouTube videos, you must install multimedia/mplayer and www/mplayer-plugin, the Greasemonkey Plugin for Firefox and install this script on Greasemonkey. Be sure to select the “mini” GUI for mplayer because it is needed for the plugin (update: be sure to install mplayer WITH_GUI (thx to Oliver for the hint)). text/html 2009-02-26T16:33:25-04:00 http://wiki.stardothosting.com/doku.php?id=setup_a_nagios_mysql_backend&rev=1235684005&do=diff Setting up Nagios with MySQL backend This guide is based on several guides throughout the internet, and the system used to install this on is Debian. Installing Nagios-MySQL Step One - apt-get packages / install nagios apt-get install apache2 mysql-server libapache2-mod-auth-mysql nagios-mysql nagios-plugins text/html 2009-02-26T12:41:29-04:00 http://wiki.stardothosting.com/doku.php?id=setup_dag_repository&rev=1235670089&do=diff Add Dag repository for YUM in CENTOS 5 / RHEL5 Create the file /etc/yum.repos.d/dag.repo , and put the following in it: [dag] name=Dag RPM Repository for Red Hat Enterprise Linux baseurl=http://apt.sw.be/redhat/el4/en/$basearch/dag gpgcheck=1 enabled=1 text/html 2009-02-26T10:59:04-04:00 http://wiki.stardothosting.com/doku.php?id=show_database_connections&rev=1235663944&do=diff Show database connections mysql> show full processlist; +------+------+-----------------+-----------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+------+-----------------+-----------+---------+------+-------+-----------------------+ | 2191 | root | localhost:43821 | mysql | Query | 0 | NULL | show full processlist | | 2776 | root | localhost | autocatch | Sleep | 195 | NULL | NULL | | 2801 | root | localhost | autoca… text/html 2009-02-26T16:20:29-04:00 http://wiki.stardothosting.com/doku.php?id=speedtest&rev=1235683229&do=diff Test download speed Right click the link and select Save As. You can see the download speed as you download the file. The filesize is approximately 43MB. text/html 2011-08-24T14:06:29-04:00 http://wiki.stardothosting.com/doku.php?id=star_dot_hosting&rev=1314209189&do=diff Go Back to Main Site At Star Dot Hosting, we feel that wiki knowledge bases are the best way to compile, distribute and communicate information. General Topics * External Monitoring Services * Download Speed test * Using Star Dot Hosting Nameservers for DNS lookups * Setting up different Linux Distro's text/html 2009-02-26T10:58:12-04:00 http://wiki.stardothosting.com/doku.php?id=test_and_pull_data_from_a_table&rev=1235663892&do=diff Mysql steps to test connect, and pulling data from a mysql DB: mysql -u s2000admin -p -h mysql.domainname.com -A geophysics Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5307738 to server version: 3.23.58 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show tables; +----------------------+ | Tables_in_geophysics | +----------------------+ | log | | users | +----------------------+ 2 rows in set (0.00 sec) … text/html 2009-02-26T11:05:42-04:00 http://wiki.stardothosting.com/doku.php?id=update_a_table_with_different_data_in_a_specific_record&rev=1235664342&do=diff Updating a table with different data in a sepcific record UPDATE `jos_users` SET `password` = MD5( 'new_password' ) WHERE `jos_users`.`username` = "admin" ; jos_users Is the table name , and password is the column that contains a password , for this specfic entry. The rest of this command obviously ensures that only the user admin is changed with that info. text/html 2009-02-26T16:26:38-04:00 http://wiki.stardothosting.com/doku.php?id=using_star_dot_hosting_nameservers_for_dns_lookups&rev=1235683598&do=diff How to use Star Dot Hosting's Nameservers For DNS Lookups Using the DNS tool Drill ( <http://www.nlnetlabs.nl/projects/drill/> ) , you can utilize our nameservers to make DNS lookups. Using these instructions , you can also utilize any other nameservers in order to make DNS queries for your testing and troubleshooting purposes. text/html 2011-08-24T14:11:52-04:00 http://wiki.stardothosting.com/doku.php?id=utilize_our_control_panel_api&rev=1314209512&do=diff Overview The client API is a http based API that allows you and your clients to interact directly with a virtual server with security and ease. The client API can be disabled at any time and access is only granted with a key and hash on a per vps basis.