setup woes

marneson · Post by **marneson** » Tue Oct 14, 2003 10:45 pm

when running setup (1.0.0.3) for an empty database, I leave the
"Drop and crete database tables" checked and I get this error:

---------------------------------------------------
Error configuring MySQL database NASA

MySQL Error: Error reading MySQL path: 2

Please verify the specified MySQL Username and Password are valid

---------------------------------------------------

The username & Password are valid. If I run setup withOUT checking the
"Drop and create database tables" I don't get any errors at all.

I can get into the database from the command prompt using the username & password entered in setup.

Any ideas?

Thanks
Mark
marneson@nasaradiology.com

Guest · Post by **Guest** » Wed Oct 15, 2003 3:21 am

This seems to indicate a MySQL installation issue.

The setup.exe program is trying to read the MySQL path from the following registry key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MySql\ImagePath\

The error message indicates that there's no such registry value. However, the fact that you can successfully run 'mysql' from a command shell means that you probably setup your system environment variable %PATH% to include the path to MySQL binaries.

Can you check the above registry settings and make sure the 'ImagePath' key exists and its string value points to where MySQL binaries were installed? (I think it's C:\mysql\bin\ by default)

Guest · Post by **Guest** » Wed Oct 15, 2003 3:59 am

Thanks. That seemed to work. I didn't have that value in the reg.

Now I get another error:

Error setting up database scheme: 1

the dbinstall.log has the "can't find command..." blurb like when you mis-type a bogus command at the C:\ prompt.

Any idea what it is trying to execute?

I put pacsone in the path just in case...no help

BTW, This is WinNT 4.0 workstation.
myql 4.0.15

Post by **pacsone** » Wed Oct 15, 2003 1:54 pm

The error message from dbinstall.log indicates it couldn't find the executable 'mysql.exe' from the path set in the registry key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MySql\ImagePath\

Make sure you can find the 'mysql.exe' executable underneath the above directory path.

Or you can use the following workaround:

http://pacsone.net/faq.htm#C3

Guest · Post by **Guest** » Wed Oct 15, 2003 2:46 pm

Bingo, that did the trick.

I had to cd to program files\pacsone and run the mysql command.

Guest · Post by **Guest** » Wed Oct 29, 2003 5:56 am

I tried to install PacsOne (1.0.0.

on Windows2000 Server (English ver.) with Mysql 4.0.15
and WindowsNT 4.0 with Mysql 4.0.15
I got a massege like 'MySQL Error;Error setting up database schema; 1' from both.

And I did just same as FAQ #3, but I got another massage.

'MySQL'is not recognized an internal or external command,
operable program or batch file.

So I check the registry key, but there is no 'ImagePath' key.
There is value as 'ImagePath:REG_EXPAND_SZ:C:/mysql/bin/mysqld-nt.exe'.

How do I set up it ?

PacsOne Server

setup woes

Check Windows registry settings

Registry settings