[SOLVED]pg_trgm.so does not exist error when seach
Posted: Thu Sep 12, 2013 9:06 pmDear all,
I beginner with subsonic, even my newbee condition, I've been able to set gresql, launch music cabinet and scan my music folder yoohooo
I'm now facing an issue when I'm doing a search on the magnifying glass, I've an error mesage saying that libdir/pg_trgm.so does not exist.
Problem Description: I'm now facing an issue when I'm doing a search on the magnifying glass, I've an error mesage saying that libdir/pg_trgm.so does not exist.
Troubleshooting Steps: I found out the file pg_trgm.so in /usr/lib/postgresql/9.3 folder; as a 9.2 folder exist and assuming that subsonic was searching there, I placed a sybolic link to 9.3/lib/pg_trgm.so
I got another error message telling that
Playback Application and version: flashplayer, works fine...
Subsonic Version:Subsonic, originally written by Sindre Mehus. Built with MusicCabinet plugin, version 0.7.24c, on 25 mars 2013.
Server Version: jetty/8.y.z-SNAPSHOT, java 1.7.0_25, Linux (36,0 MB / 64,8 MB)
Hardware Platform: Debian squeeze 2.6.32-5-amd64
Java Memory Limit: hum I gess it's Memory Used 40 of 66 MB?
Problem Filename: pg_trgm.so
Output from ffmpeg -i: unable to install ffmpeg on my debian squeeze, dependency issue
Last ten log file lines:
Well ffmped is present but not correcly installed, to be complete a add my source.list:
Also the error message I've got
If someboby can help me, it would be great, thanks in advance.
Cheers
MOD: Moved post to correct sub-forum
I beginner with subsonic, even my newbee condition, I've been able to set gresql, launch music cabinet and scan my music folder yoohooo
I'm now facing an issue when I'm doing a search on the magnifying glass, I've an error mesage saying that libdir/pg_trgm.so does not exist.
Problem Description: I'm now facing an issue when I'm doing a search on the magnifying glass, I've an error mesage saying that libdir/pg_trgm.so does not exist.
Troubleshooting Steps: I found out the file pg_trgm.so in /usr/lib/postgresql/9.3 folder; as a 9.2 folder exist and assuming that subsonic was searching there, I placed a sybolic link to 9.3/lib/pg_trgm.so
I got another error message telling that
- Code: Select all
/usr/lib/postgresql/9.2/lib/pg_trgm.so: undefined symbol: palloc0
Playback Application and version: flashplayer, works fine...
Subsonic Version:Subsonic, originally written by Sindre Mehus. Built with MusicCabinet plugin, version 0.7.24c, on 25 mars 2013.
Server Version: jetty/8.y.z-SNAPSHOT, java 1.7.0_25, Linux (36,0 MB / 64,8 MB)
Hardware Platform: Debian squeeze 2.6.32-5-amd64
Java Memory Limit: hum I gess it's Memory Used 40 of 66 MB?
Problem Filename: pg_trgm.so
Output from ffmpeg -i: unable to install ffmpeg on my debian squeeze, dependency issue
- Code: Select all
ffmpeg : Dépend: libavcodec54 mais ne sera pas installé
Dépend: libavdevice54 mais ne sera pas installé
Dépend: libavfilter3 mais ne sera pas installé
Dépend: libavformat54 mais ne sera pas installé
Dépend: libavutil51 mais ne sera pas installé
Dépend: libpostproc52 mais ne sera pas installé
Dépend: libswresample0 mais ne sera pas installé
Dépend: libswscale2 mais ne sera pas installé
E: Paquets défectueux
Last ten log file lines:
- Code: Select all
[11/09/13 23:03:50 CEST] DEBUG InputStreamReaderThread (/var/subsonic/transcode/ffmpeg) WM/EncodingTime : 1532748
[11/09/13 23:03:50 CEST] DEBUG InputStreamReaderThread (/var/subsonic/transcode/ffmpeg) WM/UniqueFileIdentifier: AMGa_id=R 375547;AMGp_id=P 226070;AMGt_id=T 3297089
[11/09/13 23:03:50 CEST] DEBUG InputStreamReaderThread (/var/subsonic/transcode/ffmpeg) TCOM : Manu Chao
[11/09/13 23:03:50 CEST] DEBUG InputStreamReaderThread (/var/subsonic/transcode/ffmpeg) TPUB : EMI
[11/09/13 23:03:50 CEST] DEBUG InputStreamReaderThread (/var/subsonic/transcode/ffmpeg) TCON : Latin
[11/09/13 23:03:50 CEST] DEBUG InputStreamReaderThread (/var/subsonic/transcode/ffmpeg) TALB : Clandestino
[11/09/13 23:03:50 CEST] DEBUG InputStreamReaderThread (/var/subsonic/transcode/ffmpeg) TPE2 : Manu Chao
[11/09/13 23:03:50 CEST] DEBUG InputStreamReaderThread (/var/subsonic/transcode/ffmpeg) WM/Provider : AMG
[11/09/13 23:03:50 CEST] DEBUG InputStreamReaderThread (/var/subsonic/transcode/ffmpeg) WM/ProviderRating: 7
[11/09/13 23:03:50 CEST] DEBUG InputStreamReaderThread (/var/subsonic/transcode/ffmpeg) WM/ProviderStyle: Latin
Well ffmped is present but not correcly installed, to be complete a add my source.list:
- Code: Select all
deb http://ftp.fr.debian.org/debian/ squeeze main
deb-src http://ftp.fr.debian.org/debian/ squeeze main
deb http://security.debian.org/ squeeze/updates main non-free
deb-src http://security.debian.org/ squeeze/updates main non-free
# squeeze-updates, previously known as 'volatile'
deb http://ftp.fr.debian.org/debian/ squeeze-updates main non-free
deb-src http://ftp.fr.debian.org/debian/ squeeze-updates main non-free
# Dépot PostgreSQL Debian Squeeze
deb http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg main
Also the error message I've got
- Code: Select all
Subsonic encountered an internal error. You can report this error in the Subsonic Forum. Please include the information below.
Exception org.springframework.dao.DataAccessResourceFailureException
Message PreparedStatementCallback; SQL [select ma.id, ma.artist_name_capitalization from library.artist la inner join music.artist ma on la.artist_id = ma.id where la.artist_name_search like ? order by la.hasalbums desc, ma.artist_name offset ? limit ?]; ERREUR: n'a pas pu accéder au fichier « $libdir/pg_trgm » : Aucun fichier ou dossier de ce type; nested exception is org.postgresql.util.PSQLException: ERREUR: n'a pas pu accéder au fichier « $libdir/pg_trgm » : Aucun fichier ou dossier de ce type
Java version Oracle Corporation 1.7.0_25
Operating system Linux 2.6.32-5-amd64
Server jetty/8.y.z-SNAPSHOT
Memory Used 40 of 66 MB
Stack trace org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select ma.id, ma.artist_name_capitalization from library.artist la inner join music.artist ma on la.artist_id = ma.id where la.artist_name_search like ? order by la.hasalbums desc, ma.artist_name offset ? limit ?]; ERREUR: n'a pas pu accéder au fichier « $libdir/pg_trgm » : Aucun fichier ou dossier de ce type; nested exception is org.postgresql.util.PSQLException: ERREUR: n'a pas pu accéder au fichier « $libdir/pg_trgm » : Aucun fichier ou dossier de ce type at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLException
If someboby can help me, it would be great, thanks in advance.
Cheers
MOD: Moved post to correct sub-forum
Edit: solved removing the postgre repository from sources.list removing all postgre packages and reinstalling from squeeze repository