File Manager's depth limit

cbahiana 2010-07-15 18:54:39 UTC #1

Hi folks,

We’ve been using Egroupware for eight months now. It’s a 1.6.002 upgraded to 1.6.003 running on Ubuntu Server 9.10 upgraded to 10.4. We are not using LDAP. The File Manager root is at /home and files are kept in the FS.

Now, the problem: Every file included on the seventh level directory becomes unavailable, cannot be downloaded.

Example: /home/1/2/3/4/5/6/file.txt is unavailable. The same file, if uploaded to /home/1/2/3/4/5/, is
available;
I can’t copy or cut these files to paste on a lower level directory, they are really unreachable;
I can copy or cut “6/” and paste it to /home/1/2/3/4, making the files available;
I can create a directory /home/1/2/3/4/5/6/test/, but it also becames unreachable;
It doesn’t matter if I’m logged as a regular user, as admin or as superuser, the result is the same;
It happens on every seventh level subdirectory.

Using sub directories was helping us to organize and segregate content, so it became quite a problem.

Can you help us?

Robert_Ludvik 2010-07-16 05:00:13 UTC #2

Hi
I use 1.7.003 (from SVN) and just tried to create 8 subdirs, put in one file and it is reachable.
Sorry I can’t help more …
Regards

cbahiana 2010-07-16 12:26:07 UTC #3

Thank you, Robert. I’ll give it a try.

Ralf_Becker_6 2010-07-18 12:50:29 UTC #4

Unfortunatly that’s a limitation of MySQL and depend on the MySQL
version. All MySQL versions have a limit of subqueries, but that limit
differs from version to version.

EGroupware has a hardcoded limit (as I do NOT know of any possebility to
query the limit). If your MySQL version has a lower limit, you can
adaped it only in the source: phpgwapi/inc/class.sqlfs.inc.php (search
for MySQL, there’s a comment what to do).

Ralf

Hi folks,

We’ve been using Egroupware for eight months now. It’s a 1.6.002 upgraded to
1.6.003 running on Ubuntu Server 9.10 upgraded to 10.4. We are not using
LDAP. The File Manager root is at /home and files are kept in the FS.

Now, the problem: Every file included on the seventh level directory becomes
unavailable.

Example: /home/1/2/3/4/5/6/file.txt is unavailable. The same file, if
uploaded to /home/1/2/3/4/5/, is
available;

I can’t copy or cut these files to paste on a lower level directory, they
are really unreachable;

I can create a directory /home/1/2/3/4/5/6/test/, but it also becames
unreachable;

It doesn’t matter if I’m logged as a regular user, as admin or as
superuser, the result is the same;

It happens on every seventh level subdirectory.

Using sub directories was helping us to organize and segregate content, so
it became quite a problem.

Can you hel us?

–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first – http://p.sf.net/sfu/sprint-com-first

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

cbahiana 2010-07-18 14:02:37 UTC #5

Ralf,

First of all, thanks for the great software.

We are using MySQL 5.1.37. I couldn’t find phpgwapi/inc/class.sqlfs.inc.php,
but there’s a class.sqlfs_stream_wrapper.inc.php in that directory (version
29241 2010-02-15 06:07:58Z). As I am not a programmer, I’m not quite shure
what to do in it. The closest thing I found was:

    /**
     * due to problems with recursive directory creation, we have our

own here
*/
function mkdir_recursive($pathname, $mode, $depth=0)
{
$maxdepth=10;
$depth2propagate = (int)$depth + 1;
if ($depth2propagate > $maxdepth) return is_dir($pathname);
is_dir(dirname($pathname)) ||
self::mkdir_recursive(dirname($pathname), $mode, $depth2propagate);
return is_dir($pathname) || @mkdir($pathname, $mode);
}

Raising $maxdepth will do any good?

Greetings,
Carlos Bahiana

2010/7/18 Ralf Becker [via EGroupware] <

Unfortunatly that’s a limitation of MySQL and depend on the MySQL
version. All MySQL versions have a limit of subqueries, but that limit
differs from version to version.

EGroupware has a hardcoded limit (as I do NOT know of any possebility to
query the limit). If your MySQL version has a lower limit, you can
adaped it only in the source: phpgwapi/inc/class.sqlfs.inc.php (search
for MySQL, there’s a comment what to do).

Ralf

Hi folks,

We’ve been using Egroupware for eight months now. It’s a 1.6.002 upgraded
to
1.6.003 running on Ubuntu Server 9.10 upgraded to 10.4. We are not using
LDAP. The File Manager root is at /home and files are kept in the FS.

Now, the problem: Every file included on the seventh level directory
becomes
unavailable.

Example: /home/1/2/3/4/5/6/file.txt is unavailable. The same file, if
uploaded to /home/1/2/3/4/5/, is
available;

I can’t copy or cut these files to paste on a lower level directory,
they
are really unreachable;

I can create a directory /home/1/2/3/4/5/6/test/, but it also becames
unreachable;

It doesn’t matter if I’m logged as a regular user, as admin or as
superuser, the result is the same;

It happens on every seventh level subdirectory.

Using sub directories was helping us to organize and segregate content,
so
it became quite a problem.

Can you hel us?

–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de http://www.egroupware-support.de?by-user=t
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first – http://p.sf.net/sfu/sprint-com-first

eGroupWare-users mailing list
[hidden email] http://user/SendEmail.jtp?type=node&node=976372&i=0
https://lists.sourceforge.net/lists/listinfo/egroupware-users

View message @
http://egroupware.219119.n3.nabble.com/File-Manager-s-depth-limit-tp970410p976372.html
To unsubscribe from File Manager’s depth limit, click herehttp://egroupware.219119.n3.nabble.com/subscriptions/Unsubscribe.jtp?code=Y2FybG9zLmJhaGlhbmFAZ21haWwuY29tfDk3MDQxMHw2MTk4MDgwNjk=.

–
[]s,
Carlos Bahiana

Ralf_Becker_Stylite 2010-07-20 11:59:07 UTC #6

Yes, it’s class.sqlfs_stream_wrapper.inc.php, but you are looking at the
wrong place.

// MySQL 5.0 has a nesting limit for subqueries
// --> we replace the so far cumulated subqueries with their result
// no idea about the other DBMS, but this does NOT hurt …
// setting the value to 7, after reports on the user list, thought MySQL
5.0.51 with MyISAM engine works up to 10
if ($n > 1 && !(($n-1) % 7) && !($query =
self::$pdo->query($query)->fetchColumn()))

Try it eg. with 5.

Ralf

Ralf,

First of all, thanks for the great software.

We are using MySQL 5.1.37. I couldn’t find
phpgwapi/inc/class.sqlfs.inc.php, but there’s a
class.sqlfs_stream_wrapper.inc.php in that directory (version 29241
2010-02-15 06:07:58Z). As I am not a programmer, I’m not quite shure
what to do in it. The closest thing I found was:
    /**
     * due to problems with recursive directory creation, we have
our own here
*/
function mkdir_recursive($pathname, $mode, $depth=0)
{
$maxdepth=10;
$depth2propagate = (int)$depth + 1;
if ($depth2propagate > $maxdepth) return is_dir($pathname);
is_dir(dirname($pathname)) ||
self::mkdir_recursive(dirname($pathname), $mode, $depth2propagate);
return is_dir($pathname) || @mkdir($pathname, $mode);
}

Raising $maxdepth will do any good?

Greetings,
Carlos Bahiana

2010/7/18 Ralf Becker [via EGroupware] <[hidden email]
</user/SendEmail.jtp?type=node&node=976458&i=0>>
Unfortunatly that's a limitation of MySQL and depend on the MySQL
version. All MySQL versions have a limit of subqueries, but that limit
differs from version to version.

EGroupware has a hardcoded limit (as I do NOT know of any
possebility to
query the limit). If your MySQL version has a lower limit, you can
adaped it only in the source: phpgwapi/inc/class.sqlfs.inc.php (search
for MySQL, there's a comment what to do).

Ralf


>
> Hi folks,
>
> We've been using Egroupware for eight months now. It's a 1.6.002
upgraded to
> 1.6.003 running on Ubuntu Server 9.10 upgraded to 10.4. We are not
using
> LDAP. The File Manager root is at /home and files are kept in the FS.
>
> Now, the problem: Every file included on the seventh level
directory becomes
> unavailable.
>
> - Example: /home/1/2/3/4/5/6/file.txt is unavailable. The same
file, if
> uploaded to /home/1/2/3/4/5/, is
>   available;
> - I can't copy or cut these files to paste on a lower level
directory, they
> are really unreachable;
> - I can create a directory /home/1/2/3/4/5/6/test/, but it also
becames
> unreachable;
> - It doesn't matter if I'm logged as a regular user, as admin or as
> superuser, the result is the same;
> - It happens on every seventh level subdirectory.
>
> Using sub directories was helping us to organize and segregate
content, so
> it became quite a problem.
>
> Can you hel us?
-- 
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
<http://www.egroupware-support.de?by-user=t&by-user=t>
Outdoor Unlimited Training GmbH [www.outdoor-training.de
<http://www.outdoor-training.de?by-user=t>]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

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

This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first <http://sprint.com/first> --
http://p.sf.net/sfu/sprint-com-first
_______________________________________________
eGroupWare-users mailing list
[hidden email] <http://user/SendEmail.jtp?type=node&node=976372&i=0>
https://lists.sourceforge.net/lists/listinfo/egroupware-users


------------------------------------------------------------------------
View message @
http://egroupware.219119.n3.nabble.com/File-Manager-s-depth-limit-tp970410p976372.html
<http://egroupware.219119.n3.nabble.com/File-Manager-s-depth-limit-tp970410p976372.html?by-user=t>

To unsubscribe from File Manager's depth limit, click here.
–
[]s,
Carlos Bahiana

View this message in context: Re: File Manager’s depth limit
http://egroupware.219119.n3.nabble.com/File-Manager-s-depth-limit-tp970410p976458.html
Sent from the egroupware-users mailing list archive
http://egroupware.219119.n3.nabble.com/egroupware-users-f244990.html
at Nabble.com.

This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first – http://p.sf.net/sfu/sprint-com-first

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

–
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

This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first – http://p.sf.net/sfu/sprint-com-first

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

cbahiana 2010-07-20 19:53:02 UTC #7

Ralf,

Thank you very, very much, that did the trick! Now I can include files at
leat until de 12th level of depth.

Regards,
Carlos Bahiana

Yes, it’s class.sqlfs_stream_wrapper.inc.php, but you are looking at the
wrong place.

// MySQL 5.0 has a nesting limit for subqueries
// --> we replace the so far cumulated subqueries with their result
// no idea about the other DBMS, but this does NOT hurt …
// setting the value to 7, after reports on the user list, thought MySQL
5.0.51 with MyISAM engine works up to 10
if ($n > 1 && !(($n-1) % 7) && !($query =
self::$pdo->query($query)->fetchColumn()))

Try it eg. with 5.

Ralf
Ralf,

First of all, thanks for the great software.

We are using MySQL 5.1.37. I couldn’t find
phpgwapi/inc/class.sqlfs.inc.php, but there’s a
class.sqlfs_stream_wrapper.inc.php in that directory (version 29241
2010-02-15 06:07:58Z). As I am not a programmer, I’m not quite shure
what to do in it. The closest thing I found was:
    /**
     * due to problems with recursive directory creation, we have
our own here
*/
function mkdir_recursive($pathname, $mode, $depth=0)
{
$maxdepth=10;
$depth2propagate = (int)$depth + 1;
if ($depth2propagate > $maxdepth) return
is_dir($pathname);
is_dir(dirname($pathname)) ||
self::mkdir_recursive(dirname($pathname), $mode, $depth2propagate);
return is_dir($pathname) || @mkdir($pathname, $mode);
}

Raising $maxdepth will do any good?

Greetings,
Carlos Bahiana

2010/7/18 Ralf Becker [via EGroupware] <[hidden email]
</user/SendEmail.jtp?type=node&node=976458&i=0>>
Unfortunatly that's a limitation of MySQL and depend on the MySQL
version. All MySQL versions have a limit of subqueries, but that
limit
differs from version to version.

EGroupware has a hardcoded limit (as I do NOT know of any
possebility to
query the limit). If your MySQL version has a lower limit, you can
adaped it only in the source: phpgwapi/inc/class.sqlfs.inc.php
(search
for MySQL, there's a comment what to do).

Ralf


>
> Hi folks,
>
> We've been using Egroupware for eight months now. It's a 1.6.002
upgraded to
> 1.6.003 running on Ubuntu Server 9.10 upgraded to 10.4. We are not
using
> LDAP. The File Manager root is at /home and files are kept in the
FS.
>
> Now, the problem: Every file included on the seventh level
directory becomes
> unavailable.
>
> - Example: /home/1/2/3/4/5/6/file.txt is unavailable. The same
file, if
> uploaded to /home/1/2/3/4/5/, is
>   available;
> - I can't copy or cut these files to paste on a lower level
directory, they
> are really unreachable;
> - I can create a directory /home/1/2/3/4/5/6/test/, but it also
becames
> unreachable;
> - It doesn't matter if I'm logged as a regular user, as admin or as
> superuser, the result is the same;
> - It happens on every seventh level subdirectory.
>
> Using sub directories was helping us to organize and segregate
content, so
> it became quite a problem.
>
> Can you hel us?
--
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
<http://www.egroupware-support.de?by-user=t&by-user=t>
Outdoor Unlimited Training GmbH [www.outdoor-training.de
<http://www.outdoor-training.de?by-user=t>]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first <http://sprint.com/first> --
http://p.sf.net/sfu/sprint-com-first
_______________________________________________
eGroupWare-users mailing list
[hidden email] <http://user/SendEmail.jtp?type=node&node=976372&i=0>
https://lists.sourceforge.net/lists/listinfo/egroupware-users
View message @
http://egroupware.219119.n3.nabble.com/File-Manager-s-depth-limit-tp970410p976372.html
<
http://egroupware.219119.n3.nabble.com/File-Manager-s-depth-limit-tp970410p976372.html?by-user=t
To unsubscribe from File Manager's depth limit, click here.
–
[]s,
Carlos Bahiana

View this message in context: Re: File Manager’s depth limit
<
http://egroupware.219119.n3.nabble.com/File-Manager-s-depth-limit-tp970410p976458.html

Sent from the egroupware-users mailing list archive
http://egroupware.219119.n3.nabble.com/egroupware-users-f244990.html
at Nabble.com.
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first – http://p.sf.net/sfu/sprint-com-first

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

–
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

This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first – http://p.sf.net/sfu/sprint-com-first

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

–
[]s,
Carlos Bahiana

damien 2012-03-22 10:45:50 UTC #8

Hello everyone,

I’ve got a somewhat similar problem as the one described here : http://www.egroupware.org/forum#nabble-td970410.
We’re using eGroupware 1.6.003 on PHP 5.2.4 with MySQL 5.0.95.

The filemanager is setup with the FS as the repository.

My problem is : every file under the 3rd level directory is unavailable (cannot be downloaded). When trying to access the files, the webdav.php file is completely blank, and nothing shows up in Apache’s error.log.

When I check the fs_id in the sqlfs database table, i can retrieve the actual file on the FS, with the correct data in it.
The files’ access rights are correct, so Apache can read or write to the directory.
The filemanager’s access rights are also correct.

I tried changing the number of SQL subqueries but it did nothing.

Any help will be greatly appreciated !

Damien

Ralf_Becker_Stylite 2012-03-22 12:37:34 UTC #9

Hello everyone,

I’ve got a somewhat similar problem as the one described here :
http://www.egroupware.org/forum#nabble-td970410.
We’re using eGroupware 1.6.003 on PHP 5.2.4 with MySQL 5.0.95.

The filemanager is setup with the FS as the repository.

My problem is : every file under the 3rd level directory is unavailable
(cannot be downloaded). When trying to access the files, the webdav.php
file is completely blank, and nothing shows up in Apache’s error.log.

When I check the fs_id in the sqlfs database table, i can retrieve the
actual file on the FS, with the correct data in it.
The files’ access rights are correct, so Apache can read or write to the
directory.
The filemanager’s access rights are also correct.

I tried changing the number of SQL subqueries but it did nothing.

Then you set it not small enough.

Anyway you should definitly update to the recent version of EGroupware!

Ralf

Ralf Becker
Director Software Development

Stylite AG

Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

damien 2012-03-22 13:07:02 UTC #10

Hello everyone,

I’ve got a somewhat similar problem as the one described here :
http://www.egroupware.org/forum#nabble-td970410.
We’re using eGroupware 1.6.003 on PHP 5.2.4 with MySQL 5.0.95.

The filemanager is setup with the FS as the repository.

My problem is : every file under the 3rd level directory is unavailable
(cannot be downloaded). When trying to access the files, the webdav.php
file is completely blank, and nothing shows up in Apache’s error.log.

When I check the fs_id in the sqlfs database table, i can retrieve the
actual file on the FS, with the correct data in it.
The files’ access rights are correct, so Apache can read or write to the
directory.
The filemanager’s access rights are also correct.

I tried changing the number of SQL subqueries but it did nothing.

Then you set it not small enough.

Anyway you should definitly update to the recent version of EGroupware!

Ralf

Hello Ralf,

You’re right I did not set it low enough.
I tried with ‘3’, and now it seems to be working.

Anyway, we have an upgrade to the latest 1.8 release planned for this
summer.

Thank you very much for your help !

Regards,
Damien

–
Damien Depluvrez
University of Liège, Belgium | IT Manager

This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users