Error during database connection check

[Daouneizh]

Hello,

When I try to check my database connection, here is what I get :
Database test
create table OK
insert Necessary. You can not continue until this function works!
select Necessary. You can not continue until this function works!
delete Necessary. You can not continue until this function works!
drop table OK

I checked the rights for the MySQL user I created, he has all rights on limbas db ... it makes no sense to me, may you help ?

Thanks

Denis

[Axel Westhagen]

Hi

Because of supporting a couple of databases limbas is "not case sensitive" in table and field names
You have to set lowercase tablenames in /etc/my.cnf
lower_case_table_names = 1

http://en.limbas.org/wiki/-MySQL#Configuration

Axel

[Daouneizh]

An update :
I tried to create a new MySQL db on another server, with exactly the same result.

I even tried with root access, exactly the same as well : create and drop ok, insert, select, delect nok

Crazy, isn't it ?

[Daouneizh]

Danke Axel !

Indeed, I had done the suggested change but I had forgot to restart the server .... it's done know and it works, thanks !