3rd party software/SQL

From Freeside
Jump to: navigation, search


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 ...>