Gary
Author Comments aka Comic News
Happy new year
Happy new year everyone!
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.
- LoadModule php4_module "C:/php-4.4.9/php4apache2.dll"
- Where "C:/php-4.4.9/" is your php directory
- 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.
- The mysql I'm using is 5.1.30
- After installing, you'll have to setup users
- login to mysql command prompt
- use mysql
- 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
Check out our new links page in the top menu.
|