Problem z proftpd+mysql...

[miras 0]

Witam, chcę zainstalować proftpd+mysql na debianie 6 i po wydaniu polecenia:

 

apt-get install proftpd-mysql proftpd-common mysql-client mysql-common mysql-server libmysqlclient10

 

mam błąd:

 

Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package proftpd-mysql
E: Unable to locate package proftpd-common
E: Unable to locate package libmysqlclient10

 

O co chodzi ?

 

dzięki z góry

[NetMat 107]

nano /etc/apt/sources.list zobacz czy masz dobre źródło. Następnie :

apt-get update

apt-get upgrade

Edytowano Maj 13, 2012 przez NetMat (zobacz historię edycji)

[miras 0]

plik sources.list:

 

deb http://ftp.debian.org/debian squeeze main contrib non-free
deb http://security.debian.org squeeze/updates main contrib non-free

nic nie zmieniło..

[NetMat 107]

Jaka wersja debiana ?

[miras 0]

debian-6.0-x86

[kammil1 0]

apt-get install proftpd-mod-mysql

[miras 0]

No dobrze, zainstalowało się poprawnie niby, ale w /etc/ nie widzę katalogu proftpd-mod-mysql ... ?

 

I gdzie mam teraz ustawić to ? :

 

SQLConnectInfo proftpd@localhost:3306 proftpd naszehaslo
SQLUserInfo users name pass uid gid home shell
SQLGroupInfo groups name gid members
SQLAuthenticate users* groups*
SQLAuthTypes PlainText

[kammil1 0]

http://www.howtoforge.com/virtual-hosting-with-proftpd-and-mysql-debian-lenny czytaj

[miras 0]

No ok, niby wszystko według poradnika a jednak: Starting ftp server: proftpd - warning: handling possibly truncated configuration data at line 88 of '/etc/proftpd/sql.conf'

 

Załącze cały plik sql.conf bo najwidoczniej tutaj jest problem:

#
# Proftpd sample configuration for SQL-based authentication.
#
# (This is not to be used if you prefer a PAM-based SQL authentication)
#
<IfModule mod_sql.c>
#
# Choose a SQL backend among MySQL or PostgreSQL.
# Both modules are loaded in default configuration, so you have to specify the backend
# or comment out the unused module in /etc/proftpd/modules.conf.
# Use 'mysql' or 'postgres' as possible values.
#
#SQLBackend	    mysql
#
#SQLEngine on
#SQLAuthenticate on
#
# Use both a crypted or plaintext password
#SQLAuthTypes Crypt Plaintext
#
# Use a backend-crypted or a crypted password
#SQLAuthTypes Backend Crypt
#
# Connection
#SQLConnectInfo proftpd@sql.example.com proftpd_user proftpd_password
#
# Describes both users/groups tables
#
#SQLUserInfo users userid passwd uid gid homedir shell
#SQLGroupInfo groups groupname gid members
#
DefaultRoot ~
SQLBackend			  mysql
# The passwords in MySQL are encrypted using CRYPT
SQLAuthTypes		    Plaintext Crypt
SQLAuthenticate		 users groups

# used to connect to the database
# databasename@host database_user user_password
SQLConnectInfo  ftp@localhost proftpd password

# Here we tell ProFTPd the names of the database columns in the "usertable"
# we want it to interact with. Match the names with those in the db
SQLUserInfo	 ftpuser userid passwd uid gid homedir shell
# Here we tell ProFTPd the names of the database columns in the "grouptable"
# we want it to interact with. Again the names match with those in the db
SQLGroupInfo    ftpgroup groupname gid members
# set min UID and GID - otherwise these are 999 each
SQLMinID	    500
# create a user's home directory on demand if it doesn't exist
CreateHome on
# Update count every time user logs in
SQLLog PASS updatecount
SQLNamedQuery updatecount UPDATE "count=count+1, accessed=now() WHERE userid='%u'" ftpuser
# Update modified everytime user uploads or deletes a file
SQLLog  STOR,DELE modified
SQLNamedQuery modified UPDATE "modified=now() WHERE userid='%u'" ftpuser
# User quotas
# ===========
QuotaEngine on
QuotaDirectoryTally on
QuotaDisplayUnits Mb
QuotaShowQuotas on
SQLNamedQuery get-quota-limit SELECT "name, quota_type, per_session, limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail FROM ftpquotalimits WHERE name = '%{0}' AND quota_type = '%{1}'"
SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used, bytes_out_used, bytes_xfer_used, files_in_used, files_out_used, files_xfer_used FROM ftpquotatallies WHERE name = '%{0}' AND quota_type = '%{1}'"
SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, files_in_used = files_in_used + %{3}, files_out_used = files_out_used + %{4}, files_xfer_used = files_xfer_used + %{5} WHERE name = '%{6}' AND quota_type = '%{7}'" ftpquotatallies
SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" ftpquotatallies
QuotaLimitTable sql:/get-quota-limit
QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally
RootLogin off
RequireValidShell off
</IfModule>

[kammil1 0]

spróbuj na to podmienić : http://www.wklejto.pl/124987

 

oczywiście wiesz że :

# databasename@host database_user user_password
SQLConnectInfo  ftp@localhost proftpd password

 

musi się zgadzać tak jak w bazie danych

Edytowano Maj 13, 2012 przez kammil1 (zobacz historię edycji)

[miras 0]

Niestety nadal to samo, a hasła muszą się zgadzać, bo przy tworzeniu nic nie zmieniałem tylko skopiowałem z tego tutoriala, który podałeś a tam było:

 

CREATE DATABASE ftp;
GRANT SELECT, INSERT, UPDATE, DELETE ON ftp.* TO 'proftpd'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT, INSERT, UPDATE, DELETE ON ftp.* TO 'proftpd'@'localhost.localdomain' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

[kammil1 0]

nie wiem może to coś da : http://wklejto.pl/124992 ja osobiscie bawie sie na ubuntu i w taki sposob to robilem u siebie : http://www.howtoforg...sql-ubuntu-8.04 i tam zamiast apt-get install proftpd-mod zmienielm na " apt-get install proftpd-mod-mysql " i śmiagało

Edytowano Maj 13, 2012 przez kammil1 (zobacz historię edycji)

[miras 0]

A więc przeinstaluje mojego vps'a - spróbuję od nowa i dam znać.

[kammil1 0]

jak coś pisz na priv spróbuje pomóc zawsze nowe doświadczenie się przyda