./make_project script created database successfully ,but not the whole projec

Message boards : Server programs : ./make_project script created database successfully ,but not the whole projec
Message board moderation

To post messages, you must log in.

AuthorMessage
Kunsheng Chen

Send message
Joined: 3 Jun 08
Posts: 40
United States
Message 17683 - Posted: 5 Jun 2008, 21:18:01 UTC
Last modified: 5 Jun 2008, 21:20:07 UTC

I used 'make_project' to create a project but strange things happened: The script did create database and 31 tables in it inside mysql, however I could not find the file $projectname.httpd.conf under the project directory (which ought to be combined with httpd.conf under apache2 later)

Also the message come after the script ran .

The message is as below:


kchen3@lobo:~$ ./make_project --db_user 'kchen3' --db_host 'localhost' --db_passwd 'mypassword';
-bash: ./make_project: No such file or directory
kchen3@lobo:~$ cd boinc
kchen3@lobo:~/boinc$ cd tools
kchen3@lobo:~/boinc/tools$ ./make_project --db_user 'kchen3' --db_passwd 'mysql' test_app5 'test app5';
Creating project 'test app5' (short name 'test_app5'):
PROJECT_ROOT = /osr/users/kchen3/projects/test_app5/
URL_BASE = http://lobo.csc.ncsu.edu/
HTML_USER_URL = http://lobo.csc.ncsu.edu/test_app5/
HTML_OPS_URL = http://lobo.csc.ncsu.edu/test_app5_ops/
CGI_URL = http://lobo.csc.ncsu.edu/test_app5_cgi/
KEY_DIR = /osr/users/kchen3/projects/test_app5/keys/
DB_NAME = test_app5
DB_HOST =

Continue? [Y/n] Y
Setting up server: creating directories

Keys don't exist in /osr/users/kchen3/projects/test_app5/keys/; generate them? [Y/n] y
Setting up database
Traceback (most recent call last):
File "./make_project", line 217, in <module>
project.install_project()
File "/osr/users/kchen3/boinc/py/Boinc/setup_project.py", line 538, in install_project
drop_first = options.drop_db_first
File "/osr/users/kchen3/boinc/py/Boinc/database.py", line 271, in create_database
_execute_sql_script(cursor, os.path.join(schema_path, file))
File "/osr/users/kchen3/boinc/py/Boinc/database.py", line 257, in _execute_sql_script
cursor.execute(query)
File "/var/lib/python-support/python2.5/MySQLdb/cursors.py", line 166, in execute
self.errorhandler(self, exc, value)
File "/var/lib/python-support/python2.5/MySQLdb/connections.py", line 35, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6")



I did grant all privileges to the user 'kchen3', also I set up PYTHONPATH as '/osr/users/kchen3/boinc/py' in ~./bashrc, which should be correct setting.
Does anyone have some idea? I appreciate any help here.
Thank you.
ID: 17683 · Report as offensive
Nicolas

Send message
Joined: 19 Jan 07
Posts: 1179
Argentina
Message 17716 - Posted: 7 Jun 2008, 3:32:08 UTC

Upgrade to the latest version. There was an error in schema.sql
ID: 17716 · Report as offensive
Kunsheng Chen

Send message
Joined: 3 Jun 08
Posts: 40
United States
Message 17726 - Posted: 7 Jun 2008, 19:11:13 UTC - in response to Message 17716.  
Last modified: 7 Jun 2008, 19:12:49 UTC

Upgrade to the latest version. There was an error in schema.sql


Thank you,Nic. I redownloaded all the files and the response is like this:


kchen3@lobo:~/boinc_trunk/tools$ ./make_project --db_user 'kchen3' --db_passwd 'mysql' test1 'test1';
Creating project 'test1' (short name 'test1'):
PROJECT_ROOT = /osr/users/kchen3/projects/test1/
URL_BASE = http://lobo.csc.ncsu.edu/
HTML_USER_URL = http://lobo.csc.ncsu.edu/test1/
HTML_OPS_URL = http://lobo.csc.ncsu.edu/test1_ops/
CGI_URL = http://lobo.csc.ncsu.edu/test1_cgi/
KEY_DIR = /osr/users/kchen3/projects/test1/keys/
DB_NAME = test1
DB_HOST =

Continue? [Y/n] Y
Setting up server: creating directories

Keys don't exist in /osr/users/kchen3/projects/test1/keys/; generate them? [Y/n] y
Setting up server files: linking cgi programs Done installing default daemons.

Done installing files. Please view
/osr/users/kchen3/projects/test1/test1.readme
for important additional instructions.




That means I got it done finally. Isn't it?

I am still a little confused by the instruction in the readme file, the second step.


2. Add to crontab (as kchen3)

0,5,10,15,20,25,30,35,40,45,50,55 * * * * /osr/users/kchen3/projects/test1/bin/start --cron

(If cron cannot run "start", try using a helper script to set PATH and
PYTHONPATH)


What does it really mean? I have no idea what to do by it

Thank! It really help me!
ID: 17726 · Report as offensive

Message boards : Server programs : ./make_project script created database successfully ,but not the whole projec

Copyright © 2024 University of California.
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.