Always get the 'not found' on query

[GoogleCodeExporter]

All server is running. like:
./metadatadb -d /root/ffmpeg/audio.db -l 7
./auscoutd -d tcp://localhost:4005 -l 7
./tblservd -s localhost -p 4005 -i /root/ffmpeg/audio.db

create sql  is:
CREATE TABLE trcks (
        uid INTEGER PRIMARY KEY AUTOINCREMENT,
        composer varchar(30),
        title    varchar(30),
        performer varchar(30),
        date      varchar(10),
        album     varchar(30),
        genre     varchar(10),
        year      int,
        dur       int,
        part      int,
        time      datetime
);
------------------------------------------------------------

I submit 2 mp3. and get the following info. How to confirm it is right? i don't 
find anything on table trcks.

[root@localhost ffmpeg]# auscoutclient /root/ffmpeg/audio tcp://localhost:4005 
2 0 0
cmd = 2,  2 files in /root/ffmpeg/audio
(0) 1.mp3
    2872 hash frames

Sending metadata:    1.mp3              0  0  0  ---->What is the mean?

Recieved: id = 0
***************************************************

(1) 2.mp3
    2905 hash frames

Sending metadata:    2.mp3            (12)   0  0  0

Recieved: id = 4294904040
***************************************************

--------------------------------------------------------------------
I test on query. like, 

[root@localhost ffmpeg]# auscoutclient /root/ffmpeg/audio tcp://localhost:4005 
1 10 5 -->what is the mean for nbtoggles?
cmd = 1,  2 files in /root/ffmpeg/audio
(0) 1.mp3
    904 hash frames

Sending query ...

Recieved: not found

***********Hit Enter for next**********************

(1) 2.mp3
    904 hash frames

Sending query ...

Recieved: not found

***********Hit Enter for next**********************

 Use the same mp3 files. query is 'not found'

MANY THANKS.

Original issue reported on code.google.com by tengming...@gmail.com on 13 Mar 2013 at 3:36

[GoogleCodeExporter]

The metadatadb server runs on port 4000 by default.  The auscoutd needs the 
address of the metadata server. You can do this with the auscoutd -d option - 
"-d tcp://localhost:4000" .  You had port 4005 when it should be 4000.

Original comment by starkd88@gmail.com on 13 Mar 2013 at 2:54

[GoogleCodeExporter]

Thanks. I change the port.
when 'auscoutclient /root/ffmpeg/audio tcp://localhost:4005 2 0 0'. Can find 
the following data on table

1||1.mp3|||||0|0|0|2013-03-13 15:09:49
2||2.mp3||||(12)|0|0|0|2013-03-13 15:10:01

Is it right?

But still query is 'not found'

 like, 

[root@localhost ffmpeg]# auscoutclient /root/ffmpeg/audio tcp://localhost:4005 
1 10 5 
cmd = 1,  2 files in /root/ffmpeg/audio
(0) 1.mp3
    904 hash frames

Sending query ...

Recieved: not found

***********Hit Enter for next**********************

(1) 2.mp3
    904 hash frames

Sending query ...

Recieved: not found

***********Hit Enter for next**********************

Original comment by tengming...@gmail.com on 13 Mar 2013 at 3:23

[GoogleCodeExporter]

Could you send the audiodb.sql to me? I don't find this sql on build. I use 
that sql from google.

Original comment by tengming...@gmail.com on 13 Mar 2013 at 3:26

[GoogleCodeExporter]

You need to submit the files again. Be sure to start with new tbl index files 
too. Then after submitting, sync the tables with:

kill -s <pid_tblservd> SIGUSR1

This will merge the temp table into the main table.

Original comment by starkd88@gmail.com on 13 Mar 2013 at 3:26

[GoogleCodeExporter]

the audiodb.sql file in svn should be fine.  I've never changed that.

Original comment by starkd88@gmail.com on 13 Mar 2013 at 3:27

[GoogleCodeExporter]

Thanks. I will reboot the OS and create one new db.  Will send the detail info 
soon. 

Original comment by tengming...@gmail.com on 13 Mar 2013 at 3:31

[GoogleCodeExporter]

Thanks. I will reboot the OS and create one new db.  Will send the detail info 
soon. 

Original comment by tengming...@gmail.com on 13 Mar 2013 at 3:32

[GoogleCodeExporter]

I reboot the OS ,change the directory, create one new db. get the same result.  
Could you give me some advice? many thanks.

[root@localhost tmp2]# sqlite3 audio.db
SQLite version 3.7.15.2 2013-01-09 11:53:05
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .read audiodb.sql

sqlite> .quit
[root@localhost tmp2]# metadatadb -d /root/tmp2/audio.db -l 7
[root@localhost tmp2]# auscoutd -d tcp://localhost:4000 -l 7
[root@localhost tmp2]# tblservd -s localhost -p 4005 -i /root/tmp2/audio.db
[root@localhost tmp2]# auscoutclient /root/ffmpeg/audio tcp://localhost:4005 2 
0 0
cmd = 2,  2 files in /root/ffmpeg/audio
(0) 1.mp3
    2872 hash frames

Sending metadata:    1.mp3              0  0  0

Recieved: id = 1
***************************************************

(1) 2.mp3
    2905 hash frames

Sending metadata:    2.mp3            (12)   0  0  0

Recieved: id = 2
***************************************************

[root@localhost tmp2]# cp ../ffmpeg/test.sql .
[root@localhost tmp2]# ls
audio.db  audio.db.idx  audiodb.sql  test.sql
[root@localhost tmp2]# ls -l
×Ü¼Æ 131236
-rw-r--r-- 1 root root      3072 03-13 23:40 audio.db
-rwxr-xr-x 1 root root 134217789 03-13 23:39 audio.db.idx
-rw-r--r-- 1 root root       351 03-13 23:37 audiodb.sql
-rw-r--r-- 1 root root        21 03-13 23:58 test.sql
[root@localhost tmp2]# sqlite3 audio.db
SQLite version 3.7.15.2 2013-01-09 11:53:05
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .read test.sql
1||1.mp3|||||0|0|0|2013-03-13 15:40:10
2||2.mp3||||(12)|0|0|0|2013-03-13 15:40:22

sqlite> .quit
[root@localhost tmp2]# auscoutclient /root/ffmpeg/audio tcp://localhost:4005 1 
10 2
cmd = 1,  2 files in /root/ffmpeg/audio
(0) 1.mp3
    904 hash frames

Sending query ...

Recieved: not found

***********Hit Enter for next**********************

(1) 2.mp3
    904 hash frames

Sending query ...

Recieved: not found

***********Hit Enter for next**********************

Original comment by tengming...@gmail.com on 13 Mar 2013 at 4:12

[GoogleCodeExporter]

looks like you forgot to send the signal to the tblservd. Try:

kill -s USR1 <pid_tblservd>

you can get the process id number by running "ps -A" 

Original comment by starkd88@gmail.com on 13 Mar 2013 at 4:46

[GoogleCodeExporter]

thanks. 
I can submit and query the music now.
And I did the following testing:
1. Record music on IPHONE.  An amr file. It is fine. audioscount can distribute.

2. Record music on Android. It is amr/3gpp file. But it is fail. Attached 
please find these two files.
[root@localhost ~]# auscoutclient /root/tmp2/check tcp://localhost:4005 1 0 10

(1) 254.3gpp
unable to read file - error 1006

(2) 124.amr
unable to read file - error 2

Could you give me some advice?

Original comment by tengming...@gmail.com on 14 Mar 2013 at 12:03

Attachments:

• 124.amr
• 254.3gpp

[GoogleCodeExporter]

You need the opencore-amr development libraries to open those files, and 
compile the AudioData library to use that library.  Specifically, you need 
opencore-amrnb (not the wb).  I don't think it will read the 3gpp file.  

Original comment by starkd88@gmail.com on 14 Mar 2013 at 4:21

[GoogleCodeExporter]

I have been installed opencore-amr. 
[root@localhost ffmpeg]# find / -name 'opencore-amrnb'
/usr/local/include/opencore-amrnb

And audioscout can identify iphone's amr, Only can not for Android's amr file

Original comment by tengming...@gmail.com on 14 Mar 2013 at 4:34