http://freebsdwiki.net/api.php?action=feedcontributions&user=ColdFire&feedformat=atomFreeBSDwiki - User contributions [en]2024-03-29T11:20:53ZUser contributionsMediaWiki 1.18.0http://freebsdwiki.net/index.php/User_talk:ColdFireUser talk:ColdFire2006-05-28T21:23:47Z<p>ColdFire: </p>
<hr />
<div>Hey man, if there's a problem with one of the other MySQL articles, how about fixing it - or at least commenting on it at the discussion page for that article - rather than snarking about it in a new article? That isn't very helpful for anybody. --[[User:Jimbo|Jimbo]] 16:17, 28 May 2006 (EDT)<br />
<br />
Yeah ok, just didn't want to fiddle with someone else's work :/ --[[User:ColdFire|ColdFire]] 10:17, 28 May 2006 GMT<br />
<br />
Additional: Please note Jimbo, I used the ports collecton this time.. *I did think of you guys!*</div>ColdFirehttp://freebsdwiki.net/index.php/MySQLMySQL2006-05-28T21:21:50Z<p>ColdFire: </p>
<hr />
<div>This article is the main portal for all things MySQL at The BSD Wiki. <br />
<br />
See also: [[MySQL_Simple_Installation]]<br />
<br />
See also: [[MySQL:_set_root_password]]<br />
<br />
See also: [[MySQL:_tips]]<br />
<br />
See also: [[Mysql_5.0%2C_installing|MySQL 5 INSTALL]]<br />
<br />
[[Category : Ports and Packages]]</div>ColdFirehttp://freebsdwiki.net/index.php/User_talk:ColdFireUser talk:ColdFire2006-05-28T21:18:09Z<p>ColdFire: </p>
<hr />
<div>Hey man, if there's a problem with one of the other MySQL articles, how about fixing it - or at least commenting on it at the discussion page for that article - rather than snarking about it in a new article? That isn't very helpful for anybody. --[[User:Jimbo|Jimbo]] 16:17, 28 May 2006 (EDT)<br />
<br />
Yeah ok, just didn't want to fiddle with someone else's work :/ --[[User:ColdFire|ColdFire]] 10:17, 28 May 2006 GMT</div>ColdFirehttp://freebsdwiki.net/index.php/User_talk:ColdFireUser talk:ColdFire2006-05-28T21:17:20Z<p>ColdFire: </p>
<hr />
<div>Hey man, if there's a problem with one of the other MySQL articles, how about fixing it - or at least commenting on it at the discussion page for that article - rather than snarking about it in a new article? That isn't very helpful for anybody. --[[User:Jimbo|Jimbo]] 16:17, 28 May 2006 (EDT)<br />
<br />
Yeah ok, just didn't want to fiddle with someone else's work :/</div>ColdFirehttp://freebsdwiki.net/index.php/Mysql_5.0,_installingMysql 5.0, installing2006-05-28T18:57:08Z<p>ColdFire: </p>
<hr />
<div><p align="center">[[Image:Mysql.jpg]]</p><br />
<br />
This MySQL guide <b>DOES</b> work, unlike the other MySQL guides on this wiki!<br />
<br />
== Installation from ports ==<br />
<br />
# su<br />
# cd /usr/ports/databases/mysql50-server<br />
# make install clean<br />
# mysql_install_db<br />
# chown -R mysql /var/db/mysql/<br />
# chgrp -R mysql /var/db/mysql/<br />
<br />
== Start MySQL ==<br />
<br />
... From command:<br />
<br />
# /usr/local/bin/mysqld_safe -user=mysql &<br />
<br />
.. Or a handy pre-made script:<br />
<br />
# /usr/local/etc/rc.d/mysql-server.sh<br />
<br />
== Starting MySQL on system boot ==<br />
<br />
# echo 'mysql_enable="YES"' >> /etc/rc.conf<br />
<br />
== Creating the root password ==<br />
<br />
To set the root password, replace "yourpass" with your desired password:<br />
<br />
# mysqladmin -u root password <i>yourpass</i><br />
<br />
Note: If this command returns "command not found", type "rehash" in the CLI:<br />
<br />
# rehash<br />
<br />
== Final Notes ==<br />
<br />
Job done! You now have MySQL installed and running. Give yourself a pat on the back!<br />
<br />
<br />
[[Category:FreeBSD for Servers]]<br />
[[Category:Ports and Packages]]</div>ColdFirehttp://freebsdwiki.net/index.php/File:Mysql.jpgFile:Mysql.jpg2006-05-28T18:24:19Z<p>ColdFire: The MySQL Logo</p>
<hr />
<div>The MySQL Logo</div>ColdFirehttp://freebsdwiki.net/index.php/Talk:Apache,_Installing_with_PHPTalk:Apache, Installing with PHP2006-03-29T20:45:38Z<p>ColdFire: </p>
<hr />
<div>==Understood, but...==<br />
Read this page, and your arguements are valid, but there isn't a banner saying "ports only". I've been running FreeBSD (and Linux Gentoo) for about 4 years, going through versions 4, 5 and now 6. There are some things that I'd automatically use for ports: wget, lynx, perl, blah blah.. but for some programs I prefer to install myself, so I know what is being installed, where its going and how it will work.. ie --with-xx..<br />
<br />
So now you'r saying it's a good idea to write in source to offer an alternative?? "...Maybe you could write us an article specifically about building applications from tarballs..." Talk about contradict yourself!<br />
<br />
Regarding the below comment: See above. Oh and I use the crons just to simplify and group up tasks that get run, So I can see a large list of all things that get run at specified times: hourly, monthly, and at boot.<br />
<br />
You can't rub tarballs away, they will always exist cos there will always be source junkies around.<br />
<br />
So... Want me to remove my invalid page? Or will it be reinstated to a "from source" guide?<br />
<br />
==Are you a Linux guy, ColdFire?== Just kinda curious as to why you'd compile Apache and PHP raw-dog rather than use the ports tree (and run a cron job to start it at boot time rather than use a /usr/local/etc/rc.d script). --[[User:Jimbo|Jimbo]] 01:49, 27 March 2006 (EST)<br />
<br />
== not to mention ==<br />
<br />
using [[wget]] instead of [[fetch]]<br />
--[[User:Dave|Dave]] 13:00, 28 March 2006 (EST)<br />
<br />
==Is There No Thing Called Free Speach?==<br />
So is "from source" not welcome here? What is the point of me writing articles, only for you to just change the whole lot?<br />
<br />
[[Installing_Apache_with_PHP]] was a "from source" guide, for one simple fact: You know where everything goes, and you can then easily query errors. And not like all, some people '''do''' prefer source installs -- which I'd thought I'd give the user a choice!<br />
<br />
But it seems this a pkg_add based wiki. Great. What gives?<br />
<br />
==Actually==<br />
Actually around here we generally prefer the [[ports tree]], which Dave also gave the nod to. Which is also building from source, but has the (rather distinct) advantage of also creating entries in the ports database, as well as making sure that any FreeBSD-centric patches and file location changes get made, you can use portupgrade to update the port later, etc etc etc.<br />
<br />
However I was still interested to see your "from tarballs" approach. It's not something I'd normally recommend on a FreeBSD machine when there is a port for that application, for the reasons mentioned above, but it's nice to see it done a bit. After all every now and then it is possible to run across something you want that there isn't already a port for!<br />
<br />
Maybe you could write us an article specifically about building applications from tarballs rather than using the ports tree, and common gotchas and how to fix them?<br />
<br />
PS: the talk page for your article is really a better place for this kinda thing, I had already asked you a leading question about some of this stuff there. =) --[[User:Jimbo|Jimbo]] 10:02, 29 March 2006 (EST)<br />
<br />
== from source ==<br />
<br />
I've moved the last two comments from my talk page to this one for easier readability. Installing from ports is exactly the same as installing from source with the added bonus that Jimbo brought up: the install of the program gets added to the ports db, so the BSD package manager knows that the package is installed. Additionally, it's a lot less work and much easier to update (see [[Ports Tree, Updating]]) with [[portupgrade]] -- so if there's a patch or fix or upgrade to apache 1.3 or php4, you can update it pretty easily. Installing from ports is the preferred method, but I've added the pkg_add method for those who don't have the time, patience or hardware firepower to compile everything.<br />
<br />
--[[User:Dave|Dave]] 11:25, 29 March 2006 (EST)</div>ColdFirehttp://freebsdwiki.net/index.php/User_talk:DaveUser talk:Dave2006-03-29T09:52:14Z<p>ColdFire: </p>
<hr />
<div>==Is There No Thing Called Free Speach?==<br />
So is "from source" not welcome here? What is the point of me writing articles, only for you to just change the whole lot?<br />
<br />
[[Installing_Apache_with_PHP]] was a "from source" guide, for one simple fact: You know where everything goes, and you can then easily query errors. And not like all, some people '''do''' prefer source installs -- which I'd thought I'd give the user a choice!<br />
<br />
But it seems this a pkg_add based wiki. Great. What gives?<br />
<br />
<br />
==RE:welcome==<br />
What do you think of the idea of putting the whole handbook in here and improving it through the wiki process? We may be able to get the doc project on board with that, especially since there are some tools (crude as of yet I think) that can convert mediawiki markup to docbook. Do you have the space and bandwidth for that? If it really takes off it could be merged back into the official FreeBSD webspace. - [[User:Taxman|Taxman]] 15:28, 17 Sep 2004 (GMT)<br />
<br />
<br />
==problem with that==<br />
There are two problems with that; a) this question is better asked of Jimbo (since this is his baby, not mine,) although I am pretty sure his answer's going to be along the lines of "no, I'd rather write something easier to deal with than to copy verbatim" and b) the handbook makes my eyes gloss over, and part of the reason I think a wiki is better than the handbook is because it brings fresher ways of presenting the information -- especially nice is the compactness of it (specifics when you want 'em). I mean, the handbook is already available in chunks of HTML-ized chapters....don't need to repeat work that's been done already. Although I'm sure Jimbo would be happy to see his work linked from/become part of official FreeBSD documentation (I know I'd be happy if someone saw an article I wrote and went "oh shit! that's how you do it! thanks!")<br />
<br />
--[[User:Dave|Dave]]<br />
<br />
==Dave said it right==<br />
I'm not in favor of getting this project buried underneath the ''Handbook'', for all the reasons Dave listed. I get pretty frustrated every time I try digging information out of the ''Handbook''; so while I don't mind incorporating some of the stuff from it piecemeal, I am very very very much not in favor of dumping it here ''en masse''. --[[User:Jimbo|Jimbo]] 00:40, 18 Sep 2004 (GMT)</div>ColdFirehttp://freebsdwiki.net/index.php/Apache,_Installing_with_PHPApache, Installing with PHP2006-03-26T19:31:49Z<p>ColdFire: /* Getting Started */</p>
<hr />
<div><p align="center">[[Image:Apachefeather.jpg|140px]] [[Image:Php.jpg]]</p><br />
<br />
= Getting Started =<br />
<br />
I have decided to use Apache/1.x with PHP/4.x. I belive this is the better combination, as time tells, they are the most popular and better stability. Anyhow, this is my opinion, so this guide will use those two versions...<br />
<br />
First off, cd into a good location for sources, ie: /root/installs/<br />
<br />
mkdir /root/installs/<br />
cd /root/installs/<br />
<br />
Next, we best go get the sources:<br />
<br />
(As of writing this guide, the current versions are: Apache/1.3.34 and PHP/4.4.2. You might have to amend the following arguments inorder to download the current version!)<br />
<br />
wget <nowiki>http://www.mirror.ac.uk/mirror/ftp.apache.org/httpd/apache_1.3.34.tar.gz</nowiki><br />
wget <nowiki>http://uk.php.net/get/php-4.4.2.tar.gz/from/uk.php.net/mirror</nowiki><br />
<br />
= Compiling and Installing Apache =<br />
<br />
tar zxvf apache_1.3.34.tar.gz<br />
cd apache_1.3.34/<br />
./configure --prefix=/usr/local/apache --enable-module=so<br />
make<br />
make install<br />
<br />
= Compiling and Installing PHP =<br />
<br />
tar zxvf php-4.4.2.tar.gz<br />
cd php-4.4.2/<br />
./configure --with-apxs=/usr/local/apache/bin/apxs<br />
make<br />
make install<br />
<br />
= Setting up php.ini =<br />
<br />
cp php.ini-dist /usr/local/lib/php.ini<br />
<br />
Note:<br />
<br />
You may wish to edit the above file to set PHP options. If you'd rather use php.ini-recommended, make sure to read the list of changes, and how they affect the behaviour of PHP.<br />
<br />
= httpd.conf =<br />
<br />
Now, you will have to edit the httpd.conf file to load the PHP module:<br />
<br />
pico /usr/local/apache/conf/httpd.conf<br />
<br />
1) Add the following line to the above file:<br />
<br />
LoadModule php4_module libexec/libphp4.so<br />
<br />
- Or if you are lazy and can't be bothered to check httpd.conf:<br />
<br />
echo "LoadModule php4_module libexec/libphp4.so" >> /usr/local/apache/conf/httpd.conf<br />
<br />
Note:<br />
<br />
Running "make install" might of added the line for you, best be on the safe side and check!<br />
<br />
<br />
2) In the AddModule section of httpd.conf, add the following line to the bottom of the section:<br />
<br />
AddModule mod_php4.c<br />
<br />
<br />
3) Apache will need to be told on what to class as a PHP document. Add this line to the httpd.conf file in the AddType section:<br />
<br />
AddType application/x-httpd-php .php<br />
<br />
...You might consider using the following line to show highlighted PHP source, it can be achieved by adding the line also to the AddModule section under the line you have just added:<br />
<br />
AddType application/x-httpd-php-source .phps<br />
<br />
= Starting Apache =<br />
<br />
Use the following command to start Apache:<br />
<br />
/usr/local/apache/bin/apachectl start<br />
<br />
= All works? =<br />
<br />
To test everything went according to plan, we will now make a PHP file:<br />
<br />
echo "<? phpinfo(); ?>" >> /usr/local/apache/htdocs/php-test.php<br />
<br />
Run your favourite browser (FireFox) and point it to http://localhost/php-test.php. You will now see lots of compilation and configuration options for PHP.<br />
<br />
<br />
Your Done!<br />
<br />
= Final Notes =<br />
<br />
You should now have a working version of Apache with PHP. The next and only thing I will suggest is to make a crontab to start Apache at boot:<br />
<br />
crontab -e<br />
<br />
and add to the bottom:<br />
<br />
<code>@reboot /usr/local/apache/bin/apachectl start</code></div>ColdFirehttp://freebsdwiki.net/index.php/ApacheApache2006-03-26T19:27:37Z<p>ColdFire: </p>
<hr />
<div>[[Apache]] is an (some would say ''the'') open source webserver; used more than any other webserver in the world. It is available for easy installation from FreeBSD's [[:Category:Ports and Packages|ports tree]] in several different flavors, including pre-configured versions with and without [[OpenSSL]], [[mod_php]], [[frontpage extensions]], and lots more.<br />
<br />
Apache fits most purposes well, however when configured with PHP and/or mod_perl its memory requirements scale upwards dramatically, so for particularly high-volume applications a separate server for static content becomes very desirable. Apache itself is reasonably light when the aforementioned modules are not loaded, however [[thttpd]] is even lighter. A reverse proxy setup also solves the problem well.<br />
<br />
See also:<br />
[[Apache2_Installation]] - [[Apache Controlling]] - [[Installing_Apache_with_PHP]]<br />
<br />
[[Category:Ports and Packages]]</div>ColdFirehttp://freebsdwiki.net/index.php/Apache,_Installing_with_PHPApache, Installing with PHP2006-03-26T17:04:26Z<p>ColdFire: Apache+PHP</p>
<hr />
<div><p align="center">[[Image:Apachefeather.jpg|140px]] [[Image:Php.jpg]]</p><br />
<br />
= Getting Started =<br />
<br />
I have decided to use Apache/1.x with PHP/4.x. I belive this is the better combianation, as time tells, they are the most popular and better stability. Anyhow, this is my opinion, so this guide will use those two versions...<br />
<br />
First off, cd into a good location for sources, ie: /root/installs/<br />
<br />
mkdir /root/installs/<br />
cd /root/installs/<br />
<br />
Next, we best go get the sources:<br />
<br />
(As of writing this guide, the current versions are: Apache/1.3.34 and PHP/4.4.2. You might have to amend the following arguments inorder to download the current version!)<br />
<br />
wget <nowiki>http://www.mirror.ac.uk/mirror/ftp.apache.org/httpd/apache_1.3.34.tar.gz</nowiki><br />
wget <nowiki>http://uk.php.net/get/php-4.4.2.tar.gz/from/uk.php.net/mirror</nowiki><br />
<br />
= Compiling and Installing Apache =<br />
<br />
tar zxvf apache_1.3.34.tar.gz<br />
cd apache_1.3.34/<br />
./configure --prefix=/usr/local/apache --enable-module=so<br />
make<br />
make install<br />
<br />
= Compiling and Installing PHP =<br />
<br />
tar zxvf php-4.4.2.tar.gz<br />
cd php-4.4.2/<br />
./configure --with-apxs=/usr/local/apache/bin/apxs<br />
make<br />
make install<br />
<br />
= Setting up php.ini =<br />
<br />
cp php.ini-dist /usr/local/lib/php.ini<br />
<br />
Note:<br />
<br />
You may wish to edit the above file to set PHP options. If you'd rather use php.ini-recommended, make sure to read the list of changes, and how they affect the behaviour of PHP.<br />
<br />
= httpd.conf =<br />
<br />
Now, you will have to edit the httpd.conf file to load the PHP module:<br />
<br />
pico /usr/local/apache/conf/httpd.conf<br />
<br />
1) Add the following line to the above file:<br />
<br />
LoadModule php4_module libexec/libphp4.so<br />
<br />
- Or if you are lazy and can't be bothered to check httpd.conf:<br />
<br />
echo "LoadModule php4_module libexec/libphp4.so" >> /usr/local/apache/conf/httpd.conf<br />
<br />
Note:<br />
<br />
Running "make install" might of added the line for you, best be on the safe side and check!<br />
<br />
<br />
2) In the AddModule section of httpd.conf, add the following line to the bottom of the section:<br />
<br />
AddModule mod_php4.c<br />
<br />
<br />
3) Apache will need to be told on what to class as a PHP document. Add this line to the httpd.conf file in the AddType section:<br />
<br />
AddType application/x-httpd-php .php<br />
<br />
...You might consider using the following line to show highlighted PHP source, it can be achieved by adding the line also to the AddModule section under the line you have just added:<br />
<br />
AddType application/x-httpd-php-source .phps<br />
<br />
= Starting Apache =<br />
<br />
Use the following command to start Apache:<br />
<br />
/usr/local/apache/bin/apachectl start<br />
<br />
= All works? =<br />
<br />
To test everything went according to plan, we will now make a PHP file:<br />
<br />
echo "<? phpinfo(); ?>" >> /usr/local/apache/htdocs/php-test.php<br />
<br />
Run your favourite browser (FireFox) and point it to http://localhost/php-test.php. You will now see lots of compilation and configuration options for PHP.<br />
<br />
<br />
Your Done!<br />
<br />
= Final Notes =<br />
<br />
You should now have a working version of Apache with PHP. The next and only thing I will suggest is to make a crontab to start Apache at boot:<br />
<br />
crontab -e<br />
<br />
and add to the bottom:<br />
<br />
<code>@reboot /usr/local/apache/bin/apachectl start</code></div>ColdFirehttp://freebsdwiki.net/index.php/File:Php.jpgFile:Php.jpg2006-03-26T16:56:48Z<p>ColdFire: </p>
<hr />
<div></div>ColdFirehttp://freebsdwiki.net/index.php/File:Apachefeather.jpgFile:Apachefeather.jpg2006-03-26T16:52:45Z<p>ColdFire: </p>
<hr />
<div></div>ColdFirehttp://freebsdwiki.net/index.php/User:ColdFireUser:ColdFire2006-03-26T10:35:58Z<p>ColdFire: </p>
<hr />
<div>See: [http://www.tattybox.net www.tattybox.net]</div>ColdFirehttp://freebsdwiki.net/index.php/User:ColdFireUser:ColdFire2006-03-26T10:35:31Z<p>ColdFire: </p>
<hr />
<div>[http://www.tattybox.net See: www.tattybox.net]</div>ColdFire