now I'm at the point where I got stuck each time I tried....
I populated mySQL database with some data from a site I'm running and
tested that it was running and working.
then I began a new project, this time saying, yes, add propel.
here's the output with line numbers to ease reference:
1: luke@debian2:~/phocoa_projects$ phocoa newProject
2: phing -f /usr/share/php/phocoa/phing/build.xml -
Dusing.phocoa.make=true -Dphocoa.pwd=/home/luke/phocoa_projects -
Dphocoa.dir=/usr/share/php/phocoa -
Dphocoa.project.name= -
Dphocoa.project.dir= newProject
3: Buildfile: /usr/share/php/phocoa/phing/build.xml
4:
5: phocoa > prepareGeneral:
6:
7: [echo] PHOCOA framework base dir at: /usr/share/php/phocoa
8:
9: phocoa > newProject:
10:
11: Enter the name of the new project: [] test2
12: [echo] The container directory for your PHOCOA project will
be used to place the log, runtime, and project directories. Please be
careful!
13: Enter the path to the project container directory: [/home/luke/
phocoa_projects/test2]
14: [realpathexpandhome] Resolved /home/luke/phocoa_projects/test2
to /home/luke/phocoa_projects/test2
15: Enter the name of the server (ie dns name) that will host this
application: [localhost]
16: Enter the IP of the server that will host this application:
[127.0.0.1]
17: Enter the PORT of the server that will host this application:
[80] 8080
18: [phingcall] Calling Buildfile '/usr/share/php/phocoa/phing/
build.xml' with target 'setupProjectContainer'
19:
20: phocoa > setupProjectContainer:
21:
22: [echo] Creating project container directories and setting
up permissions
23: [mkdir] Created dir: /home/luke/phocoa_projects/test2/log
24: [chmod] Changed file mode on '/home/luke/phocoa_projects/
test2/log' to 777
25: [mkdir] Created dir: /home/luke/phocoa_projects/test2/
runtime
26: [chmod] Changed file mode on '/home/luke/phocoa_projects/
test2/runtime' to 777
27: [mkdir] Created dir: /home/luke/phocoa_projects/test2/
runtime/smarty/templates_c
28: [chmod] Changed file mode on '/home/luke/phocoa_projects/
test2/runtime/smarty/templates_c' to 777
29: [echo] Creating project directory: /home/luke/
phocoa_projects/test2/test2
30: [mkdir] Created dir: /home/luke/phocoa_projects/test2/test2
31: [echo] Copying PHOCOA templates...
32: [copy] Copying 14 files to /home/luke/phocoa_projects/test2/
test2
33: [mkdir] Created dir: /home/luke/phocoa_projects/test2/test2/
wwwroot/www
34: [mkdir] Created dir: /home/luke/phocoa_projects/test2/test2/
modules
35: [echo] Setting up configuration files...
36: [copy] Copying 3 files to /home/luke/phocoa_projects/test2/
test2
37: [filter:ReplaceTokens] Replaced "##PHOCOA_BASE_DIR##" with "/usr/
share/php/phocoa"
38: [filter:ReplaceTokens] Replaced "##PHOCOA_APP_CONTAINER_DIR##"
with "/home/luke/phocoa_projects/test2"
39: [filter:ReplaceTokens] Replaced "##PHOCOA_APP_CONTAINER_DIR##"
with "/home/luke/phocoa_projects/test2"
40: [filter:ReplaceTokens] Replaced "##PHOCOA_APP_DIR##" with "/home/
luke/phocoa_projects/test2/test2"
41: [filter:ReplaceTokens] Replaced "##PHOCOA_PROJECT_NAME##" with
"test2"
42: [filter:ReplaceTokens] Replaced "##SERVER_IP##" with "127.0.0.1"
43: [filter:ReplaceTokens] Replaced "##SERVER_PORT##" with "8080"
44: [filter:ReplaceTokens] Replaced "##SERVER_NAME##" with
"localhost"
45: [filter:ReplaceTokens] Replaced "##PHOCOA_APP_DIR##" with "/home/
luke/phocoa_projects/test2/test2"
46: [filter:ReplaceTokens] Replaced "##PHOCOA_BASE_DIR##" with "/usr/
share/php/phocoa"
47: [filter:ReplaceTokens] Replaced "##PHOCOA_APP_DIR##" with "/home/
luke/phocoa_projects/test2/test2"
48: [filter:ReplaceTokens] Replaced "##PHOCOA_APP_DIR##" with "/home/
luke/phocoa_projects/test2/test2"
49: [filter:ReplaceTokens] Replaced "##PHOCOA_BASE_DIR##" with "/usr/
share/php/phocoa"
50: [filter:ReplaceTokens] Replaced "##PHOCOA_APP_DIR##" with "/home/
luke/phocoa_projects/test2/test2"
51: [filter:ReplaceTokens] Replaced "##PHOCOA_APP_CONTAINER_DIR##"
with "/home/luke/phocoa_projects/test2"
52: [filter:ReplaceTokens] Replaced "##PHOCOA_APP_CONTAINER_DIR##"
with "/home/luke/phocoa_projects/test2"
53: [filter:ReplaceTokens] Replaced "##PHOCOA_APP_DIR##" with "/home/
luke/phocoa_projects/test2/test2"
54: [filter:ReplaceTokens] Replaced "##PHOCOA_APP_DIR##" with "/home/
luke/phocoa_projects/test2/test2"
55: [filter:ReplaceTokens] Replaced "##PHOCOA_BASE_DIR##" with "/usr/
share/php/phocoa"
56: [phingcall] Calling Buildfile '/usr/share/php/phocoa/phing/
build.xml' with target 'httpdconf'
57:
58: phocoa > prepareGeneral:
59:
60: [echo] PHOCOA framework base dir at: /usr/share/php/phocoa
61:
62: phocoa > prepareProject:
63:
64: [echo] 1
65: [php] Evaluating PHP expression: getenv('_') ? getenv
('_') : getenv('PHP_COMMAND')
66: [echo] Using PHP: /usr/bin/php
67: [echo] PHOCOA project dir at: /home/luke/phocoa_projects/
test2/test2
68: [resolvepath] Resolved /home/luke/phocoa_projects/test2/test2/..
to /home/luke/phocoa_projects/test2
69: [echo] PHOCOA project container dir at: /home/luke/
phocoa_projects/test2
70: [property] Loading /home/luke/phocoa_projects/test2/test2/conf/
build.properties
71: [property] Unable to find property file: /home/luke/
phocoa_projects/test2/test2/conf/build.properties... skipped
72:
73: phocoa > httpdconf:
74:
75: [echo] PHOCOA requires some httpd configurations to work
its magic. You must either be able to edit httpd.conf, or have an
apache with mod_rewrite enabled.
76: Select httpd configuration mode: 1=httpd.conf, 2=.htaccess [1] 1
77: [echo] Make sure your httpd.conf file contains the line:
Include /home/luke/phocoa_projects/test2/test2/test2/conf/httpd.conf
78: Will this project use database access via Propel?(yes/no) [1]
yes
79: [phingcall] Calling Buildfile '/usr/share/php/phocoa/phing/
build.xml' with target 'addpropel'
80:
81: phocoa > prepareGeneral:
82:
83: [echo] PHOCOA framework base dir at: /usr/share/php/phocoa
84:
85: phocoa > prepareProject:
86:
87: [echo] 1
88: [php] Evaluating PHP expression: getenv('_') ? getenv
('_') : getenv('PHP_COMMAND')
89: [echo] Using PHP: /usr/bin/php
90: [echo] PHOCOA project dir at: /home/luke/phocoa_projects/
test2/test2
91: [resolvepath] Resolved /home/luke/phocoa_projects/test2/test2/..
to /home/luke/phocoa_projects/test2
92: [echo] PHOCOA project container dir at: /home/luke/
phocoa_projects/test2
93: [property] Loading /home/luke/phocoa_projects/test2/test2/conf/
build.properties
94: [property] Unable to find property file: /home/luke/
phocoa_projects/test2/test2/conf/build.properties... skipped
95:
96: phocoa > addpropel:
97:
98: [echo] NOTE: this task is only tested with Propel 1.3. If
you have problems, please report them.
99: [echo] Setting up PHOCOA project for Propel in dir: /home/
luke/phocoa_projects/test2/test2/propel-build
100: Select the path for executable: propel-gen: /usr/bin/propel-gen
101: [selectExecutable] Using propel-gen at /usr/bin/propel-gen
102: [mkdir] Created dir: /home/luke/phocoa_projects/test2/test2/
propel-build
103: Enter the database type:(pgsql,mysql,mssql,sqllite,ldap) mysql
104: Enter the database name: phocoa_lukeZcom
105: Enter the database username: phocoa
106: Enter the database password: phocoa
107: Enter the database host: [localhost]
108: [writeconffile] Writing conf file: /home/luke/phocoa_projects/
test2/test2/propel-build/build.properties.
109: [echo] Building Propel... setup conf file, reverse engineer
database, build db classes.
110: [copy] Copying 1 file to /home/luke/phocoa_projects/test2/
test2/propel-build
111: [filter:ReplaceTokens] Replaced "##LOG_DIR##" with "/home/luke/
phocoa_projects/test2/log"
112: [filter:ReplaceTokens] Replaced "##PHOCOA_PROJECT_NAME##" with
"test2"
113: [filter:ReplaceTokens] Replaced "##DB_NAME##" with
"phocoa_lukeZcom"
114: [filter:ReplaceTokens] Replaced "##DB_NAME##" with
"phocoa_lukeZcom"
115: [filter:ReplaceTokens] Replaced "##PROPEL_DATABASE##" with
"mysql"
116: [filter:ReplaceTokens] Replaced "##PROPEL_DATABASE##" with
"mysql"
117: [filter:ReplaceTokens] Replaced "##DB_NAME##" with
"phocoa_lukeZcom"
118: [filter:ReplaceTokens] Replaced "##DB_USER##" with "phocoa"
119: [filter:ReplaceTokens] Replaced "##DB_HOST##" with "localhost"
120: [filter:ReplaceTokens] Replaced "##DB_PASS##" with "phocoa"
121: [filter:ReplaceTokens] Replaced "##DB_USER##" with "phocoa"
122: [filter:ReplaceTokens] Replaced "##PROPEL_DATABASE##" with
"mysql"
123: [filter:ReplaceTokens] Replaced "##DB_HOST##" with "localhost"
124: [filter:ReplaceTokens] Replaced "##DB_NAME##" with
"phocoa_lukeZcom"
125: [filter:ReplaceTokens] Replaced "##DB_USER##" with "phocoa"
126: [filter:ReplaceTokens] Replaced "##DB_PASS##" with "phocoa"
127: [exec] Executing command: /usr/bin/propel-gen /home/luke/
phocoa_projects/test2/test2/propel-build convert-conf 2>&1
128: [exec] Buildfile: /usr/share/php/data/propel_generator/pear-
build.xml
129: [exec] [resolvepath] Resolved /home/luke/phocoa_projects/
test2/test2/propel-build to /home/luke/phocoa_projects/test2/test2/
propel-build
130: [exec]
131: [exec] propel-project-builder > projdircheckExists:
132: [exec]
133: [exec]
134: [exec] propel-project-builder > projdircheck:
135: [exec]
136: [exec]
137: [exec] propel-project-builder > configure:
138: [exec]
139: [exec] [echo] Loading project-specific props from /
home/luke/phocoa_projects/test2/test2/propel-build/build.properties
140: [exec] [property] Loading /home/luke/phocoa_projects/test2/
test2/propel-build/build.properties
141: [exec]
142: [exec] propel-project-builder > convert-conf:
143: [exec]
144: [exec] [phing] Calling Buildfile '/usr/share/php/data/
propel_generator/build-propel.xml' with target 'convert-conf'
145: [exec] [property] Loading /usr/share/php/data/
propel_generator/./build.properties
146: [exec] [property] Loading /usr/share/php/data/
propel_generator/./default.properties
147: [exec]
148: [exec] propel > convert-conf:
149: [exec]
150: [exec] [echo]
+------------------------------------------+
151: [exec] [echo]
| |
152: [exec] [echo] | Converting runtime config file to
an |
153: [exec] [echo] | array dump for improved
performance. |
154: [exec] [echo]
| |
155: [exec] [echo]
+------------------------------------------+
156: [exec] [echo] Output file: test2-conf.php
157: [exec] [echo] XMLFile: /home/luke/phocoa_projects/
test2/test2/propel-build/runtime-conf.xml
158: [exec] Execution of target "convert-conf" failed for the
following reason: /usr/share/php/data/propel_generator/build-
propel.xml:507:20: No schema files were found (matching your schema
fileset definition).
159: [exec] [phing] /usr/share/php/data/propel_generator/
build-propel.xml:507:20: No schema files were found (matching your
schema fileset definition).
160: [exec]
161: [exec] BUILD FINISHED
162: [exec]
163: [exec] Total time: 0.3373 seconds
164: [exec]
165: [echo] Propel general setup complete.
166: [echo] To complete propel integration, complete the
following manual tasks:
167: [echo] 1. Make sure that propel is available in your
include_path. If not, edit webapp.conf and munge include_path.
168: [echo] 2. Edit Propel's om/BaseObject.php BaseObject
declaration to this: 'abstract class BaseObject extends WFObject'.
169: [echo] 3. Edit Propel's util/BasePeer.php BasePeer
declaration to this: 'class BasePeer extends WFObject'.
170: If your database already exists, we can generate a PHP interface
to your database objects. Does your database already exist?(yes/no) []
yes
171: [exec] Executing command: /usr/bin/propel-gen /home/luke/
phocoa_projects/test2/test2/propel-build creole 2>&1
172: [exec] Buildfile: /usr/share/php/data/propel_generator/pear-
build.xml
173: [exec] [resolvepath] Resolved /home/luke/phocoa_projects/
test2/test2/propel-build to /home/luke/phocoa_projects/test2/test2/
propel-build
174: [exec]
175: [exec] propel-project-builder > projdircheckExists:
176: [exec]
177: [exec]
178: [exec] propel-project-builder > projdircheck:
179: [exec]
180: [exec]
181: [exec] propel-project-builder > configure:
182: [exec]
183: [exec] [echo] Loading project-specific props from /
home/luke/phocoa_projects/test2/test2/propel-build/build.properties
184: [exec] [property] Loading /home/luke/phocoa_projects/test2/
test2/propel-build/build.properties
185: [exec]
186: [exec] propel-project-builder > creole:
187: [exec]
188: [exec] [phing] Calling Buildfile '/usr/share/php/data/
propel_generator/build-propel.xml' with target 'creole'
189: [exec] [property] Loading /usr/share/php/data/
propel_generator/./build.properties
190: [exec] [property] Loading /usr/share/php/data/
propel_generator/./default.properties
191: [exec]
192: [exec] propel > creole:
193: [exec]
194: [exec] [echo]
+-----------------------------------------------+
195: [exec] [echo]
| |
196: [exec] [echo] | Generating XML from Creole
connection ! |
197: [exec] [echo]
| |
198: [exec] [echo]
+-----------------------------------------------+
199: [exec] [PHP Error] PropelCreoleTransformTask::include_once
(creole/Creole.php): failed to open stream: No such file or directory
[line 267 of /usr/share/php/propel/phing/
PropelCreoleTransformTask.php]
200: [exec] [PHP Error] PropelCreoleTransformTask::include_once
(): Failed opening 'creole/Creole.php' for inclusion (include_path='/
usr/share/php/data/propel_generator/classes:.:/usr/share/php:/usr/
share/php/Smarty-2.6.26:/usr/share/php/SssS:/usr/share/pear') [line
267 of /usr/share/php/propel/phing/PropelCreoleTransformTask.php]
201: [exec] Execution of target "creole" failed for the
following reason: /usr/share/php/data/propel_generator/build-
propel.xml:298:1: PropelCreoleTransformTask task depends on Creole
classes being on include_path. (i.e. include of 'creole/Creole.php'
failed.)
202: [exec] [phing] /usr/share/php/data/propel_generator/
build-propel.xml:298:1: PropelCreoleTransformTask task depends on
Creole classes being on include_path. (i.e. include of 'creole/
Creole.php' failed.)
203: [exec]
204: [exec] BUILD FINISHED
205: [exec]
206: [exec] Total time: 0.2964 seconds
207: [exec]
208: [exec] Executing command: /usr/bin/propel-gen /home/luke/
phocoa_projects/test2/test2/propel-build main 2>&1
209: [exec] Buildfile: /usr/share/php/data/propel_generator/pear-
build.xml
210: [exec] [resolvepath] Resolved /home/luke/phocoa_projects/
test2/test2/propel-build to /home/luke/phocoa_projects/test2/test2/
propel-build
211: [exec]
212: [exec] propel-project-builder > projdircheckExists:
213: [exec]
214: [exec]
215: [exec] propel-project-builder > projdircheck:
216: [exec]
217: [exec]
218: [exec] propel-project-builder > configure:
219: [exec]
220: [exec] [echo] Loading project-specific props from /
home/luke/phocoa_projects/test2/test2/propel-build/build.properties
221: [exec] [property] Loading /home/luke/phocoa_projects/test2/
test2/propel-build/build.properties
222: [exec]
223: [exec] propel-project-builder > main:
224: [exec]
225: [exec] [phing] Calling Buildfile '/usr/share/php/data/
propel_generator/build-propel.xml' with target 'main'
226: [exec] [property] Loading /usr/share/php/data/
propel_generator/./build.properties
227: [exec] [property] Loading /usr/share/php/data/
propel_generator/./default.properties
228: [exec]
229: [exec] propel > mysqli-check:
230: [exec]
231: [exec]
232: [exec] propel > main:
233: [exec]
234: [exec] [phingcall] Calling Buildfile '/usr/share/php/data/
propel_generator/build-propel.xml' with target 'sql'
235: [exec] [property] Loading /usr/share/php/data/
propel_generator/./build.properties
236: [exec] [property] Loading /usr/share/php/data/
propel_generator/./default.properties
237: [exec]
238: [exec] propel > check-run-only-on-schema-change:
239: [exec]
240: [exec]
241: [exec] propel > sql-check:
242: [exec]
243: [exec]
244: [exec] propel > pgsql-quoting-check:
245: [exec]
246: [exec]
247: [exec] propel > mysqli-check:
248: [exec]
249: [exec]
250: [exec] propel > sql:
251: [exec]
252: [exec] [echo]
+------------------------------------------+
253: [exec] [echo]
| |
254: [exec] [echo] | Generating SQL for YOUR Propel
project! |
255: [exec] [echo]
| |
256: [exec] [echo]
+------------------------------------------+
257: [exec] [phingcall] Calling Buildfile '/usr/share/php/data/
propel_generator/build-propel.xml' with target 'sql-template'
258: [exec] [property] Loading /usr/share/php/data/
propel_generator/./build.properties
259: [exec] [property] Loading /usr/share/php/data/
propel_generator/./default.properties
260: [exec]
261: [exec] propel > sql-template:
262: [exec]
263: [exec] Execution of target "sql-template" failed for the
following reason: /usr/share/php/data/propel_generator/build-
propel.xml:196:10: No schema files were found (matching your schema
fileset definition).
264: [exec] [phingcall] /usr/share/php/data/propel_generator/
build-propel.xml:196:10: No schema files were found (matching your
schema fileset definition).
265: [exec] Execution of target "sql" failed for the following
reason: /usr/share/php/data/propel_generator/build-propel.xml:181:22:
Execution of the target buildfile failed. Aborting.
266: [exec] [phingcall] /usr/share/php/data/propel_generator/
build-propel.xml:181:22: Execution of the target buildfile failed.
Aborting.
267: [exec] Execution of target "main" failed for the following
reason: /usr/share/php/data/propel_generator/build-propel.xml:91:22:
Execution of the target buildfile failed. Aborting.
268: [exec] [phing] /usr/share/php/data/propel_generator/
build-propel.xml:91:22: Execution of the target buildfile failed.
Aborting.
269: [exec]
270: [exec] BUILD FINISHED
271: [exec]
272: [exec] Total time: 0.4104 seconds
273: [exec]
274: [echo] Propel code generation complete.
275: [echo] Activating propel in application delegate...
276: [reflexive] Applying reflexive processing to 1 files.
277: [echo] Done adding Propel support.
278: [echo] New Project setup complete.
279:
280: BUILD FINISHED
281:
282: Total time: 24 minutes 55.86 seconds
It all looks OK until line 94 and especially line 158
As phocoa didn't die, I ignored the error and replied 'yes' on line
170
the rest reveals that the propel or phing installation package doesn't
seem to
resolve and install it's dependencies correctly. (creole missing,
there is a folder in phing /usr/share/php/phing/tasks/ext/creole but
that's just the tasks)
Is this where I have to run a modified version of fix-schema.php?
I still don't have any schema.xml so I'm guessing not, that mysql
isn't suported.
I'm not sure if I should ask this here as it seems to hang on
propel...but without propel phocoa's true power can't unfold. Am I
wrong?