http://wiki.logicaldoc.com/wiki/index.php?title=Installation_using_MySQL_database&feed=atom&action=historyInstallation using MySQL database - Revision history2024-03-28T12:09:33ZRevision history for this page on the wikiMediaWiki 1.32.2http://wiki.logicaldoc.com/wiki/index.php?title=Installation_using_MySQL_database&diff=1254&oldid=prevBlucecio at 07:19, 24 August 20102010-08-24T07:19:37Z<p></p>
<p><b>New page</b></p><div>__TOC__ <br> Starting from LD 5.0 MySQL 5.1 is the recommended external RDBMS for the software.<br>LogicalDOC Enterprise Edition installs this database during the installation procedure.<br> <br> Follow the steps required to perform the installation. <br />
<br />
== Proceed with the installation of the MySQL database ==<br />
<br />
MySQL 5.1) Download the installer: mysql-5.1.37-win32.msi<br> <br />
<br />
=== Perform the installation of MySQL ===<br />
<br />
[[Image:MySQL Database Usage.gif|thumb|left|100px|MySQL Database Usage]] <br />
<br />
*select Typical as type of setup<br> <br />
*select Detailed Configuration<br> <br />
*select Developer Machine<br> <br />
*select Multifunctional Database<br><br />
<br />
Proceed to complete the installation<br> <br> the most important thing in my opinion is set the usage of the database as Multifunctional. <br />
<br />
== Connect to the server and create the DB schema for LogicalDOC ==<br />
<br />
launch the MySQL Command Line Client<br> <br> connect as root with the password you previously asseigned to the user.<br> <br> launch the following commands:<br> <br> CREATE DATABASE logicaldoc;<br> <br />
<br />
GRANT ALL PRIVILEGES ON *.* TO 'logicaldoc'@'%' IDENTIFIED BY 'sa' WITH GRANT OPTION;<br> (this create a user 'logicaldoc' with password 'sa' that can access the db from every host)<br> <br> FLUSH PRIVILEGES;<br> <br> COMMIT;<br> <br> EXIT; <br />
<br />
== Run the setup of LogicalDOC ==<br />
<br />
Log on to the setup of your. application LogicalDOC<br> http://localhost:8080/logicaldoc/setup/<br> <br />
<br />
=== Select the MySQL DB ===<br />
<br />
[[Image:Database Configuration.gif|thumb|left|100px|Database Configuration]]enter the jdbc Connection Url for the database:<br> jdbc:mysql://localhost:3306/logicaldoc<br> <br />
<br />
specify "logicaldoc" as the Username, "sa" as the Password<br> <br> Start the creation of tables and the population of the initial data by pressing the button on the right (Continue).<br> <br> If you still have problem to complete the setup procedure try to compare the file my.ini in your MySQL installation folder with that other contained in this compressed archive [[Media:My.zip|my.zip]] <br />
<br />
<br></div>Blucecio