How do I test it?

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Mark,
My apologies for not replying sooner; I forgot to enable notifications on the project as I didn't think anyone would find it anyway :) But glad you did!

Just to clarify, OpenAuctionLive is designed for on-site management of Silent/Live Auction events; it currently does not include on-line auction capabilities. I'm planning to add these features later this summer, including some install/config scripts however anyone is open to help out by doing them sooner.

That said, OpenAuctionLive uses the CakePHP framework so the best source of installation is their documentation, specifically:

http://book.cakephp.org/view/912/Installation

The easiest way is to put the /openauctionlive directory at the web root of your server (i.e. /var/www/htdocs/openauctionlive) then you'd access it from http://your.server.name/openauctionlive/. Make sure the /openauctionlive/app/tmp directory is readable and writable by your web server.

You'll need to set up your MySQL database and update the /app/config/database.php file accordingly per:

http://book.cakephp.org/view/922/Database-Configuration

Once that's done, you can use the schema.php file I created to auto-generate the database tables by going to /openauctionlive/cake/console/ and running "./cake schema create" from the command line. Check out :

http://book.cakephp.org/view/1524/Generating-and-using-Schema-files

for more information on auto-generating with Cake. If you're new to CakePHP I strongly recommend reading through their excellent documentation at http://book.cakephp.org/.

Good luck with your auction!

Thanks for the response. I managed to solve my issue with Joomla and a plugin for auctions.. I just needed the capability as a one-off application that happens once a year.

Dear Michael Paric,

Thank you for the installation guide post of 2011-02-26. This is very helpful.
I have been studying your installation outline for openauctionlive, as located at:

https://answers.launchpad.net/openauctionlive/+question/141123

I have created the cake database on the MySQL database, and I feel certain that I can get
the right schema into it if I had some idea which of the schema.php's to use:

SIZE LOCATION
13504 ./cake/console/libs/schema.php
16934 ./cake/libs/model/cake_schema.php
1484 ./cake/tests/test_app/plugins/test_plugin/config/schema/schema.php
9885 ./app/config/schema/schema.php

Frankly, I feel that I may have gone astray,

from the page:
http://prodlsvr/htdocs/openauctionlive/auction/
(running on an internal beast)

<snip>
Sweet, "Auction" got Baked by CakePHP!

Your tmp directory is writable.
The FileEngine is being used for caching. To change the config edit APP/config/core.php
Your database configuration file is present.
Cake is able to connect to the database.
Editing this Page

To change the content of this page, edit:
/var/www/htdocs/openauctionlive/auction/views/pages/home.ctp.
To change its layout, edit:
/var/www/htdocs/openauctionlive/auction/views/layouts/default.ctp.
You can also add some CSS styles for your pages at:
/var/www/htdocs/openauctionlive/auction/webroot/css
CakePHP: the rapid development php framework
(default) 0 query took ms Nr Query Error Affected Num. rows Took (ms)
<snap>

the good news is that I have learned a bit about cake, and a bit more about MySQL. Anyway,
it looks like a sweet bit of PHP, so I would like to continue to get it operational.

If you have any tips I would be happy to try them out.

Kindest Regards,
Paul Flint

Hi Paul;
I'm glad the program has been helpful! The Cake console programs are tricky to use because they're dependent on proper path directives. Check out http://cakephp.19694.n2.nabble.com/Schema-Could-Not-Be-Loaded-td786615.html for some discussion on how to include the path to the Cake console programs in and out of the app directory. For me, I add the full path to the cake/console directory in my php.ini file so I don't have to type long directory lists every time (check out http://ahmerzaidi.com/2010/08/19/configure-cakephp-console-in-linux/).

The ./app/config/schema/schema.php file is the schema specific to the application (the others are default schemas used by Cake for things like Sessions and ACL setup, as well as the code to create the database tables themselves).

Once you have the Cake schema program working, you can either use the 'create' command to create all the tables in an empty database specific in the /app/config/database.php file or use the 'dump' command which will create SQL statements based on the schema which you can cut-and-paste into phpmyadmin.

Also, check out the app/webroot/.htaccess file. I originally created the program to run as a subdirectory of the web root due to the way I needed other people to access it. So the program is expecting http://your.domain.com/openauctionlive; if you're running the program at the web root or another directory, you may need to modify the .htaccess file.

As the controllers, models and views are already created, you shouldn't have to use the 'bake' command as that's only necessary to create an empty framework. The 'bake' command may modify or overwrite existing code. Just copy all of the files into your web directory and update the .htaccess file noted above if app/webroot is not the webroot of the domain.

Good luck!
Michael