LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 09-23-2010, 12:24 PM   #1
never say never
Member
 
Registered: Sep 2009
Location: Indiana, USA
Distribution: SLES, SLED, OpenSuse, CentOS, ubuntu 10.10, OpenBSD, FreeBSD
Posts: 195

Rep: Reputation: 37
LDAP or NTLM and SQL for authenication


Hello,

I have a problem I hope someone here can give me some guidance on. I have been looking for ways to do this and so far have come up short.

My need is to keep logs of usage of several copiers for billing purposes. The copiers have a built in account code system, with a 999 code limit and will keep the counts, however we have about 12,000 active accounts. Not every account will have usage every month and not every copier needs every account. The last thing I want to have to do is manually update the copier account information every day.

The copiers can authenticate against NTLM (v1 and v2) and "Active Directory" I am told they will happily access LDAP or e-Directory (we are a Novell shop). I dont' want to authenticate users, I want to authenticate "Accounts". I have a MS SQL database that has the "Account information" and my thought was to set up a way to have an LDAP server access the M$ SQL DB (probably a view) to get authentication for the copier to allow the prints and keep the counts. Which I can then import weekly into the accounting system.

So the question is has anyone ever done something like this?

Anyone have any idea how best to go about accomplishing this?

I guess I could set up an LDAP server separately for the purpose, but it seems I should be able to consolidate things more than that, so that if the account is "Active" it is Authenticated to the copiers.

If this works well, I will be probably be moving to moving to phone authentication next.

Thanks in advance for any ideas.
 
Old 12-17-2010, 06:58 PM   #2
archtoad6
Senior Member
 
Registered: Oct 2004
Location: Houston, TX (usa)
Distribution: MEPIS, Debian, Knoppix,
Posts: 4,727
Blog Entries: 15

Rep: Reputation: 231Reputation: 231Reputation: 231
3 months & no replies.

Did you solve your problem?
  • If so, please provide your solution -- it might help someone else w/ the same problem.
  • If not, would you like some help w/ re-phrasing your question, or providing more info.?
 
Old 12-18-2010, 09:19 AM   #3
never say never
Member
 
Registered: Sep 2009
Location: Indiana, USA
Distribution: SLES, SLED, OpenSuse, CentOS, ubuntu 10.10, OpenBSD, FreeBSD
Posts: 195

Original Poster
Rep: Reputation: 37
I was not able to get LDAP to authenticate via MSSQL, and other conditions changed, so in the end I just added departments to the copiers and it is up so users to enter billable copies into our case management software, not as automated as I had wanted, but more versatile than other solutions.
 
Old 12-18-2010, 11:12 AM   #4
archtoad6
Senior Member
 
Registered: Oct 2004
Location: Houston, TX (usa)
Distribution: MEPIS, Debian, Knoppix,
Posts: 4,727
Blog Entries: 15

Rep: Reputation: 231Reputation: 231Reputation: 231
Thanks for replying. If you need more help, please ask.
 
  


Reply

Tags
ldap, ntlm, sql


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
Dovecot Authenication - Help! LinuxLuvr Linux - Server 1 05-28-2008 07:07 PM
Samba with ldap support with back-sql turab Linux - General 0 08-30-2006 10:31 PM
Login Authenication sunhui Linux - Software 3 08-24-2006 05:25 AM
Can't get authenication with Apache bentman78 Linux - Software 3 09-10-2003 03:34 PM


All times are GMT -5. The time now is 01:26 PM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration