- (type "para_client si" to find out)
-
- - the user who runs para_client has the paraslash DB_WRITE
- and DB_READ permissions set in server.users
-
+ (type "para_client si" to find out)
+ - the user who runs para_client has the paraslash AFS_WRITE
+ and AFS_READ permissions set in server.users
Remember: If something doesn't work as expected, look at the server
log file and/or increase output verbosity by using the -l switch for
server and client.
Remember: If something doesn't work as expected, look at the server
log file and/or increase output verbosity by using the -l switch for
server and client.
-you'll have to recompile.
+you'll have to recompile. If configure does not detect your mysql
+installation, use the --enable-mysql-headers and --enable-mysql-libs
+options to specify the mysql path explicitly . Example:
The second command forces para_server to re-init the mysql selector.
Check the log. There should not be any warnings or errors.
The second command forces para_server to re-init the mysql selector.
Check the log. There should not be any warnings or errors.
If this command fails, it most likely means the audio file directory
(given in the server configuration file) does not exist, is empty,
If this command fails, it most likely means the audio file directory
(given in the server configuration file) does not exist, is empty,
prints the list of all files known by the mysql selector. If the list
is empty, double check the mysql_audio_file_dir option.
prints the list of all files known by the mysql selector. If the list
is empty, double check the mysql_audio_file_dir option.
-Create a stream which selects all songs
-~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-
-To keep it simple, let's only define the stream "all_songs". See below for
-advanced stream usage.
+To keep it simple, let's only define the stream "all_songs". See
+below for advanced stream usage.
para_client stradd all_songs < /dev/null
para_client sl 10 all_songs
The latter command should show you ten filenames.
para_client stradd all_songs < /dev/null
para_client sl 10 all_songs
The latter command should show you ten filenames.
An attribute is simply a bit which can be set for each audio file
individually. You may have as many attributes as you like. A new
An attribute is simply a bit which can be set for each audio file
individually. You may have as many attributes as you like. A new
A stream is a pair of expressions in terms of attributes and other data
contained in the database. The first, boolian, expression determines
A stream is a pair of expressions in terms of attributes and other data
contained in the database. The first, boolian, expression determines
- Assume you already have an attribute "test" and you'd like to
- to restrict audio streaming to those files having the "test"
- attribute set. Define a new stream "only_test" by
+Assume you already have an attribute "test" and you'd like to to
+restrict audio streaming to those files having the "test" attribute
+set. Define a new stream "only_test" by
There is no need to keep the temporary files containing the stream
definition since you can always use the strq command to get it back:
There is no need to keep the temporary files containing the stream
definition since you can always use the strq command to get it back:
The accept/deny expressions are used to find out which songs are
permitted. The following four cases are all possible and valid:
The accept/deny expressions are used to find out which songs are
permitted. The following four cases are all possible and valid:
- o Only accept lines: Songs that match at least one accept
- expression are accepted, all others are denied:
+ - Only accept lines: Songs that match at least one accept
+ expression are accepted, all others are denied:
- o Only deny lines: Songs that match at least one deny expression are
- denied, all others are accepted:
+ - Only deny lines: Songs that match at least one deny expression are
+ denied, all others are accepted:
- o Both accept and deny lines: A song is accepted if it matches
- at least one accept expression, but no deny expression, i.e.
+ - Both accept and deny lines: A song is accepted if it matches
+ at least one accept expression, but no deny expression, i.e.
is true for a given audio file if and only if it has the attribute
"foo" set. Here are some more macros you can use:
is true for a given audio file if and only if it has the attribute
"foo" set. Here are some more macros you can use:
- o IS_N_SET(attr): True if attribute attr is not set
-
- o NAME_LIKE(string): True if basename is like (in the sense
- of mysql) "string"
-
- o LASTPLAYED(): Expands to number of minutes that are gone
- since this audio file has been played (by paraslash).
-
- o NUMPLAYED(): Expands to number of times, the file has
- been played.
-
- o PICID(): Expands to the number of the picture which is
- associated with this song.
+ - IS_N_SET(attr): True if attribute attr is not set
+ - NAME_LIKE(string): True if basename is like (in the sense
+ of mysql) "string"
+ - LASTPLAYED(): Expands to number of minutes that are gone
+ since this audio file has been played (by paraslash).
+ - NUMPLAYED(): Expands to number of times, the file has
+ been played.
+ - PICID(): Expands to the number of the picture which is
+ associated with this song.
To give a real-life example, suppose you have already added the
attributes "pop", "rock" with the "na" command. Assume also that you
To give a real-life example, suppose you have already added the
attributes "pop", "rock" with the "na" command. Assume also that you
You may put a single score line anywhere in the stream definition. If
omitted, the default scoring rule specified in the configuration file
applies. If there is no default scoring rule in the config file either,
You may put a single score line anywhere in the stream definition. If
omitted, the default scoring rule specified in the configuration file
applies. If there is no default scoring rule in the config file either,
The mysql selector can also magage images that, when associated
with one or more audio files, can be displayed by para_sdl_gui and
The mysql selector can also magage images that, when associated
with one or more audio files, can be displayed by para_sdl_gui and