comic dialog: Title caption: Ahh... the new year.
Panel 1
Caption: A time for new projects,
Chump: *sigh*
Panel 2
Caption: new budgets,
Chump: WhooHooo! I'm in the money'z
Panel 3
Caption: new victories,
Chump: YAY!
Panel 4
Caption: and new defeats.
Chump: Nooooooo!
Title caption: so, basicall, the same as last year.
Sorry today's comic went up a little late. Last night I was working on getting a development environment working on my laptop, so I could start work on some new features that I want to add to the site. For those of you out there trying to set up your own site using apache, php, and mysql, see the bottom of this post for some tid bits of knowledge, that I either didn't know or had forgotten about.
So here's my take on new year's, it's a fun celebration, but really it means nothing. Every year is the same as the last if we don't deliberately go out of our way to change something and make a difference. That's somewhat why I built my dev server. I want to add some more ways for me to remain creative. The other day, I was looking through some old notebooks, and I saw the comics I started, the stories I wrote or started, and the sketches I did. I miss that creativity. Some of the sketches are pretty good, and I have a lot of stories that need to be finished, to be told. So far, this site has helped me remain creative, and hopefully it's provided some entertainment for the rest of you out there, and with a little luck, it will remain a creative outlet for me.
On a different note, Happy birthday dad.
Server tid bits
Apache 2.2 does not work with php 4.4.9. It works with version 5 and greater. Apache 2.0.63, however works fine with it.
For apache 2.0.63 and php 4.4.9, here are the lines you'll have to add to your httpd.conf (located in [apache home]\conf\), you should be able to see where all the LoadModule lines are in the config file, add it with them.
copy php4apache2.dll from the sapi directory in your php directory into your php root directory.
AddType application/x-httpd-php .php
PHPIniDir "C:/php-4.4.9"
Where "C:/php-4.4.9" is your php directory
copy the php.ini-recommended file from your php directory to your php directory, and rename it php.ini
If you're running the wrong version of apache with php, it'll throw this error: httpd: Syntax error on line 130 of C:/Program Files/Apache Software Foundation/Apache2.2/conf/httpd.conf: Cannot load C:/php-4.4.9/php4apache2.dll into server: The specified module could not be found.
If you decide that you want a root directory other than, [apache home]\htdocs, then change the following lines in your httpd.conf
Change 'DocumentRoot "C:/Program Files/Apache Group/Apache2/htdocs"' to be the location you want to be your document root.
Change '' to match the line above
If you want to use mod_rewrite in .htaccess files, you have to enable that module in the httpd.conf
Change '#LoadModule rewrite_module modules/mod_rewrite.so' to 'LoadModule rewrite_module modules/mod_rewrite.so'
If you want .htaccess files in subdirectories to overwrite the default .htaccess, then you also have to change 'AllowOverride None' to 'AllowOverride All' on the directories that you want this to occur in.
if you're using modrewrite and it's not enabled, it'll throw this error: Invalid command 'RewriteEngine'
If you want to use index.htm or index.php as an index file, edit your httpd.conf and change DirectoryIndex index.html index.html.var to DirectoryIndex index.php index.html index.html.var index.htm
You might have to edit your php.ini and change the line extension_dir = "./" to extension_dir = "./extensions/". For most setups, the rest is probably fine.
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION; where username is the username you want, and password is the password you want for that user. This sets up a user with all access to your mysql server
INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv) VALUES ('localhost', 'dbname', 'username',
'Y', 'Y', 'Y', 'Y', 'Y', 'Y'); where dbname is the name of the database you want to grant this user rights to, and username is the name of the user you want to grants rights to. This adds the user to that db with most privaliges.
FLUSH PRIVILEGES; this resets the users in cache.
If you do all this and you're still not able to connect, then check the error.log in your [apache home]\logs directory. if this error, client does not support authentication protocol requested by server, then that means that the password authentication that mysql is using by default isn't supported by your version of php, so run this SET PASSWORD FOR 'username'@'localhost' = OLD_PASSWORD('password'); and FLUSH PRIVILEGES; where username is the username you want, and password is the password you want to use. That should fix the connection issues.
New feature Gary
Check out our new links page in the top menu.
