Re: Integrating Samba into a Database and configured for OpenVPN

[Collen Blijenberg <collen@xxxxxxxxxxxxxxx>]

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@xxxxxxxxx> wrote:
>
>   
> >  On Sun, Aug 31, 2008 at 4:47 PM, John Drescher <drescherjm@xxxxxxxxx>
> > wrote:
> >     
> > > On Sun, Aug 31, 2008 at 4:23 PM, Jesse Stone <jstone1999@xxxxxxxxx>
> > >       
> > 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
> >
> >     

--
To unsubscribe from this list go to the following URL and read the
instructions:  https://lists.samba.org/mailman/listinfo/samba