We're Hiring!

Can´t populate my database OMERO4.1_0 sql

Having a problem deploying OMERO? Please ask new questions at https://forum.image.sc/tags/omero
Please note:
Historical discussions about OMERO. Please look for and ask new questions at https://forum.image.sc/tags/omero

The OMERO.server installation documentation begins here and you can find OMERO.web deployment documentation here.

Can´t populate my database OMERO4.1_0 sql

Postby NUser » Wed Feb 03, 2010 11:49 am

Hello,
i like to test the omero system on windows xp for my chef and I don´t work with any of the prequesites (like PostgreSql etc. ) before.
I have create the database script (as you can see on the picture) and it was saved at C:\omero\omero_dist\bin.
At the installation script for windows I have to populate the database with \i /omero... and I try it. But I only get the message "No such file or directory" as you can see on the second picture.
How can I find the file or how can I change the path so that the command \i .. was working?
Thank you
Attachments
omeropopulate.JPG
populate
omeropopulate.JPG (88.24 KiB) Viewed 5037 times
OMERO4.1_0sql.JPG
initializationscript
OMERO4.1_0sql.JPG (64.48 KiB) Viewed 5037 times
NUser
 
Posts: 18
Joined: Wed Feb 03, 2010 11:38 am

Re: Can´t populate my database OMERO4.1_0 sql

Postby jmoore » Wed Feb 03, 2010 12:09 pm

As you said, the SQL script was created in "C:\omero\omero_dist\bin" but the PSQL shell started in "C:\Programme\PostgreSQL\8.3\bin". When you type "\i OMERO4.1__0.sql" it looks for the file in the PostgreSQL directory. Try using the full path to the file.

Hope that helps,
~Josh
User avatar
jmoore
Site Admin
 
Posts: 1591
Joined: Fri May 22, 2009 1:29 pm
Location: Germany

Re: Can´t populate my database OMERO4.1_0 sql

Postby NUser » Wed Feb 03, 2010 1:29 pm

the full path is C:\omero\omero_dist\bin\OMERO4.1_0.sql
I´ve tried some variants:
omero=> \i /C:/omero/...
omero=> \i /C:\omero\omero_dist\bin/OMERO4.1_0sql
But I get only "No such file or directory"
"/C: inalid argument"
or permission denied
It could be the backslashes.
Can I save the OMERO4.1_0.sql to another path so that PostgreSQL/bin can find it?

Thanks
NUser
 
Posts: 18
Joined: Wed Feb 03, 2010 11:38 am

Re: Can´t populate my database OMERO4.1_0 sql

Postby jmoore » Wed Feb 03, 2010 1:35 pm

Sure, you can either move the file yourself with "move OMERO4.1__0.sql C:\Programme\PostgreSQL\8.3\bin" or you can have it created in your current directory via:
Code: Select all
cd c:\Programme\PostgreSQL\8.3\bin
C:\omero\omero_dist\bin\omero db script


Cheers,
~Josh
User avatar
jmoore
Site Admin
 
Posts: 1591
Joined: Fri May 22, 2009 1:29 pm
Location: Germany

Re: Can´t populate my database OMERO4.1_0 sql

Postby NUser » Wed Feb 03, 2010 2:11 pm

If I try it
Code: Select all
C:\omero\omero_dist\bin\omero db script

I get the line
"The command "python" could not be found

Could it have something to to with the enviroment variables path and PYTHONPATH?
NUser
 
Posts: 18
Joined: Wed Feb 03, 2010 11:38 am

Re: Can´t populate my database OMERO4.1_0 sql

Postby NUser » Wed Feb 03, 2010 2:14 pm

Thank you very much for your help, cause I´m such a amateur.
NUser
 
Posts: 18
Joined: Wed Feb 03, 2010 11:38 am

Re: Can´t populate my database OMERO4.1_0 sql

Postby jmoore » Wed Feb 03, 2010 2:30 pm

Yes, with the PATH variable. I'm not sure of how you've configured your PATH, so it's probably easiest to move the SQL script into your PostgreSQL directory. Then, you should then be able to use "\i OMERO4.1__0.sql". Alternatively, you should be able to use:

Code: Select all
\i /omero/omero_dist/bin/OMERO4.1__0.sql


as long as the file is on the same drive (C:), which it is.

Cheers,
~Josh
User avatar
jmoore
Site Admin
 
Posts: 1591
Joined: Fri May 22, 2009 1:29 pm
Location: Germany

Re: Can´t populate my database OMERO4.1_0 sql

Postby NUser » Wed Feb 03, 2010 3:32 pm

It´s so frustrating.
Now I´ve changed the PATH so I could use
Code: Select all
C:\omero\omero_dist\bin\omero db script

And as you can see it was saved to C:\Programme\PostgreSQL\8.3\bin\OMERO4.1_0.sql
No I have on version in this path and one in C:\omero\omero_dist\bin\OMERO4.1_0.sql
Then I tried different versions of \i ... as you can see at the second picture, but I get the message "No such file or directory" again.
Actually it has to be work or not?
Kind regards
Attachments
populate.JPG
populate.JPG (58.97 KiB) Viewed 5028 times
NUser
 
Posts: 18
Joined: Wed Feb 03, 2010 11:38 am

Re: Can´t populate my database OMERO4.1_0 sql

Postby NUser » Wed Feb 03, 2010 3:34 pm

the other picture
Attachments
omero_sql.JPG
omero_sql.JPG (42.84 KiB) Viewed 5028 times
NUser
 
Posts: 18
Joined: Wed Feb 03, 2010 11:38 am

Re: Can´t populate my database OMERO4.1_0 sql

Postby jmoore » Wed Feb 03, 2010 3:46 pm

I think the problem is that you are only using one underscore: The file has two "__" (which looks the same as "_"). ~J
User avatar
jmoore
Site Admin
 
Posts: 1591
Joined: Fri May 22, 2009 1:29 pm
Location: Germany

Next

Return to Installation and Deployment

Who is online

Users browsing this forum: No registered users and 1 guest