Just a suggestion: If you're concerned about others getting unauthorized access to the list, set it up so that the SQL server can upload the files to a directory where it only has write permission. Then, you could use a simple shell script via cron that has read/write access to the same directory. This way, you're not compromising using root... On Wed, 02 Aug 2000, you wrote: > I have a situation which I don't know how to solve better than I have and > I'd like to get some feedback from you folks. > > We have a RedHat box which we are using, by way of a little trickery, as > the MLM(majordomo) in concert without our Novell Groupwise mail server. > > Now, the U has the central Peoplesoft dbs which our data guy pulls info > about our department from and generates all sorts of file for us so we can > populate the Majordomo mailing lists and the Groupwise addressbooks. > > The problem is that we have been able to automate most of the process for > importing the address books but not the mailing lists. We are importing > from Oracle to a windows SQL server where the data is manipulated and > puked out into the formats we need but I cannot think of a good way to get > it from windows to Redhat. I thought of running samba but it seems a > little daunting and a bit much condering this is one person and one > task; I'd just much prefer not running the service. > > Any other ideas? The only other thing I could come up with was a root > level cron which would sweep an ftp'able folder for new files...if it > finds them, they are copied to the majordomo lists directory. This, of > course, is only for updating the lists... > > suggestions? > > ____________________________ > Mike Neuharth > ADCS Technology Specialist > http://www.umn.edu/adcs > > E-Mail : mjn at umn.edu > Page Mail : 6126486512 at page.metrocall.com > http://nifty.dsl.visi.com/ > ____________________________ > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: tclug-list-unsubscribe at mn-linux.org > For additional commands, e-mail: tclug-list-help at mn-linux.org -- Eric F Crist System Administrator Ardent-Hacker.net --------------------------------------------------------------------- To unsubscribe, e-mail: tclug-list-unsubscribe at mn-linux.org For additional commands, e-mail: tclug-list-help at mn-linux.org