Difference between revisions of "3rd party software/SQL"

From Freeside
Jump to: navigation, search
(Postgresql)
 
(20 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
{{3rd_party_software}}
 
{{3rd_party_software}}
  
= Postgresql =
+
= PostgreSQL =
  
;Website
+
{{Website_box
:http://www.postgres.org
+
|website=http://www.postgresql.org/
 
+
|about=http://www.postgresql.org/about/
{{website_box}}
+
|faq=http://www.postgresql.org/docs/faqs.FAQ.html
 +
|wikipedia=Postgresql
 +
}}
 +
;Manuals
 +
:http://www.postgresql.org/docs/
  
 
= MySQL =
 
= MySQL =
  
;Website
+
{{Website_box
:http://www.mysql.com
+
|website=http://www.mysql.com
 +
|about=http://www.mysql.org/company/
 +
|faq=http://www.mysql.com/industry/faq/
 +
|wikipedia=MySQL
 +
}}
 +
;Manuals
 +
:http://dev.mysql.com/doc/#refman
 +
;FAQ - Why do I get "Too many connections" when connecting to MySQL, and how can I solve it?
 +
:Your max_connections setting is too low, See http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html
 +
;FAQ - How do I tell what port mysql uses?
 +
:You can check the server directly, or make a good guess from a client.  The default port is most always <code>3306</code>.  Use these steps to confirm, or to isolate for troubleshooting.
 +
:On the server
 +
:* <code># netstat -tlnp | grep mysqld</code>
 +
:* <code>$ grep mysql /etc/services</code>
 +
:* Review the <code>[mysqld]</code> section of <code>/etc/mysql/my.cnf</code> for <code>port = </code> settings. (file location varies)
 +
:As a mysql client
 +
:* Review the <code>[client]</code> section of <code>/etc/mysql/my.cnf</code> for <code>port = </code> settings. (file location varies)
 +
:* As a last resort, <code>strace -e connect mysql -h example.com</code> Output will be less noisy if you use <code>example.com</code> as a literal.  Eg, <code>connect(3, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("208.77.188.166")}, 16 <unfinished ...></code>

Latest revision as of 21:33, 6 April 2009


PostgreSQL

Website
http://www.postgresql.org/
About
http://www.postgresql.org/about/
FAQ
http://www.postgresql.org/docs/faqs.FAQ.html
Wikipedia
http://en.wikipedia.org/wiki/Postgresql
Manuals
http://www.postgresql.org/docs/

MySQL

Website
http://www.mysql.com
About
http://www.mysql.org/company/
FAQ
http://www.mysql.com/industry/faq/
Wikipedia
http://en.wikipedia.org/wiki/MySQL
Manuals
http://dev.mysql.com/doc/#refman
FAQ - Why do I get "Too many connections" when connecting to MySQL, and how can I solve it?
Your max_connections setting is too low, See http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html
FAQ - How do I tell what port mysql uses?
You can check the server directly, or make a good guess from a client. The default port is most always 3306. Use these steps to confirm, or to isolate for troubleshooting.
On the server
  • # netstat -tlnp | grep mysqld
  • $ grep mysql /etc/services
  • Review the [mysqld] section of /etc/mysql/my.cnf for port = settings. (file location varies)
As a mysql client
  • Review the [client] section of /etc/mysql/my.cnf for port = settings. (file location varies)
  • As a last resort, strace -e connect mysql -h example.com Output will be less noisy if you use example.com as a literal. Eg, connect(3, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("208.77.188.166")}, 16 <unfinished ...>