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