cattaDoc Installation Step 2: Create MySQL backend database 

cattaDoc Installation Step 2:
Create MySQL backend database

Create the cattaDoc database and database users

cattaDoc uses a MySQL database for all its data, except documents and library files.

Create a new database in MySQL for cattaDoc:

 

Create database in Windows

Here is what you do in Windows:

  1. Open a command prompt ("DOS Window")

  2. Go to the sub-folder db in the cattaDoc folder

  3. Run the batch file createdatabase.bat with username for a MySQL system administrator as first argument and the associated, optional password as second argument, ie.:

    createdatabase username [password]

Note: You have to change the MySQL installation path in createdatabase.bat, if not installed in the default C:\mysql.

 

Create database in Linux

Run the shell script createdatabase from the sub-directory db in the cattaDoc directory.

./createdatabase

You are prompted for a username and password for a MySQL system administrator.

 

What is done?

Both scripts do the same:

  1. Create a MySQL database with the name cattadoc

    Note: If you want another database name, you'll have to change the name in 3 files:
    • The script / command file, createdatabase(.bat)
    • The database creation file, createcddb.sql
    • The users file, createuser.sql

  2. Create 3 MySQL users with the following roles / permissions:
    • cda: System administrator
    • cdw: Normal user with read and write permissions
    • cdr: A read-only user

    Note: I will strongly advise you to change the default passwords for the 3 MySQL users. Do it in the input file createuser.sql before running the script.

  3. Create the cattaDoc database structure with tables, initial master data, etc.

MySQL reports warnings about using a password on the command line. It is normal. You can ignore these warnings.

 



Comments

3 comments for this page


3 Giovanni (Napoli - Italia) wrote 2014-06-12 17:05:07 :

Login error
 Hello,
about the login error also reported in the faq.
I have the same problem but I don't think it cames fron wrong user or password. Is it possible an issue from Mysql connection or the php crypt function?
The error reported is:"Warning: mysql_connect(): [2002] Impossibile stabilire la connessione. Rifiuto persistente del computer di destinazione. (trying to connect via tcp://localhost:3306) in F:\cattadoc\adodb\drivers\adodb-mysql.inc.php on line 458 Warning: mysql_connect(): Impossibile stabilire la connessione. Rifiuto persistente del computer di destinazione. in F:\cattadoc\adodb\drivers\adodb-mysql.inc.php on line 458 Error! Error : Invalid username / password combination"
There is something to set in ADODB?
Thanks a lot.


2 Erik Maaløe (Copenhagen - Denmark) wrote 2010-02-02 15:28:28 :

Re. Cannot create 3 users
Hi Anton,

Thanks for your interest in cattaDoc.

The user cpitsob_cattadoc mentioned in the MySQL error message you get is not defined in the supplied cattaDoc installation files. cattaDoc assumes you have created the MySQL root user and then creates 3 additional users, cda, cdw and cdr.

Please try first with these users.

Best regards,
Erik


1 Anton (Christchurch - New Zealand) wrote 2010-01-28 08:34:43 :

cannot create 3 users
I succeed in creating my database but when I run the SQL query to create the 3 users I get this error message: #1044 - Access denied for user 'cpitsob_cattadoc'@'localhost' to database 'cpitsob_cattadoc'
Please advise

Leave a Comment

 
Revised: 2016-01-11