[Samba] Integrating Samba into a Database and configured for OpenVPN

[Collen Blijenberg]

checkout: http://sourceforge.net/projects/pdbsql/

there is a passwd backend for mysql and pgsql.
you can combine it with nss-mysql and pam-mysql.

the pdbsql is for samba 3.0.x and 3.2.x !!

have fun..

Cheers, Collen

Jesse Stone wrote:
> Thanks for the quick response.  Without going into a huge discussion over my
> plans (I've written up a several page phased plan for configuring Ubuntu to
> my liking), I looked into LDAP and was afraid it wouldn't offer the
> flexibility I wanted.
>
> Basically, I want to intergrate two seperate environments to use MySQL for
> authenication (for everything:  shell access, SSH, Samba, OpenVPN ect),
> performancing logging, and user activity logging.  I then plan on using
> Python to migrade the data from both MySQL instances (1 in app server, 1 in
> DMZ) to MS SQL 2008 so that I can create a website (using C#) that displays
> all aspects of my envionment(s) in 1 page.
>
> I understand a lot of this may be done but the key is for me to learn new
> technologies.  My work is pro-Microsoft and my passion/hobby is Linux so I'm
> attempting to combine the two.  I plan on needing to learn Python for
> extensive scripting to make all this work.
>
> My problem, is I haven't found that anyone has done this before and I don't
> know where to begin.  OpenVPN adds a second problem since I want it to be
> completely segregrated from the rest of my network yet be able to reach
> certain shares that will be on my local network.  Instead of sharing on
> specific machines (or even having their names visible), I want all shares to
> be done via Samba and then setup Samba so that it's the only visible object
> for OpenVPN users.
>
> I guess the main thing, I don't know (but I have a good guess) that my
> approach isn't the best way to go about things but I'm using this has a
> project to learn several new technologies (and have fun).
>
> I hope that helps.
>
> -Jesse
>
> On Sun, Aug 31, 2008 at 1:47 PM, John Drescher <drescherjm at gmail.com> wrote:
>
>   
>>  On Sun, Aug 31, 2008 at 4:47 PM, John Drescher <drescherjm at gmail.com>
>> wrote:
>>     
>>> On Sun, Aug 31, 2008 at 4:23 PM, Jesse Stone <jstone1999 at gmail.com>
>>>       
>> wrote:
>>     
>>>> Hi All,
>>>>
>>>> This is my first post and I am relatively new with Linux.
>>>>
>>>> I am attempting to do three things and I'm hoping for advice:
>>>>
>>>> 1)  Intergrate Samba fully with MySQL  (unless another database would be
>>>> considered better for this task).  One of the things I've always had
>>>>         
>> trouble
>>     
>>>> with Linux is that everything is seperate.  I understand that provides
>>>> flexibility but I would like to configure my system (Ubuntu 8.04) so
>>>>         
>> that
>>     
>>>> everything is intragrated into 1 single database.  This includes SSH,
>>>>         
>> Shell
>>     
>>>> Access, VPN, VNC, ect.
>>>>
>>>> 2) I have configured an OpenVPN server that I would like to provide
>>>>         
>> shares
>>     
>>>> to via Samba.  The problems I'm running into is A) The OpenVPN is
>>>>         
>> configured
>>     
>>>> to be on a seperate subnet than the rest of my network.  I want to
>>>>         
>> configure
>>     
>>>> Samba (and only Samba, not the rest of the machines in my network) to
>>>>         
>> appear
>>     
>>>> under Network Neighborhood to provide share access.  The main thing is
>>>>         
>> that
>>     
>>>> I do not want VPN users to see any of my machines that sit outside the
>>>>         
>> VPN
>>     
>>>> even if (through Samba) they obtain data from them.
>>>>
>>>> 3)  I've been researching setting Samba as a domain controller for my
>>>> Windows machines (and other Linux machines?).  I would like this to be
>>>>         
>> used
>>     
>>>> for the VPN as well.  Instead of me required to create actual users on
>>>>         
>> my
>>     
>>>> system and then disabling SSH access.  I would like to be able to add
>>>>         
>> users
>>     
>>>> via MySQL and indicate that they are VPN users and should have limited
>>>> access.
>>>>
>>>> For me, this is a learning process and I do not expect detailed
>>>>         
>> instructions
>>     
>>>> in how to acomplish this.  I would just like guidance (web sites would
>>>>         
>> be
>>     
>>>> great) that would help me acomplish this goal.  What I do NOT want to do
>>>>         
>> is
>>     
>>>> have to setup two seperate instances of Samba, 1 for the VPN and 1 for
>>>>         
>> the
>>     
>>>> rest of the network.
>>>>
>>>>         
>> Why do you need MySQL to do this when LDAP does all of this without much
>> effort?
>> --
>> To unsubscribe from this list go to the following URL and read the
>> instructions:  https://lists.samba.org/mailman/listinfo/samba
>>
>>