#566 mysql backend broken

None
closed
nobody
mysql (1)
1
10 hours ago
2014-06-07
dMopp
No

Jun 08 00:00:30.870879 afpd[25836] {cnid_mysql.c:235} (I:CNID): MySQL query "CREATE TABLE IF NOT EXISTS 46433444454531412D463739352D434445362D383638392D373930334639333530414133(Id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,Name VARCHAR(255) NOT NULL,Did INT UNSIGNED NOT NULL,DevNo BIGINT UNSIGNED NOT NULL,InodeNo BIGINT UNSIGNED NOT NULL,UNIQUE DidName(Did, Name), UNIQUE DevIno(DevNo, InodeNo)) AUTO_INCREMENT=17", error: Incorrect table name '46433444454531412D463739352D434445362D383638392D373930334639333530414133'
Jun 08 00:00:30.871030 afpd[25836] {cnid_mysql.c:926} (E:CNID): MySQL query error: Incorrect table name '46433444454531412D463739352D434445362D383638392D373930334639333530414133'

Reason: maximum table name length: 64 .. size of netatalk created tablename: 72

Was working some time ago (i had cleaned the database, maybe thats the reason why i found that error)

Discussion

  • dMopp
    dMopp
    2014-06-07

    Small Update: still working with 3.1.1, broken with 3.1.2

     
  • Traff
    Traff
    2014-07-06

    This is being caused by a buffer overrun in printuuid() in cnid_mysql.c. It's expecting the binary uuid passed in to be null terminated and it's not. I'll submit my patch to fix it after I test it for a few days.

     
  • dMopp
    dMopp
    2014-07-07

    Thanks for feedback, iam happy to know the cause is found. :)

     
  • dMopp
    dMopp
    2014-08-03

    Is there a Plan to fix this in 3.1.4 ?

     
  • dMopp
    dMopp
    2014-08-07

    Still broken with 3.1.4

     
  • Kristoffer Ek
    Kristoffer Ek
    2014-10-31

    Still broken in 3.1.6

     
  • Ralph Böhme
    Ralph Böhme
    10 hours ago

    • status: open --> closed
    • Group: -->