mysqlfs-general

[Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Tony S. <tsh...@os...>]

Yes, there is Fuse for FreeBSD.  I've built it from ports, and it's 
using API 2.6.

Anyhooo....../configure is okay (after editing fuse.h to report the 
correct API, apparently it has a backwards compat mode to version 2.1 
and defaults to that.  Changing to 2.6 per the instructions works 
fine!), then when I attempt to do make or gmake, I get this error:

manager# gmake
gmake  all-am
gmake[1]: Entering directory `/usr/local/src/mysqlfs-0.4.0-rc1'
if gcc -DHAVE_CONFIG_H -I. -I. -I.   -I/usr/include -I/usr/local/include 
-L/usr/lib -L/usr/local/lib  -I/usr/include -I/usr/local/include 
-L/usr/lib -L/usr/local/lib -I/usr/local/include -Wall -Werror 
-I/usr/local/include/mysql -Wall -Werror -MT query.o -MD -MP -MF 
".deps/query.Tpo" -c -o query.o query.c; \
         then mv -f ".deps/query.Tpo" ".deps/query.Po"; else rm -f 
".deps/query.Tpo"; exit 1; fi
query.c: In function `query_utime':
query.c:439: warning: long int format, time_t arg (arg 4)
query.c:439: warning: long int format, time_t arg (arg 5)
query.c:439: warning: long int format, time_t arg (arg 4)
query.c:439: warning: long int format, time_t arg (arg 5)
gmake[1]: *** [query.o] Error 1
gmake[1]: Leaving directory `/usr/local/src/mysqlfs-0.4.0-rc1'
gmake: *** [all] Error 2

The code section it's complaining about is below.  The last line is line 
439.

---------

int query_utime(MYSQL *mysql, long inode, struct utimbuf *time)
{
     int ret;
     char sql[SQL_MAX];

     snprintf(sql, SQL_MAX,
              "UPDATE inodes "
              "SET atime=%ld, mtime=%ld "
              "WHERE inode=%lu",
              time->actime, time->modtime, inode);

--------

It appears to not like time->actime and time->modtime.  Any idea what 
might cause this or how to debug it/fix it up?

Thanks!

Tony Shadwick
OSS Solutions

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Tony S. <tsh...@os...>]

Well, figured this out partially.  time.h on freebsd doesn't define the 
struct utimbuf. utime.h does, however including it with or without 
time.h makes no difference, I get the same error. :\

Tony Shadwick
OSS Solutions

Tony Shadwick wrote:
> Yes, there is Fuse for FreeBSD.  I've built it from ports, and it's 
> using API 2.6.
> 
> Anyhooo....../configure is okay (after editing fuse.h to report the 
> correct API, apparently it has a backwards compat mode to version 2.1 
> and defaults to that.  Changing to 2.6 per the instructions works 
> fine!), then when I attempt to do make or gmake, I get this error:
> 
> manager# gmake
> gmake  all-am
> gmake[1]: Entering directory `/usr/local/src/mysqlfs-0.4.0-rc1'
> if gcc -DHAVE_CONFIG_H -I. -I. -I.   -I/usr/include -I/usr/local/include 
> -L/usr/lib -L/usr/local/lib  -I/usr/include -I/usr/local/include 
> -L/usr/lib -L/usr/local/lib -I/usr/local/include -Wall -Werror 
> -I/usr/local/include/mysql -Wall -Werror -MT query.o -MD -MP -MF 
> ".deps/query.Tpo" -c -o query.o query.c; \
>          then mv -f ".deps/query.Tpo" ".deps/query.Po"; else rm -f 
> ".deps/query.Tpo"; exit 1; fi
> query.c: In function `query_utime':
> query.c:439: warning: long int format, time_t arg (arg 4)
> query.c:439: warning: long int format, time_t arg (arg 5)
> query.c:439: warning: long int format, time_t arg (arg 4)
> query.c:439: warning: long int format, time_t arg (arg 5)
> gmake[1]: *** [query.o] Error 1
> gmake[1]: Leaving directory `/usr/local/src/mysqlfs-0.4.0-rc1'
> gmake: *** [all] Error 2
> 
> The code section it's complaining about is below.  The last line is line 
> 439.
> 
> ---------
> 
> int query_utime(MYSQL *mysql, long inode, struct utimbuf *time)
> {
>      int ret;
>      char sql[SQL_MAX];
> 
>      snprintf(sql, SQL_MAX,
>               "UPDATE inodes "
>               "SET atime=%ld, mtime=%ld "
>               "WHERE inode=%lu",
>               time->actime, time->modtime, inode);
> 
> --------
> 
> It appears to not like time->actime and time->modtime.  Any idea what 
> might cause this or how to debug it/fix it up?
> 
> Thanks!
> 
> Tony Shadwick
> OSS Solutions
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Mysqlfs-general mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Tony S. <tsh...@os...>]

Well, I replied to myself from the wrong address earlier, so it didn't 
get posted.  ooops.

Okay, the compile error was fixed by first running ./configure, then 
modifying Makefile to remove -Wall from CFLAGS (there are two instances 
of it).

So it compiles, and I can mount the filesytem:

manager# df -h
Filesystem     Size    Used   Avail Capacity  Mounted on
/dev/ad0s1a    496M     76M    380M    17%    /
devfs          1.0K    1.0K      0B   100%    /dev
/dev/ad0s1e    496M     20K    456M     0%    /tmp
/dev/ad0s1f     28G    1.9G     24G     7%    /usr
/dev/ad0s1d    2.9G     39M    2.6G     1%    /var
devfs          1.0K    1.0K      0B   100%    /var/named/dev
/dev/fuse1       0B      0B      0B   100%    /mysqlfs

Um...capacity 100%?

It gets better:

manager# cd /mysqlfs/
manager# ls -alhs
total 2
0 drwxr-xr-x   1 root  wheel     0B Apr 13 14:01 .
2 drwxr-xr-x  22 root  wheel   512B Apr 13 14:00 ..
manager# touch test
touch: test: No such file or directory
manager# mkdir test
mkdir: .: No such file or directory
manager# pwd
/mysqlfs

I did a little research on this, and came across this page:

http://datafarm.apgrid.org/ml/gfarm-discuss/msg00162.html

It makes mention of sys/statfs.h, configure.in not being right, and most 
importantly:

"statvfs->f_frsize is not set, therefore df command cannot work 
correctly on FreeBSD."

It seems to be a bit more than that though, as I can't execute any file 
operations at all, and nothing appears to be getting logged...

Tony Shadwick wrote:
> Well, figured this out partially.  time.h on freebsd doesn't define the 
> struct utimbuf. utime.h does, however including it with or without 
> time.h makes no difference, I get the same error. :\
> 
> Tony Shadwick
> OSS Solutions
> 
> Tony Shadwick wrote:
>> Yes, there is Fuse for FreeBSD.  I've built it from ports, and it's 
>> using API 2.6.
>>
>> Anyhooo....../configure is okay (after editing fuse.h to report the 
>> correct API, apparently it has a backwards compat mode to version 2.1 
>> and defaults to that.  Changing to 2.6 per the instructions works 
>> fine!), then when I attempt to do make or gmake, I get this error:
>>
>> manager# gmake
>> gmake  all-am
>> gmake[1]: Entering directory `/usr/local/src/mysqlfs-0.4.0-rc1'
>> if gcc -DHAVE_CONFIG_H -I. -I. -I.   -I/usr/include -I/usr/local/include 
>> -L/usr/lib -L/usr/local/lib  -I/usr/include -I/usr/local/include 
>> -L/usr/lib -L/usr/local/lib -I/usr/local/include -Wall -Werror 
>> -I/usr/local/include/mysql -Wall -Werror -MT query.o -MD -MP -MF 
>> ".deps/query.Tpo" -c -o query.o query.c; \
>>          then mv -f ".deps/query.Tpo" ".deps/query.Po"; else rm -f 
>> ".deps/query.Tpo"; exit 1; fi
>> query.c: In function `query_utime':
>> query.c:439: warning: long int format, time_t arg (arg 4)
>> query.c:439: warning: long int format, time_t arg (arg 5)
>> query.c:439: warning: long int format, time_t arg (arg 4)
>> query.c:439: warning: long int format, time_t arg (arg 5)
>> gmake[1]: *** [query.o] Error 1
>> gmake[1]: Leaving directory `/usr/local/src/mysqlfs-0.4.0-rc1'
>> gmake: *** [all] Error 2
>>
>> The code section it's complaining about is below.  The last line is line 
>> 439.
>>
>> ---------
>>
>> int query_utime(MYSQL *mysql, long inode, struct utimbuf *time)
>> {
>>      int ret;
>>      char sql[SQL_MAX];
>>
>>      snprintf(sql, SQL_MAX,
>>               "UPDATE inodes "
>>               "SET atime=%ld, mtime=%ld "
>>               "WHERE inode=%lu",
>>               time->actime, time->modtime, inode);
>>
>> --------
>>
>> It appears to not like time->actime and time->modtime.  Any idea what 
>> might cause this or how to debug it/fix it up?
>>
>> Thanks!
>>
>> Tony Shadwick
>> OSS Solutions
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Mysqlfs-general mailing list
>> Mys...@li...
>> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Mysqlfs-general mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Tony S. <tsh...@os...>]

Ugh, I did it again.  Here's the URL spelling out how to fix this:

http://fuse4bsd.creo.hu/doc/html_single_out/doc.html#hd001005

Tony Shadwick wrote:
> Well, I replied to myself from the wrong address earlier, so it didn't 
> get posted.  ooops.
> 
> Okay, the compile error was fixed by first running ./configure, then 
> modifying Makefile to remove -Wall from CFLAGS (there are two instances 
> of it).
> 
> So it compiles, and I can mount the filesytem:
> 
> manager# df -h
> Filesystem     Size    Used   Avail Capacity  Mounted on
> /dev/ad0s1a    496M     76M    380M    17%    /
> devfs          1.0K    1.0K      0B   100%    /dev
> /dev/ad0s1e    496M     20K    456M     0%    /tmp
> /dev/ad0s1f     28G    1.9G     24G     7%    /usr
> /dev/ad0s1d    2.9G     39M    2.6G     1%    /var
> devfs          1.0K    1.0K      0B   100%    /var/named/dev
> /dev/fuse1       0B      0B      0B   100%    /mysqlfs
> 
> Um...capacity 100%?
> 
> It gets better:
> 
> manager# cd /mysqlfs/
> manager# ls -alhs
> total 2
> 0 drwxr-xr-x   1 root  wheel     0B Apr 13 14:01 .
> 2 drwxr-xr-x  22 root  wheel   512B Apr 13 14:00 ..
> manager# touch test
> touch: test: No such file or directory
> manager# mkdir test
> mkdir: .: No such file or directory
> manager# pwd
> /mysqlfs
> 
> I did a little research on this, and came across this page:
> 
> http://datafarm.apgrid.org/ml/gfarm-discuss/msg00162.html
> 
> It makes mention of sys/statfs.h, configure.in not being right, and most 
> importantly:
> 
> "statvfs->f_frsize is not set, therefore df command cannot work 
> correctly on FreeBSD."
> 
> It seems to be a bit more than that though, as I can't execute any file 
> operations at all, and nothing appears to be getting logged...
> 
> Tony Shadwick wrote:
>> Well, figured this out partially.  time.h on freebsd doesn't define the 
>> struct utimbuf. utime.h does, however including it with or without 
>> time.h makes no difference, I get the same error. :\
>>
>> Tony Shadwick
>> OSS Solutions
>>
>> Tony Shadwick wrote:
>>> Yes, there is Fuse for FreeBSD.  I've built it from ports, and it's 
>>> using API 2.6.
>>>
>>> Anyhooo....../configure is okay (after editing fuse.h to report the 
>>> correct API, apparently it has a backwards compat mode to version 2.1 
>>> and defaults to that.  Changing to 2.6 per the instructions works 
>>> fine!), then when I attempt to do make or gmake, I get this error:
>>>
>>> manager# gmake
>>> gmake  all-am
>>> gmake[1]: Entering directory `/usr/local/src/mysqlfs-0.4.0-rc1'
>>> if gcc -DHAVE_CONFIG_H -I. -I. -I.   -I/usr/include -I/usr/local/include 
>>> -L/usr/lib -L/usr/local/lib  -I/usr/include -I/usr/local/include 
>>> -L/usr/lib -L/usr/local/lib -I/usr/local/include -Wall -Werror 
>>> -I/usr/local/include/mysql -Wall -Werror -MT query.o -MD -MP -MF 
>>> ".deps/query.Tpo" -c -o query.o query.c; \
>>>          then mv -f ".deps/query.Tpo" ".deps/query.Po"; else rm -f 
>>> ".deps/query.Tpo"; exit 1; fi
>>> query.c: In function `query_utime':
>>> query.c:439: warning: long int format, time_t arg (arg 4)
>>> query.c:439: warning: long int format, time_t arg (arg 5)
>>> query.c:439: warning: long int format, time_t arg (arg 4)
>>> query.c:439: warning: long int format, time_t arg (arg 5)
>>> gmake[1]: *** [query.o] Error 1
>>> gmake[1]: Leaving directory `/usr/local/src/mysqlfs-0.4.0-rc1'
>>> gmake: *** [all] Error 2
>>>
>>> The code section it's complaining about is below.  The last line is line 
>>> 439.
>>>
>>> ---------
>>>
>>> int query_utime(MYSQL *mysql, long inode, struct utimbuf *time)
>>> {
>>>      int ret;
>>>      char sql[SQL_MAX];
>>>
>>>      snprintf(sql, SQL_MAX,
>>>               "UPDATE inodes "
>>>               "SET atime=%ld, mtime=%ld "
>>>               "WHERE inode=%lu",
>>>               time->actime, time->modtime, inode);
>>>
>>> --------
>>>
>>> It appears to not like time->actime and time->modtime.  Any idea what 
>>> might cause this or how to debug it/fix it up?
>>>
>>> Thanks!
>>>
>>> Tony Shadwick
>>> OSS Solutions
>>>
>>> -------------------------------------------------------------------------
>>> Take Surveys. Earn Cash. Influence the Future of IT
>>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>>> opinions on IT & business topics through brief surveys-and earn cash
>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>> _______________________________________________
>>> Mysqlfs-general mailing list
>>> Mys...@li...
>>> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Mysqlfs-general mailing list
>> Mys...@li...
>> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Mysqlfs-general mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Tony S. <tsh...@os...>]

This just keeps getting better and better.  I might note here that I'm 
no c programmer, so be nice to me. :)

I've added this into mysqlfs.c:

static int mysqlfs_statfs(const char *path, struct statvfs *buf)
{
     (void) path;

     buf->f_namemax = 255;
     buf->f_bsize = 4096;
     /* df seems to use f_bsize instead of f_frsize, so make them the 
same */
     buf->f_frsize = buf->f_bsize;
     buf->f_blocks = buf->f_bfree =  buf->f_bavail =
         1000ULL * 1024 * 1024 * 1024 / buf->f_frsize;
     buf->f_files = buf->f_ffree = 1000000000;
     return 0;
}

and also added a declaration for it to the fuse_operations struct.  I 
might also mention that the hard drive in this system isn't all that 
large, about 20GB if I recall, and I'm connecting to a local MySQL 
database.  This ought to strike you as funny then:

/dev/fuse3     1.0T      0B    1.0T     0%    /mysqlfs

Obviously I have f_namemax and f_bsize completely wrong. :P  That, and I 
still can't write.  Same errors.  Grrr...I'm missing something here, I 
just don't know what.

Tony Shadwick wrote:
> Ugh, I did it again.  Here's the URL spelling out how to fix this:
> 
> http://fuse4bsd.creo.hu/doc/html_single_out/doc.html#hd001005
> 
> Tony Shadwick wrote:
>> Well, I replied to myself from the wrong address earlier, so it didn't 
>> get posted.  ooops.
>>
>> Okay, the compile error was fixed by first running ./configure, then 
>> modifying Makefile to remove -Wall from CFLAGS (there are two instances 
>> of it).
>>
>> So it compiles, and I can mount the filesytem:
>>
>> manager# df -h
>> Filesystem     Size    Used   Avail Capacity  Mounted on
>> /dev/ad0s1a    496M     76M    380M    17%    /
>> devfs          1.0K    1.0K      0B   100%    /dev
>> /dev/ad0s1e    496M     20K    456M     0%    /tmp
>> /dev/ad0s1f     28G    1.9G     24G     7%    /usr
>> /dev/ad0s1d    2.9G     39M    2.6G     1%    /var
>> devfs          1.0K    1.0K      0B   100%    /var/named/dev
>> /dev/fuse1       0B      0B      0B   100%    /mysqlfs
>>
>> Um...capacity 100%?
>>
>> It gets better:
>>
>> manager# cd /mysqlfs/
>> manager# ls -alhs
>> total 2
>> 0 drwxr-xr-x   1 root  wheel     0B Apr 13 14:01 .
>> 2 drwxr-xr-x  22 root  wheel   512B Apr 13 14:00 ..
>> manager# touch test
>> touch: test: No such file or directory
>> manager# mkdir test
>> mkdir: .: No such file or directory
>> manager# pwd
>> /mysqlfs
>>
>> I did a little research on this, and came across this page:
>>
>> http://datafarm.apgrid.org/ml/gfarm-discuss/msg00162.html
>>
>> It makes mention of sys/statfs.h, configure.in not being right, and most 
>> importantly:
>>
>> "statvfs->f_frsize is not set, therefore df command cannot work 
>> correctly on FreeBSD."
>>
>> It seems to be a bit more than that though, as I can't execute any file 
>> operations at all, and nothing appears to be getting logged...
>>
>> Tony Shadwick wrote:
>>> Well, figured this out partially.  time.h on freebsd doesn't define the 
>>> struct utimbuf. utime.h does, however including it with or without 
>>> time.h makes no difference, I get the same error. :\
>>>
>>> Tony Shadwick
>>> OSS Solutions
>>>
>>> Tony Shadwick wrote:
>>>> Yes, there is Fuse for FreeBSD.  I've built it from ports, and it's 
>>>> using API 2.6.
>>>>
>>>> Anyhooo....../configure is okay (after editing fuse.h to report the 
>>>> correct API, apparently it has a backwards compat mode to version 2.1 
>>>> and defaults to that.  Changing to 2.6 per the instructions works 
>>>> fine!), then when I attempt to do make or gmake, I get this error:
>>>>
>>>> manager# gmake
>>>> gmake  all-am
>>>> gmake[1]: Entering directory `/usr/local/src/mysqlfs-0.4.0-rc1'
>>>> if gcc -DHAVE_CONFIG_H -I. -I. -I.   -I/usr/include -I/usr/local/include 
>>>> -L/usr/lib -L/usr/local/lib  -I/usr/include -I/usr/local/include 
>>>> -L/usr/lib -L/usr/local/lib -I/usr/local/include -Wall -Werror 
>>>> -I/usr/local/include/mysql -Wall -Werror -MT query.o -MD -MP -MF 
>>>> ".deps/query.Tpo" -c -o query.o query.c; \
>>>>          then mv -f ".deps/query.Tpo" ".deps/query.Po"; else rm -f 
>>>> ".deps/query.Tpo"; exit 1; fi
>>>> query.c: In function `query_utime':
>>>> query.c:439: warning: long int format, time_t arg (arg 4)
>>>> query.c:439: warning: long int format, time_t arg (arg 5)
>>>> query.c:439: warning: long int format, time_t arg (arg 4)
>>>> query.c:439: warning: long int format, time_t arg (arg 5)
>>>> gmake[1]: *** [query.o] Error 1
>>>> gmake[1]: Leaving directory `/usr/local/src/mysqlfs-0.4.0-rc1'
>>>> gmake: *** [all] Error 2
>>>>
>>>> The code section it's complaining about is below.  The last line is line 
>>>> 439.
>>>>
>>>> ---------
>>>>
>>>> int query_utime(MYSQL *mysql, long inode, struct utimbuf *time)
>>>> {
>>>>      int ret;
>>>>      char sql[SQL_MAX];
>>>>
>>>>      snprintf(sql, SQL_MAX,
>>>>               "UPDATE inodes "
>>>>               "SET atime=%ld, mtime=%ld "
>>>>               "WHERE inode=%lu",
>>>>               time->actime, time->modtime, inode);
>>>>
>>>> --------
>>>>
>>>> It appears to not like time->actime and time->modtime.  Any idea what 
>>>> might cause this or how to debug it/fix it up?
>>>>
>>>> Thanks!
>>>>
>>>> Tony Shadwick
>>>> OSS Solutions
>>>>
>>>> -------------------------------------------------------------------------
>>>> Take Surveys. Earn Cash. Influence the Future of IT
>>>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>>>> opinions on IT & business topics through brief surveys-and earn cash
>>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>>> _______________________________________________
>>>> Mysqlfs-general mailing list
>>>> Mys...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general
>>> -------------------------------------------------------------------------
>>> Take Surveys. Earn Cash. Influence the Future of IT
>>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>>> opinions on IT & business topics through brief surveys-and earn cash
>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>> _______________________________________________
>>> Mysqlfs-general mailing list
>>> Mys...@li...
>>> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Mysqlfs-general mailing list
>> Mys...@li...
>> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Mysqlfs-general mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Tony S. <tsh...@os...>]

...and here's what is going wrong!

http://fuse4bsd.creo.hu/doc/html_single_out/doc.html#hd001005

Tony Shadwick wrote:
> Well, I replied to myself from the wrong address earlier, so it didn't 
> get posted.  ooops.
> 
> Okay, the compile error was fixed by first running ./configure, then 
> modifying Makefile to remove -Wall from CFLAGS (there are two instances 
> of it).
> 
> So it compiles, and I can mount the filesytem:
> 
> manager# df -h
> Filesystem     Size    Used   Avail Capacity  Mounted on
> /dev/ad0s1a    496M     76M    380M    17%    /
> devfs          1.0K    1.0K      0B   100%    /dev
> /dev/ad0s1e    496M     20K    456M     0%    /tmp
> /dev/ad0s1f     28G    1.9G     24G     7%    /usr
> /dev/ad0s1d    2.9G     39M    2.6G     1%    /var
> devfs          1.0K    1.0K      0B   100%    /var/named/dev
> /dev/fuse1       0B      0B      0B   100%    /mysqlfs
> 
> Um...capacity 100%?
> 
> It gets better:
> 
> manager# cd /mysqlfs/
> manager# ls -alhs
> total 2
> 0 drwxr-xr-x   1 root  wheel     0B Apr 13 14:01 .
> 2 drwxr-xr-x  22 root  wheel   512B Apr 13 14:00 ..
> manager# touch test
> touch: test: No such file or directory
> manager# mkdir test
> mkdir: .: No such file or directory
> manager# pwd
> /mysqlfs
> 
> I did a little research on this, and came across this page:
> 
> http://datafarm.apgrid.org/ml/gfarm-discuss/msg00162.html
> 
> It makes mention of sys/statfs.h, configure.in not being right, and most 
> importantly:
> 
> "statvfs->f_frsize is not set, therefore df command cannot work 
> correctly on FreeBSD."
> 
> It seems to be a bit more than that though, as I can't execute any file 
> operations at all, and nothing appears to be getting logged...
> 
> Tony Shadwick wrote:
>> Well, figured this out partially.  time.h on freebsd doesn't define the 
>> struct utimbuf. utime.h does, however including it with or without 
>> time.h makes no difference, I get the same error. :\
>>
>> Tony Shadwick
>> OSS Solutions
>>
>> Tony Shadwick wrote:
>>> Yes, there is Fuse for FreeBSD.  I've built it from ports, and it's 
>>> using API 2.6.
>>>
>>> Anyhooo....../configure is okay (after editing fuse.h to report the 
>>> correct API, apparently it has a backwards compat mode to version 2.1 
>>> and defaults to that.  Changing to 2.6 per the instructions works 
>>> fine!), then when I attempt to do make or gmake, I get this error:
>>>
>>> manager# gmake
>>> gmake  all-am
>>> gmake[1]: Entering directory `/usr/local/src/mysqlfs-0.4.0-rc1'
>>> if gcc -DHAVE_CONFIG_H -I. -I. -I.   -I/usr/include -I/usr/local/include 
>>> -L/usr/lib -L/usr/local/lib  -I/usr/include -I/usr/local/include 
>>> -L/usr/lib -L/usr/local/lib -I/usr/local/include -Wall -Werror 
>>> -I/usr/local/include/mysql -Wall -Werror -MT query.o -MD -MP -MF 
>>> ".deps/query.Tpo" -c -o query.o query.c; \
>>>          then mv -f ".deps/query.Tpo" ".deps/query.Po"; else rm -f 
>>> ".deps/query.Tpo"; exit 1; fi
>>> query.c: In function `query_utime':
>>> query.c:439: warning: long int format, time_t arg (arg 4)
>>> query.c:439: warning: long int format, time_t arg (arg 5)
>>> query.c:439: warning: long int format, time_t arg (arg 4)
>>> query.c:439: warning: long int format, time_t arg (arg 5)
>>> gmake[1]: *** [query.o] Error 1
>>> gmake[1]: Leaving directory `/usr/local/src/mysqlfs-0.4.0-rc1'
>>> gmake: *** [all] Error 2
>>>
>>> The code section it's complaining about is below.  The last line is line 
>>> 439.
>>>
>>> ---------
>>>
>>> int query_utime(MYSQL *mysql, long inode, struct utimbuf *time)
>>> {
>>>      int ret;
>>>      char sql[SQL_MAX];
>>>
>>>      snprintf(sql, SQL_MAX,
>>>               "UPDATE inodes "
>>>               "SET atime=%ld, mtime=%ld "
>>>               "WHERE inode=%lu",
>>>               time->actime, time->modtime, inode);
>>>
>>> --------
>>>
>>> It appears to not like time->actime and time->modtime.  Any idea what 
>>> might cause this or how to debug it/fix it up?
>>>
>>> Thanks!
>>>
>>> Tony Shadwick
>>> OSS Solutions
>>>
>>> -------------------------------------------------------------------------
>>> Take Surveys. Earn Cash. Influence the Future of IT
>>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>>> opinions on IT & business topics through brief surveys-and earn cash
>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>> _______________________________________________
>>> Mysqlfs-general mailing list
>>> Mys...@li...
>>> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Mysqlfs-general mailing list
>> Mys...@li...
>> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Mysqlfs-general mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Michal L. <mi...@lo...>]

Tony Shadwick wrote:

> manager# df -h
> Filesystem     Size    Used   Avail Capacity  Mounted on
> /dev/ad0s1a    496M     76M    380M    17%    /
> devfs          1.0K    1.0K      0B   100%    /dev
> /dev/ad0s1e    496M     20K    456M     0%    /tmp
> /dev/ad0s1f     28G    1.9G     24G     7%    /usr
> /dev/ad0s1d    2.9G     39M    2.6G     1%    /var
> devfs          1.0K    1.0K      0B   100%    /var/named/dev
> /dev/fuse1       0B      0B      0B   100%    /mysqlfs
> 
> Um...capacity 100%?

I have no idea how to get an amount of free space from MySQL. I could 
indeed count the Used space quite easily but not the free space. I'm not 
sure that MySQL can report it somehow. Any ideas?

Michal

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Tony S. <tsh...@os...>]

mysql -u <user> --password=<pass> <db_name> -e 'show table status;' | 
awk '{sum=sum+$7+$9;} END {print sum/1024/1024}'

where <user>, <pass> and <db_name> is your account and database.

returns the size of (sum of) columns Data_length + Index_length in MB

That came from mysql's website.   So far as total space available, 
that's trickier.  Unless you've built-in some sort of limit for a 
particular database, it would be ~= to the amount of space left of the 
filesystem that the database resides on *or* ~= to the space available 
left in the ndb cluster.  Good question either way though. :\

Michal Ludvig wrote:
> Tony Shadwick wrote:
> 
>> manager# df -h
>> Filesystem     Size    Used   Avail Capacity  Mounted on
>> /dev/ad0s1a    496M     76M    380M    17%    /
>> devfs          1.0K    1.0K      0B   100%    /dev
>> /dev/ad0s1e    496M     20K    456M     0%    /tmp
>> /dev/ad0s1f     28G    1.9G     24G     7%    /usr
>> /dev/ad0s1d    2.9G     39M    2.6G     1%    /var
>> devfs          1.0K    1.0K      0B   100%    /var/named/dev
>> /dev/fuse1       0B      0B      0B   100%    /mysqlfs
>>
>> Um...capacity 100%?
> 
> I have no idea how to get an amount of free space from MySQL. I could 
> indeed count the Used space quite easily but not the free space. I'm not 
> sure that MySQL can report it somehow. Any ideas?
> 
> Michal
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Mysqlfs-general mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Stef B. <st...@bo...>]

On Friday 13 April 2007 20:39:37 Tony Shadwick wrote:
> Well, figured this out partially.  time.h on freebsd doesn't define the 
> struct utimbuf. utime.h does, however including it with or without 
> time.h makes no difference, I get the same error. :\
> 
> Tony Shadwick
> OSS Solutions

Hello,

do not use the 3.1 version. Use the version from cvs. 3.1 version is not able to store files bigger than 1M.

Stef Bon

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Tony S. <tsh...@os...>]

I pulled down the cvs version a few mins ago, but my box doesn't appear 
to have aclocal, so I'm working on that since there's no configure 
script. :P

Tony Shadwick
OSS Solutions


Stef Bon wrote:
> On Friday 13 April 2007 20:39:37 Tony Shadwick wrote:
>> Well, figured this out partially.  time.h on freebsd doesn't define the 
>> struct utimbuf. utime.h does, however including it with or without 
>> time.h makes no difference, I get the same error. :\
>>
>> Tony Shadwick
>> OSS Solutions
> 
> Hello,
> 
> do not use the 3.1 version. Use the version from cvs. 3.1 version is not able to store files bigger than 1M.
> 
> Stef Bon
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Mysqlfs-general mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Tony S. <tsh...@os...>]

Well, I built from cvs, but I still have the problem of not being able 
to write at all.  Once I'm able to write, I might be able to write files 
larger than 1MB though! :)

manager# mount_fusefs /dev/fuse0 /mysqlfs/ mysqlfs -ohost=localhost 
-ouser=mysqlfs -opassword=mysqlfs -odatabase=mysqlfs
* Opening logfile 'mysqlfs.log':  OK
manager# pwd
/usr/local/src/mysqlfs
manager# cat mysqlfs.log
manager# touch /mysqlfs/new
touch: /mysqlfs/new: No such file or directory
manager# df -h
Filesystem     Size    Used   Avail Capacity  Mounted on
/dev/ad0s1a    496M     76M    380M    17%    /
devfs          1.0K    1.0K      0B   100%    /dev
/dev/ad0s1e    496M     20K    456M     0%    /tmp
/dev/ad0s1f     28G    1.9G     24G     7%    /usr
/dev/ad0s1d    2.9G     39M    2.6G     1%    /var
devfs          1.0K    1.0K      0B   100%    /var/named/dev
/dev/fuse0       0B      0B      0B   100%    /mysqlfs
manager# cat mysqlfs.log

Tony Shadwick wrote:
> I pulled down the cvs version a few mins ago, but my box doesn't appear 
> to have aclocal, so I'm working on that since there's no configure 
> script. :P
> 
> Tony Shadwick
> OSS Solutions
> 
> 
> Stef Bon wrote:
>> On Friday 13 April 2007 20:39:37 Tony Shadwick wrote:
>>> Well, figured this out partially.  time.h on freebsd doesn't define the 
>>> struct utimbuf. utime.h does, however including it with or without 
>>> time.h makes no difference, I get the same error. :\
>>>
>>> Tony Shadwick
>>> OSS Solutions
>> Hello,
>>
>> do not use the 3.1 version. Use the version from cvs. 3.1 version is not able to store files bigger than 1M.
>>
>> Stef Bon
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Mysqlfs-general mailing list
>> Mys...@li...
>> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Mysqlfs-general mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Tony S. <tsh...@os...>]

I'm still trying to debug this...I turned on verbose logging of mysql, 
hoping to find the answer to what's going on, but I'm afraid the logs 
are somewhat greek to me:

manager# cd /mysqlfs/
manager# touch new
touch: new: No such file or directory
manager# cat /var/log/mysql.log
/usr/local/libexec/mysqld, Version: 5.0.37-log (FreeBSD port: 
mysql-server-5.0.37). started with:
Tcp port: 0  Unix socket: (null)
Time                 Id Command    Argument
070413 17:21:46       1 Connect     mysqlfs@localhost on mysqlfs
                       1 Query       SET NAMES latin1
                       1 Query       SELECT t0.inode, t0.name, 
t0.parent,        (SELECT COUNT(inode) FROM tree AS t1 WHERE 
t1.inode=t0.inode)                AS nlinks FROM tree AS t0 WHERE 
t0.parent IS NULL
                       1 Query       SELECT inode, mode, uid, gid, 
atime, mtime FROM inodes WHERE inode=1
                       1 Query       SELECT t0.inode, t0.name, 
t0.parent,        (SELECT COUNT(inode) FROM tree AS t1 WHERE 
t1.inode=t0.inode)                AS nlinks FROM tree AS t0 WHERE 
t0.parent IS NULL
                       1 Query       SELECT size FROM inodes WHERE inode=1
070413 17:21:47       1 Query       SELECT t0.inode, t0.name, t0.parent, 
        (SELECT COUNT(inode) FROM tree AS t1 WHERE t1.inode=t0.inode) 
              AS nlinks FROM tree AS t0 WHERE t0.parent IS NULL
                       1 Query       SELECT inode, mode, uid, gid, 
atime, mtime FROM inodes WHERE inode=1
                       1 Query       SELECT t0.inode, t0.name, 
t0.parent,        (SELECT COUNT(inode) FROM tree AS t1 WHERE 
t1.inode=t0.inode)                AS nlinks FROM tree AS t0 WHERE 
t0.parent IS NULL
                       1 Query       SELECT size FROM inodes WHERE inode=1
070413 17:21:49       1 Query       SELECT t1.inode, t1.name, t1.parent, 
        (SELECT COUNT(inode) FROM tree AS t2 WHERE t2.inode=t1.inode) 
              AS nlinks FROM tree AS t0 LEFT JOIN tree AS t1 ON t0.inode 
= t1.parent WHERE t0.parent IS NULL AND t1.name = 'new'
                       1 Query       SELECT t1.inode, t1.name, 
t1.parent,        (SELECT COUNT(inode) FROM tree AS t2 WHERE 
t2.inode=t1.inode)                AS nlinks FROM tree AS t0 LEFT JOIN 
tree AS t1 ON t0.inode = t1.parent WHERE t0.parent IS NULL AND t1.name = 
'new'
                       1 Query       SELECT t1.inode, t1.name, 
t1.parent,        (SELECT COUNT(inode) FROM tree AS t2 WHERE 
t2.inode=t1.inode)                AS nlinks FROM tree AS t0 LEFT JOIN 
tree AS t1 ON t0.inode = t1.parent WHERE t0.parent IS NULL AND t1.name = 
'new'

Here's to hoping you see something that I don't!

Tony Shadwick wrote:
> Well, I built from cvs, but I still have the problem of not being able 
> to write at all.  Once I'm able to write, I might be able to write files 
> larger than 1MB though! :)
> 
> manager# mount_fusefs /dev/fuse0 /mysqlfs/ mysqlfs -ohost=localhost 
> -ouser=mysqlfs -opassword=mysqlfs -odatabase=mysqlfs
> * Opening logfile 'mysqlfs.log':  OK
> manager# pwd
> /usr/local/src/mysqlfs
> manager# cat mysqlfs.log
> manager# touch /mysqlfs/new
> touch: /mysqlfs/new: No such file or directory
> manager# df -h
> Filesystem     Size    Used   Avail Capacity  Mounted on
> /dev/ad0s1a    496M     76M    380M    17%    /
> devfs          1.0K    1.0K      0B   100%    /dev
> /dev/ad0s1e    496M     20K    456M     0%    /tmp
> /dev/ad0s1f     28G    1.9G     24G     7%    /usr
> /dev/ad0s1d    2.9G     39M    2.6G     1%    /var
> devfs          1.0K    1.0K      0B   100%    /var/named/dev
> /dev/fuse0       0B      0B      0B   100%    /mysqlfs
> manager# cat mysqlfs.log
> 
> Tony Shadwick wrote:
>> I pulled down the cvs version a few mins ago, but my box doesn't appear 
>> to have aclocal, so I'm working on that since there's no configure 
>> script. :P
>>
>> Tony Shadwick
>> OSS Solutions
>>
>>
>> Stef Bon wrote:
>>> On Friday 13 April 2007 20:39:37 Tony Shadwick wrote:
>>>> Well, figured this out partially.  time.h on freebsd doesn't define the 
>>>> struct utimbuf. utime.h does, however including it with or without 
>>>> time.h makes no difference, I get the same error. :\
>>>>
>>>> Tony Shadwick
>>>> OSS Solutions
>>> Hello,
>>>
>>> do not use the 3.1 version. Use the version from cvs. 3.1 version is not able to store files bigger than 1M.
>>>
>>> Stef Bon
>>>
>>> -------------------------------------------------------------------------
>>> Take Surveys. Earn Cash. Influence the Future of IT
>>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>>> opinions on IT & business topics through brief surveys-and earn cash
>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>> _______________________________________________
>>> Mysqlfs-general mailing list
>>> Mys...@li...
>>> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Mysqlfs-general mailing list
>> Mys...@li...
>> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Mysqlfs-general mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Michal L. <mi...@lo...>]

Tony Shadwick wrote:
> I'm still trying to debug this...I turned on verbose logging of mysql, 
> hoping to find the answer to what's going on, but I'm afraid the logs 
> are somewhat greek to me:
> 
> manager# cd /mysqlfs/
> manager# touch new
> touch: new: No such file or directory
> manager# cat /var/log/mysql.log
> /usr/local/libexec/mysqld, Version: 5.0.37-log (FreeBSD port: 
> mysql-server-5.0.37). started with:

Turn on MySQLfs logging instead.

On the top of log.c it reads:

//int log_types_mask = LOG_ERROR | LOG_INFO | LOG_DEBUG;
int log_types_mask = LOG_ERROR | LOG_INFO;
//int log_debug_mask = LOG_D_CALL | LOG_D_SQL | LOG_D_OTHER;
//int log_debug_mask = LOG_D_CALL;
int log_debug_mask = 0;

Instead make it:

int log_types_mask = LOG_ERROR | LOG_INFO | LOG_DEBUG;
//int log_types_mask = LOG_ERROR | LOG_INFO;
int log_debug_mask = LOG_D_CALL | LOG_D_SQL | LOG_D_OTHER;
//int log_debug_mask = LOG_D_CALL;
//int log_debug_mask = 0;

Yes I know this should be a command line switch and not a compile time
setting ;-)

Michal

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Tony S. <tsh...@os...>]

Well, I did that, did a make clean, make, make install, umount 
/dev/fuse0, and then mount_fusefs /dev/fuse0 /mysqlfs mysqlfs 
-ohost=localhost -ouser=mysqlfs -opassword=mysqlfs -odatabase=mysqlfs, I 
get the exact some result, and still nothing in the mysqlfs.log file. ???

Michal Ludvig wrote:
> Tony Shadwick wrote:
>> I'm still trying to debug this...I turned on verbose logging of mysql, 
>> hoping to find the answer to what's going on, but I'm afraid the logs 
>> are somewhat greek to me:
>>
>> manager# cd /mysqlfs/
>> manager# touch new
>> touch: new: No such file or directory
>> manager# cat /var/log/mysql.log
>> /usr/local/libexec/mysqld, Version: 5.0.37-log (FreeBSD port: 
>> mysql-server-5.0.37). started with:
> 
> Turn on MySQLfs logging instead.
> 
> On the top of log.c it reads:
> 
> //int log_types_mask = LOG_ERROR | LOG_INFO | LOG_DEBUG;
> int log_types_mask = LOG_ERROR | LOG_INFO;
> //int log_debug_mask = LOG_D_CALL | LOG_D_SQL | LOG_D_OTHER;
> //int log_debug_mask = LOG_D_CALL;
> int log_debug_mask = 0;
> 
> Instead make it:
> 
> int log_types_mask = LOG_ERROR | LOG_INFO | LOG_DEBUG;
> //int log_types_mask = LOG_ERROR | LOG_INFO;
> int log_debug_mask = LOG_D_CALL | LOG_D_SQL | LOG_D_OTHER;
> //int log_debug_mask = LOG_D_CALL;
> //int log_debug_mask = 0;
> 
> Yes I know this should be a command line switch and not a compile time
> setting ;-)
> 
> Michal
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Mysqlfs-general mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Tony S. <tsh...@os...>]

K, I feel like I'm not making progress here. :(  With log debugging on, 
here's what happens when I go to run mkdir testdir:

2007-04-14 11:09:21 1338 mysqlfs_getattr("/testdir")
2007-04-14 11:09:21 1338 sql=SELECT t1.inode, t1.name, t1.parent, 
  (SELECT COUNT(inode) FROM tree AS t2 WHERE t2.inode=t1.inode) 
        AS nlinks FROM tree AS t0 LEFT JOIN tree AS t1 ON t0.inode = 
t1.parent WHERE t0.parent IS NULL AND t1.name = 'testdir'
2007-04-14 11:09:21 1338 mysqlfs_mkdir("/testdir", 040755)
2007-04-14 11:09:21 1338 sql=SELECT t1.inode, t1.name, t1.parent, 
  (SELECT COUNT(inode) FROM tree AS t2 WHERE t2.inode=t1.inode) 
        AS nlinks FROM tree AS t0 LEFT JOIN tree AS t1 ON t0.inode = 
t1.parent WHERE t0.parent IS NULL AND t1.name = 'testdir'

and touch testfile

2007-04-14 11:11:29 1338 mysqlfs_getattr("/testfile")
2007-04-14 11:11:29 1338 sql=SELECT t1.inode, t1.name, t1.parent, 
  (SELECT COUNT(inode) FROM tree AS t2 WHERE t2.inode=t1.inode) 
        AS nlinks FROM tree AS t0 LEFT JOIN tree AS t1 ON t0.inode = 
t1.parent WHERE t0.parent IS NULL AND t1.name = 'testfile'
2007-04-14 11:11:29 1338 mysqlfs_getattr("/testfile")
2007-04-14 11:11:29 1338 sql=SELECT t1.inode, t1.name, t1.parent, 
  (SELECT COUNT(inode) FROM tree AS t2 WHERE t2.inode=t1.inode) 
        AS nlinks FROM tree AS t0 LEFT JOIN tree AS t1 ON t0.inode = 
t1.parent WHERE t0.parent IS NULL AND t1.name = 'testfile'
2007-04-14 11:11:29 1338 mysqlfs_mknod("/testfile", 100644): file
2007-04-14 11:11:29 1338 sql=SELECT t1.inode, t1.name, t1.parent, 
  (SELECT COUNT(inode) FROM tree AS t2 WHERE t2.inode=t1.inode) 
        AS nlinks FROM tree AS t0 LEFT JOIN tree AS t1 ON t0.inode = 
t1.parent WHERE t0.parent IS NULL AND t1.name = 'testfile'

The console responds the same both ways - no such file or directory.

Tony Shadwick wrote:
> Well, I did that, did a make clean, make, make install, umount 
> /dev/fuse0, and then mount_fusefs /dev/fuse0 /mysqlfs mysqlfs 
> -ohost=localhost -ouser=mysqlfs -opassword=mysqlfs -odatabase=mysqlfs, I 
> get the exact some result, and still nothing in the mysqlfs.log file. ???
> 
> Michal Ludvig wrote:
>> Tony Shadwick wrote:
>>> I'm still trying to debug this...I turned on verbose logging of mysql, 
>>> hoping to find the answer to what's going on, but I'm afraid the logs 
>>> are somewhat greek to me:
>>>
>>> manager# cd /mysqlfs/
>>> manager# touch new
>>> touch: new: No such file or directory
>>> manager# cat /var/log/mysql.log
>>> /usr/local/libexec/mysqld, Version: 5.0.37-log (FreeBSD port: 
>>> mysql-server-5.0.37). started with:
>> Turn on MySQLfs logging instead.
>>
>> On the top of log.c it reads:
>>
>> //int log_types_mask = LOG_ERROR | LOG_INFO | LOG_DEBUG;
>> int log_types_mask = LOG_ERROR | LOG_INFO;
>> //int log_debug_mask = LOG_D_CALL | LOG_D_SQL | LOG_D_OTHER;
>> //int log_debug_mask = LOG_D_CALL;
>> int log_debug_mask = 0;
>>
>> Instead make it:
>>
>> int log_types_mask = LOG_ERROR | LOG_INFO | LOG_DEBUG;
>> //int log_types_mask = LOG_ERROR | LOG_INFO;
>> int log_debug_mask = LOG_D_CALL | LOG_D_SQL | LOG_D_OTHER;
>> //int log_debug_mask = LOG_D_CALL;
>> //int log_debug_mask = 0;
>>
>> Yes I know this should be a command line switch and not a compile time
>> setting ;-)
>>
>> Michal
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Mysqlfs-general mailing list
>> Mys...@li...
>> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Mysqlfs-general mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Michal L. <mi...@lo...>]

Tony Shadwick wrote:
> K, I feel like I'm not making progress here. :(  With log debugging on, 
> here's what happens when I go to run mkdir testdir:
> 
> 2007-04-14 11:09:21 1338 mysqlfs_getattr("/testdir")
> 2007-04-14 11:09:21 1338 sql=SELECT t1.inode, t1.name, t1.parent, 
>   (SELECT COUNT(inode) FROM tree AS t2 WHERE t2.inode=t1.inode) 
>         AS nlinks FROM tree AS t0 LEFT JOIN tree AS t1 ON t0.inode = 
> t1.parent WHERE t0.parent IS NULL AND t1.name = 'testdir'
> 2007-04-14 11:09:21 1338 mysqlfs_mkdir("/testdir", 040755)
> 2007-04-14 11:09:21 1338 sql=SELECT t1.inode, t1.name, t1.parent, 
>   (SELECT COUNT(inode) FROM tree AS t2 WHERE t2.inode=t1.inode) 
>         AS nlinks FROM tree AS t0 LEFT JOIN tree AS t1 ON t0.inode = 
> t1.parent WHERE t0.parent IS NULL AND t1.name = 'testdir'
> 
> and touch testfile
> 
> 2007-04-14 11:11:29 1338 mysqlfs_getattr("/testfile")
> 2007-04-14 11:11:29 1338 sql=SELECT t1.inode, t1.name, t1.parent, 
>   (SELECT COUNT(inode) FROM tree AS t2 WHERE t2.inode=t1.inode) 
>         AS nlinks FROM tree AS t0 LEFT JOIN tree AS t1 ON t0.inode = 
> t1.parent WHERE t0.parent IS NULL AND t1.name = 'testfile'
> 2007-04-14 11:11:29 1338 mysqlfs_getattr("/testfile")
> 2007-04-14 11:11:29 1338 sql=SELECT t1.inode, t1.name, t1.parent, 
>   (SELECT COUNT(inode) FROM tree AS t2 WHERE t2.inode=t1.inode) 
>         AS nlinks FROM tree AS t0 LEFT JOIN tree AS t1 ON t0.inode = 
> t1.parent WHERE t0.parent IS NULL AND t1.name = 'testfile'
> 2007-04-14 11:11:29 1338 mysqlfs_mknod("/testfile", 100644): file
> 2007-04-14 11:11:29 1338 sql=SELECT t1.inode, t1.name, t1.parent, 
>   (SELECT COUNT(inode) FROM tree AS t2 WHERE t2.inode=t1.inode) 
>         AS nlinks FROM tree AS t0 LEFT JOIN tree AS t1 ON t0.inode = 
> t1.parent WHERE t0.parent IS NULL AND t1.name = 'testfile'
> 
> The console responds the same both ways - no such file or directory.

It doesn't do any INSERTs - weird. Have you imported the DB schema into 
database 'mysqlfs'? Does user 'mysqlfs' have enough rights to read/write it?

Michal

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Tony S. <tsh...@os...>]

Yes and yes.  Followed your instructions to the hilt.  I've even tried 
user root instead of user mysqlfs.  Same outcome.

Michal Ludvig wrote:
> Tony Shadwick wrote:
>> K, I feel like I'm not making progress here. :(  With log debugging on, 
>> here's what happens when I go to run mkdir testdir:
>>
>> 2007-04-14 11:09:21 1338 mysqlfs_getattr("/testdir")
>> 2007-04-14 11:09:21 1338 sql=SELECT t1.inode, t1.name, t1.parent, 
>>   (SELECT COUNT(inode) FROM tree AS t2 WHERE t2.inode=t1.inode) 
>>         AS nlinks FROM tree AS t0 LEFT JOIN tree AS t1 ON t0.inode = 
>> t1.parent WHERE t0.parent IS NULL AND t1.name = 'testdir'
>> 2007-04-14 11:09:21 1338 mysqlfs_mkdir("/testdir", 040755)
>> 2007-04-14 11:09:21 1338 sql=SELECT t1.inode, t1.name, t1.parent, 
>>   (SELECT COUNT(inode) FROM tree AS t2 WHERE t2.inode=t1.inode) 
>>         AS nlinks FROM tree AS t0 LEFT JOIN tree AS t1 ON t0.inode = 
>> t1.parent WHERE t0.parent IS NULL AND t1.name = 'testdir'
>>
>> and touch testfile
>>
>> 2007-04-14 11:11:29 1338 mysqlfs_getattr("/testfile")
>> 2007-04-14 11:11:29 1338 sql=SELECT t1.inode, t1.name, t1.parent, 
>>   (SELECT COUNT(inode) FROM tree AS t2 WHERE t2.inode=t1.inode) 
>>         AS nlinks FROM tree AS t0 LEFT JOIN tree AS t1 ON t0.inode = 
>> t1.parent WHERE t0.parent IS NULL AND t1.name = 'testfile'
>> 2007-04-14 11:11:29 1338 mysqlfs_getattr("/testfile")
>> 2007-04-14 11:11:29 1338 sql=SELECT t1.inode, t1.name, t1.parent, 
>>   (SELECT COUNT(inode) FROM tree AS t2 WHERE t2.inode=t1.inode) 
>>         AS nlinks FROM tree AS t0 LEFT JOIN tree AS t1 ON t0.inode = 
>> t1.parent WHERE t0.parent IS NULL AND t1.name = 'testfile'
>> 2007-04-14 11:11:29 1338 mysqlfs_mknod("/testfile", 100644): file
>> 2007-04-14 11:11:29 1338 sql=SELECT t1.inode, t1.name, t1.parent, 
>>   (SELECT COUNT(inode) FROM tree AS t2 WHERE t2.inode=t1.inode) 
>>         AS nlinks FROM tree AS t0 LEFT JOIN tree AS t1 ON t0.inode = 
>> t1.parent WHERE t0.parent IS NULL AND t1.name = 'testfile'
>>
>> The console responds the same both ways - no such file or directory.
> 
> It doesn't do any INSERTs - weird. Have you imported the DB schema into 
> database 'mysqlfs'? Does user 'mysqlfs' have enough rights to read/write it?
> 
> Michal
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Mysqlfs-general mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Tony S. <tsh...@os...>]

I have the exact same issue with the cvs version.  I may be able to 
write files larger than 1MB with this version, but at the moment, I 
can't write anything at all. :P

manager# mount_fusefs /dev/fuse0 /mysqlfs/ mysqlfs -ohost=localhost 
-ouser=mysqlfs -opassword=mysqlfs -odatabase=mysqlfs
* Opening logfile 'mysqlfs.log':  OK
manager# pwd
/usr/local/src/mysqlfs
manager# cat mysqlfs.log
manager# touch /mysqlfs/new
touch: /mysqlfs/new: No such file or directory
manager# df -h
Filesystem     Size    Used   Avail Capacity  Mounted on
/dev/ad0s1a    496M     76M    380M    17%    /
devfs          1.0K    1.0K      0B   100%    /dev
/dev/ad0s1e    496M     20K    456M     0%    /tmp
/dev/ad0s1f     28G    1.9G     24G     7%    /usr
/dev/ad0s1d    2.9G     39M    2.6G     1%    /var
devfs          1.0K    1.0K      0B   100%    /var/named/dev
/dev/fuse0       0B      0B      0B   100%    /mysqlfs

Tony Shadwick wrote:
> I pulled down the cvs version a few mins ago, but my box doesn't appear 
> to have aclocal, so I'm working on that since there's no configure 
> script. :P
> 
> Tony Shadwick
> OSS Solutions
> 
> 
> Stef Bon wrote:
>> On Friday 13 April 2007 20:39:37 Tony Shadwick wrote:
>>> Well, figured this out partially.  time.h on freebsd doesn't define the 
>>> struct utimbuf. utime.h does, however including it with or without 
>>> time.h makes no difference, I get the same error. :\
>>>
>>> Tony Shadwick
>>> OSS Solutions
>> Hello,
>>
>> do not use the 3.1 version. Use the version from cvs. 3.1 version is not able to store files bigger than 1M.
>>
>> Stef Bon
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Mysqlfs-general mailing list
>> Mys...@li...
>> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Mysqlfs-general mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Tony S. <tsh...@os...>]

Nevermind, I got it.  Your code appears to be fine, it's just the 
default CFLAGS includes -Wall -Werror.  I removed the -Wall and it built 
fine.  Weirdness.  Is this fixable?

Tony Shadwick wrote:
> Well, figured this out partially.  time.h on freebsd doesn't define the 
> struct utimbuf. utime.h does, however including it with or without 
> time.h makes no difference, I get the same error. :\
> 
> Tony Shadwick
> OSS Solutions
> 
> Tony Shadwick wrote:
>> Yes, there is Fuse for FreeBSD.  I've built it from ports, and it's 
>> using API 2.6.
>>
>> Anyhooo....../configure is okay (after editing fuse.h to report the 
>> correct API, apparently it has a backwards compat mode to version 2.1 
>> and defaults to that.  Changing to 2.6 per the instructions works 
>> fine!), then when I attempt to do make or gmake, I get this error:
>>
>> manager# gmake
>> gmake  all-am
>> gmake[1]: Entering directory `/usr/local/src/mysqlfs-0.4.0-rc1'
>> if gcc -DHAVE_CONFIG_H -I. -I. -I.   -I/usr/include -I/usr/local/include 
>> -L/usr/lib -L/usr/local/lib  -I/usr/include -I/usr/local/include 
>> -L/usr/lib -L/usr/local/lib -I/usr/local/include -Wall -Werror 
>> -I/usr/local/include/mysql -Wall -Werror -MT query.o -MD -MP -MF 
>> ".deps/query.Tpo" -c -o query.o query.c; \
>>          then mv -f ".deps/query.Tpo" ".deps/query.Po"; else rm -f 
>> ".deps/query.Tpo"; exit 1; fi
>> query.c: In function `query_utime':
>> query.c:439: warning: long int format, time_t arg (arg 4)
>> query.c:439: warning: long int format, time_t arg (arg 5)
>> query.c:439: warning: long int format, time_t arg (arg 4)
>> query.c:439: warning: long int format, time_t arg (arg 5)
>> gmake[1]: *** [query.o] Error 1
>> gmake[1]: Leaving directory `/usr/local/src/mysqlfs-0.4.0-rc1'
>> gmake: *** [all] Error 2
>>
>> The code section it's complaining about is below.  The last line is line 
>> 439.
>>
>> ---------
>>
>> int query_utime(MYSQL *mysql, long inode, struct utimbuf *time)
>> {
>>      int ret;
>>      char sql[SQL_MAX];
>>
>>      snprintf(sql, SQL_MAX,
>>               "UPDATE inodes "
>>               "SET atime=%ld, mtime=%ld "
>>               "WHERE inode=%lu",
>>               time->actime, time->modtime, inode);
>>
>> --------
>>
>> It appears to not like time->actime and time->modtime.  Any idea what 
>> might cause this or how to debug it/fix it up?
>>
>> Thanks!
>>
>> Tony Shadwick
>> OSS Solutions
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Mysqlfs-general mailing list
>> Mys...@li...
>> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Mysqlfs-general mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Michal L. <mi...@lo...>]

Tony Shadwick wrote:
>>> query.c: In function `query_utime':
>>> query.c:439: warning: long int format, time_t arg (arg 4)
>>> query.c:439: warning: long int format, time_t arg (arg 5)
>>> query.c:439: warning: long int format, time_t arg (arg 4)
>>> query.c:439: warning: long int format, time_t arg (arg 5)
>>> gmake[1]: *** [query.o] Error 1
>>> gmake[1]: Leaving directory `/usr/local/src/mysqlfs-0.4.0-rc1'
>>> gmake: *** [all] Error 2
>>>
>>> The code section it's complaining about is below.  The last line is line 
>>> 439.

What GCC version have you got on your FreeBSD?

> Nevermind, I got it.  Your code appears to be fine, it's just the 
> default CFLAGS includes -Wall -Werror.  I removed the -Wall and it built 
> fine.  Weirdness.  Is this fixable?

You should have removed -Werror instead (this switch turns warnings into 
errors) and keep -Wall to see all warnings. Some might be useful. I'll 
remove -Werror from default CFLAGS in future versions.

Michal

Re: [Mysqlfs-general] Trouble building on FreeBSD 6 using Fuse from Ports

[Tony S. <tsh...@os...>]

 > gcc -v
Using built-in specs.
Configured with: FreeBSD/i386 system compiler
Thread model: posix
gcc version 3.4.6 [FreeBSD] 20060305



Michal Ludvig wrote:
> Tony Shadwick wrote:
>>>> query.c: In function `query_utime':
>>>> query.c:439: warning: long int format, time_t arg (arg 4)
>>>> query.c:439: warning: long int format, time_t arg (arg 5)
>>>> query.c:439: warning: long int format, time_t arg (arg 4)
>>>> query.c:439: warning: long int format, time_t arg (arg 5)
>>>> gmake[1]: *** [query.o] Error 1
>>>> gmake[1]: Leaving directory `/usr/local/src/mysqlfs-0.4.0-rc1'
>>>> gmake: *** [all] Error 2
>>>>
>>>> The code section it's complaining about is below.  The last line is line 
>>>> 439.
> 
> What GCC version have you got on your FreeBSD?
> 
>> Nevermind, I got it.  Your code appears to be fine, it's just the 
>> default CFLAGS includes -Wall -Werror.  I removed the -Wall and it built 
>> fine.  Weirdness.  Is this fixable?
> 
> You should have removed -Werror instead (this switch turns warnings into 
> errors) and keep -Wall to see all warnings. Some might be useful. I'll 
> remove -Werror from default CFLAGS in future versions.
> 
> Michal
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Mysqlfs-general mailing list
> Mys...@li...
> https://lists.sourceforge.net/lists/listinfo/mysqlfs-general