Nie jesteś zalogowany.
Jeśli nie posiadasz konta, zarejestruj je już teraz! Pozwoli Ci ono w pełni korzystać z naszego serwisu. Spamerom dziękujemy!

Ogłoszenie

Prosimy o pomoc dla małej Julki — przekaż 1% podatku na Fundacji Dzieciom zdazyć z Pomocą.
Więcej informacji na dug.net.pl/pomagamy/.

#1  2013-06-23 12:01:21

  morfik - Cenzor wirtualnego świata

morfik
Cenzor wirtualnego świata
Skąd: ze WSI
Zarejestrowany: 2011-09-15
Serwis

Brak połączenia z mpd

Problem jako taki udało mi się rozwiązać ale może komuś się przyda.

Zainstalowałem mpd oraz dwa klienty -- gmpc i sonata . W obu przypadkach nie szło się podłączyć do mpd. Config /etc/mpd.conf był domyślny. Znalazłem wątek sprzed 5 lat -- http://forum.dug.net.pl/viewtopic.php?id=12005 i po przejrzeniu go ustaliłem co nasŧepuje:

W pliku /etc/mpd.conf widnieją wpisy:

Kod:

bind_to_address        "localhost"
port                "6600"

lsof zwraca:

Kod:

root:~# lsof -P -n -l | egrep "^mpd.*LISTEN"
mpd       6606           115    5u     IPv6      31042         0t0        TCP [::1]:6600 (LISTEN)
mpd       6606           115    7u     IPv4      31043         0t0        TCP 127.0.0.1:6600 (LISTEN)
mpd       6606 6609      115    5u     IPv6      31042         0t0        TCP [::1]:6600 (LISTEN)
mpd       6606 6609      115    7u     IPv4      31043         0t0        TCP 127.0.0.1:6600 (LISTEN)
mpd       6606 6610      115    5u     IPv6      31042         0t0        TCP [::1]:6600 (LISTEN)
mpd       6606 6610      115    7u     IPv4      31043         0t0        TCP 127.0.0.1:6600 (LISTEN)
mpd       6606 6612      115    5u     IPv6      31042         0t0        TCP [::1]:6600 (LISTEN)
mpd       6606 6612      115    7u     IPv4      31043         0t0        TCP 127.0.0.1:6600 (LISTEN)
mpd       6606 6614      115    5u     IPv6      31042         0t0        TCP [::1]:6600 (LISTEN)
mpd       6606 6614      115    7u     IPv4      31043         0t0        TCP 127.0.0.1:6600 (LISTEN)
mpd       6606 6615      115    5u     IPv6      31042         0t0        TCP [::1]:6600 (LISTEN)
mpd       6606 6615      115    7u     IPv4      31043         0t0        TCP 127.0.0.1:6600 (LISTEN)

nc zwraca:

Kod:

morfik:~$ nc localhost 6600
OK MPD 0.17.0

W logu /var/log/mpd/mpd.log po ustawieniu log_level "verbose" w pliku konfiguracyjnym widnieją wpisy:

Kod:

Jun 23 10:07 : avahi: Initializing interface
Jun 23 10:07 : avahi: Client changed to state 2
Jun 23 10:07 : avahi: Client is RUNNING
Jun 23 10:07 : avahi: Registering service _mpd._tcp/Music Player
Jun 23 10:07 : avahi: Service group changed to state 0
Jun 23 10:07 : avahi: Service group is UNCOMMITED
Jun 23 10:07 : state_file: Loading state file /var/lib/mpd/state
No protocol specified
xcb_connection_has_error() returned true
Jun 23 10:07 : avahi: Service group changed to state 1
Jun 23 10:07 : avahi: Service group is REGISTERING
Jun 23 10:07 : avahi: Service group changed to state 2
Jun 23 10:07 : avahi: Service 'Music Player' successfully established.

Demon startuje:

Kod:

root:~# /etc/init.d/mpd restart
[ ok ] Stopping Music Player Daemon: mpd.
[....] Starting Music Player Daemon: mpdpath: path_set_fs_charset: fs charset is: UTF-8
pcm: libsamplerate converter 'Fastest Sinc Interpolator'
wildmidi: configuration file does not exist: /etc/timidity/timidity.cfg
database: reading DB
disabling the last.fm playlist plugin because account is not configured
disabling the soundcloud playlist plugin because API key is not set
daemon: opening pid file
daemon: daemonized!
daemon: writing pid file
. ok

A mimo to, przy odpaleniu gmpc dostałem komunikat:

Kod:

Error in connection() 111 - Połączenie odrzucone
Error in connection() 111 - Połączenie odrzucone

W sonacie z kolei dostałem coś takiego:

Kod:

morfik:~$ sonata
/usr/lib/python2.7/dist-packages/sonata/dbus_plugin.py:26: DeprecationWarning: Importing dbus.glib to use the GLib main loop with dbus-python is deprecated.
Instead, use this sequence:

    from dbus.mainloop.glib import DBusGMainLoop

    DBusGMainLoop(set_as_default=True)

  import dbus.glib

(sonata:8507): Gnome-WARNING **: Accessibility: failed to find module 'libgail-gnome' which is needed to make this application accessible
2013-06-23 10:10:07  Connection lost while reading MPD hello
2013-06-23 10:10:07  Not connected
2013-06-23 10:10:07  Connection lost while reading MPD hello
2013-06-23 10:10:07  Not connected
2013-06-23 10:10:08  Connection lost while reading MPD hello
2013-06-23 10:10:08  Not connected
...

Po wyexportowaniu:

Kod:

export MPD_HOST=127.0.0.1
export MPD_PORT=6600

Sonata się łączy ale gmpc dalej pluje błędami.

Okazał się winny adres ip. W gmpc były dwa profile jeden Music Player i drugi Default. Ja wybrałem ten pierwszy chyba nie muszę pisać dlaczego. Tam w polu komputer jest fe80::3e4a:92ff:fe00:4c5b . W default było zaś, nie pamiętam już co. xD  W każdym razie w tym pięcioletnim wątku ludzie mieli się upewnić, że używają localhost, to wpisałem localhost. Dostałem poniższy błąd

Kod:

Jun 23 11:03 : client: libwrap refused connection (libwrap=mpd) from [::1]:34955
Jun 23 11:03 : client: libwrap refused connection (libwrap=mpd) from [::1]:34958
Jun 23 11:03 : client: libwrap refused connection (libwrap=mpd) from [::1]:34960
Jun 23 11:03 : client: libwrap refused connection (libwrap=mpd) from [::1]:34962
Jun 23 11:03 : client: libwrap refused connection (libwrap=mpd) from [::1]:34964
Jun 23 11:03 : client: libwrap refused connection (libwrap=mpd) from [::1]:34965

To zmieniłem na 127.0.0.1 i problem się rozwiązał. Co ciekawe, to przy fe80::3e4a:92ff:fe00:4c5b w iptables można było zaobserwować przypisanie zapytań do regułki z

Kod:

   12  2475 REJECT     udp  --  *      *       0.0.0.0/0            0.0.0.0/0            reject-with icmp-port-unreachable

Ale wyłączenie zapory nic nie zmieniło.

Przy okazji znalazłem trochę nieaktualny poradnik od mpd http://jakilinux.org/aplikacje/uzywaj-mpd-i-ncmpcpp-jak-profesjonalista/ . Z niego się dowiedziałem, że można mpd startować per user i całą konfigurację trzymać w katalogu /home/morfik/ . Wystarczy skopiować zawartość /etc/mpd.conf i wrzucić ją do ~/.mpdconf oraz stworzyć katalog ~/.mpd/ a w nim odpowiednie pliki:

Kod:

mkdir -p ~/.mpd/playlists
touch ~/.mpd/mpd.db
touch ~/.mpd/log

mpd będzie działać lokalnie przy odpowiednim dostosowaniu ~/.mpdconf (jeszcze się temu nie przyglądałem zbytnio) oraz wydawaniu polecenia mpd jako zwykły user. Poza tym, przy używaniu mpd > alsa> pulse dźwięk jest bardzo zniekształcony ale przy bezpośrednim przesyłaniu do pulse już jest wszystko w porzadku.

Póki co, trzeba ubijać i gmpc/sonatę + mpd by zatrzymać dźwięk. W przypadku ubicia samego klienta, dźwięk jest dalej odtwarzany. W przypadku gdy chce się konfigurować mpd per user, trzeba wyłączyć domyślnego demona w pliku /etc/default/mpd :

Kod:

START_MPD=false

W przeciwnym wypadku dostaniemy błąd:

Kod:

[....] Starting Music Player Daemon: mpdFailed to bind to '[::1]:6600': Address already in use
no message buffer overruns
 failed!

Obra programy zjadają razem 50MiB:

Kod:

# ps -eo "%mem user args" --sort -%mem | grep mpd
 0.8 morfik   mpd
# ps -eo "%mem user args" --sort -%mem | grep gmpc
 1.7 morfik   gmpc

Także, wszystko jest na najlepszej drodze by amaroka się pozbyć o ile tylko uda mi się dostosować klienta.

Ostatnio edytowany przez morfik (2013-06-23 12:12:36)

Offline

 

#2  2013-06-23 15:57:39

  yossarian - Szczawiożerca

yossarian
Szczawiożerca
Skąd: Shangri-La
Zarejestrowany: 2011-04-25

Re: Brak połączenia z mpd

Tu masz lepszy i aktualniejszy poradnik:
http://crunchbang.org/forums/viewtopic.php?pid=182574

Na kilku komputerach już instalowałem i nie ma żadnych problemów.

Offline

 

#3  2013-06-24 00:05:31

  morfik - Cenzor wirtualnego świata

morfik
Cenzor wirtualnego świata
Skąd: ze WSI
Zarejestrowany: 2011-09-15
Serwis

Re: Brak połączenia z mpd

Generalnie nie trzeba exportować:

Kod:

export MPD_HOST=127.0.0.1
export MPD_PORT=6600

Samo zmienienie adresu z localhost na 127.0.0.1 pomaga, praktycznie w każdym kliencie. Trochę lipa z tymi textowymi klientami tam ciągle trzeba wpisywać --host 127.0.0.1 --port 6600. xD

No i dobrze, że jest możliwość update bazy, bo jak tagi zmieniłem to nie mogłem ich uaktualnić, a tak można to zrobić przez:

Kod:

mpc --host 127.0.0.1 --port 6600 update

Offline

 

#4  2013-06-24 09:29:25

  yossarian - Szczawiożerca

yossarian
Szczawiożerca
Skąd: Shangri-La
Zarejestrowany: 2011-04-25

Re: Brak połączenia z mpd

Trochę lipa z tymi textowymi klientami tam ciągle trzeba wpisywać --host 127.0.0.1 --port 6600. xD[/quote]
Dziwne te twoje problemy ;)

Offline

 

#5  2013-06-24 10:59:26

  morfik - Cenzor wirtualnego świata

morfik
Cenzor wirtualnego świata
Skąd: ze WSI
Zarejestrowany: 2011-09-15
Serwis

Re: Brak połączenia z mpd

Te wszystkie textowe klienty chcą tego, nie mogli w nich zdefiniować domyślnych opcji? W sumie to już lepiej jest wyexportować te zmienne i mieć święty spokój. xD

Offline

 

#6  2013-06-24 11:20:51

  yossarian - Szczawiożerca

yossarian
Szczawiożerca
Skąd: Shangri-La
Zarejestrowany: 2011-04-25

Re: Brak połączenia z mpd

[quote=morfik]Te wszystkie textowe klienty chcą tego, nie mogli w nich zdefiniować domyślnych opcji? W sumie to już lepiej jest wyexportować te zmienne i mieć święty spokój. xD[/quote]
Przecież te problemy występują tylko u ciebie :)
Ustaw wszystko raz dobrze i nic więcej nie będzie trzeba dopisywać.

Offline

 

#7  2013-06-27 14:30:10

  spook - Użytkownik

spook
Użytkownik
Zarejestrowany: 2013-03-26

Re: Brak połączenia z mpd

Ja mpd mam wyłączony z autostaru w pliku /etc/default/mpd

Kod:

## Defaults for the MPD init script, sourced by /etc/init.d/mpd on Debian
## systems.  Uncomment (remove the leading '#') and change values as needed.

## Change this to prevent MPD from being started as a system service (for
## example, if you want to run it from a regular user account)
START_MPD=false

## The configuration file location for mpd:
# MPDCONF=/etc/mpd.conf

Konfig wygląda tak

Kod:

# An example configuration file for MPD
# See the mpd.conf man page for a more detailed description of each parameter.


# Files and directories #######################################################
#
# This setting controls the top directory which MPD will search to discover the
# available audio files and add them to the daemon's online database. This 
# setting defaults to the XDG directory, otherwise the music directory will be
# be disabled and audio files will only be accepted over ipc socket (using
# file:// protocol) or streaming files over an accepted protocol.
#
music_directory        "/home/spook/music"
#
# This setting sets the MPD internal playlist directory. The purpose of this
# directory is storage for playlists created by MPD. The server will use 
# playlist files not created by the server but only if they are in the MPD
# format. This setting defaults to playlist saving being disabled.
#
playlist_directory        "/home/spook/.mpd/playlists"
#
# This setting sets the location of the MPD database. This file is used to
# load the database at server start up and store the database while the 
# server is not up. This setting defaults to disabled which will allow
# MPD to accept files over ipc socket (using file:// protocol) or streaming
# files over an accepted protocol.
#
db_file            "/home/spook/.mpd/tag_cache"
# 
# These settings are the locations for the daemon log files for the daemon.
# These logs are great for troubleshooting, depending on your log_level
# settings.
#
# The special value "syslog" makes MPD use the local syslog daemon. This
# setting defaults to logging to syslog, otherwise logging is disabled.
#
log_file            "/home/spook/.mpd/mpd.log"
#
# This setting sets the location of the file which stores the process ID
# for use of mpd --kill and some init scripts. This setting is disabled by
# default and the pid file will not be stored.
#
pid_file            "/home/spook/.mpd/pid"
#
# This setting sets the location of the file which contains information about
# most variables to get MPD back into the same general shape it was in before
# it was brought down. This setting is disabled by default and the server 
# state will be reset on server start up.
#
state_file            "/home/spook/.mpd/state"
#
# The location of the sticker database.  This is a database which
# manages dynamic information attached to songs.
#
sticker_file                   "/home/spook/.mpd/sticker.sql"
#
###############################################################################


# General music daemon options ################################################
#
# This setting specifies the user that MPD will run as. MPD should never run as
# root and you may use this setting to make MPD change its user ID after
# initialization. This setting is disabled by default and MPD is run as the
# current user.
#
#user                "mpd"
#
# This setting specifies the group that MPD will run as. If not specified
# primary group of user specified with "user" setting will be used (if set).
# This is useful if MPD needs to be a member of group such as "audio" to
# have permission to use sound card.
#
#group                          "nogroup"
#
# This setting sets the address for the daemon to listen on. Careful attention
# should be paid if this is assigned to anything other then the default, any.
# This setting can deny access to control of the daemon. Choose any if you want
# to have mpd listen on every address
#
# For network
#bind_to_address        "127.0.0.1"
bind_to_address                "localhost"
#
# And for Unix Socket
#bind_to_address        "/var/run/mpd/socket"
#
# This setting is the TCP port that is desired for the daemon to get assigned
# to.
#
#port                "6600"
#
# This setting controls the type of information which is logged. Available 
# setting arguments are "default", "secure" or "verbose". The "verbose" setting
# argument is recommended for troubleshooting, though can quickly stretch
# available resources on limited hardware storage.
#
#log_level            "default"
#
# If you have a problem with your MP3s ending abruptly it is recommended that 
# you set this argument to "no" to attempt to fix the problem. If this solves
# the problem, it is highly recommended to fix the MP3 files with vbrfix
# (available as vbrfix in the debian archive), at which
# point gapless MP3 playback can be enabled.
#
gapless_mp3_playback            "yes"
#
# This setting enables MPD to create playlists in a format usable by other
# music players.
#
save_absolute_paths_in_playlists    "yes"
#
# This setting defines a list of tag types that will be extracted during the 
# audio file discovery process. Optionally, 'comment' can be added to this
# list.
#
metadata_to_use    "artist,album,title,track,name,genre,date,composer,performer,disc"
#
# This setting enables automatic update of MPD's database when files in 
# music_directory are changed.
#
auto_update    "yes"
#
# Limit the depth of the directories being watched, 0 means only watch
# the music directory itself.  There is no limit by default.
#
auto_update_depth "3"
#
###############################################################################


# Symbolic link behavior ######################################################
#
# If this setting is set to "yes", MPD will discover audio files by following 
# symbolic links outside of the configured music_directory.
#
#follow_outside_symlinks    "yes"
#
# If this setting is set to "yes", MPD will discover audio files by following
# symbolic links inside of the configured music_directory.
#
#follow_inside_symlinks        "yes"
#
###############################################################################


# Zeroconf / Avahi Service Discovery ##########################################
#
# If this setting is set to "yes", service information will be published with
# Zeroconf / Avahi.
#
#zeroconf_enabled        "yes"
#
# The argument to this setting will be the Zeroconf / Avahi unique name for
# this MPD server on the network.
#
#zeroconf_name            "Music Player"
#
###############################################################################


# Permissions #################################################################
#
# If this setting is set, MPD will require password authorization. The password
# can setting can be specified multiple times for different password profiles.
#
#password                        "password@read,add,control,admin"
#
# This setting specifies the permissions a user has who has not yet logged in. 
#
#default_permissions             "read,add,control,admin"
#
###############################################################################


# Input #######################################################################
#

input {
        plugin "curl"
#       proxy "proxy.isp.com:8080"
#       proxy_user "user"
#       proxy_password "password"
}

#
###############################################################################

# Audio Output ################################################################
#
# MPD supports various audio output types, as well as playing through multiple 
# audio outputs at the same time, through multiple audio_output settings 
# blocks. Setting this block is optional, though the server will only attempt
# autodetection for one sound card.
#
# See <http://mpd.wikia.com/wiki/Configuration#Audio_Outputs> for examples of 
# other audio outputs.
#
# An example of an ALSA output:
#
#audio_output {
#    type        "alsa"
#    name        "My ALSA Device"
#    device        "hw:0,0"    # optional
#    format        "44100:16:2"    # optional
#    mixer_device    "default"    # optional
#    mixer_control    "PCM"        # optional
#    mixer_index    "0"        # optional
#}

# An example of an OSS output:
#
audio_output {
    type        "oss"
    name        "My OSS Device"
#    device        "/dev/dsp"    # optional
#    format        "44100:16:2"    # optional
#    mixer_device    "/dev/mixer"    # optional
#    mixer_control    "PCM"        # optional
}
#
# An example of a shout output (for streaming to Icecast):
#
#audio_output {
#    type        "shout"
#    encoding    "ogg"            # optional
#    name        "My Shout Stream"
#    host        "localhost"
#    port        "8000"
#    mount        "/mpd.ogg"
#    password    "hackme"
#    quality        "5.0"
#    bitrate        "128"
#    format        "44100:16:1"
#    protocol    "icecast2"        # optional
#    user        "source"        # optional
#    description    "My Stream Description"    # optional
#    genre        "jazz"            # optional
#    public        "no"            # optional
#    timeout        "2"            # optional
#}
#
# An example of a recorder output:
#
#audio_output {
#       type            "recorder"
#       name            "My recorder"
#       encoder         "vorbis"                # optional, vorbis or lame
#       path            "/var/lib/mpd/recorder/mpd.ogg"
##      quality         "5.0"                   # do not define if bitrate is defined
#       bitrate         "128"                   # do not define if quality is defined
#       format          "44100:16:1"
#}
#
# An example of a httpd output (built-in HTTP streaming server):
#
#audio_output {
#    type        "httpd"
#    name        "My HTTP Stream"
#    encoder        "vorbis"        # optional, vorbis or lame
#    port        "8000"
#    quality        "5.0"            # do not define if bitrate is defined
#    bitrate        "128"            # do not define if quality is defined
#    format        "44100:16:1"
#}
#
# An example of a pulseaudio output (streaming to a remote pulseaudio server)
#
#audio_output {
#    type        "pulse"
#    name        "My Pulse Output"
#    server        "remote_server"        # optional
#    sink        "remote_server_sink"    # optional
#}
#
## Example "pipe" output:
#
#audio_output {
#    type        "pipe"
#    name        "my pipe"
#    command        "aplay -f cd 2>/dev/null"
## Or if you're want to use AudioCompress
#    command        "AudioCompress -m | aplay -f cd 2>/dev/null"
## Or to send raw PCM stream through PCM:
#    command        "nc example.org 8765"
#    format        "44100:16:2"
#}
#
## An example of a null output (for no audio output):
#
#audio_output {
#    type        "null"
#    name        "My Null Output"
#}
#
# This setting will change all decoded audio to be converted to the specified
# format before being passed to the audio outputs. By default, this setting is
# disabled.
#
#audio_output_format        "44100:16:2"
#
# If MPD has been compiled with libsamplerate support, this setting specifies 
# the sample rate converter to use.  Possible values can be found in the 
# mpd.conf man page or the libsamplerate documentation. By default, this is
# setting is disabled.
#
#samplerate_converter        "Fastest Sinc Interpolator"
#
audio_output {
        type                    "fifo"
        name                    "My FIFO"
        path                    "/tmp/mpd.fifo"
        format                  "44100:16:2"
}

###############################################################################


# Volume control mixer ########################################################
#
# These are the global volume control settings. By default, this setting will
# be detected to the available audio output device, with preference going to 
# hardware mixing. Hardware and software mixers for individual audio_output
# sections cannot yet be mixed.
#
# An example for controlling an ALSA, OSS or Pulseaudio mixer; If this
# setting is used other sound applications will be affected by the volume
# being controlled by MPD.
#
#mixer_type            "hardware"
#
# An example for controlling all mixers through software. This will control
# all controls, even if the mixer is not supported by the device and will not
# affect any other sound producing applications.
#
mixer_type            "software"
#
# This example will not allow MPD to touch the mixer at all and will disable
# all volume controls.
#
#mixer_type            "disabled"
#
###############################################################################


# Normalization automatic volume adjustments ##################################
#
# This setting specifies the type of ReplayGain to use. This setting can have
# the argument "album" or "track". See <http://www.replaygain.org> for more
# details. This setting is disabled by default.
#
#replaygain            "album"
#
# This setting sets the pre-amp used for files that have ReplayGain tags. By
# default this setting is disabled.
#
#replaygain_preamp        "0"
#
# This setting enables on-the-fly normalization volume adjustment. This will
# result in the volume of all playing audio to be adjusted so the output has 
# equal "loudness". This setting is disabled by default.
#
#volume_normalization        "no"
#
###############################################################################


# MPD Internal Buffering ######################################################
#
# This setting adjusts the size of internal decoded audio buffering. Changing
# this may have undesired effects. Don't change this if you don't know what you
# are doing.
#
#audio_buffer_size        "2048"
#
# This setting controls the percentage of the buffer which is filled before 
# beginning to play. Increasing this reduces the chance of audio file skipping, 
# at the cost of increased time prior to audio playback.
#
#buffer_before_play        "10%"
#
###############################################################################


# Resource Limitations ########################################################
#
# These settings are various limitations to prevent MPD from using too many
# resources. Generally, these settings should be minimized to prevent security
# risks, depending on the operating resources.
#
#connection_timeout        "60"
#max_connections        "10"
#max_playlist_length        "16384"
#max_command_list_size        "2048"
#max_output_buffer_size        "8192"
#
###############################################################################


# Character Encoding ##########################################################
#
# If file or directory names do not display correctly for your locale then you 
# may need to modify this setting. After modification of this setting mpd 
# --create-db must be run to change the database.
#
filesystem_charset        "UTF-8"
#
# This setting controls the encoding that ID3v1 tags should be converted from.
#
id3v1_encoding            "ISO-8859-2"
#
###############################################################################
# SIDPlay decoder #############################################################
#
# songlength_database:
#  Location of your songlengths file, as distributed with the HVSC.
#  The sidplay plugin checks this for matching MD5 fingerprints.
#  See http://www.c64.org/HVSC/DOCUMENTS/Songlengths.faq
#
# default_songlength:
#  This is the default playing time in seconds for songs not in the
#  songlength database, or in case you're not using a database.
#  A value of 0 means play indefinitely.
#
# filter:
#  Turns the SID filter emulation on or off.
#
#decoder {
#       plugin                  "sidplay"
#       songlength_database     "/media/C64Music/DOCUMENTS/Songlengths.txt"
#       default_songlength      "120"
#       filter "true"
#}
#
###############################################################################

Jeśli mam zamiar skorzystać z klienta odpalam go w skrypcie

Kod:

#!/bin/sh
(mpd && xterm -e ncmpc && mpd --kill) &
exit "$?"

Działa bez problemu a mpd nie jest uruchomiony bez potrzeby.

Offline

 

Stopka forum

Powered by PunBB
© Copyright 2002–2005 Rickard Andersson
Możesz wyłączyć AdBlock — tu nie ma reklam ;-)

[ Generated in 0.009 seconds, 11 queries executed ]

Informacje debugowania

Time (s) Query
0.00010 SET CHARSET latin2
0.00004 SET NAMES latin2
0.00098 SELECT u.*, g.*, o.logged FROM punbb_users AS u INNER JOIN punbb_groups AS g ON u.group_id=g.g_id LEFT JOIN punbb_online AS o ON o.ident='3.144.101.75' WHERE u.id=1
0.00080 REPLACE INTO punbb_online (user_id, ident, logged) VALUES(1, '3.144.101.75', 1732620165)
0.00040 SELECT * FROM punbb_online WHERE logged<1732619865
0.00067 SELECT topic_id FROM punbb_posts WHERE id=235408
0.00007 SELECT id FROM punbb_posts WHERE topic_id=23795 ORDER BY posted
0.00055 SELECT t.subject, t.closed, t.num_replies, t.sticky, f.id AS forum_id, f.forum_name, f.moderators, fp.post_replies, 0 FROM punbb_topics AS t INNER JOIN punbb_forums AS f ON f.id=t.forum_id LEFT JOIN punbb_forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=3) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id=23795 AND t.moved_to IS NULL
0.00005 SELECT search_for, replace_with FROM punbb_censoring
0.00235 SELECT u.email, u.title, u.url, u.location, u.use_avatar, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online FROM punbb_posts AS p INNER JOIN punbb_users AS u ON u.id=p.poster_id INNER JOIN punbb_groups AS g ON g.g_id=u.group_id LEFT JOIN punbb_online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE p.topic_id=23795 ORDER BY p.id LIMIT 0,25
0.00092 UPDATE punbb_topics SET num_views=num_views+1 WHERE id=23795
Total query time: 0.00693 s