[ome-users] SQL Shell database initialisation - persmission issue, Windows 7 x64

[Angelos]

Hi Blazej,

This did the trick! Excellent! I tested already the installation with 
the Django development server, it looks great!

Thank you for the help!

Best wishes,
Angelos

On 8/2/13 11:14 AM, Blazej Pindelski wrote:
>> Dear list,
> Hi Angelos,
>
>> Yet again, I would need people's advice on some permission issue I encountered while trying to initialize the omero database. This is what I type in the SQL Shell, and the error I get:
>>
>> Server [localhost]:
>> Database [postgres]: omero_database
>> Port [5432]:
>> Username [postgres]: omero_db_users
>> Password for user omero_db_users:
>> psql (9.2.2)
>> WARNING: Console code page (437) differs from Windows code page (1252)
>>           8-bit characters might not work correctly. See psql reference
>>           page "Notes for Windows users" for details.
>> Type "help" for help.
>>
>> omero_database=> \i C:\omero_dist\OMERO4.4__0.sql
>> C:: Permission denied
>> omero_database=>
>
> That is one quirk of the psql shell on Windows. You'd have to use the forward slash ("/") as a path separator. So your command would look like this:
>
> omero_database=> \i C:/omero_dist/OMERO4.4__0.sql
>
> We have already an fixed version of the user docs that address this issue and the documentation will be soon updated.
>
>
>> I tried to back trace the installation steps, in case I overlooked anything, but to my best knowledge, I could not see any deviations from the described procedure.
>> I run the Shell as Administrator, but I got the same error again.
>>
>> Any insight on the matter is greatly appreciated!
>>
>> Thank you
>> -A
> Regards,
> Blazej
>
>> _______________________________________________
>> ome-users mailing list
>> ome-users at lists.openmicroscopy.org.uk
>> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
>
> The University of Dundee is a registered Scottish Charity, No: SC015096
>