Re: [Ground-user] ./databaseInterface start problem ?

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Great news.

BTW you might want to look at using the development version that is uploaded to the git archive. This fixes a couple of problems that are in the general release.

But if everything that you are using is working then no need.

Cheers
Cal

On 26 Sep 2011, at 09:59, Gerry Brennan wrote:

> Hi Calum
> 
> This got me sorted 
> 
> Thank you
> 
> 
> Sent from my iPhone
> 
> On 24 Sep 2011, at 19:43, Calum Fitzgerald <cal...@gm...> wrote:
> 
>> Hi Gerry,
>> 
>> Apologies about the delay in response, I had some connectivity issues which I have now resolved.
>> 
>> Please can you try upgrading the version of postgres to 8.2 or above. I would recommend trying version 9.
>> 
>> The software was never tested on version 8.1 and it would be nice to rule out version incompatibility in the first instance.
>> 
>> There are centos rpms available for postgres:
>> 
>> http://yum.pgrpms.org/
>> 
>> here is the how-to page which is useful for integrating the repository with yum:
>> 
>> http://yum.pgrpms.org/howtoyum.php
>> 
>> Cheers
>> Cal
>> 
>> On 21 Sep 2011, at 09:15, Gerry Brennan wrote:
>> 
>>> Hi Calum,
>>> 
>>> 
>>> 
>>> psql (PostgreSQL) 8.1.23 Installed via YUM ... Just checking again...
>>> 
>>> yum install postgresql postgresql-server
>>> Loaded plugins: fastestmirror
>>> Loading mirror speeds from cached hostfile
>>>  * base: archive.cs.uu.nl
>>>  * extras: archive.cs.uu.nl
>>>  * updates: centos.mirror.transip.nl
>>> Setting up Install Process
>>> Package postgresql-8.1.23-1.el5_6.1.i386 already installed and latest version
>>> Package postgresql-server-8.1.23-1.el5_6.1.i386 already installed and latest version
>>> Nothing to do
>>> 
>>> 
>>> CREATE DATABASE ground_stats  ENCODING 'UTF8'; > database command interpreter.
>>> 
>>> createlang plpgsql ground_stats > via unix command console.
>>> 
>>> CentOS release 5.6 (Final) 
>>> uname -a  -> Linux localhost.localdomain 2.6.18-238.9.1.el5 #1 SMP Tue Apr 12 18:10:56 EDT 2011 i686 i686 i386 GNU/Linux
>>> 
>>> Gerry
>>> 
>>> On Tue, Sep 20, 2011 at 9:22 PM, Calum Fitzgerald <cal...@gm...> wrote:
>>> Hi Gerry,
>>> 
>>> Looks like an interesting problem....and not one that I have come
>>> across before unfortunately.
>>> 
>>> Please can you let me know which version of Postgres you are running against?
>>> is the PL/PGSQL language installed?
>>> Also which OS are you using?
>>> 
>>> Cheers
>>> Cal
>>> 
>>> On 19 September 2011 15:49, Gerry Brennan <ger...@gm...> wrote:
>>> > Hi Calum,
>>> >
>>> > I got past this issue. Thank you very much for your response.
>>> >
>>> > I am currently on another one around the database. (in my opinion)
>>> >
>>> >
>>> > When I run in to Databaseinterface.bash and press 1 to install database i
>>> > get the following.
>>> >
>>> > I have manipulated some code in the file  databaseFactory.py file  to
>>> > highlight the problems ONLY...
>>> >
>>> > When i identify them i can revert back to the original.
>>> >
>>> > DATABASE CONTROL MENU
>>> >
>>> > -----------------------
>>> >
>>> >
>>> >
>>> >  Select action to perform:
>>> >
>>> >
>>> >
>>> >   1 ) install Database
>>> >
>>> >   2 ) delete Database
>>> >
>>> >   3 ) reset Database
>>> >
>>> >   4 ) upload Files
>>> >
>>> >   5 ) refresh Materialised Views
>>> >
>>> >   6 ) drop Data
>>> >
>>> >
>>> >
>>> >  Experimental
>>> >
>>> >  ------------
>>> >
>>> >   7 ) cluster Database
>>> >
>>> >   8 ) refresh Extended Stats Materialised Views
>>> >
>>> >
>>> >
>>> >  Information
>>> >
>>> >  ------------
>>> >
>>> >   9 ) show loadrun information
>>> >
>>> >   10) show data file information
>>> >
>>> >
>>> >
>>> >  Type 'exit' to escape the menu
>>> >
>>> >
>>> >
>>> >  Enter action: 1
>>> >
>>> >
>>> >
>>> >  Create Database Selected
>>> >
>>> >
>>> >
>>> > Traceback (innermost last):
>>> >
>>> >   File "~/ground_report-1.5/lib/databaseInterface.py", line 455, in ?
>>> >
>>> >   File "~/ground_report-1.5/lib/databaseInterface.py", line 197, in
>>> > startDBMenu
>>> >
>>> >   File "~/ground_report-1.5/lib/databaseFactory.py", line 35, in createDB
>>> >
>>> > Error: ERROR: syntax error at or near "(" [SQLCode: 0], [SQLState: 42601]
>>> >
>>> >
>>> >
>>> > Then when I look at the line of code in lib/databaseFactory.py
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >   c.execute('''CREATE TABLE "raw_data_http"
>>> >
>>> >   17             (
>>> >
>>> >   18              "RAW_ID" integer NOT NULL DEFAULT
>>> > nextval(('public."raw_http_seq"'::text)::regclass),
>>> >
>>> >   19              "Load Run" integer NOT NULL,
>>> >
>>> >   20              "Data File" integer NOT NULL,
>>> >
>>> >   21              "Thread" integer NOT NULL,
>>> >
>>> >   22              "Run" integer NOT NULL,
>>> >
>>> >   23              "Test" bigint NOT NULL,
>>> >
>>> >   24              "Milliseconds Since Epoch" bigint NOT NULL,
>>> >
>>> >   25              "Test Time" integer NOT NULL,
>>> >
>>> >   26              "Errors" integer NOT NULL,
>>> >
>>> >   27              "HTTP Response Code" integer NOT NULL,
>>> >
>>> >   28              "HTTP Response Length" integer NOT NULL,
>>> >
>>> >   29              "HTTP Response Errors" integer NOT NULL,
>>> >
>>> >   30              "Time To Resolve Host" integer NOT NULL,
>>> >
>>> >   31              "Time To Establish Connection" integer NOT NULL,
>>> >
>>> >   32              "Time To First Byte" integer NOT NULL,
>>> >
>>> >   33              CONSTRAINT raw_http_pkey PRIMARY KEY ("RAW_ID")
>>> >
>>> >   34             )
>>> >
>>> >   35             WITH (OIDS=FALSE); ''')
>>> >
>>> >
>>> >
>>> > In the database log file I get
>>> >
>>> >
>>> >
>>> > ERROR:  syntax error at or near "(" at character 904
>>> >
>>> > LOG:  unexpected EOF on client connection
>>> >
>>> >
>>> >
>>> >
>>> >
>>> > When I remove the component
>>> >
>>> >
>>> >
>>> > WITH (OIDS=FALSE);
>>> >
>>> >
>>> >
>>> > It moves on to the next problem statement.
>>> >
>>> >
>>> >
>>> > WITH (OIDS=FALSE);
>>> >
>>> >
>>> >
>>> > So I remove them all of them across Across all the file.
>>> >
>>> >
>>> >
>>> > Finally I get to  an PL/PgSQL problem.
>>> >
>>> >
>>> >
>>> > NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> > "raw_http_pkey" for table "raw_data_http"
>>> >
>>> > NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> > "upload_http_pkey" for table "http_upload_info"
>>> >
>>> > NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> > "datafile_http_pkey" for table "http_data_files"
>>> >
>>> > NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> > "descfile_http_pkey" for table "http_desc_files"
>>> >
>>> > NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>>> > "descriptions_http_pkey" for table "descriptions_http"
>>> >
>>> > ERROR:  syntax error at or near "$1" at character 46
>>> >
>>> > QUERY:  SELECT  sum("Started Threads") INTO  STRICT  $1  FROM
>>> > thread_start_buckets_http_mv WHERE "Load Run" =  $2  AND "Time Bucket" <=
>>> > $3
>>> >
>>> > CONTEXT:  SQL statement in PL/PgSQL function "concurrent_users_http" near
>>> > line 9
>>> >
>>> > Traceback (innermost last):
>>> >   File "/home/devweb/ground_report-1.5/lib/databaseInterface.py", line 455,
>>> > in ?
>>> >   File "/home/devweb/ground_report-1.5/lib/databaseInterface.py", line 197,
>>> > in startDBMenu
>>> >   File "/home/devweb/ground_report-1.5/lib/databaseFactory.py", line 180, in
>>> > createDB
>>> > Error: ERROR: syntax error at or near "$1" [SQLCode: 0], [SQLState: 42601]
>>> >
>>> > Your help is greatly appreciated.
>>> >
>>> > Gerry.
>>> >
>>> >
>>> > On Mon, Sep 19, 2011 at 12:53 PM, Calum Fitzgerald
>>> > <cal...@gm...> wrote:
>>> >>
>>> >> Hi Gerry,
>>> >>
>>> >> The issue is to do with the fact that the ground report cannot find
>>> >> the Jython installation:
>>> >>
>>> >> Some initial steps to try with respects to troubleshooting:
>>> >>
>>> >> 1. Have you installed Jython onto your machine?
>>> >> 2. Have you updated the configuration files with the location of your
>>> >> Jython installation?
>>> >>
>>> >>
>>> >> Cheers
>>> >> Cal
>>> >>
>>> >>
>>> >> On 16 September 2011 15:32, Gerry Brennan <ger...@gm...> wrote:
>>> >> >
>>> >> > Hi Group,
>>> >> >
>>> >> > I am trying to install ground report I have got as far as trying to run
>>> >> > databaseInterface
>>> >> >
>>> >> > ./databaseInterface.bash
>>> >> > Exception in thread "main" java.lang.NoClassDefFoundError:
>>> >> > org/python/util/jython
>>> >> > Caused by: java.lang.ClassNotFoundException: org.python.util.jython
>>> >> >         at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
>>> >> >         at java.security.AccessController.doPrivileged(Native Method)
>>> >> >         at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
>>> >> >         at java.lang.ClassLoader.loadClass(ClassLoader.java:319)
>>> >> >         at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
>>> >> >         at java.lang.ClassLoader.loadClass(ClassLoader.java:264)
>>> >> >         at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:332)
>>> >> > Could not find the main class: org.python.util.jython. Program will
>>> >> > exit.
>>> >> >
>>> >> >
>>> >> > Can anyone help
>>> >> >
>>> >> >
>>> >> > ------------------------------------------------------------------------------
>>> >> > BlackBerry&reg; DevCon Americas, Oct. 18-20, San Francisco, CA
>>> >> > http://p.sf.net/sfu/rim-devcon-copy2
>>> >> > _______________________________________________
>>> >> > Ground-user mailing list
>>> >> > Gro...@li...
>>> >> > https://lists.sourceforge.net/lists/listinfo/ground-user
>>> >> >
>>> >> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> 
>>> 
>>> 
>>> -- 
>>> Gerry Brennan. 
>>> "Shalom"
>>> Lipstown
>>> Narraghmore
>>> Co. Kildare
>>> Ireland
>>> 
>>> Tel :  + 353 86 0200999.
>>> Tel :  + 353 87 9783902.
>>> 
>>> Personal Mail: ger...@gm...
>> 