Portál AbcLinuxu, 10. května 2025 00:14
díky
A z konzole se k mysql přihlásíš? Co třeba nastavení firewallu? Rz konzole jsem to vsechno instaloval a vytvarel tabulky, tak že odpoved je ANO, PŘIHLÁSÍM
SQLLogFile /tmp/sqllog.txttohle mam spustit kde? v commandlajně a jak to vypnu?
aj pod userom, ktoreho ma nastavene proftpd ?jestli myslite toho co pristupuje do mysql tak ano
spusti proftpd takto: proftpd -n -d 5
web:~# proftpd -n -d 5 - mod_ctrls/0.9.4: binding ctrls socket to '/var/run/proftpd/proftpd.sock' - parsing '/etc/proftpd/proftpd.conf' configuration - parsing '/etc/proftpd/modules.conf' configuration - mod_tls/2.1.1: using OpenSSL 0.9.8c 05 Sep 2006 - disabling runtime support for IPv6 connections - DenyFilter: compiling deny regex '\*.*/' - IfModule: using 'mod_tls.c' section at line 68 - IfModule: skipping 'mod_quota.c' section at line 72 - IfModule: skipping 'mod_ratio.c' section at line 76 - IfModule: using 'mod_delay.c' section at line 84 - IfModule: using 'mod_ctrls.c' section at line 88 - mod_ctrls/0.9.4: closing ctrls socket '/var/run/proftpd/proftpd.sock' (3) - IfModule: using 'mod_ctrls_admin.c' section at line 96 - SQLAuthenticate: use of * in SQLAuthenticate has been deprecated. Use AuthOrder for setting authoritativeness - SQLAuthenticate: use of * in SQLAuthenticate has been deprecated. Use AuthOrder for setting authoritativeness example.foo - example.foo - Config for Debian: example.foo - DeferWelcome example.foo - DefaultRoot example.foo - DefaultServer example.foo - ShowSymlinks example.foo - TimeoutNoTransfer example.foo - TimeoutStalled example.foo - TimeoutIdle example.foo - DisplayLogin example.foo - DisplayFirstChdir example.foo - ListOptions example.foo - DenyFilter example.foo - UserID example.foo - UserName example.foo - GroupID example.foo - GroupName example.foo - Umask example.foo - DirUmask example.foo - AllowOverwrite example.foo - TransferLog example.foo - TLSEngine example.foo - DelayEngine example.foo - RequireValidShell example.foo - SQLAuthTypes example.foo - SQLAuthenticate example.foo - SQLConnectInfo example.foo - SQLUserTable example.foo - SQLUsernameField example.foo - SQLPasswordField example.foo - SQLUidField example.foo - SQLGidField example.foo - SQLHomedirField example.foo - SQLShellField example.foo - SQLGroupTable example.foo - SQLGroupnameField example.foo - SQLGroupGIDField example.foo - SQLGroupMembersField example.foo - SQLMinID example.foo - SQLHomedirOnDemand example.foo - SQLLog_PASS example.foo - SQLNamedQuery_updatecount example.foo - SQLLog_STOR example.foo - SQLLog_DELE example.foo - SQLNamedQuery_modified example.foo - QuotaEngine example.foo - QuotaDirectoryTally example.foo - QuotaDisplayUnits example.foo - QuotaShowQuotas example.foo - SQLNamedQuery_get-quota-limit example.foo - SQLNamedQuery_get-quota-tally example.foo - SQLNamedQuery_update-quota-tally example.foo - SQLNamedQuery_insert-quota-tally example.foo - QuotaLimitTable example.foo - QuotaTallyTable example.foo - RootLogin example.foo - RequireValidShell example.foo - mod_ctrls/0.9.4: binding ctrls socket to '/var/run/proftpd/proftpd.sock' example.foo - deleting existing scoreboard '/var/run/proftpd/proftpd.scoreboard' example.foo - Failed binding to 0.0.0.0, port 21: Address already in use example.foo - Check the ServerType directive to ensure you are configured correctly.
- FTP session requested from unknown class - FTP session closed. - FTP session requested from unknown class - FTP session closed. - FTP session requested from unknown class - FTP session closed.
a ten sqllog ? normalne ten riadok pridaj do proftpd.conf (napr. niekde na zaciatok) a prestartuj proftpd. potom sa skus prihlasit a pozri do toho logu - mal by si tam vidiet presne SQL dotazy, ktore proftpd posielal do mysql. pripadne nejake errory (napr. problem pri prihlaseni atd.)Starting ftp server: proftpd - Fatal: unknown configuration directive 'SQLLogFile' on line 5 of '/etc/proftpd/proftpd.conf' failed!
Apr 24 19:22:24 mod_sql/4.2.1[7155]: defaulting to 'postgres' backend Apr 24 19:22:24 mod_sql/4.2.1[7155]: backend module 'mod_sql_postgres/4.02' Apr 24 19:22:24 mod_sql/4.2.1[7155]: backend api 'mod_sql_api_v2' Apr 24 19:22:24 mod_sql/4.2.1[7155]: >>> sql_sess_init Apr 24 19:22:24 mod_sql/4.2.1[7155]: entering postgres cmd_defineconnection Apr 24 19:22:24 mod_sql/4.2.1[7155]: name: 'default' Apr 24 19:22:24 mod_sql/4.2.1[7155]: user: 'proftpd' Apr 24 19:22:24 mod_sql/4.2.1[7155]: host: 'localhost' Apr 24 19:22:24 mod_sql/4.2.1[7155]: db: 'ftp' Apr 24 19:22:24 mod_sql/4.2.1[7155]: port: '5432' Apr 24 19:22:24 mod_sql/4.2.1[7155]: ttl: '0' Apr 24 19:22:24 mod_sql/4.2.1[7155]: exiting postgres cmd_defineconnection Apr 24 19:22:24 mod_sql/4.2.1[7155]: entering postgres cmd_open Apr 24 19:22:24 mod_sql/4.2.1[7155]: exiting postgres cmd_open Apr 24 19:22:24 mod_sql/4.2.1[7155]: unrecoverable backend error Apr 24 19:22:24 mod_sql/4.2.1[7155]: error: 'mod_sql_postgres/4.02' Apr 24 19:22:24 mod_sql/4.2.1[7155]: message: 'could not connect to server: Connection refused Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? '
Apr 24 19:22:24 mod_sql/4.2.1[7155]: error: 'mod_sql_postgres/4.02' Apr 24 19:22:24 mod_sql/4.2.1[7155]: message: 'could not connect to server: Connection refused Is the server running on host "localhost" and accepting TCP/IP connections on port 5432?
Tiskni
Sdílej:
ISSN 1214-1267, (c) 1999-2007 Stickfish s.r.o.
