First database import

[mapomme1108]

Hello,

I install slimpd on Debian 8.7.1

I have installed mpd, mariadb-server, php5, python2.7 and sphinx . I have created a virtualhost in apache2 and when I type the slimpd address in a webbrowser, there is this message
"Can't connect to database. please check your settings!"

To create the database, I would like to know how to execute the command :
php '*/slimpd/slimpd' hard-reset

When I type this command in a ssh console, there is this message
"Could not open input file: */slimpd/slimpd"

Thanks

[othmar52]

Hi
the asterisk * indicates the path of your slimpd filesystem.

you can use the absolute path like

php /var/www/slimpd/slimpd hard-reset or whatever your installation directory looks like.

or simply php ./slimpd hard-reset in case you are already inside the directory

so slimpd is a php file in your filesystem without the extension .php

[mapomme1108]

Hello,

Thank you, it works.

How long should the database importation last?
I ran the database importation an hour ago and I still have the message
"Can't connect to database. please check your settings!"

[othmar52]

How long should the database importation last?

It depends on the size of your music collection.

I ran the database importation an hour ago and I still have the message
"Can't connect to database. please check your settings!"

due to some caching issues remove the cached config manually each time after changing stuff in your config

rm localdata/cache/conf*

and give it another try

[mapomme1108]

Hello,

I have created a test music collection with one album

I still have the message "Can't connect to database"

I have added my database informations in /etc/sphinxsearch/sphinx.conf but it is the same.

When I run "indexer slimpdmain slimpdsuggest", there is this message
Sphinx 2.2.11-id64-release (95ae9a6)
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/etc/sphinxsearch/sphinx.conf'...
WARNING: no such index 'slimpdmain', skipping.
WARNING: no such index 'slimpdsuggest', skipping.
total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg

[othmar52]

I still have the message "Can't connect to database"

have you tested your database-credentials? it seems that you have configured invalid credentials.

to verify this try:

grep -A 5 database localdata/cache/conf-a5a38a2b010.php
then you should see something like:

  'database' => 
  array (
    'dbhost' => '127.0.0.1',
    'dbusername' => 'slimpd',
    'dbpassword' => 'xxxyyy',
    'dbdatabase' => 'slimpd',
  ),

and then try to connect with those credentials to the mysql-shell

mysql -uslimpd -pxxxyyy -h127.0.0.1

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| slimpd             |
+--------------------+
2 rows in set (0,00 sec)

mysql> quit
Bye

[mapomme1108]

Hello,
I have successfully create the database with php ./slimpd hard-reset

I can see my music in the web interface but I can't play it

There is always this message :
Can't connect to mpd. please check your settings!

When I play localy, nothing happens.
When I play with MPD, there is this message
OH Snap! SliMpd/The Beastie Boys - The Mix Up (2010)/02 - 14th St. Break.mp3 does not exist in MPD-database. updating

[othmar52]

please try to login as admin in the sliMpd frontend and visit /systemcheck which should be in the main nav

maybe you will find some useful hints there!?

[mapomme1108]

Hello,
I have visited the systemcheck
and there is this message
` CONNECTION

ERROR: MPD connection to host 192.168.0.23 on port 6600 can't be established
Check your configuration core/config/config_local.ini in section
[mpd]
host = 127.0.0.1
port = 6600
username =
password =

I have checked my config_local.ini > there is a [mpd] section but there are no username and password entries

[othmar52]

Hi
username and password can be left blank in case you dont have it activated in your /etc/mpd.conf
maybe your mpd configuration does not allow connections from non-localhost clients!?
check in your setting of bind_to_address in your mpd.conf

you can insert the ip of the machine that runs sliMpd.
to allow connections from any ip you can configure

bind_to_address "0.0.0.0"

after modifying /etc/mpd.conf you have to restart mpd