···
---Yao
I have been trying to set up a local server for the odk by installing the ODK Aggregate v1.3.0 windows-installer.
I have tomcat v6 and mysql already installed in my comp.
I have been following these steps http://code.google.com/p/crossriver-openhds/wiki/OpenDataKitInstallation
unfortunately, when i get to the last step and try to implement the steps below, I get two errors in the command window which I suspect are making me not be able to run the odk aggregate server
Error 1007 ; can't create a database 'odk-prod'; database already exists
Error 1397 ; Operation CREATE USER failed for 'odk_user' @ 'local host'
I expect to have the above statement to be as highlighted in yellow below
what could be the problem?
I would wish to know whether there is an alternative for converting the xml forms with data into csv format on my personal comp.
my comp is running on windows 7
Regards
Karuru
To complete the installation, you need to:
- Execute the mysql (mysql.exe) commandline client using the root account and password (the password you chose during the installation of the database), and supply the
create_db_and_user.sql
to it.
To open the mysql commandline client, open a cmd window (Windows), terminal window (MacOS) or
term window (Linux) and 'cd' to the directory containing the mysql client (mysql.exe on Windows).
Then, please type:
mysql --user root --password
And enter the MySQL server root password. You will then be within the mysql commandline client. You should see a 'mysql>' prompt. Type:
source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK Aggregate/create_db_and_user.sql
exit
Here is what this looks like on Windows, with what you must type in red:
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Windows\System32>cd "\Program Files\MySQL\MySQL Server 5.1\bin" C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql.exe --user root --password
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.1.47-community MySQL Community Server (GPL) Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> source C:/Users/Karuru/ODK Aggregate/ODK Aggregate/ODK Aggregate/create_db_and_user.sql
Query OK, 1 row affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> exit
Bye C:\Program Files\MySQL\MySQL Server 5.1\bin>
- copy the
ODKAggregate.war
to the\webapps
directory of the Apache
Tomcat installation. - start Apache (if not already started)
- visit http://karuru-pc:8080/ODKAggregate/ and go to the Management / Permissions tab to complete configuring the access rights for ODK Aggregate. NOTE: It may take a few moments for the Apache Tomcat server to detect the ODKAggregate.war; if you get a 404 error, wait a few moments then refresh your browser.
If you want ODKAggregate to be reached at justhttp://Karuru-PC:8080/
, you can
rename it to ROOT.war before copying it to the\webapps
directory.
Regards;
Stephen Karuru Maina
https://profiles.google.com/TheKarurus