no database tables??

Trouble during PacsOne Server installations
Post Reply
bstamper
Posts:1
Joined:Thu Nov 17, 2005 7:56 pm
no database tables??

Post by bstamper » Thu Nov 17, 2005 8:12 pm

I'm attempting to install pacsone but for some reason can not get the database to create any initial tables. I go thru the install and it acts as tho it sets the AE title and sets up the database properly but when i'm done and i look at the database there is nothing there. Any ideas? Otherwise i think things are working properly so far.

pacsone
Site Admin
Posts:3149
Joined:Tue Sep 30, 2003 2:47 am

Post by pacsone » Thu Nov 17, 2005 8:25 pm

1. Are you installing a Windows or Linux version of PacsOne Server?

2. When the PacsOne installer finishes, it should have created a log file named db_install.log and you can check that file to see if there were any errors.

3. How did you tell there were no database tables?

Ruwan
Posts:1
Joined:Fri Feb 24, 2006 11:07 am

No DataBase tables ????

Post by Ruwan » Fri Feb 24, 2006 11:47 am

I also have the same promblem. I go thru the install and it acts as expected.but when i'm done and i look at the database there is nothing there.
db_install.log file says '"mysql.exe"' is not recognized as an internal or external command, operable program or batch file. What's wrong ????

pacsone
Site Admin
Posts:3149
Joined:Tue Sep 30, 2003 2:47 am

Post by pacsone » Fri Feb 24, 2006 1:48 pm

You must be running the Basic Edition of PacsOne Server as the installer for the Basic Edition sometimes would fail to find the MySQL client executable program mysql.exe (which would then result in empty MySQL database tables).

You can run the following manually to setup your database from a command shell:

1. Open a command shell and add the path to MySQL client program to the PATH. For example:

Code: Select all

C:\>path=%path%;C:\mysql\bin
2. Change dir to the directory where PacsOne is installed, the run the following:

Code: Select all

mysql -vvf -u $username -p $database < db_schema
where:

$database is the MySQL database you've created for PacsOne
$username is the MySQL username you've created for PacsOne

Post Reply