Skocz do zawartości

arczi886

Użytkownicy
  • Zawartość

    24
  • Rejestracja

  • Ostatnio

Wszystko napisane przez arczi886

  1. Witam, Poszukuję systemu FTP na stronę WWW dla drukarni. Po krótce: Klient ma swoje konto, gdzie się loguje podając nick i pass (bez podawania adresu i portu) po czym kilkoma kliknięciami jest w stanie dodać na FTP'a pliki. Może być to w formie wtyczki do WordPress lub w formie osobnego skrytpu. Czy są jakieś gotowe rozwiązania ? Jeśli tak to jakie Pozdrawiam, Artur
  2. FTP lub Cloud na stronę drukarni

    Czy Twoim zdaniem w celach komercyjnych można wykorzystać wersję darmową ownCloud?
  3. FTP lub Cloud na stronę drukarni

    ciekawe rozwiązanie tylko sporo kosztuje licencja
  4. system FTP

    Witam, Poszukuje systemu zarządzania kontami FTP web. Potrzebuję tworzyć Klientowi konto FTP wraz z kontem do systemu. Po zalogowaniu się do systemu Klient mógłby bez użycia Klienta FTP dodawać pliki na serwer do przypisanego dla niego konta FTP poprzez interface web. Dodam, że chodzi o duże pliki graficzne
  5. witam posiadam serwer vps wraz z darmowym panelem hostingowym (poniewaz chce zapoznac sie tylko z dzialaniem firm hostingowych) kloxo. Dtworzylem nowego klienta wraz z kontem www , ftp i poddomena. wchodzac na konto http://ip_serwera/~demo mozna wejsc bez problemu na konto. Ale wchodza poprzez www.demo.nazwa_domeny.pl wywala blad Gdzie popelnielem blad albo czego nie skonfigurowalenm?
  6. problem z adresami do kont klienckich

    hehe wiadomo, ze studentem jestem. Musze zarobic troche przed nowym semestrem:) a tak powaznie to robie to dla swojej satysfakcji i z czystej ciekawosci.
  7. postfix i ispconfig 3

    Witam Po skonfigurowaniu serwera www, php itd przyszedl czas na serwer poczty. Wraz z ispconfig zainstalowany zostal postfix. Niestety ale nie moge wysylac maila na zewnatrz ani tez odebrac. Wewnatrz oczywiscie wszystko jest jak najbardziej ok. Ponizej zamieszczam ostatnich kilka linijek logow z maillog Prosze o pomoc:) Sep 12 01:27:55 Host2You spamd[1570]: spamd: server killed by SIGTERM, shutting$ Sep 12 01:28:03 Host2You amavis[1430]: starting. /usr/sbin/amavisd-new at Host$ Sep 12 01:28:03 Host2You amavis[1430]: Perl version 5.010000 Sep 12 01:28:04 Host2You spamd[1537]: logger: removing stderr method Sep 12 01:28:05 Host2You spamd[1557]: dns: sendto() failed: Operation not permi$ Sep 12 01:28:09 Host2You spamd[1557]: spamd: server started on port 783/tcp (ru$ Sep 12 01:28:09 Host2You spamd[1557]: spamd: server pid: 1557 Sep 12 01:28:09 Host2You spamd[1557]: spamd: server successfully spawned child $ Sep 12 01:28:09 Host2You spamd[1557]: spamd: server successfully spawned child $ Sep 12 01:28:09 Host2You spamd[1557]: prefork: child states: II Sep 12 01:28:14 Host2You authdaemond: modules="authmysql", daemons=5 Sep 12 01:28:14 Host2You authdaemond: Installing libauthmysql Sep 12 01:28:14 Host2You authdaemond: Installation complete: authmysql Sep 12 01:29:52 Host2You imapd: Connection, ip=[::ffff:213.156.106.210] Sep 12 01:29:53 Host2You imapd: Disconnected, ip=[::ffff:213.156.106.210], time$ Sep 12 01:30:01 Host2You pop3d: Connection, ip=[::ffff:127.0.0.1] Sep 12 01:30:01 Host2You pop3d: Disconnected, ip=[::ffff:127.0.0.1] Sep 12 01:30:01 Host2You imapd: Connection, ip=[::ffff:127.0.0.1] Sep 12 01:30:01 Host2You imapd: Disconnected, ip=[::ffff:127.0.0.1], time=0 zaznaczam jeszcze, ze nie zamierzam otwierac hostingu jak wskazuje na to nazwa:) chce tylko i wylacznie zapoznac sie z tym jak dzialaja firmy hostingowe ponizej plik conf # See /usr/share/postfix/main.cf.dist for a commented, more complete version # Debian specific: Specifying a file name will cause the first # line of that file to be used as the name. The Debian default # is /etc/mailname. #myorigin = /etc/mailname smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU) biff = no # appending .domain is the MUA's job. append_dot_mydomain = no # Uncomment the next line to generate "delayed mail" warnings #delay_warning_time = 4h readme_directory = /usr/share/doc/postfix # TLS parameters smtpd_tls_cert_file = /etc/postfix/smtpd.cert smtpd_tls_key_file = /etc/postfix/smtpd.key smtpd_use_tls = no smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache # See /usr/share/doc/postfix/TLS_README.gz in the postfix-doc package for # information on enabling SSL in the smtp client. myhostname = mail.host2you.pl alias_maps = hash:/etc/aliases alias_database = hash:/etc/aliases myorigin = /etc/mailname mydestination = mail.host2you.pl, localhost, localhost.localdomain relayhost = host2you.pl mynetworks = all mailbox_command = procmail -a "$EXTENSION" mailbox_size_limit = 0 recipient_delimiter = + inet_interfaces = all html_directory = /usr/share/doc/postfix/html virtual_alias_domains = ts-poland.pl virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf virtual_mailbox_base = /var/vmail virtual_uid_maps = static:5000 virtual_gid_maps = static:5000 smtpd_sasl_auth_enable = yes broken_sasl_auth_clients = yes smtpd_sasl_authenticated_header = yes smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, check_recipient_access mysql:/etc/postfix/mysql-virtual_recipient.cf, reject_un$ smtpd_tls_security_level = may transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf relay_domains = mysql:/etc/postfix/mysql-virtual_relaydomains.cf relay_recipient_maps = mysql:/etc/postfix/mysql-virtual_relayrecipientmaps.cf virtual_create_maildirsize = yes virtual_maildir_extended = yes virtual_mailbox_limit_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf virtual_mailbox_limit_override = yes virtual_maildir_limit_message = "The user you are trying to reach is over quota." virtual_overquota_bounce = yes proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_reci$ smtpd_sender_restrictions = check_sender_access mysql:/etc/postfix/mysql-virtual_sender.cf smtpd_client_restrictions = check_client_access mysql:/etc/postfix/mysql-virtual_client.cf maildrop_destination_concurrency_limit = 1 maildrop_destination_recipient_limit = 1 virtual_transport = maildrop header_checks = regexp:/etc/postfix/header_checks mime_header_checks = regexp:/etc/postfix/mime_header_checks nested_header_checks = regexp:/etc/postfix/nested_header_checks body_checks = regexp:/etc/postfix/body_checks content_filter = amavis:[127.0.0.1]:10024 receive_override_options = no_address_mappings message_size_limit = 0
  8. postfix i ispconfig 3

    niestety nadal to samo...zainstalowalo poprawnie wszystko ale nic to nie zmienilo
  9. postfix i ispconfig 3

    ok instalacja to jedno a jak teraz wyglada kwestia konfiguracji tego?
  10. postfix i ispconfig 3

    Niestety ale tak Mozesz podpowiedziec jak do tego podejsc? Gdzie szukac przyczyny? Niestety ale dla mnie bazy danych to czarna magia
  11. postfix i ispconfig 3

    dodaje dzisiejsze logi Sep 12 13:57:28 Host2You imapd: Connection, ip=[::ffff:213.156.106.210] Sep 12 13:57:29 Host2You imapd: LOGOUT, ip=[::ffff:213.156.106.210], rcvd=60, sent=525 Sep 12 13:57:29 Host2You imapd: Connection, ip=[::ffff:213.156.106.210] Sep 12 13:57:30 Host2You imapd: Disconnected, ip=[::ffff:213.156.106.210], time=1, starttls=1 Sep 12 13:57:39 Host2You postfix/smtpd[32186]: fatal: dict_open: unsupported dictionary type: mysql (/usr/lib/postfix/dict_mysql.so not found. Is the postf$ Sep 12 13:57:40 Host2You postfix/master[28416]: warning: process /usr/lib/postfix/smtpd pid 32186 exit status 1 Sep 12 13:57:40 Host2You postfix/master[28416]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling Sep 12 13:57:45 Host2You postfix/qmgr[32187]: fatal: dict_open: unsupported dictionary type: mysql (/usr/lib/postfix/dict_mysql.so not found. Is the postfi$ Sep 12 13:57:46 Host2You postfix/master[28416]: warning: process /usr/lib/postfix/qmgr pid 32187 exit status 1 Sep 12 13:57:46 Host2You postfix/master[28416]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling Sep 12 13:57:54 Host2You imapd: Connection, ip=[::ffff:213.156.106.210] Sep 12 13:57:54 Host2You last message repeated 2 times Sep 12 13:57:54 Host2You pop3d-ssl: Maximum connection limit reached for ::ffff:213.156.106.210 Sep 12 13:57:54 Host2You pop3d-ssl: Maximum connection limit reached for ::ffff:213.156.106.210 Sep 12 13:57:54 Host2You imapd-ssl: Connection, ip=[::ffff:213.156.106.210] Sep 12 13:57:54 Host2You imapd-ssl: Connection, ip=[::ffff:213.156.106.210] Sep 12 13:57:54 Host2You pop3d-ssl: Connection, ip=[::ffff:213.156.106.210] Sep 12 13:57:54 Host2You pop3d: Connection, ip=[::ffff:213.156.106.210] Sep 12 13:57:54 Host2You imapd-ssl: Connection, ip=[::ffff:213.156.106.210] Sep 12 13:57:54 Host2You pop3d-ssl: Connection, ip=[::ffff:213.156.106.210] Sep 12 13:57:54 Host2You pop3d-ssl: Connection, ip=[::ffff:213.156.106.210] Sep 12 13:57:54 Host2You pop3d-ssl: Connection, ip=[::ffff:213.156.106.210] Sep 12 13:57:54 Host2You imapd: LOGOUT, ip=[::ffff:213.156.106.210], rcvd=66, sent=677 Sep 12 13:57:54 Host2You pop3d-ssl: Connection, ip=[::ffff:213.156.106.210] Sep 12 13:57:54 Host2You imapd: LOGOUT, ip=[::ffff:213.156.106.210], rcvd=66, sent=677 Sep 12 13:57:54 Host2You imapd: LOGOUT, ip=[::ffff:213.156.106.210], rcvd=66, sent=677 Sep 12 13:57:54 Host2You imapd-ssl: Disconnected, ip=[::ffff:213.156.106.210], time=0, starttls=1 Sep 12 13:57:54 Host2You imapd-ssl: Disconnected, ip=[::ffff:213.156.106.210], time=0, starttls=1 Sep 12 13:57:54 Host2You pop3d-ssl: Disconnected, ip=[::ffff:213.156.106.210] Sep 12 13:57:54 Host2You imapd-ssl: Disconnected, ip=[::ffff:213.156.106.210], time=0, starttls=1 Sep 12 13:57:54 Host2You pop3d-ssl: Disconnected, ip=[::ffff:213.156.106.210] Sep 12 13:57:54 Host2You last message repeated 2 times Sep 12 13:57:55 Host2You pop3d: Connection, ip=[::ffff:213.156.106.210] Sep 12 13:57:55 Host2You pop3d: Disconnected, ip=[::ffff:213.156.106.210] Sep 12 13:58:19 Host2You imapd-ssl: Connection, ip=[::ffff:213.156.106.210] Sep 12 13:58:20 Host2You imapd-ssl: LOGOUT, ip=[::ffff:213.156.106.210], rcvd=18, sent=316 Sep 12 13:58:20 Host2You imapd: Connection, ip=[::ffff:213.156.106.210] Sep 12 13:58:21 Host2You imapd: LOGIN FAILED, method=PLAIN, ip=[::ffff:213.156.106.210] Sep 12 13:58:26 Host2You imapd: LOGIN FAILED, user=test, ip=[::ffff:213.156.106.210] Sep 12 13:58:31 Host2You imapd: Disconnected, ip=[::ffff:213.156.106.210], time=11, starttls=1 Sep 12 13:58:32 Host2You imapd: Connection, ip=[::ffff:213.156.106.210] Sep 12 13:58:32 Host2You imapd: LOGOUT, ip=[::ffff:213.156.106.210], rcvd=60, sent=525 Sep 12 13:58:33 Host2You imapd: Connection, ip=[::ffff:213.156.106.210] Sep 12 13:58:34 Host2You imapd: LOGIN, user=test@host2you.pl, ip=[::ffff:213.156.106.210], port=[59547], protocol=IMAP Sep 12 13:58:34 Host2You imapd: DISCONNECTED, user=test@host2you.pl, ip=[::ffff:213.156.106.210], headers=0, body=0, rcvd=10, sent=16, time=0, starttls=1 Sep 12 13:58:40 Host2You postfix/smtpd[32234]: fatal: dict_open: unsupported dictionary type: mysql (/usr/lib/postfix/dict_mysql.so not found. Is the postf$ Sep 12 13:58:41 Host2You postfix/master[28416]: warning: process /usr/lib/postfix/smtpd pid 32234 exit status 1 Sep 12 13:58:41 Host2You postfix/master[28416]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling Sep 12 13:58:46 Host2You postfix/qmgr[32235]: fatal: dict_open: unsupported dictionary type: mysql (/usr/lib/postfix/dict_mysql.so not found. Is the postfi$ Sep 12 13:58:47 Host2You postfix/master[28416]: warning: process /usr/lib/postfix/qmgr pid 32235 exit status 1 Sep 12 13:58:47 Host2You postfix/master[28416]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling Sep 12 13:59:41 Host2You postfix/smtpd[32242]: fatal: dict_open: unsupported dictionary type: mysql (/usr/lib/postfix/dict_mysql.so not found. Is the postf$ Sep 12 13:59:42 Host2You postfix/master[28416]: warning: process /usr/lib/postfix/smtpd pid 32242 exit status 1 Sep 12 13:59:42 Host2You postfix/master[28416]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling Sep 12 13:59:47 Host2You postfix/qmgr[32243]: fatal: dict_open: unsupported dictionary type: mysql (/usr/lib/postfix/dict_mysql.so not found. Is the postfi$ Sep 12 13:59:48 Host2You postfix/master[28416]: warning: process /usr/lib/postfix/qmgr pid 32243 exit status 1 Sep 12 13:59:48 Host2You postfix/master[28416]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling Sep 12 14:00:01 Host2You pop3d: Connection, ip=[::ffff:127.0.0.1] Sep 12 14:00:01 Host2You pop3d: Disconnected, ip=[::ffff:127.0.0.1] Sep 12 14:00:01 Host2You imapd: Connection, ip=[::ffff:127.0.0.1] Sep 12 14:00:01 Host2You imapd: Connection, ip=[::ffff:127.0.0.1] Sep 12 14:00:01 Host2You imapd: Disconnected, ip=[::ffff:127.0.0.1], time=0 Sep 12 14:00:02 Host2You postfix/proxymap[32308]: fatal: dict_open: unsupported dictionary type: mysql (/usr/lib/postfix/dict_mysql.so not found. Is the po$ Sep 12 14:00:03 Host2You postfix/cleanup[32307]: warning: private/proxymap socket: service dict_proxy_open: Success Sep 12 14:00:03 Host2You postfix/master[28416]: warning: process /usr/lib/postfix/proxymap pid 32308 exit status 1 Sep 12 14:00:03 Host2You postfix/master[28416]: warning: /usr/lib/postfix/proxymap: bad command startup -- throttling Sep 12 14:00:42 Host2You postfix/smtpd[32320]: fatal: dict_open: unsupported dictionary type: mysql (/usr/lib/postfix/dict_mysql.so not found. Is the postf$ Sep 12 14:00:43 Host2You postfix/master[28416]: warning: process /usr/lib/postfix/smtpd pid 32320 exit status 1 Sep 12 14:00:43 Host2You postfix/master[28416]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling Sep 12 14:00:48 Host2You postfix/qmgr[32321]: fatal: dict_open: unsupported dictionary type: mysql (/usr/lib/postfix/dict_mysql.so not found. Is the postfi$ Sep 12 14:00:49 Host2You postfix/master[28416]: warning: process /usr/lib/postfix/qmgr pid 32321 exit status 1 Sep 12 14:00:49 Host2You postfix/master[28416]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling Sep 12 14:01:03 Host2You postfix/proxymap[32329]: fatal: dict_open: unsupported dictionary type: mysql (/usr/lib/postfix/dict_mysql.so not found. Is the po$ Sep 12 14:01:04 Host2You postfix/cleanup[32307]: warning: private/proxymap socket: service dict_proxy_open: Success Sep 12 14:01:04 Host2You postfix/master[28416]: warning: process /usr/lib/postfix/proxymap pid 32329 exit status 1 Sep 12 14:01:04 Host2You postfix/master[28416]: warning: /usr/lib/postfix/proxymap: bad command startup -- throttling Sep 12 14:01:43 Host2You postfix/smtpd[32332]: fatal: dict_open: unsupported dictionary type: mysql (/usr/lib/postfix/dict_mysql.so not found. Is the postf$ Sep 12 14:01:44 Host2You postfix/master[28416]: warning: process /usr/lib/postfix/smtpd pid 32332 exit status 1 Sep 12 14:01:44 Host2You postfix/master[28416]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling Sep 12 14:01:49 Host2You postfix/qmgr[32333]: fatal: dict_open: unsupported dictionary type: mysql (/usr/lib/postfix/dict_mysql.so not found. Is the postfi$ Sep 12 14:01:50 Host2You postfix/master[28416]: warning: process /usr/lib/postfix/qmgr pid 32333 exit status 1 Sep 12 14:01:50 Host2You postfix/master[28416]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling Sep 12 14:02:04 Host2You postfix/proxymap[32340]: fatal: dict_open: unsupported dictionary type: mysql (/usr/lib/postfix/dict_mysql.so not found. Is the po$ Sep 12 14:02:05 Host2You postfix/cleanup[32307]: warning: private/proxymap socket: service dict_proxy_open: Success Sep 12 14:02:05 Host2You postfix/master[28416]: warning: process /usr/lib/postfix/proxymap pid 32340 exit status 1 Sep 12 14:02:05 Host2You postfix/master[28416]: warning: /usr/lib/postfix/proxymap: bad command startup -- throttling Sep 12 14:02:44 Host2You postfix/smtpd[32347]: fatal: dict_open: unsupported dictionary type: mysql (/usr/lib/postfix/dict_mysql.so not found. Is the postf$ Sep 12 14:02:45 Host2You postfix/master[28416]: warning: process /usr/lib/postfix/smtpd pid 32347 exit status 1 Sep 12 14:02:45 Host2You postfix/master[28416]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling Sep 12 14:02:50 Host2You postfix/qmgr[32353]: fatal: dict_open: unsupported dictionary type: mysql (/usr/lib/postfix/dict_mysql.so not found. Is the postfi$ Sep 12 14:02:51 Host2You postfix/master[28416]: warning: process /usr/lib/postfix/qmgr pid 32353 exit status 1 Sep 12 14:02:51 Host2You postfix/master[28416]: warning: /usr/lib/postfix/qmgr: bad command startup -- throttling Sep 12 14:03:05 Host2You postfix/proxymap[32360]: fatal: dict_open: unsupported dictionary type: mysql (/usr/lib/postfix/dict_mysql.so not found. Is the po$ Sep 12 14:03:06 Host2You postfix/master[28416]: warning: process /usr/lib/postfix/proxymap pid 32360 exit status 1 Sep 12 14:03:06 Host2You postfix/master[28416]: warning: /usr/lib/postfix/proxymap: bad command startup -- throttling Sep 12 14:03:06 Host2You postfix/cleanup[32307]: warning: private/proxymap socket: service dict_proxy_open: Success Sep 12 14:03:45 Host2You postfix/smtpd[32361]: fatal: dict_open: unsupported dictionary type: mysql (/usr/lib/postfix/dict_mysql.so not found. Is the postf$ Sep 12 14:03:46 Host2You postfix/master[28416]: warning: process /usr/lib/postfix/smtpd pid 32361 exit status 1 Sep 12 14:03:46 Host2You postfix/master[28416]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling Sep 12 14:03:51 Host2You postfix/qmgr[32362]: fatal: dict_open: unsupported dictionary type: mysql (/usr/lib/postfix/dict_mysql.so not found. Is the postfi$ Sep 12 14:03:52 Host2You postfix/master[28416]: warning: process /usr/lib/postfix/qmgr pid 32362 exit status 1
  12. postfix i ispconfig 3

    Firewall ma odblokowane porty, ktore uzywa postfix
  13. Witam Podczas instalacji ISPConfig 3 wywala mi cos takiego: >> Initial configuration Notice: Undefined variable: distver in /tmp/ispconfig3_install/install/lib/install.lib.ph p on line 135 Notice: Undefined variable: distid in /tmp/ispconfig3_install/install/lib/install.lib.php on line 135 Notice: Undefined variable: distbaseid in /tmp/ispconfig3_install/install/lib/install.lib .php on line 135 Linux Distribution or Version not recognized.bighost:/tmp/ispconfig3_install/install# Jak do tego podejsc? Z gory zaznaczam ze nie biore sie za zaden hosting tylko probuje postawic serwer w ramach nauki Pozdrawiam
  14. zgadza się żąda hasła do mysql i to tez podaje ale jak widać bez efektu ponieważ wywala błąd. Z kolei instalując to z control panelu od vps po zalogowaniu do panelu nie widzi serwera oraz uslug typu mysql, php, apache itd
  15. php -q install.php oczywiscie bedac w katalgou z plikiem install.php
  16. jeszcze jedno pytanie. dlaczego instalujac system z ispconfig (z solusvm) dlaczego loguja sie mam pusta liste serwerow, apache, php, mysql itd.) doslownie nic nie mozna zrobic odinstalowanie ispconfig nic nie dalo
  17. witam ponownie po położeniu serwera przy instalacji skrzynki e-mail przy instalacji ispconfig wywala mi blad: ERROR: Unable to load SQL-Dump into database table. wszystko robilem tak jak ostatnio a jednak cos poszlo nie tak. Gdzie szukac bledu?
  18. Witam Z góry piszę, że nie zabieram się za żaden hosting itd tylko z ciekawości i dla nauki stawiam sobie swój serer:)Jestem kompletnie zielony jeśli chodzi o bazy danych. Stawiają swój serwer i wgrywają forum oparte na bazach MySQL natrafiłem na mnóstwo błędów a mianowicie, sprawdzając poprawność funkcjonowania baz danych mysqltunerem pokazało kilka błędów: General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate Enable the slow query log to troubleshoot bad queries When making adjustments, make tmp_table_size/max_heap_table_size equal Reduce your SELECT DISTINCT queries without LIMIT clauses Set thread_cache_size to 4 as a starting value Increase table_cache gradually to avoid file descriptor limits Your applications are not closing MySQL connections properly Variables to adjust: key_buffer_size (> 330.0K) query_cache_size (>= 8M) tmp_table_size (> 32M) max_heap_table_size (> 16M) thread_cache_size (start at 4) table_cache (> 4) Jak mam do tego podejść? Co i gdzie należy zmienić? prosze o pomoc i wyrozumiałość
  19. Optymalizacja baz danych MySQL

    moze cos wiecej? Jakies wskazowki ew jakis sprawdzony tutorial?Poniewaz tak jak mowie blady w tym temacie estem
  20. dzieki bardzo za odpowiedz i pomoc. Nie chodzi o to czy daje rade czy nie. Chce zapoznac sie jak dzialaja firmy hostingowe i przy okazji sam przez to przejsc od A do Z:) i nie ukrywam ale przy mojej srednej znajomosci systemow unixowych troche trzeba sie nameczyc:)
  21. już ogarnięty temat. usunąłem wszystko i wgrałem od nowa i działa:) Najwyraźniej popełniłem jakiś błąd po drodze. Wiem, że troche off ale czy znacie jakieś darmowe panele typu whmcs?
×