Folder Scan Not Working

[Sean]

Hi,

 

First of all I want to say thank you for making such a wonderful and useful app - the potential of this product is amazing. However, I am having a few issues setting it up. I recently setup streeme with my Plugbox using the SQLite backend (MySQL PDO was being uncooperative). However, using the folder backend, when I scan for media, the scan-media command does not pick up any of my files on my drive. The drive is an NTFS drive with full write support via ntfs-3g and permissions should be set such that everyone can read and write. I have attached databases.yml and app.yml for good measure. Any ideas?

 

 

Thanks,

 

Sean

[Maxime Hadjinlian]

Hey,

I too have the same problem with SQLite. Don't know why. I tried
SQLite using the VM Ware image available
but it only prints some logs saying "Query preparatoin failed for:
MediaScan/add_song" and I can't really find out
where or why this message is printed.

Some help would be welcome :/

On 17 avr, 10:39, Sean <seane...@gmail.com> wrote:
> Hi,
>
> First of all I want to say thank you for making such a wonderful and useful
> app - the potential of this product is amazing. However, I am having a few

> issues setting it up. I recently setup streeme with my Plugbox<http://plugapps.com/index.php5/Main_Page> using

> the SQLite backend (MySQL PDO was being uncooperative). However, using the
> folder backend, when I scan for media, the scan-media command does not pick
> up any of my files on my drive. The drive is an NTFS drive with full write
> support via ntfs-3g and permissions should be set such that everyone can
> read and write. I have attached databases.yml and app.yml for good
> measure. Any ideas?
>
> Thanks,
>
> Sean
>

>  databases.yml
> < 1 000AfficherTélécharger
>
>  app.yml
> 2KAfficherTélécharger

[Rich]

Thanks for the bug reports:

@sean - are you using samba style path names or is the drive mounted
with a drive letter? I found that the trick was that PHP's fopen
sometimes misbehaved with mapped drives on NAS's - PHP and windows FS
stuff can be a bit annoying sometimes, honestly. There's a workaround
in the apps/client/config/app.yml config file to remap itunes paths to
samba style file paths, but for the filesystem, you'll have to use the
samba style path instead of the drive letter.

this:

wf:
watched_folders:
- "//mediabox/music"

or this:

# If your music is predominantly stored on NAS drives on Windows,
please remap the locations
# from the itunes style full paths to the windows style sharing
paths using forward slashes
# only required for itunes scanning
# eg. 'file://localhost/Z:' : '//mediabox/music'
# you may experience some pretty heavy lag over SAMBA, but it'll
work fine
mdl:
mapped_drive_locations:
'file://localhost/Z:' : '//mediabox/music'

make sure to type symfony cc after changing those paths as
configuration files are cached


@maxime - this is the first report I've heard on this one and the code
may have a bug somewhere for SQLite - I'll go look at the tests for
that class you provided and see if I can track down what the trouble
is. At least it's giving you a concrete error in the VM environment,
should make it easy to track down :) - I don't know why the mySQL
version isn't working in the VM though - it worked when the VM
shipped :/.. that sounds weird. sorry for the headaches and I'll get
back to you.

-Rich

On Apr 19, 5:11 am, Maxime Hadjinlian <maxime.hadjinl...@gmail.com>
wrote:

[Sean]

Rich,

The drive is mounted as /media/ProDrive under Arch Linux using NTFS-3G as the backend, so there is no drive letter as such. I tried the above suggestion with the double slash at the beginning of the file path to no avail, so I'm not really sure what the issue is. Could it be an issue with SQLite and NTFS drives? I certainly hope not, but if you deem it is, I suppose I'll give PostgreSQL a spin as well (I am extremely new to all databases and webservers by the way, so excuse any newbiness).

Thanks for your help,

Sean

[Rich]

@sean I think you might want to run through the unit test suite just
to see exactly where the scan is failing. In your databases.yml file,
set the test connection to something like:

test:
doctrine:
class: sfDoctrineDatabase
param:
dsn: 'sqlite:/media/ProDrive/streeme/testdb.sqlite'
encoding: utf8
attributes:
default_table_collate: utf8_general_ci
default_table_charset: utf8

then run the unit tests by typing:

./symfony test:unit

with any luck you'll catch the offending system red handed. if you get
a test that goes red, let me know and I'll see what the particular
problem with sqllite is/take a screenshot of the tests. On my ubuntu
test VM, the tests are currently all passing, but I haven't explored
all of the linuxes. This could still be a permission or filesystem
issue though, so make double sure that the permissions are set and if
you have a linux ext2/3 partition kicking around, try putting sqlite
on there instead, just in case sqlite isn't compatible with NTFS3G.




@maxime how long ago did you install Streeme out of curiousity, did
you copy it over from the VM version? can you type:

svn up

in the streeme project folder
just to make sure you have the latest version - I seem to remember
that query preparation message to be in a very old copy of Streeme.


-Rich

-Rich

[Sean]

Rich,

 

 

Thanks for the suggestion! I caught at least one problem - I idiotically left the php executable out of the allowed path in php.ini. I will rerun the testdb and then the scan and let you know how things go.

 

-Sean

[Sean]

Rich, upon fixing the php.ini, the testdb ran fine, but still no dice as far as finding any of my files for the actual database. I'll see if I can find and ext2/3 drive to test this on as my plugbox's drive is only a 1 GB USB stick.

-Sean

[Sean]

Hey Rich,

I finally got almost everything working! The problem was I needed more memory, so I made some swap and now can use mySQL. The issue I'm having now though is the following: after logging in:

"Warning: Your session has expired. Please login again to extend the session - Reload the page to sign in again"

What should I do?

[Rich]

you may want to check out the latest code if you haven't already done
so. That message means that either a) you aren't logged in anymore or
b) the song list is corrupt for some reason. if you use firebug, you
should be able to see what's coming back for the song list and see
what's going on. But make sure you update to the latest code (v0.5)
and follow all the directions to re-initialize your database as there
have been a lot of changes to the database schema lately. Hope it's
not too hard to figure out

-Rich

[Sean]

Thanks Rich, I'll try that out and see what happens.