https://wiki.xmission.com/api.php?action=feedcontributions&user=Ewaters&feedformat=atomXMission Wiki - User contributions [en]2024-03-29T06:19:31ZUser contributionsMediaWiki 1.28.2https://wiki.xmission.com/index.php?title=MySQL_FAQ&diff=1762MySQL FAQ2008-04-07T22:15:25Z<p>Ewaters: /* Can I use stored routines? */</p>
<hr />
<div>{{archived}}<br />
==What is SQL?==<br />
SQL stands for "Structured Query Language". SQL is the most common standardized language used to access databases.<br />
<br />
XMission uses MySQL, which is a very popular open-source database management system. <br />
<br />
<br />
==What version of MySQL does XMission use?==<br />
XMission currently has two versions of MySQL running: version 5.0.24a and version 4.1.11. The current version is also displayed when you log in to the MySQL server. <br />
<br />
<br />
==How much does a database at XMission cost?==<br />
If you have a Deluxe Hosting or Pro Hosting account, an SQL database is included in your account package. For any other account type, the charge is $5 per month.<br />
<br />
<br />
==How do I get a database set up for my account?==<br />
To add a database to your account, either [mailto:sql@xmission.com email sql@xmission.com] or contact sales. <br />
<br />
<br />
==How do I log in to my database?==<br />
Depending on your MySQL version, you will need to connect to a different host. For MySQL version 4.x, the server name is ''mysql-41.xmission.com''<br />
<div class="messagebox metadata">'''Note''': ''mysql.xmission.com'' is the same machine, and will work for legacy purposes.</div><br />
<br />
For MySQL version 5.x the server name is ''mysql-50.xmission.com''<br />
<br />
To connect directly to the database from our shell server:<br />
#telnet or ssh to ''shell.xmission.com''<br />
#<tt>mysql -u acctname -h servername -p databasename</tt><br />
#This will prompt you for a password, which is not necessarily the same as your login password.<br />
<br />
For example: to connect to a MySQL version 5.x database, you would use:<br />
<tt>mysql -u acctname -h mysql-50.xmission.com -p databasename</tt><br />
<br />
<br />
==What can I use to access my database?==<br />
There isn't a "recommended" method to access your database, but here is a list of the more popular programing languages connection methods which we support. <br />
<br />
'''perl''' : DBI module <br />
<br />
'''python''' : mysql module or MySQLdb module <br />
<br />
'''php''' : php has been compiled with the mysql functions built in <br />
<br />
'''C''' : The header and libraries for mysql are installed so #include <mysql/mysql.h> will need to be present in your source files. <br />
<br />
'''C++''' : same as C, but we also have mysql++ headers and libraries on XMission servers. To use this, #include <sqlplus> <br />
<br />
'''Java''' : JDBC classes are available <br />
<br />
<br />
==What do I do if I forgot my password?==<br />
[mailto:sql@xmission.com Email sql@xmission.com] to have your password reset. <br />
<br />
<br />
==Do I have a size limit (quota) for my database?==<br />
<br />
Yes. The size of your database counts against your /home quota, which is 100MB default for most account types. Pro Hosting accounts get 200MB /home storage, and additional storage can be purchased.<br />
<br />
<br />
==Can I use stored routines?==<br />
<br />
Our MySQL 5.0 server support stored functions, procedures, triggers, and other such routines. Since it is a shared server, we do not allow users to create or edit their own routines. If you would like to have a routine installed, please contact support, providing a full copy of the routine you'd like installed. We will install the routine if we decide the code does not cause any problems or cause an unreasonable support burden. If you would like more complete control over database routines, please consider our [[VPS]] or [[Colocate]] products.<br />
<br />
==Where can I get more information about using MySQL?==<br />
<br />
Thorough documentation can be found at [http://www.mysql.com MySQL.com].<br />
<br />
<br />
{{Footer}}<br />
[[Category:Hosting Archives|MySQL FAQ]]<br />
[[Category:FAQ|MySQL]]</div>Ewatershttps://wiki.xmission.com/index.php?title=MySQL_FAQ&diff=1761MySQL FAQ2008-04-07T22:15:06Z<p>Ewaters: </p>
<hr />
<div>{{archived}}<br />
==What is SQL?==<br />
SQL stands for "Structured Query Language". SQL is the most common standardized language used to access databases.<br />
<br />
XMission uses MySQL, which is a very popular open-source database management system. <br />
<br />
<br />
==What version of MySQL does XMission use?==<br />
XMission currently has two versions of MySQL running: version 5.0.24a and version 4.1.11. The current version is also displayed when you log in to the MySQL server. <br />
<br />
<br />
==How much does a database at XMission cost?==<br />
If you have a Deluxe Hosting or Pro Hosting account, an SQL database is included in your account package. For any other account type, the charge is $5 per month.<br />
<br />
<br />
==How do I get a database set up for my account?==<br />
To add a database to your account, either [mailto:sql@xmission.com email sql@xmission.com] or contact sales. <br />
<br />
<br />
==How do I log in to my database?==<br />
Depending on your MySQL version, you will need to connect to a different host. For MySQL version 4.x, the server name is ''mysql-41.xmission.com''<br />
<div class="messagebox metadata">'''Note''': ''mysql.xmission.com'' is the same machine, and will work for legacy purposes.</div><br />
<br />
For MySQL version 5.x the server name is ''mysql-50.xmission.com''<br />
<br />
To connect directly to the database from our shell server:<br />
#telnet or ssh to ''shell.xmission.com''<br />
#<tt>mysql -u acctname -h servername -p databasename</tt><br />
#This will prompt you for a password, which is not necessarily the same as your login password.<br />
<br />
For example: to connect to a MySQL version 5.x database, you would use:<br />
<tt>mysql -u acctname -h mysql-50.xmission.com -p databasename</tt><br />
<br />
<br />
==What can I use to access my database?==<br />
There isn't a "recommended" method to access your database, but here is a list of the more popular programing languages connection methods which we support. <br />
<br />
'''perl''' : DBI module <br />
<br />
'''python''' : mysql module or MySQLdb module <br />
<br />
'''php''' : php has been compiled with the mysql functions built in <br />
<br />
'''C''' : The header and libraries for mysql are installed so #include <mysql/mysql.h> will need to be present in your source files. <br />
<br />
'''C++''' : same as C, but we also have mysql++ headers and libraries on XMission servers. To use this, #include <sqlplus> <br />
<br />
'''Java''' : JDBC classes are available <br />
<br />
<br />
==What do I do if I forgot my password?==<br />
[mailto:sql@xmission.com Email sql@xmission.com] to have your password reset. <br />
<br />
<br />
==Do I have a size limit (quota) for my database?==<br />
<br />
Yes. The size of your database counts against your /home quota, which is 100MB default for most account types. Pro Hosting accounts get 200MB /home storage, and additional storage can be purchased.<br />
<br />
<br />
==Can I use stored routines?==<br />
<br />
Our MySQL 5.0 server support stored functions, procedures, triggers, and other such routines. Since it is a shared server, we do not allow users to create or edit their own routines. If you would like to have a routine installed, please contact support, providing a full copy of the routine you'd like installed. We will install the routine if we decide the code does not cause any problems or cause an unreasonable support burden. If you would like more complete control over database routines, please consider our [VPS] or [Colocate] products.<br />
<br />
==Where can I get more information about using MySQL?==<br />
<br />
Thorough documentation can be found at [http://www.mysql.com MySQL.com].<br />
<br />
<br />
{{Footer}}<br />
[[Category:Hosting Archives|MySQL FAQ]]<br />
[[Category:FAQ|MySQL]]</div>Ewatershttps://wiki.xmission.com/index.php?title=CGI_help&diff=378CGI help2007-11-14T18:25:10Z<p>Ewaters: </p>
<hr />
<div>Common Gateway Interface (CGI) services are typically scripts or programs that can be executed in conjunction with web pages. They are often used to process data entered by a visitor. <br />
<br />
While HTML is a static language that mainly controls page layout, CGI (Common Gateway Interface) opens up many possibilities for dynamic web pages. XMission encourages our subscribers to explore what CGI can do for them. <br />
<br />
<br />
==Naming & Placement==<br />
CGI on XMission requires no interaction from administration. You can set up your own CGI scripts in your public_html directory simply by naming them with a filename ending in ".cgi". There is no need to put your scripts in a cgi-bin directory. (This is also the same with ".php" and ".php3".) <br />
<br />
<br />
===Permissions===<br />
The file should be set to allow the web server execute permissions. Assuming the group on the file is "www", issuing the command "chmod g+x filename.cgi" (using your XMission shell account) would give the web server permission to execute the file. <br />
<br />
<div class="messagebox metadata">'''Note''': You may set all public_html permissions to defaults by logging in to http://home.xmission.com/ and selecting the "My Account" tab. There, you will find a "Repair Your Web Permissions" option under the "XMission Tools" section.</div> <br />
<br />
<br />
===SSI (Server Side Includes)===<br />
If you wish to include your script as a part of an HTML file, you will want to use Server Side Includes (SSI) with the Apache web server. The syntax is very simple. You simply need to give your file the ".shtml" extension instead of just ".html" and use the following tag within the file where you'd like to include the script: "<!--#include file="filename"-->". <br />
<br />
<br />
==WWW Services==<br />
<br />
WWW services can be invoked by using a URL such as "http://www.xmission.com/cgi-bin/servicename", where "servicename" is the name of the service you're invoking. <br />
<br />
<br />
===cgiemail===<br />
This is a powerful WWW-to-email gateway that can be configured for your specific needs. By default, you have a simple cgiemail form in your public_html directory. It comes in two parts: mail.html and mail.txt. Refer to our [cgi-email cgiemail help page] for details. <br />
<br />
<br />
===post-query ===<br />
This is a debugging aid for CGI script writers. It shows the data delivered by a form using the POST method. <br />
<br />
<br />
===query===<br />
This is a debugging aid for CGI script writers. It shows the data delivered by an ISINDEX query. <br />
<br />
<br />
===showrawenv===<br />
This is a debugging aid for CGI script writers. It shows the entire environment available to the CGI script. This is handy for examining the default command search path, for instance. <br />
<br />
<br />
===test-cgi===<br />
This is a debugging aid for CGI script writers. It shows CGI related information (i.e., command line arguments and related environment variables).<br />
<br />
==Perl Modules==<br />
<br />
Our webhosting servers have a limited selection of Perl modules installed by default. We are happy to consider installing modules server-wide upon request, but only for versions considered to be stable by the Debian or Ubuntu package repositories. If you have code that needs a later version of code than we have, or if you need code that's not normally packaged, consider using CPAN.<br />
<br />
===CPAN===<br />
<br />
You can maintain your own CPAN repository, start with this link: http://www.digitalramble.com/2006/06/14/39/ Once you have your local CPAN repository setup, you can type 'cpan' at a shell on shell.xmission.com and install whatever modules you need ('install DBIx::Class', for example). To utilize your local repository in your CGI scripts, add the following at the top:<br />
<br />
use lib "$ENV{HOME}/perl/lib"; # or whatever the path to your local repository is<br />
<br />
We'd also recommend you add this use line:<br />
<br />
use CGI::Carp qw(fatalsToBrowser); <br />
<br />
This allows for any error messages that may result for module discrepancies to be printed to the browser instead of the servers error.log (which you don't have access to unless you've asked us to redirect it somewhere for you).</div>Ewatershttps://wiki.xmission.com/index.php?title=DansGuardian_User_Agreement&diff=33DansGuardian User Agreement2007-07-13T14:45:32Z<p>Ewaters: </p>
<hr />
<div>'''DansGuardian NOTE''': Please understand that all web filtering software is less than 100% successful. XMission encourages parents to actively participate in their children's Internet Experience. It is the only way to be sure they view what your family considers acceptable. If you wish to use DansGuardian you must review and accept the disclaimer before you can turn on this service.<br />
<br />
----<br />
<br />
DansGuardian's terms of service<br />
<br />
I acknowledge that this, and any content filter, is flawed and will not work 100% of the time. Some web pages may be incorrectly filtered and some potentially offensive pages may not be filtered.<br />
<br />
I understand that XMission provides this content filter to assist me in controlling offensive content from the Internet and I will not hold XMission responsible for any problems with the content filter or with XMission's blocking services.</div>Ewatershttps://wiki.xmission.com/index.php?title=Proxy&diff=32Proxy2007-07-13T14:42:55Z<p>Ewaters: </p>
<hr />
<div>'''Proxy Servers'''<br />
<br />
An HTTP, or web, proxy server provides a gateway between your browser and the rest of the Internet. A proxy server replaces your identity (IP address, in this case) with its own, making it possible to browse more privately, securely, and can offer additional features depending upon the proxy. XMission now provides three different web proxies. Information about each is listed below.<br />
<br />
'''Dial-up Web Accelerator'''<br />
<br />
Our dial-up accelerator transparently compresses and caches web documents (i.e., text and html) locally to cut down on load time. Downloading compressed and cached web pages through XMission can speed up web browsing for dial-up users. To use this service, find your browser on our [[Dial-up Web Accelerator Usage]] instruction page.<br />
<br />
'''Privoxy'''<br />
<br />
Privoxy is geared towards filtering pop-up advertisements and regular web advertisements. XMission had previously offered a proxy called "Junkbuster" for the same purpose. Privoxy is based off Junkbuster but provides better filtering. Privoxy also provides all of the features offered by the "Normal Caching Proxy". If you wish to use this service, find your browser on our [[Privoxy Usage]] instruction page.<br />
<br />
'''DansGuardian'''<br />
<br />
DansGuardian is a web proxy capable of filtering out web content (sex, drugs, profanity, violence, etc.) some might consider offensive. DansGuardian also offers all of the features offered by "Privoxy" and the "Normal Caching Proxy". If you wish to use this service, visit our [[DansGuardian Usage]] page.<br />
<br />
'''Normal Caching Proxy'''<br />
<br />
Our normal proxy transparently caches web documents locally to cut down on load time. Downloading a web page from an XMission server is faster than downloading one from across the Internet. If you wish to use this service, find your browser on our [[Caching Proxy Usage]] instruction page.</div>Ewatershttps://wiki.xmission.com/index.php?title=DansGuardian_User_Agreement&diff=31DansGuardian User Agreement2007-07-13T14:42:31Z<p>Ewaters: New page: '''DansGuardian NOTE''': Please understand that all web filtering software is less than 100% successful. XMission encourages parents to actively participate in their children's Internet Ex...</p>
<hr />
<div>'''DansGuardian NOTE''': Please understand that all web filtering software is less than 100% successful. XMission encourages parents to actively participate in their children's Internet Experience. It is the only way to be sure they view what your family considers acceptable. If you wish to use DansGuardian you must review and accept the disclaimer before you can turn on this service.</div>Ewatershttps://wiki.xmission.com/index.php?title=Proxy&diff=30Proxy2007-07-13T14:42:09Z<p>Ewaters: </p>
<hr />
<div>'''Proxy Servers'''<br />
<br />
An HTTP, or web, proxy server provides a gateway between your browser and the rest of the Internet. A proxy server replaces your identity (IP address, in this case) with its own, making it possible to browse more privately, securely, and can offer additional features depending upon the proxy. XMission now provides three different web proxies. Information about each is listed below.<br />
<br />
'''Dial-up Web Accelerator'''<br />
<br />
Our dial-up accelerator transparently compresses and caches web documents (i.e., text and html) locally to cut down on load time. Downloading compressed and cached web pages through XMission can speed up web browsing for dial-up users. To use this service, find your browser on our [Dial-up Web Accelerator Usage] instruction page.<br />
<br />
'''Privoxy'''<br />
<br />
Privoxy is geared towards filtering pop-up advertisements and regular web advertisements. XMission had previously offered a proxy called "Junkbuster" for the same purpose. Privoxy is based off Junkbuster but provides better filtering. Privoxy also provides all of the features offered by the "Normal Caching Proxy". If you wish to use this service, find your browser on our [Privoxy Usage] instruction page.<br />
<br />
'''DansGuardian'''<br />
<br />
DansGuardian is a web proxy capable of filtering out web content (sex, drugs, profanity, violence, etc.) some might consider offensive. DansGuardian also offers all of the features offered by "Privoxy" and the "Normal Caching Proxy". If you wish to use this service, visit our [[DansGuardian Usage]] page.<br />
<br />
'''Normal Caching Proxy'''<br />
<br />
Our normal proxy transparently caches web documents locally to cut down on load time. Downloading a web page from an XMission server is faster than downloading one from across the Internet. If you wish to use this service, find your browser on our [Caching Proxy Usage] instruction page.</div>Ewatershttps://wiki.xmission.com/index.php?title=Proxy&diff=29Proxy2007-07-13T14:41:12Z<p>Ewaters: </p>
<hr />
<div>'''Proxy Servers'''<br />
<br />
An HTTP, or web, proxy server provides a gateway between your browser and the rest of the Internet. A proxy server replaces your identity (IP address, in this case) with its own, making it possible to browse more privately, securely, and can offer additional features depending upon the proxy. XMission now provides three different web proxies. Information about each is listed below.<br />
<br />
'''Dial-up Web Accelerator'''<br />
<br />
Our dial-up accelerator transparently compresses and caches web documents (i.e., text and html) locally to cut down on load time. Downloading compressed and cached web pages through XMission can speed up web browsing for dial-up users. To use this service, find your browser on our [Dial-up Web Accelerator Usage] instruction page.<br />
<br />
'''Privoxy'''<br />
<br />
Privoxy is geared towards filtering pop-up advertisements and regular web advertisements. XMission had previously offered a proxy called "Junkbuster" for the same purpose. Privoxy is based off Junkbuster but provides better filtering. Privoxy also provides all of the features offered by the "Normal Caching Proxy". If you wish to use this service, find your browser on our [Privoxy Usage] instruction page.<br />
<br />
'''DansGuardian'''<br />
<br />
DansGuardian is a web proxy capable of filtering out web content (sex, drugs, profanity, violence, etc.) some might consider offensive. DansGuardian also offers all of the features offered by "Privoxy" and the "Normal Caching Proxy". If you wish to use this service, visit our [DansGuardian Usage] page.<br />
<br />
'''Normal Caching Proxy'''<br />
<br />
Our normal proxy transparently caches web documents locally to cut down on load time. Downloading a web page from an XMission server is faster than downloading one from across the Internet. If you wish to use this service, find your browser on our [Caching Proxy Usage] instruction page.</div>Ewatershttps://wiki.xmission.com/index.php?title=Proxy&diff=28Proxy2007-07-13T14:38:50Z<p>Ewaters: </p>
<hr />
<div>'''Proxy Servers'''<br />
<br />
An HTTP, or web, proxy server provides a gateway between your browser and the rest of the Internet. A proxy server replaces your identity (IP address, in this case) with its own, making it possible to browse more privately, securely, and can offer additional features depending upon the proxy. XMission now provides three different web proxies. Information about each is listed below.<br />
<br />
'''Dial-up Web Accelerator'''<br />
<br />
Our dial-up accelerator transparently compresses and caches web documents (i.e., text and html) locally to cut down on load time. Downloading compressed and cached web pages through XMission can speed up web browsing for dial-up users. To use this service, find your browser on our [dial-up accelerator instruction page|http://www.xmission.com/help/security/proxies/accelerator.html].<br />
<br />
'''Privoxy'''<br />
<br />
Privoxy is geared towards filtering pop-up advertisements and regular web advertisements. XMission had previously offered a proxy called "Junkbuster" for the same purpose. Privoxy is based off Junkbuster but provides better filtering. Privoxy also provides all of the features offered by the "Normal Caching Proxy". If you wish to use this service, find your browser on our Privoxy instruction page.<br />
<br />
'''DansGuardian'''<br />
<br />
DansGuardian is a web proxy capable of filtering out web content (sex, drugs, profanity, violence, etc.) some might consider offensive. DansGuardian also offeres all of the features offered by "Privoxy" and the "Normal Caching Proxy".<br />
<br />
'''Normal Caching Proxy'''<br />
<br />
Our normal proxy transparently caches web documents locally to cut down on load time. Downloading a web page from an XMission server is faster than downloading one from across the Internet. If you wish to use this service, find your browser on our caching proxy instruction page.<br />
<br />
'''DansGuardian NOTE''': Please understand that all web filtering software is less than 100% successful. XMission encourages parents to actively participate in their children's Internet Experience. It is the only way to be sure they view what your family considers acceptable. If you wish to use DansGuardian you must review and accept the disclaimer before you can turn on this service.</div>Ewatershttps://wiki.xmission.com/index.php?title=Proxy&diff=27Proxy2007-07-13T14:38:05Z<p>Ewaters: New page: '''Proxy Servers''' An HTTP, or web, proxy server provides a gateway between your browser and the rest of the Internet. A proxy server replaces your identity (IP address, in this case) wi...</p>
<hr />
<div>'''Proxy Servers'''<br />
<br />
An HTTP, or web, proxy server provides a gateway between your browser and the rest of the Internet. A proxy server replaces your identity (IP address, in this case) with its own, making it possible to browse more privately, securely, and can offer additional features depending upon the proxy. XMission now provides three different web proxies. Information about each is listed below.<br />
<br />
'''Dial-up Web Accelerator'''<br />
<br />
Our dial-up accelerator transparently compresses and caches web documents (i.e., text and html) locally to cut down on load time. Downloading compressed and cached web pages through XMission can speed up web browsing for dial-up users. To use this service, find your browser on our dial-up accelerator instruction page.<br />
<br />
'''Privoxy'''<br />
<br />
Privoxy is geared towards filtering pop-up advertisements and regular web advertisements. XMission had previously offered a proxy called "Junkbuster" for the same purpose. Privoxy is based off Junkbuster but provides better filtering. Privoxy also provides all of the features offered by the "Normal Caching Proxy". If you wish to use this service, find your browser on our Privoxy instruction page.<br />
<br />
'''DansGuardian'''<br />
<br />
DansGuardian is a web proxy capable of filtering out web content (sex, drugs, profanity, violence, etc.) some might consider offensive. DansGuardian also offeres all of the features offered by "Privoxy" and the "Normal Caching Proxy".<br />
<br />
'''Normal Caching Proxy'''<br />
<br />
Our normal proxy transparently caches web documents locally to cut down on load time. Downloading a web page from an XMission server is faster than downloading one from across the Internet. If you wish to use this service, find your browser on our caching proxy instruction page.<br />
<br />
'''DansGuardian NOTE''': Please understand that all web filtering software is less than 100% successful. XMission encourages parents to actively participate in their children's Internet Experience. It is the only way to be sure they view what your family considers acceptable. If you wish to use DansGuardian you must review and accept the disclaimer before you can turn on this service.</div>Ewaters