PhpBB, WebCal, and Bower Studios Genealogy program on Apache with MySQL
daniel Sun, 08/27/2006 - 9:17pm
Phpbb
First, We'll install a forum to the site. I chose a well known PHP driven forum called phpbb. This forum is very easy to install.
- Downloaded phpBB2.
- Unzip file in the location you would like to have the forum. ex. /var/www/htdocs/unsecure/phpbb/
- Create the database in mysql for the forum. I used phpMyAdmin for this.
- Configure the forum, by its directions. Be sure to use the user account in mysql and not the root account in mysql.
- I configured 2 forums, one in secure and one in public. For the secure site, we need to set port to 443 and cookie to ssl in the forum setup.
- I customized the forums by editing the downloadable template.
All in all, this is a very good piece of forum software. I highly recommend it.
Calendar
I ended up choosing this Web Calendar that is available on SourceForge. It is pretty simple and looks to be nicely featured.
Unzip WebCalendar-0.9.44.tar.gz in the location you would like to have the forum. ex. /var/www/htdocs/unsecure/calendar/
You will have to enable php magic quotes for cookies in php.ini. Just open your /var/www/conf/php.ini file and set Magic quotes for cookies to On.
I customized WebCalendar by editing styles.php and working in the program to add styling such as headers and footers.
BowerStudios Genealogy
This is my own homegrown genealogy program. It requires php and mysql. It is very, very simple. There are no graphics or complicated functions available as of yet.
Anyone can use the BowerStudios Genealogy program so long as you document this site clearly as the source. I give no guarantees with this software.
In terms of development, this program is v.5. It works, but I plan to add additional functionality as well as packaging for installation at a later point in time.
Installation
- Add the database "genealogy" to your mysql server, and allow it to be writable by the user.
- Add the table structure to the genealogy database. You can load this file using phpMyAdmin (change extension to .sql first), or read it to figure out the structure.
- Create a directory on your webserver called "genealogy".
- Download files geneInputForm.txt, geneMarInputForm.txt, geneSchMilInputForm.txt, index.txt, and view.txt into this directory.
- You will have to modify each file to include the username and password of your mysql server. These are only needed once in each file (except index.txt - not needed).
- You will need to make sure that Apache will apply php to html pages in /var/www/conf/httpd.conf by making sure this line includes the .html at the end. AddType application/x-httpd-php .php .html
- Change all the filenames you downloaded from *.txt to *.html.
- Look at the results in the webbrowser.
- Log in to post comments