--------------
drop table if exists applentity, patient, study, series, image, dbjob, privilege, autoroute
--------------
Query OK, 0 rows affected, 8 warnings
--------------
drop table if exists worklist, scheduledps, protocolcode, requestedprocedure, procedurecode
--------------
Query OK, 0 rows affected, 5 warnings
--------------
drop table if exists referencedstudy, referencedpatient, referencedvisit, referencedpps
--------------
Query OK, 0 rows affected, 4 warnings
--------------
drop table if exists coercion, export, conceptname, autopurge, postroute, config, annotation
--------------
Query OK, 0 rows affected, 7 warnings
--------------
drop table if exists cronjob, studynotes, imagenotes, attachment, download, journal, smtp
--------------
Query OK, 0 rows affected, 7 warnings
--------------
create table applentity (
title VARCHAR(16) NOT NULL,
description VARCHAR(64),
hostname VARCHAR(64),
ipaddr VARCHAR(64),
port INT,
allowaccess BOOL DEFAULT 0,
archivedir VARCHAR(255),
queryScp BOOL DEFAULT 0,
worklistScp BOOL DEFAULT 0,
printScp BOOL DEFAULT 0,
maxsessions INT DEFAULT 10,
printerType VARCHAR(64),
PRIMARY KEY (title))
--------------
Query OK, 0 rows affected
--------------
create table patient (
origid VARCHAR(64) NOT NULL,
lastname VARCHAR(64) NOT NULL,
firstname VARCHAR(64) NOT NULL,
middlename VARCHAR(64),
prefix VARCHAR(64),
suffix VARCHAR(64),
birthdate DATE,
birthtime TIME,
sex VARCHAR(16),
otherid VARCHAR(64),
othername VARCHAR(64),
ethnicgroup VARCHAR(16),
institution VARCHAR(64),
comments TEXT,
age FLOAT,
height FLOAT,
weight FLOAT,
occupation VARCHAR(16),
history TEXT,
private BOOL DEFAULT 1,
lastaccess TIMESTAMP,
PRIMARY KEY (origid),
INDEX fullname (lastname, firstname))
--------------
Query OK, 0 rows affected
--------------
create table study (
uid VARCHAR(64) NOT NULL,
id VARCHAR(16) NOT NULL,
patientid VARCHAR(64) NOT NULL,
date DATE,
time TIME,
accessionnum VARCHAR(16),
modalities VARCHAR(16),
referringphysician VARCHAR(64),
description VARCHAR(64),
readingphysician VARCHAR(64),
admittingdiagnoses VARCHAR(64),
interpretationauthor VARCHAR(64),
private BOOL DEFAULT 1,
received DATE,
PRIMARY KEY (uid),
INDEX (id(10)),
INDEX (patientid))
--------------
Query OK, 0 rows affected
--------------
create table series (
uid VARCHAR(64) NOT NULL,
studyuid VARCHAR(64) NOT NULL,
description VARCHAR(64),
date DATE,
time TIME,
modality VARCHAR(16),
bodypart VARCHAR(16),
number INT,
instances INT,
PRIMARY KEY (uid),
INDEX (studyuid))
--------------
Query OK, 0 rows affected
--------------
create table image (
uid VARCHAR(64) NOT NULL,
sopclass VARCHAR(64) NOT NULL,
seriesuid VARCHAR(64) NOT NULL,
xfersyntax VARCHAR(64) NOT NULL DEFAULT '1.2.840.10008.1.2',
date DATE,
time TIME,
instance INT,
overlay INT,
curve INT,
lut INT,
samplesperpixel SMALLINT,
numrows SMALLINT,
numcolumns SMALLINT,
bitsallocated SMALLINT,
bitsstored SMALLINT,
pixelrepresentation SMALLINT,
path VARCHAR(255) NOT NULL,
completion VARCHAR(16),
description VARCHAR(64),
verification VARCHAR(16),
contentdate DATE,
contenttime TIME,
observationdatetime DATETIME,
verificationdatetime DATETIME,
PRIMARY KEY (uid),
INDEX (seriesuid))
--------------
Query OK, 0 rows affected
--------------
create table dbjob (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
user VARCHAR(16) NOT NULL,
aetitle VARCHAR(255) NOT NULL,
type VARCHAR(16) NOT NULL,
level VARCHAR(16) NOT NULL,
uid VARCHAR(64) NOT NULL,
schedule SMALLINT,
priority SMALLINT,
submittime DATETIME,
starttime DATETIME,
finishtime DATETIME,
status VARCHAR(16),
retries TINYINT DEFAULT 0,
details TEXT,
PRIMARY KEY (id))
--------------
Query OK, 0 rows affected
--------------
create table privilege (
user VARCHAR(64) NOT NULL,
firstname VARCHAR(64) NOT NULL,
lastname VARCHAR(64) NOT NULL,
middlename VARCHAR(64),
email VARCHAR(64),
view BOOL DEFAULT 0,
modify BOOL DEFAULT 0,
forward BOOL DEFAULT 0,
query BOOL DEFAULT 0,
move BOOL DEFAULT 0,
download BOOL DEFAULT 0,
print BOOL DEFAULT 0,
export BOOL DEFAULT 0,
import BOOL DEFAULT 0,
PRIMARY KEY (user))
--------------
Query OK, 0 rows affected
--------------
create table autoroute (
source VARCHAR(16) NOT NULL,
keytag INT UNSIGNED NOT NULL DEFAULT 0,
pattern VARCHAR(64),
destination VARCHAR(16) NOT NULL,
schedule SMALLINT NOT NULL DEFAULT -1,
autopurge BOOL NOT NULL DEFAULT 0,
window INT UNSIGNED DEFAULT 0,
enabled BOOL NOT NULL DEFAULT 1,
PRIMARY KEY (source, keytag, destination))
--------------
Query OK, 0 rows affected
--------------
create table worklist (
studyuid VARCHAR(64) NOT NULL,
id VARCHAR(16),
state VARCHAR(16),
classuid VARCHAR(64),
patientname VARCHAR(64),
patientid VARCHAR(64),
birthdate DATE,
sex VARCHAR(16),
accessionnum VARCHAR(16),
requestingphysician VARCHAR(64),
referringphysician VARCHAR(64),
createdate DATE,
createtime TIME,
creatoruid VARCHAR(64),
scheduledstartdate DATE,
scheduledstarttime TIME,
location VARCHAR(16),
aetitle VARCHAR(16),
arrivedate DATE,
arrivetime TIME,
startdate DATE,
starttime TIME,
completedate DATE,
completetime TIME,
verifydate DATE,
verifytime TIME,
readdate DATE,
readtime TIME,
PRIMARY KEY (studyuid))
--------------
Query OK, 0 rows affected
--------------
create table scheduledps (
studyuid VARCHAR(64) NOT NULL,
aetitle VARCHAR(16) NOT NULL,
startdate DATE NOT NULL,
starttime TIME NOT NULL,
modality VARCHAR(16) NOT NULL,
id VARCHAR(16) NOT NULL,
performingphysician VARCHAR(64),
description VARCHAR(64),
station VARCHAR(16),
location VARCHAR(16),
premedication VARCHAR(64),
contrastagent VARCHAR(64),
status VARCHAR(16),
PRIMARY KEY (studyuid))
--------------
Query OK, 0 rows affected
--------------
create table protocolcode (
studyuid VARCHAR(64) NOT NULL,
value VARCHAR(16) NOT NULL,
schemedesignator VARCHAR(16) NOT NULL,
schemeversion VARCHAR(16),
meaning VARCHAR(64),
PRIMARY KEY (studyuid, value, schemedesignator))
--------------
Query OK, 0 rows affected
--------------
create table requestedprocedure (
studyuid VARCHAR(64) NOT NULL,
id VARCHAR(16) NOT NULL,
description VARCHAR(64),
priority VARCHAR(16),
PRIMARY KEY (studyuid))
--------------
Query OK, 0 rows affected
--------------
create table procedurecode (
studyuid VARCHAR(64) NOT NULL,
value VARCHAR(16) NOT NULL,
schemedesignator VARCHAR(16) NOT NULL,
schemeversion VARCHAR(16),
meaning VARCHAR(64),
PRIMARY KEY (studyuid, value, schemedesignator))
--------------
Query OK, 0 rows affected
--------------
create table referencedstudy (
studyuid VARCHAR(64) NOT NULL,
classuid VARCHAR(64),
instanceuid VARCHAR(64),
PRIMARY KEY (studyuid))
--------------
Query OK, 0 rows affected
--------------
create table referencedpatient (
studyuid VARCHAR(64) NOT NULL,
classuid VARCHAR(64),
instanceuid VARCHAR(64),
PRIMARY KEY (studyuid))
--------------
Query OK, 0 rows affected
--------------
create table referencedvisit (
studyuid VARCHAR(64) NOT NULL,
classuid VARCHAR(64),
instanceuid VARCHAR(64),
PRIMARY KEY (studyuid))
--------------
Query OK, 0 rows affected
--------------
create table referencedpps (
studyuid VARCHAR(64) NOT NULL,
classuid VARCHAR(64),
instanceuid VARCHAR(64),
PRIMARY KEY (studyuid))
--------------
Query OK, 0 rows affected
--------------
create table coercion (
aetitle VARCHAR(16) NOT NULL,
description VARCHAR(64),
tag INT NOT NULL,
syntax VARCHAR(64) NOT NULL,
sequence INT NOT NULL DEFAULT 1,
PRIMARY KEY (aetitle, tag, sequence))
--------------
Query OK, 0 rows affected
--------------
create table export (
seq INT UNSIGNED NOT NULL AUTO_INCREMENT,
jobid INT UNSIGNED NOT NULL,
level VARCHAR(16) NOT NULL,
uid VARCHAR(64) NOT NULL,
PRIMARY KEY(seq))
--------------
Query OK, 0 rows affected
--------------
create table conceptname (
uid VARCHAR(64) NOT NULL,
value VARCHAR(16),
schemedesignator VARCHAR(16),
schemeversion VARCHAR(16),
meaning VARCHAR(64),
PRIMARY KEY (uid))
--------------
Query OK, 0 rows affected
--------------
create table autopurge (
directory VARCHAR(255) NOT NULL,
enable BOOL DEFAULT 0,
lowwater TINYINT,
highwater TINYINT,
schedule TINYINT NOT NULL DEFAULT 0,
destdir VARCHAR(255),
PRIMARY KEY (directory))
--------------
Query OK, 0 rows affected
--------------
create table postroute (
jobid INT UNSIGNED NOT NULL,
uid VARCHAR(64) NOT NULL,
PRIMARY KEY (jobid))
--------------
Query OK, 0 rows affected
--------------
create table config (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
aetitle VARCHAR(16) NOT NULL,
port INT,
patientpage TINYINT NOT NULL DEFAULT 10,
imagepage TINYINT NOT NULL DEFAULT 10,
adminemail VARCHAR(255),
phpexe VARCHAR(255),
PRIMARY KEY (id))
--------------
Query OK, 0 rows affected
--------------
create table annotation (
printer VARCHAR(16) NOT NULL,
format VARCHAR(64),
position INT UNSIGNED NOT NULL,
text VARCHAR(64) NOT NULL,
PRIMARY KEY (printer, format, position))
--------------
Query OK, 0 rows affected
--------------
create table cronjob (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
user VARCHAR(16) NOT NULL,
aetitle VARCHAR(16) NOT NULL,
type VARCHAR(16) NOT NULL,
level VARCHAR(16) NOT NULL,
uid VARCHAR(64) NOT NULL,
schedule SMALLINT,
priority SMALLINT,
PRIMARY KEY (id))
--------------
Query OK, 0 rows affected
--------------
create table studynotes (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
uid VARCHAR(64) NOT NULL,
user VARCHAR(16) NOT NULL,
created DATETIME NOT NULL,
notes VARCHAR(1024),
attachment VARCHAR(255),
PRIMARY KEY (id),
INDEX (uid),
INDEX (created))
--------------
Query OK, 0 rows affected, 1 warning
--------------
create table imagenotes (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
uid VARCHAR(64) NOT NULL,
user VARCHAR(16) NOT NULL,
created DATETIME NOT NULL,
notes VARCHAR(1024),
attachment VARCHAR(255),
PRIMARY KEY (id),
INDEX (uid),
INDEX (created))
--------------
Query OK, 0 rows affected, 1 warning
--------------
create table attachment (
id INT UNSIGNED NOT NULL,
path VARCHAR(255) NOT NULL,
mimetype VARCHAR(64) NOT NULL,
PRIMARY KEY(id),
INDEX (path))
--------------
Query OK, 0 rows affected
--------------
create table download (
id INT UNSIGNED NOT NULL,
volume INT UNSIGNED NOT NULL,
path VARCHAR(255) NOT NULL,
created DATETIME NOT NULL,
PRIMARY KEY (id))
--------------
Query OK, 0 rows affected
--------------
create table journal (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
timestamp DATETIME NOT NULL,
user VARCHAR(64) NOT NULL,
did VARCHAR(64) NOT NULL,
what VARCHAR(64) NOT NULL,
uid VARCHAR(64) NOT NULL,
details TEXT,
PRIMARY KEY (id),
INDEX (timestamp),
INDEX (uid))
--------------
Query OK, 0 rows affected
--------------
create table smtp (
hostname VARCHAR(128) NOT NULL,
port INT UNSIGNED NOT NULL DEFAULT 25,
description VARCHAR(255),
myemail VARCHAR(255) NOT NULL,
pop3host VARCHAR(128),
username VARCHAR(255),
password VARCHAR(255),
mechanism VARCHAR(32),
ntlmhost VARCHAR(128),
PRIMARY KEY (hostname))
--------------
Query OK, 0 rows affected
Bye
Invalid MySQL Password for Administrator
Same problem in windows
Hi,
I swtiched over to windows and I got the exact same problem.
I think that there is an error with your database adapter.
It would probably help more if your code was open source. Have you read over the licensing for mysql carefully?
Under the Open Source License, you must release the complete source code for the application that is built on MySQL. You do not need to release the source code for components that are generally installed on the operating system on which your application runs, such as system header files or libraries.
I swtiched over to windows and I got the exact same problem.
I think that there is an error with your database adapter.
It would probably help more if your code was open source. Have you read over the licensing for mysql carefully?
Under the Open Source License, you must release the complete source code for the application that is built on MySQL. You do not need to release the source code for components that are generally installed on the operating system on which your application runs, such as system header files or libraries.
It appears that the version of MySQL you're using (4.1.14) is no longer compatible with older client libraries (again! 
). We'll need to install this version of MySQL and see if we can reproduce the problem you're seeing.
In the meantime, the error you got was not critical, it just means the installer could not save the AE Title and port number into the database. To work around this issue, you can manually setup the config table by logging into the MySQL database and issue the following query:
). We'll need to install this version of MySQL and see if we can reproduce the problem you're seeing.In the meantime, the error you got was not critical, it just means the installer could not save the AE Title and port number into the database. To work around this issue, you can manually setup the config table by logging into the MySQL database and issue the following query:
Code: Select all
# mysql -u root -p pacsone
mysql>insert into config set aetitle='ap3rinter2',port=104;
Re: Same problem in windows
PacsOne is an application that is a client/user of MySQL, but not an application built on MySQL, so these terms you quoted do not apply. That's the reason why we are not distributing any MySQL files with the PacsOne Server package, it is actually the end-user who would have to download a version of MySQL and install it on their servers.retsil wrote: Under the Open Source License, you must release the complete source code for the application that is built on MySQL. You do not need to release the source code for components that are generally installed on the operating system on which your application runs, such as system header files or libraries.
In future releases of PacsOne Server, we'll be adapting to the ODBC model to include support not only for MySQL, but also for any DBMS which provides an ODBC interface.
-
A
Code: Select all
# mysql -u root -p pacsone
mysql>insert into config set aetitle='ap3rinter2',port=104;
That didn't work for me.
Fedora Core 4
mysql 4.1.11
I still got:
MySQL: Couldn't connect to: pacsone, error = Access denied for user 'user'@'localhost' (using password: YES), user = user
This error means MySql could not connect to the database pacsone as username: user, so you need to make sure:A wrote: MySQL: Couldn't connect to: pacsone, error = Access denied for user 'user'@'localhost' (using password: YES), user = user
1. The database pacsone does exist
2. The username user does exist and is granted access to the database pacsone
-
Guest
I can access to pacsone database by mysql -u user -p pacsone.pacsone wrote:This error means MySql could not connect to the database pacsone as username: user, so you need to make sure:A wrote: MySQL: Couldn't connect to: pacsone, error = Access denied for user 'user'@'localhost' (using password: YES), user = user
1. The database pacsone does exist
Database pacsone exists.
2. The username user does exist and is granted access to the database pacsone
I even see that there are patients (witch I importet thought pacsone web interface) in database.
mysql> SELECT * FROM patient;
+--------+-------------------+-----------+------------+--------+--------+------------+-----------+------+---------+-----------+-------------+------------------------------+----------------------------+------+--------+--------+------------+---------+---------+---------------------+
| origid | lastname | firstname | middlename | prefix | suffix | birthdate | birthtime | sex | otherid | othername | ethnicgroup | institution | comments | age | height | weight | occupation | history | private | lastaccess |
+--------+-------------------+-----------+------------+--------+--------+------------+-----------+------+---------+-----------+-------------+------------------------------+----------------------------+------+--------+--------+------------+---------+---------+---------------------+
| | Anonymized | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | TOKYO M and D UNIV. HOSPITAL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 2005-12-15 02:03:15 |
| 55 | MRTLWS | | NULL | NULL | NULL | 0000-00-00 | NULL | F | NULL | NULL | NULL | Dres.Wünsche | NULL | 26 | NULL | 95 | NULL | NULL | 0 | 2005-12-15 02:26:32 |
| 22 | MammaOriginal | | NULL | NULL | NULL | 0000-00-00 | NULL | F | NULL | NULL | NULL | Dres.Wünsche | Anonymized with DicomWorks | NULL | NULL | NULL | NULL | NULL | 0 | 2005-12-15 02:19:14 |
| 33 | Rö-ThoraxOriginal | | NULL | NULL | NULL | 0000-00-00 | NULL | M | NULL | NULL | NULL | Dres.Wünsche | Anonymized with DicomWorks | NULL | NULL | NULL | NULL | NULL | 0 | 2005-12-15 02:26:10 |
| 77 | GKSZOriginal | | NULL | NULL | NULL | 0000-00-00 | NULL | F | NULL | NULL | NULL | Dres.Wünsche | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 2005-12-15 12:13:01 |
+--------+-------------------+-----------+------------+--------+--------+------------+-----------+------+---------+-----------+-------------+------------------------------+----------------------------+------+--------+--------+------------+---------+---------+---------------------+
5 rows in set (0.01 sec)
So sould I simply ignore that error message?