 |  |
Re: Complex SQL queries allowed?
From: InterCape
Date: Sunday, November 3, 2002
Time: 7:45:54 pm
Shawn
This type of issue has also been a *major* problem here, I have to go=
through loops sometimes trying to insure the various db's don't get out of=
sync.
This was also a big issue with ISP's in the "old" days and the problems=
were many - some employees being able to find a loophole and
add non-paying accounts to the system, some type of failure causing clients=
to never get cancelled on the server, customer changes
to email addresses causing some clients to be able to amass more email=
boxes then they were allowed and use them after they cancelled.
These issues cost real money. At one ISP I worked we found over 50=
non-paying accounts and hundreds of email boxes. A good many
were all being used for many months after they cancelled. At the time this=
ISP could not add any more modems and their clients were
getting busy signals so this issue was not only costing them money but=
customers as well.
There are so many failure points in the process they are bound to happen. A=
while ago I changed the servers to OpenSSH from SSH and did not
realize that I broke RSA auth... so server events failed and we had no way=
of knowing this. Luckily I manually check server events all the time=
because
I fear this so much. This is a big loss of time for me. Another time a=
server ip address was changed.. another time a script was moved by=
accident.
No matter how good your people are It is inevitable that things like this=
will happen.
BTW Platypus has a linux daemon that can return a success or fail code.=
This fixed the issue for that ISP.
There seems to be no way to send signals back to Optigold and you say it=
may not be hard to add .. ?
I don't know how to convince you Opti needs this but it really *does*.=
There needs to be some way of of being *100%* *certain* that server=
events are
all working correctly... something that lets you know. (BTW the sql=
failures box works pretty well but what about ssh failures?)
I have been working on my own scripts here trying to find a good or at=
least less time consuming solution to this so I don't have to ssh into the=
server
and check every time someone cxl's..
The only solution I have been able to find is some type of email script to=
check the server and mail me back to let me know when something happened
whether its an add or a cxl or a password change as a "sequence 2" event..=
then I eyeball it now and then and recouncil with Opti... all manual.
The main problem with this is what happens if that script fails for some=
reason? We are almost back to square one. And now I am spending time that
should really be automated.
Right now I am trying to find some way for a successful odbc event to email=
me so I know when something happened and what it was. I am now using the
sql "failures" email (I add "OK" to the list a long with "err") but it=
would be really nice if there was an email for a successful event so I=
could tell when I got a "real"
failure without looking at the contents of each message.
Could you do this? Just add another box for successful events just like=
the "failures" one for errors?
On the other types of methods such as ssh could you put something in to=
email everytime and event got triggered with all the debug output inside=
the message
just like the sql "failures" one?
Could there be a report made that showed all the given server events for a=
given month so a person could run it and then go spot check the servers?
Or better yet include the account class and current status along with the=
server action for the account? Yesterday I found I could go "menu - auto=
server create"
on a cancelled account and it did not change the status but got created on=
the servers.
Anything along these lines would help.
Thanks.
-Bill
*********** REPLY SEPARATOR ***********
On 11/2/2002 at 5:12 PM Shawn Hogan wrote:
>Customer Care wrote:
>
>> Please stop making excuses and get some sort of error reporting (and not
>> e-mail based).
>
>I'm not making excuses. It wouldn't be hard to add, but I don't agree=
with
>it. That's all...
>
> - Shawn
>
>-------------------------------
>Shawn D. Hogan
>President, Digital Point Solutions
>http://www.digitalpoint.com
>(858) 452-3696
>
>
>---------------------------------------------------
>To subscribe, unsubscribe or to search list archive
>please visit http://www.optigold.com/lists/isp.html
>---------------------------------------------------
---------------------------------------------------
To subscribe, unsubscribe or to search list archive
please visit http://www.optigold.com/lists/isp.html
---------------------------------------------------
Messages In This Thread:
Return to Digital Point Solutions' Home Page
| home | |
| products | |
| services | |
| support | |
| email lists |
| optigold isp | |
| optigold isp news | |
| home inspection | |
| inspectrix | |
| java companion | |
| oracle | |
| quickdns pro | |
| search engine | |
| veterinary |
| tips | |
| employees | |
| free tools | |
| portfolio | |
| jobs | |
| contact |
888/4-DPOINTSupport:
858/452-3696