How do I test it?

Asked by Mark Garrow on 2011-01-12

I've got a web server up and running at home that is accessible from outside my LAN. However I'm not sure how to grab the needed files/code to get this up and running. Can you assist? I have an upcoming charity church auction that I've been trying to find a way to allow remote bidders to participate.

Thanks for any assistance.

Mark Garrow
Scunizi / izinucs
scunizi at cox dot net

Question information

Language:
English Edit question
Status:
Answered
For:
openauctionlive Edit question
Assignee:
No assignee Edit question
Last query:
2011-01-12
Last reply:
2011-10-19
Launchpad Janitor (janitor) said : #1

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

Michael Paric (mparic) said : #2

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!

Michael Paric (mparic) said : #3

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!

Mark Garrow (scunizi) said : #4

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.

Paul Flint (flint) said : #5

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

Michael Paric (mparic) said : #6

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

Can you help with this problem?

Provide an answer of your own, or ask Mark Garrow for more information if necessary.

To post a message you must log in.