Cannot create database in MySQL

Torsten Bronger <[email protected]> Fri, 30 Jan 2009 20:33:19 +0100
Newsgroups gmane.text.refdb.general
Organization Phoenix Foundation
Message-ID <[email protected]>
Hallöchen!

I installed RefDB 0.9.8 on an Ubuntu Server 8.04 running MySQL
(which was already there, as was an Apache).  The installation
showed no error messages, however, createdb fails with

    refdba: createdb references
    999:0 created:1 failed

The daemon says

    bronger@bob:~$ sudo refdbd -s -e 0 -l 7
    dbi_driver_dir went to:

    dbi is up using default driver dir
    Available libdbi database drivers:
    mysql
    sqlite
    Requested libdbi driver found
    Database directory:
    /var/lib/refdb/db
    application server started
    share extended notes by default
    use /tmp/refdbd_fifo19841 as fifo
    server waiting n_max_fd=4
    adding client 127.0.0.1 on fd 5
    server waiting n_max_fd=5
    try to read from client
    serving client on fd 5 with protocol version 5
    210-44-10-38
    send pseudo-random string to client
    parent removing client on fd 5
    server waiting n_max_fd=4
    createdb references -u root -w 07909**********
    dbi is up
    localhost
    root
    *****


    mysql
    /var/lib/refdb/db

    refdb
    connected to database server using database:
    refdb
    updated version file:
    /var/lib/refdb/db/DB_VERSION
    Main database looks ok:
    refdb
    localhost
    root
    *****


    mysql
    /var/lib/refdb/db
    UTF-8
    refdb
    connected to database server using database:
    refdb
    SELECT VERSION()
    CREATE DATABASE references CHARACTER SET 'utf8'
    1064: 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 'references CHARACTER SET 'utf8'' at line 1
    could not create reference database
    command processing done, finish dialog now
    child finished client on fd 5
    child exited with code 0
    server waiting n_max_fd=4

The MySQL database uses by default InnoDB with UTF8.

Can someone tell me what's going wrong?  Thank you!

Tschö,
Torsten.

-- 
Torsten Bronger, aquisgrana, europa vetus
                   Jabber ID: [email protected]


------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword