Re: pure-ftpd - mysql auth

From: Martin Allan Jensen (none@bailey--sprit.dk.lh.bsd-dk.dk)
Date: Tue 03 Dec 2002 - 10:08:25 CET

Next message: Jan Henrik Radl: "Re: Krask møde - where to eat.."
Previous message: Ole Moller: "Re: pure-ftpd - mysql auth"
In reply to: Jesper Have: "pure-ftpd - mysql auth"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Mail actions: [ respond to this message ] [ mail a new topic ]

From: "Martin Allan Jensen" <none@bailey--sprit.dk.lh.bsd-dk.dk>
To: <none@bsd-dk--bsd-dk.dk.lh.bsd-dk.dk>
Subject: Re: pure-ftpd - mysql auth
Date: Tue, 3 Dec 2002 10:08:25 +0100

Hej Jesper Have,

Den kan drille en smule med cleartekst som password, jeg kører selv med en md5 kryptisering, det er nemt at sætte op, ekstremt mere sikkert, og virker perfekt...!

Med venlig hilsen
Martin A Jensen

----- Original Message -----
  From: Jesper Have
  To: bsd-dk@bsd-dk.dk
  Sent: Monday, December 02, 2002 6:46 PM
  Subject: pure-ftpd - mysql auth

  Jeg har fået installeret pure-ftpd så den køre på en mysql database, men kan
  ikke få startet serveren :(
  når jeg forsøger får jeg fejlen

  <klip>
  server# /usr/local/sbin/pure-ftpd -l
  mysql:/usr/local/etc/pureftpd-mysql.conf &
  [1] 81913
  server# 421 Configuration error: Invalid SQL configuration file:
  /usr/local/etc/pureftpd-mysql.conf

  [1] Exit 252 /usr/local/sbin/pure-ftpd -l
  mysql:/usr/local/etc/pureftpd-mysql.conf
  <klip>

og min pure-ftpd.conf ser sådan her ud

  <klip>
  # If you want to use the Socket connect methode comment out the
  # Lines with MMYSQLServer and MYSQLPort.
  # If you want to use the Port methode comment out the MYSQLSocket line
  #MYSQLSocket /tmp/mysql.sock
  MYSQLServer localhost
  MYSQLPort 3306
  MYSQLUser *******
  MYSQLPassword *********
  MYSQLDatabase pureftpd
  MYSQLCrypt cleartext
  MYSQLGetPW SELECT Password FROM ftpd WHERE User="\L" AND status="1" AND
  (ipaccess = "*" OR ipaccess LIKE "\R")
  MYSQLGetUID SELECT Uid FROM ftpd WHERE User="\L" AND status="1" AND
  (ipaccess = "*" OR ipaccess LIKE "\R")
  MYSQLGetGID SELECT Gid FROM ftpd WHERE User="\L"AND status="1" AND
  (ipaccess = "*" OR ipaccess LIKE "\R")
  MYSQLGetDir SELECT Dir FROM ftpd WHERE User="\L"AND status="1" AND
  (ipaccess = "*" OR ipaccess LIKE "\R")
  MySQLGetBandwidthUL SELECT ULBandwidth FROM ftpd WHERE User="\L"AND
  status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
  MySQLGetBandwidthDL SELECT DLBandwidth FROM ftpd WHERE User="\L"AND
  status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
  MySQLGetQTASZ SELECT QuotaSize FROM ftpd WHERE User="\L"AND status="1" AND
  (ipaccess = "*" OR ipaccess LIKE "\R")
  <klip>

  --
  Med venlig hilsen
  Jesper Have

Next message: Jan Henrik Radl: "Re: Krask møde - where to eat.."
Previous message: Ole Moller: "Re: pure-ftpd - mysql auth"
In reply to: Jesper Have: "pure-ftpd - mysql auth"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Mail actions: [ respond to this message ] [ mail a new topic ]

This archive was generated by hypermail 2b30 : Wed 15 Nov 2006 - 18:24:25 CET