[freeside] Adding accounts

[Nate Bradley]

After rebooting I get an error message in
/usr/local/etc/freeside/queued*

[Mon Mar  8 16:12:38 2004] [4092] DBD::Pg::st execute failed: server
closed the connection unexpectedly at
/usr/lib/perl5/site_perl/5.8.1/FS/Record.pm line 282.[Mon Mar  8
16:12:39 2004] [4092] Error executing "SELECT * FROM queue WHERE status
= ? AND 0 = ( SELECT COUNT(*) FROM queue_depend WHERE
queue_depend.jobnum = queue.jobnum )  ORDER BY jobnum FOR UPDATE LIMIT
1": server closed the connection unexpectedly at
/usr/local/bin/freeside-queued line 100

freeside-queued doesn't start unitl after this error messages, is this
the problem??

I looked at the perl module and freeside-queued but I can't see any
obvious mistakes that I have made.
I can issue the SQL statement directly to the database and it returns
zero results, is this causing the error (I doubt it)??

the following is my export for host localhost (should it be a fqdn or
is localhost O.K.)

usermod	usermod -c $new_finger -d $new_dir -m -l $new_username
-s $new_shell -u $new_uid -p $new_crypt_password $old_username
suspend_stdin	
unsuspend	
usermod_pwonly	
userdel	userdel -r $username
useradd_stdin	
usermod_stdin	
useradd	useradd -c $finger -d $dir -m -s $shell -u $uid -p
$crypt_password $username
userdel_stdin	
suspend	
unsuspend_stdin	
user	root

>>> rharby at caarnet.com 3/8/2004 4:32:28 PM >>>
Send back all the details of your particular export for this service..

Rick

-----Original Message-----
From: Nate Bradley [mailto:Nate at acsmagnum.com] 
Sent: Monday, March 08, 2004 4:04 PM
To: ivan-freeside at sisd.com 
Subject: RE: [freeside] Adding accounts

The documentation helps little.  I restarted freeside-queued and the
jobs were processed without error, except it still didn't create the
account.  I've checked my apache log (for cgi errors), syslog (for
pgsql
errors), sshd log (for export errors?), and the queued* log under
/usr/local/etc/freeside/ (it appears to process the jobs) and there
are
no errors.  The jobs no longer appear in the web interface.

>>> rharby at caarnet.com 3/8/2004 3:51:30 PM >>>
Main docs: http://www.sisd.com/freeside/docs/ look under 'File
Exporting and
remote setup' although most of it doesn't apply to 1.4.1, it points
you
to
the web interface, as most Admins can figure out how to use the web
interface to export.

As far as the job queue goes, they should disappear within a very
short
period of time normally, unless you have a ton of changes occurring.
They
will remain across reboots, as the queue is maintained within the
database.

Under the pending job queue view, do you see any errors, or anything?
If
not, I'd recommend restarting the freeside-queued process to start
with. As
it will record on the queued job any errors it encounters.

Rick

-----Original Message-----
From: Nate Bradley [mailto:Nate at acsmagnum.com] 
Sent: Monday, March 08, 2004 3:42 PM
To: ivan-freeside at sisd.com 
Subject: RE: [freeside] Adding accounts

Where in the documentation does it talk about exporting (why is it
excluded from the initial setup if it is vitally important)??  Do you
have a link I can use??
Freeside-queued is running, it starts automatically when the server
boots (via rc.local)
How long are jobs supposed to stay queued??  Will the queued jobs
remain if I were to reboot the server??

>>> rharby at caarnet.com 3/8/2004 3:32:40 PM >>>
Actually, the documentation should be completely read, so you'd know
about
the exporting ;) Are the jobs just sitting in your queue, if so are
you
running the freeside-queued daemon to actually process the queue? 

It's also not recommended to run Freeside on the same machine that
you'll be
creating accounts on etc, so that's why it doesn't assume anything is
localhost, it would make the system more vulnerable to issues.

Rick

-----Original Message-----
From: Nate Bradley [mailto:Nate at acsmagnum.com] 
Sent: Monday, March 08, 2004 3:25 PM
To: ivan-freeside at sisd.com 
Subject: RE: [freeside] Adding accounts

I have added an export for shellcommands (useradd, etc.) for
localhost,
so I guess I'll sit and wait.
I had a job in the queue for a new user before I added this export,
will this job be affected.
Why isn't adding an export part of the initial administration? 
Shouldn't freeside assume all jobs go to localhost unless told
otherwise?  I noticed freeside defaults to using localhost for SMTP.

>>> rharby at caarnet.com 3/8/2004 3:13:32 PM >>>
What are you using for an export on that particular service type? You
need
to ensure you have at least one export associated with the service in
question.

Rick

-----Original Message-----
From: Nate Bradley [mailto:Nate at acsmagnum.com] 
Sent: Monday, March 08, 2004 1:39 PM
To: ivan-freeside at sisd.com 
Subject: [freeside] Adding accounts

freeside 1.4.1
on fedora core 1
perl 5.8.1
mod_perl 1.29
apache 1.3.27-4 using Apache::ASP
Postgresql 7.3.4-11
DBD::Pg 1.22

I have a question regarding new users.  It seems that the user
accounts
aren't being created on the system.
I am running everything on one server.  Is there a problem with that
other than security issues.
The new user is in the database but the actual user account hasn't
been
created.

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.602 / Virus Database: 383 - Release Date: 3/1/2004
 


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.602 / Virus Database: 383 - Release Date: 3/1/2004
 


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.602 / Virus Database: 383 - Release Date: 3/1/2004
 


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.602 / Virus Database: 383 - Release Date: 3/1/2004