Difference between revisions of "Software section"

From Freephile Wiki
Jump to navigation Jump to search
Line 38: Line 38:
  
 
=Database=
 
=Database=
==MySQL==
+
{{MySQL}}
=== Installation ===
 
To get started, [https://access.redhat.com/site/documentation/en-US/Red_Hat_Enterprise_Linux/6/html/Managing_Confined_Services/chap-Managing_Confined_Services-MySQL.html installing MySQL on RHEL] is as simple as <source lang="bash">yum install mysql-server</source>.  However, you might get a message that your system is not registered to Red Hat Subscription Management (RHN in the old days), and thus the packages are not visible.  To remedy this, you would of course use <code>subscription-manager</code> to register the host with Red Hat Subscription Management.
 
  
<source lang="bash">
 
/usr/bin/mysqladmin -u root password 'new-password'
 
/usr/bin/mysqladmin -u root -h `hostname` password 'new-password'
 
# but it's easier and better to run
 
/usr/bin/mysql_secure_installation
 
# which will give you the option of removing the test database and removing the anonymous user created by default.  This is a must for production servers.
 
</source>
 
 
You can start the MySQL daemon with:
 
<source lang="bash">cd /usr ; /usr/bin/mysqld_safe &</source>
 
 
You can test the MySQL daemon with mysql-test-run.pl
 
<source lang="bash">cd /usr/mysql-test ; perl mysql-test-run.pl</source>
 
 
It's a good idea to setup a local configuration file for the system 'root' user, who can connect to the database server as db user 'root' by default when using the mysql command line client (ie. when you are user 'root' and type 'mysql' at the command line in a bash shell)
 
<source lang="bash">cat /root/.my.cnf</source>
 
<source lang="ini">
 
[client]
 
user=root
 
password=giveMeSomeDBgoodne55
 
</source>
 
 
[[Category:Database]]
 
  
 
==PostGres==
 
==PostGres==
Line 75: Line 50:
 
==Smarty==
 
==Smarty==
  
 +
[[Category:Database]]
 
[[Category:Applications]]
 
[[Category:Applications]]

Revision as of 11:38, 24 March 2014

Every single item on this page will eventually be an article, series of articles, or even a complete section. Please jump in and start off a topic

This sort of list may be deprecated now that I know how to create dynamic page lists, and also use category displays on a page. Still, this serves as a "pages wanted" list, and so it will be around until it is replaced by something better.

Software Foundations[edit | edit source]

Linux[edit | edit source]

Apache[edit | edit source]

See Apache

MySQL[edit | edit source]

PHP[edit | edit source]

Getting PHP5 installed can be daunting. It still is not packaged for Debian stable. If you want a deb, add Dotdeb.org to your sources list. http://www.dotdeb.org/

Perl[edit | edit source]

Python[edit | edit source]

System Administration[edit | edit source]

Samba[edit | edit source]

Webmin[edit | edit source]

Graphics[edit | edit source]

GIMP[edit | edit source]

SodiPodi[edit | edit source]

Dia[edit | edit source]

Gallery[edit | edit source]

Content Management[edit | edit source]

MediaWiki[edit | edit source]

Tiki[edit | edit source]

Email[edit | edit source]

SquirrelMail[edit | edit source]

Web Browsing[edit | edit source]

Mozilla[edit | edit source]

FireFox[edit | edit source]

Database[edit | edit source]

Template:MySQL


PostGres[edit | edit source]

phpMyAdmin[edit | edit source]

Search[edit | edit source]

Mnogosearch[edit | edit source]

Templating[edit | edit source]

Smarty[edit | edit source]