LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 12-15-2008, 02:37 PM   #1
saariko
LQ Newbie
 
Registered: Dec 2008
Posts: 4

Rep: Reputation: 0
newB: ProFTPD and mod_sql in a dedicated server


Hi,
I got a new Dedicated server, I have proftpd server 1.31. I Want to use sql auth, my question : how do I know if it's preinstalled with mod_sql ?



Thanks,
 
Old 12-16-2008, 12:12 AM   #2
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 13,163
Blog Entries: 1

Rep: Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032
You can run
Code:
ldd /path/to/proftpd |grerp sql
to see if it's linked against any sql libraries.
You can also use strings:
Code:
strings /path/to/proftpd |grerp sql
 
Old 12-16-2008, 07:58 AM   #3
saariko
LQ Newbie
 
Registered: Dec 2008
Posts: 4

Original Poster
Rep: Reputation: 0
Thanks for the quick reply.

So here is my result
Quote:
[root ~]# ldd /usr/sbin/proftpd | grep sql
[root ~]# strings /usr/sbin/proftpd | grep sql
mod_sql.c
Should I rebuild the server than?

Thank you
 
Old 12-16-2008, 08:18 AM   #4
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 13,163
Blog Entries: 1

Rep: Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032
Quote:
Should I rebuild the server than?
I'm afraid you have to, since there is on reference to the back-end database.
If you have to do it from source this guide will help you.

Regards
 
Old 12-17-2008, 03:28 AM   #5
saariko
LQ Newbie
 
Registered: Dec 2008
Posts: 4

Original Poster
Rep: Reputation: 0
THanks bathory, I am on my way, but stuck again.

I found both my .c and my .a files, each in it's own directory. However, I don't have a ./configure at my machine. I am using a fedora 7.

1. what is the alternate to build mysql?
2. should I run it form the /mysql.c directory? *I will use the complete script:

./configure (or alternate app) \
--with-modules=mod_sql:mod_sql_mysql \
--with-includes=/usr/local/mysql/include/mysql \
--with-libraries=/usr/local/mysql/lib/mysql


Please advise, thank you
 
Old 12-17-2008, 03:54 AM   #6
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 13,163
Blog Entries: 1

Rep: Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032
You should download the proftpd source from here and compile it using the guidelines from the URL I gave you.

1. If you have mysql installed as a fedora package, then if you don't have the mysql header files you'll need to install also packages named mysql-devel, mysqlclient-devel (or something like that). You should take care that you use the same version for devel packages as the ones of mysql already installed in your system.
You can also use the binary distribution from mysql and install it under /usr/local

2. You extract the proftpd sources and you run the ./configure from inside that directory. If you use the fedora packages then most likely you need to run:
Code:
./configure --with-modules=mod_sql:mod_sql_mysql --with-includes=/usr/include/mysql --with-libraries=/usr/lib/mysql
If you're going to use the binary mysql distribution, then everything is done as the howto in my previous post.
 
Old 12-17-2008, 04:30 AM   #7
saariko
LQ Newbie
 
Registered: Dec 2008
Posts: 4

Original Poster
Rep: Reputation: 0
OK, yum

p.s.
I found a great post/howto on installing proftpd + MySql on Fedora at: http://www.howtoforge.com/virtual_ho..._mysql_fedora7

I got into some errors during the installation process, but I will continue to battle.

Anyone knows why: chkconfig --levels 235 proftpd on
isn't working?

also, after the process, I try: ldd on my proftpd and still no sql support. weird
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Ubuntu Gutsy 32bit, Source Dedicated Server HL2MP & server UDP port not allocated rautamiekka Linux - Networking 1 10-29-2007 11:45 AM
Proftpd + mod_sql error & question MrEase Linux - Software 0 08-28-2005 01:24 PM
proftpd 1.2.8 with mod_sql -> make error on suse 8.1 CIMSW Linux - Software 1 09-15-2003 10:18 AM
proftpd using mod_sql help please ! Sonik21 Linux - Software 4 05-07-2003 10:56 AM
Newb ProFTPd questions HiRoll3r Linux - Software 1 02-13-2003 10:15 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 03:40 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration