Thanks for your help

You just need to change the table name in your sql sessions 
configuration (in horde/config/conf.php). If you don't use sql-based 
sessions then you don't need to do anything, and you don't even need 
this table.

Thanks for your help. In the next days i'll ask my provider for an 
update of mysql.

One more question: If i'll use the name horde_sessions - what i have to do?



must i do a grep of all php and then change the name?



Thanks for your help and greetings from cologne.

I'm guessing there's a limit on table name length or something in 4.1 
with innodb. So just use a different table name for now.



You can also upgrade to MySQL 5 (which is probably a good idea 
anyway), or at least the latest 4.1 release (22, I think) which might 
remove the limitation.



Since you can always use a different table name I don't think there's 
much else we should do here; if it's a big problem "horde_sessions" 
might be an okay name if that one works.

Linux: SUSE 9.3



YAST say mysql: 4.1.10a

I can't reproduce this at all. What MySQL version are you using?

It's an interesting problem.

I try the following:

mysql> create table a (

     ->     session_id             VARCHAR(32) NOT NULL,

     ->     session_lastmodified   INT NOT NULL,

     ->     session_data           LONGBLOB,

     ->

     ->     PRIMARY KEY (session_id)

     -> ) ENGINE = InnoDB;

Query OK, 0 rows affected (0.01 sec)



mysql> rename table a to  horde_sessionhandler;

ERROR 1025 (HY000): Error on rename of './horde/a' to 
'./horde/horde_sessionhandler' (errno: 121)

mysql>

I do the same statement but i don't create a table called: 
horde_sessionhandler

I name it: a



So i do:

mysql> create table a (

     ->     session_id             VARCHAR(32) NOT NULL,

     ->     session_lastmodified   INT NOT NULL,

     ->     session_data           LONGBLOB,

     ->

     ->     PRIMARY KEY (session_id)

     -> ) ENGINE = InnoDB;

Query OK, 0 rows affected (0.01 sec)



So I think it's the name. Any idea?

One more comment: Overall I think innodb works.

I try:

mysql> CREATE TABLE customers (a INT, b CHAR (20), INDEX (a)) ENGINE=InnoDB;

Query OK, 0 rows affected (0.01 sec)

Sorry, very long:

mysql> CREATE TABLE horde_sessionhandler (

     ->     session_id             VARCHAR(32) NOT NULL,

     ->     session_lastmodified   INT NOT NULL,

     ->     session_data           LONGBLOB,

     ->

     ->     PRIMARY KEY (session_id)

     -> ) ENGINE = InnoDB;

ERROR 1005 (HY000): Can't create table 
'./horde/horde_sessionhandler.frm' (errno: 121)

mysql> show engine innodb status;

+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Status                                                               
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                                                       
                                              |

+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

|

=====================================

070607 18:58:14 INNODB MONITOR OUTPUT

=====================================

Per second averages calculated from the last 30 seconds

----------

SEMAPHORES

----------

OS WAIT ARRAY INFO: reservation count 9, signal count 9

Mutex spin waits 4, rounds 80, OS waits 0

RW-shared spins 19, OS waits 9; RW-excl spins 1, OS waits 0

------------

TRANSACTIONS

------------

Trx id counter 0 8229

Purge done for trx's n:o < 0 7035 undo n:o < 0 0

History list length 4

Total number of lock structs in row lock hash table 0

LIST OF TRANSACTIONS FOR EACH SESSION:

---TRANSACTION 0 0, not started, process no 13821, OS thread id 1099000752

MySQL thread id 6, query id 113 localhost root

show engine innodb status

--------

FILE I/O

--------

I/O thread 0 state: waiting for i/o request (insert buffer thread)

I/O thread 1 state: waiting for i/o request (log thread)

I/O thread 2 state: waiting for i/o request (read thread)

I/O thread 3 state: waiting for i/o request (write thread)

Pending normal aio reads: 0, aio writes: 0,

  ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0

Pending flushes (fsync) log: 0; buffer pool: 0

39 OS file reads, 33 OS file writes, 32 OS fsyncs

0.00 reads/s, 0 avg bytes/read, 0.13 writes/s, 0.13 fsyncs/s

-------------------------------------

INSERT BUFFER AND ADAPTIVE HASH INDEX

-------------------------------------

Ibuf for space 0: size 1, free list len 0, seg size 2, is empty

Ibuf for space 0: size 1, free list len 0, seg size 2,

0 inserts, 0 merged recs, 0 merges

Hash table size 34679, used cells 0, node heap has 0 buffer(s)

0.00 hash searches/s, 0.03 non-hash searches/s

---

LOG

---

Log sequence number 0 661038

Log flushed up to   0 661038

Last checkpoint at  0 661038

0 pending log writes, 0 pending chkp writes

23 log i/o's done, 0.07 log i/o's/second

----------------------

BUFFER POOL AND MEMORY

----------------------

Total memory allocated 18300220; in additional pool allocated 892800

Buffer pool size   512

Free buffers       479

Database pages     33

Modified db pages  0

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages read 33, created 0, written 8

0.00 reads/s, 0.00 creates/s, 0.03 writes/s

Buffer pool hit rate 1000 / 1000

--------------

ROW OPERATIONS

--------------

0 queries inside InnoDB, 0 queries in queue

Main thread process no. 13821, id 1105480624, state: waiting for 
server activity

Number of rows inserted 0, updated 0, deleted 0, read 12

0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s

----------------------------

END OF INNODB MONITOR OUTPUT

============================

  |

+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.00 sec)

Then what is the output of show engine innodb status after you try 
creating the table _with_ the engine=innodb statement?

Hi,



if i create the table without the "engine=innodb" the statement works fine.

After that i do a "show engine innodb status" there is a ouput. So i 
think innodb is installed.

Do you have innodb support in MySQL?

Dear guys,



hope that's the right place to ask these question. I've search the 
internet and i didn't find an answer. So i think there is a bug in the 
create.mysql.sql.



I run the script with following command:

mysql -u root -p < create.mysql.sql



I got the message:

ERROR 1005 (HY000) at line 154: Can't create table 
'./horde/horde_sessionhandler.frm' (errno: 121)



Any idea with problem?



- Sorry for my english - I hope it works and thanks for any help.

Helmut