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