Page 1 of 1

Got error when I tried to import to new pacsone server machi

Posted: Sat Jan 21, 2006 1:15 am
by don
Hi Guy,
I was tried to import from current pacsone server (win2000) to new server (win2003). And I got the error...

Error: Failed to schedule database job for importing studies from E:/cd/VOL1/.
MySQL Error: Table 'pacsone.dbjob' doesn't exist

Do anyone know how to fix this error ? or how to transfer database from old pacsone server to new server.
Thx for any reply.
don

Posted: Sat Jan 21, 2006 2:19 am
by pacsone
This means the database tables on the server where you are performing the Import were not configured properly, since the dbjob table was missing from your database.

You can run the following query from a MySQL shell to check if your database is setup properly:

C:\mysql\bin>mysql -u $username -p $database

where:

$database/$username is the MySQL database/username you've assigned for PacsOne Server.

mysql>show tables;

Version 3.1.7 of PacsOne Server should have 31 tables while version 3.1.8 should have 32.

Posted: Tue Jan 24, 2006 7:05 pm
by Don
Hi Pacsone admin,
But when I tried and I got another error on new server neither on old server too.

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u $username -p $database
Enter password: **********
ERROR 1045 (28000): Access denied for user '$username'@'localhost' (using passwo
rd: YES)

thanks.

Posted: Wed Jan 25, 2006 3:32 am
by pacsone
This error means either your MySQL username or password is not valid for that server.

You can reset the MySQL username/password if you know the MySQL root password for that server.