[Web-meetme-users] cbmysql database setup

[Ludovic F. <lu...@ep...>]

Hi,

I  have   some  problems   to  initialize  my   mysql  db   with  your
db-table-create-v5.txt, v5 it's maybe for mysql version 5?

Below my  procedure to  install it,  maybe it will  be welcome  in the
README document some word about the db setting.

Best Regards, Ludo


mysql version
=============

root@obelix:...terisk/web-meetme_cvs/cbmysql # dpkg -l | grep mysql-server
ii  mysql-server-4.1                 4.1.15-1                    mysql database server binaries
root@obelix:...terisk/web-meetme_cvs/cbmysql #                                        

db creation and permission setting
==================================

root@obelix:...terisk/web-meetme_cvs/cbmysql # mysqladmin -p create DB_CDR                                                                                   Err 1 #5441
Enter password:
root@obelix:...terisk/web-meetme_cvs/cbmysql # mysql -p                                                                                                      13:53 #5442
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1999 to server version: 4.1.15-Debian_1-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all on DB_CDR.* to 'asterisk'@'localhost' identified by 'asterisk';
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

db initialization
=================

root@obelix:...terisk/web-meetme_cvs/cbmysql # mysql -p -u webmeet < db-table-create-v5.txt
Enter password: 
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''seq
uenceNo' INTEGER UNSIGNED DEFAULT 0,                                                                                                                                       'recurInterval' INTEGER UNSIGNED DEFA' at line 17
root@obelix:...terisk/web-meetme_cvs/cbmysql #

-- 
Ludovic Francois                +33 (0)6 20 67 05 42