Will mysql root password change fail the function of pacsone

[wenan chen]

Hi,

I have changed mysql root password using mysql safe mode because I
have forgotten the root password.

After changing the root password, I can log on the web interface of pacsone. I don't know whether this will fail the pacsone server or not.
Does pacsone server remember the root password to put data into mysql
database? If this is the case, then how can I may the pacsone server to
get the new password?

Thanks

[pacsone]

If you had configured PacsOne Server to use the root username to access MySQL during installation of PacsOne, and changed the MySQL root password afterwards, then PacsOne would no longer be able to connect to MySQL since it remembers the old password for root which has been changed without its knowledge.

It's not recommended to run PacsOne Server using the MySQL root username, since it's reserved for the System Administrator and it's subject to frequent password changes. So you should re-assign a new MySQL username to PacsOne Server, by running the Setup.exe program under the directory where PacsOne is installed. Make sure you specify the same AE Title, TCP port and database name, but enter a new username/password for use by PacsOne and the Installer will set it up automatically. Be sure to uncheck the Drop and create database tables checkbox, so that the Installer will perform an upgrade instead of a fresh new install.

[wenan chen]

Thank you for your replay. I still have some questions.

Before I change the root password, there was already a regular user in mysql and pacsone. I have forgotten both the root and this user name. Now in pacsone web interface I have changed the regular user's password. I don't know whether it will make pacsone use the new password. Do I need to use setup.exe to do it again?

Another question is that I found that pacsone is running by user root of the linux system. Does it mean that it will use the root account in mysql or the regular user of mysql system. The names of the regular user name in both the linux system and the mysql database are the same name but different password. In order to make the pacsone use the regular user name to access the database and store data, should I run the program by the regular user from the command line?


Thank you.

[pacsone]

1. If you changed the password for the MySQL username (root or a different MySQL username), then you should run the Setup.exe program under the directory where PacsOne is installed again, and specify the same AE Title, TCP port, MysQL database, but a different MySQL username/password. We recommend reserving a dedicated MySQL username for use by PacsOne Server, which should be different from the System Administrator (root) or the regular web users you create/administer through the User Administration page of PacsOne Server.

2. The MySQl root username and the Linux root account are not related and are independent of each other, although they should both be reserved for use by the System Administrator. By default, the PacsOne Server service is configured to run under the context of Linux root user account and daemon group account, as PacsOne Server is running as a system-level service. Since PacsOne Server is a client of MySQL, you can assign any MySQL username (we recommend not to use the special root MySQL username) for use by PacsOne Server to connect to MySQL.