Scalable BLOB Streaming Forum

[adraintheant]

Hello everybody!

After i build Mysql 5.1.22-rc, pbxt 0.9.91-beta sucessfully and
install the plugin 0.5.04-alpha without problems, i create a table testtab with
CREATE TABLE `testab` (
`id` int(10) unsigned NOT NULL,
`fullsize` longblob,
PRIMARY KEY (`id`)
) ENGINE=PBXT DEFAULT CHARSET=utf8
(i used the helpful annotations from www.moocowproductions.org/blog/details.php?postid=290 - thanx to Tim)

with curl -d <binary> http://localhost:8080/test i upload a binary.
I get a reference and can access BLOB Database Reference over browser to the file! : http://localhost:8080/~*test/_1-128-5cbeb8eb-0 this works fine.

Now i load a binary into the db within a script.

When i try to access BLOB Field Reference (http://localhost:8080/test/testtab/fullsize/id=1) i get following error:

HTTP Error 404: Not Found
No engine found for 'test/testtab', No streaming enabled engines
lockEngineTable(BSOpenTable.cc:782)
handleGet(BSConnectionHandler.cc:313)
doWork(BSConnectionHandler.cc:487)
run(CSThread.cc:618)

MySQL 5.1.22-rc, MyBS 0.5.04-alpha
Copyright © 2007, SNAP Innovation GmbH

Is this feature not yet implemented or do i make something wrong?

Can somebody help me, please?

Thanks for response!
Greetings Andreas

[Paul McCullagh]

Hi Andreas,

To use a BLOB field reference you must either execute "SET GLOBAL mybs_field_references=TRUE;" or use the mysqld command line option --mybs-field-references to enable this type of access.

Although I do not think this is the reason for the error message you get in the report.

It looks more like the PBXT plug-in was not installed correctly. Check the table engine returned when you ener: SHOW CREATE TABLE testab;

You may also be encountering the same problem reported here:

http://www.blobstreaming.org/forum/viewtopic.php?t=26

It seems that the binary PBXT plug-in I built does not work with the MySQL binary distribution.

Unfortunately there is nothing I can do about this at the moment.

The only possibility is to build MySQL and the plus-ins manually. If you need help, let me know!

Best regards,

Paul