installation troubles

[W Brooks]

Hello, I have been trying to install and am having a terrible time of it. I have been using Windows 2000 server and Windows XP Pro as an OS. I installed mysql version 3.23.58 and installed as the install doc. Then installed Pacsone server (the free version). At this point I tried to send a C-Echo to the pacsone server. I get an association rejected error. Upon checking the log in pacsone I see an error pertaining to mysql no table applentity and then no table djob???This is not exact will get more detail tomorrow if will help. I see the AE Title of the pc sending then the erros in the log. should I be able to C-Echo with only mysql and pacsone loaded? Any help would be great.

W Brooks

[pacsone]

Looks like your MySQL database tables for PacsOne were not setup properly by the installer. You can manually set it up by following the steps below:

1. Stop PacsOne Server.

2. Open a Windows command shell and change directory to where PacsOne Server was installed.

3. Add MySQL path to your current PATH environment variable, e.g.,

set PATH=%PATH%;C:\mysql\bin

4. Type the following command from the shell prompt:

mysql -vvf -u {USERNAME} -p {DBNAME} < db_schema

where {USERNAME} is the MySQL username you've created for PacsOne and {DBNAME} is the name of the MySQL database you've created for PacsOne.

The above command should set up all PacsOne database tables for you.

5. Restart PacsOne Server.

After the above steps, your association requests will still be rejected unless you login to the web user interface and explicitly Enable access for the AE title from where you send the C-ECHO request.

[doktorpacs]

Okay you got me I set path set PATH=%PATH%;e:\mysql\bin
that much works!
Then from either e:\mysql or e:\mysql\bin I type the command
mysql --vvf -u pacsone -p dicom < db_schema
and it returns: the system cannot find the file specified.
I have loaded mysql 4.0.18 this time around on windows XP that is loaded on e: drive. It didn't look this difficult at first!!! Should I give up?

W Brooks

[fdisk]

My sympathies. I had to install/reinstall at least 5 times. The installation setup was never able to create the MySQL tables. Had to do this manually.

Remember to set privileges (create, delete etc) for database.

S.

[pacsone]

Okay you got me I set path set PATH=%PATH%;e:\mysql\bin
that much works!
Then from either e:\mysql or e:\mysql\bin I type the command
mysql --vvf -u pacsone -p dicom < db_schema
and it returns: the system cannot find the file specified.
I have loaded mysql 4.0.18 this time around on windows XP that is loaded on e: drive. It didn't look this difficult at first!!! Should I give up?

W Brooks

Looks like you skipped Step #2 and went straight for #3 above.

Anyway, if you were in E:\mysql or E:\mysql\bin, where would you expect the command shell to find "db_schema" file?

I'm starting to think about the idea of offering installation services for a fee, now that a number of users have reported installation troubles.