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

[Blazej Pindelski]

> 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!
>

Hi Angelos,

That's great news. The final thing I would like to recommend is to use the development/debug OMERO.web server only for demo/debug.
There is extensive documentation available regarding deployment of a production OMERO.web instance under Windows (http://www.openmicroscopy.org/site/support/omero4/sysadmins/windows/install-web.html).

> Best wishes,
> Angelos

Regards,
Blazej

> 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
>>
>
>


The University of Dundee is a registered Scottish Charity, No: SC015096