Hi,
documented the issue in the source:
http://svn.stylite.de/viewvc/egroupware/branches/1.8/phpgwapi/inc/class.sqlfs_stream_wrapper.inc.php?view=markup
content of files is stored as BLOB in the DB (can be enabled by mounting
sqlfs://…?storage=db)
please note the current (php5.2.6) problems:
a) retriving files via streams does NOT work for PDO_mysql
(bindColum(,PDO::PARAM_LOB) does NOT work, string returned) (there’s a
workaround implemented, but it requires to allocate memory for the whole
file!)
b) uploading/writing files > 1M fail on PDOStatement::execute() (setting
PDO::MYSQL_ATTR_MAX_BUFFER_SIZE does NOT help) (not sure if that’s a bug
in PDO/PDO_mysql or an accepted limitation)
For files of 15MB a) is NOT a problem, but b) is a no go. Thought my
tests were with PHP 5.2.6, I have not tested again, not heard of any
change concerning that matter.
We currently have a special offer for a hosted EGroupware called eFAMILY
for less then 50Euro/year:
http://www.stylite.de/egroupware_special_offers (at the end)
Maybe it’s fitting your project …
Ralf
Hello,
I’m using eGW 1.8 hosted on a webserver that limits the number of files on
filesystem and I’m working as volunteer of a project that distributes
audiobooks for visually impaired and needs upload hundreds of files of until
15MB. For these two reasons, the better for me would be upload files on
database (MySQL), but there is a warning on egw setup that indicates
problems with files higher than 1MB on database.
Then I want to know if there is a known way to work with this files via
database and what kind of problems I may face for use this.
Thanks!
–
Ralf Becker
Director Software Development
Stylite GmbH
[open style of IT]
Morschheimer Strasse 15
67292 Kirchheimbolanden
fon +49 (0) 6352 70629-0
fax +49 (0) 6352 70629-30
mailto: rb@stylite.de
www.stylite.de
www.egroupware.org
Geschäftsführer Andre Keller,
Gudrun Müller, Ralf Becker
Registergericht Kaiserslautern HRB 30575
Umsatzsteuer-Id / VAT-Id: DE214280951
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users