{"id":1422,"date":"2018-05-30T12:25:39","date_gmt":"2018-05-30T16:25:39","guid":{"rendered":"https:\/\/www.collectionsmax.com\/index.php\/docs\/installation\/running-the-database-installation-wizard"},"modified":"2018-09-11T14:02:06","modified_gmt":"2018-09-11T18:02:06","slug":"running-the-database-installation-wizard","status":"publish","type":"docs","link":"https:\/\/www.collectionsmax.com\/index.php\/docs\/installation\/running-the-database-installation-wizard","title":{"rendered":"Running the Database Installation Wizard"},"content":{"rendered":"<div class=\"p\">You should have installed the Collections MAX Database installation Wizard when you installed the Collections MAX applications.\u00a0 Start the Collections MAX Database Installation Wizard by clicking Start \/ All Programs\/ Collections MAX Database Installation Wizard V4\/ Collections MAX Database Installation Wizard V4.<\/div>\n<div class=\"p\">If you have an icon on the desktop you can double click that instead to start the program.<\/div>\n<div class=\"p\"><\/div>\n<div class=\"p\">As stated before&#8230;.the Collections MAX Database Installation Wizard is a GUI for installing the collectionsmax database into MariaDB and configuring your initial user names and passwords.<\/div>\n<div class=\"p\">You need to have installed and configured MariaDB already before performing these steps.<\/div>\n<div><\/div>\n<div><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1478\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard1.png\" alt=\"\" width=\"258\" height=\"444\" srcset=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard1.png 258w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard1-174x300.png 174w\" sizes=\"(max-width: 258px) 100vw, 258px\" \/><\/div>\n<div><\/div>\n<div>\n<div class=\"p\">When you run the wizard&#8230;.this is the first screen you will see.\u00a0 Click the Next button.<\/div>\n<\/div>\n<div><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1479\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard2.png\" alt=\"\" width=\"466\" height=\"537\" srcset=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard2.png 466w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard2-260x300.png 260w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard2-300x346.png 300w\" sizes=\"(max-width: 466px) 100vw, 466px\" \/><\/div>\n<div><\/div>\n<div>\n<div class=\"p\">In this screen you need to enter the MariaDB(MySQL)\u00a0 root password that you set up in previous steps <strong>EXACTLY<\/strong> as it was created.\u00a0 This password is CASE SENSITIVE!\u00a0 If MariaDB(MySQL) is installed on the computer you are running the wizard on leave the first radio button checked that says &#8220;When you installed MySQL Server did you install it on THIS machine&#8221; to YES.\u00a0 Otherwise click NO and enter the ip address of the MariaDB(MySQL) machine.<strong> If you are connecting to a remote machine with the wizard you have to open port 3306 TCP on the firewalls of all computers both inbound and outbound in order to connect.<\/strong><\/div>\n<div class=\"p\"><\/div>\n<div class=\"p\">After entering your root password click NEXT.<\/div>\n<div class=\"p\"><\/div>\n<div class=\"p\"><span class=\"de_CF136AA7C2\"><strong>NOTE: On some machines the host file might be corrupted.\u00a0 In these rare instances you might need to change the &#8220;When you installed MySQL Server did you install it on THIS machine&#8221; to NO and then enter 127.0.0.1 for the server ip address.<\/strong><\/span><\/div>\n<\/div>\n<div class=\"p\"><\/div>\n<div><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1480\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard3.png\" alt=\"\" width=\"468\" height=\"486\" srcset=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard3.png 468w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard3-289x300.png 289w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard3-300x312.png 300w\" sizes=\"(max-width: 468px) 100vw, 468px\" \/><\/div>\n<div><\/div>\n<div>If the Collections MAX Database Installation Wizard can connect to the MySQL database you will see the green box below that says &#8220;CONNECTED TO MYSQL. ONE MOMENT PLEASE&#8221; . This means that the root password was correct. If the root password was NOT CORRECT the box will turn red and the error message will be displayed in the box. If this happens try your root password again and click the NEXT button again until MySQL accepts your root password.<\/div>\n<div><\/div>\n<div><\/div>\n<div>\n<div class=\"p\">If your root password was correct on this screen you are setting up your initial user names and passwords to access the system as shown below.\u00a0 Make sure to keep your user names and passwords under 16 characters or they will become truncated.\u00a0 The system needs an initial manager and collector.\u00a0 If you want to setup additional managers, administrators or collectors you can do so in the Additional User fields by putting a check in the box to activate the user.<\/div>\n<div class=\"p\">Please make sure that you are connected to the internet.\u00a0 After you have created your users click the INSTALL button to begin installation of the database.<\/div>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1482\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard4.png\" alt=\"\" width=\"604\" height=\"480\" srcset=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard4.png 604w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard4-300x238.png 300w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard4-600x477.png 600w\" sizes=\"(max-width: 604px) 100vw, 604px\" \/><\/div>\n<div><\/div>\n<div>\n<div class=\"p\">The Database Installation Wizard\u00a0 is now creating the database,\u00a0 building the routing number database and creating your users.<\/div>\n<div class=\"p\">Please sit back and wait until this process is over.\u00a0 It can take between 2-10 minutes depending on the speed of your system.<\/div>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1487\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard5.png\" alt=\"\" width=\"540\" height=\"179\" srcset=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard5.png 540w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard5-300x99.png 300w\" sizes=\"(max-width: 540px) 100vw, 540px\" \/><\/div>\n<div><\/div>\n<div>\n<div class=\"p\">After your installation is complete you will see your login information.\u00a0 Make sure to write these down.<\/div>\n<div class=\"p\">The next page will detail how to gain access to Collections MAX Administrator.<\/div>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1488\" src=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard6.png\" alt=\"\" width=\"506\" height=\"693\" srcset=\"https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard6.png 506w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard6-219x300.png 219w, https:\/\/www.collectionsmax.com\/wp-content\/uploads\/2018\/05\/dbwizard6-300x411.png 300w\" sizes=\"(max-width: 506px) 100vw, 506px\" \/><\/div>\n<div><\/div>\n<div><\/div>\n","protected":false},"featured_media":0,"parent":1384,"menu_order":5,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"comment_count":0,"_links":{"self":[{"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/docs\/1422"}],"collection":[{"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/comments?post=1422"}],"version-history":[{"count":0,"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/docs\/1422\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/docs\/1384"}],"next":[{"title":"Logging into Administrator","link":"https:\/\/www.collectionsmax.com\/index.php\/docs\/installation\/logging-into-collections-max-administrator","href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/docs\/1490"}],"prev":[{"title":"Installing and configuring MariaDB","link":"https:\/\/www.collectionsmax.com\/index.php\/docs\/installation\/installing-and-configuring-mariadb","href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/docs\/1421"}],"wp:attachment":[{"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/media?parent=1422"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.collectionsmax.com\/index.php\/wp-json\/wp\/v2\/doc_tag?post=1422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}