Server :: A Script To Shutdown A Service When A Sybase Table Reads Over A Certain Count?
Aug 3, 2009
Someone at work has requested if i can find out anything on the above.Been googling around as well as i have only been using Linux for 2 months now.
basically there is a SYBASE ASE installation on the server, which a tomcat based website references.They want the service to stop once a certain row limit is reached in the table.
I know i have to do a count statement on the sybase table from ISQL.But how can i create the action "service website stop" once the count value reaches 4000 ?
I'm using MYTHTV with AT&T's U-Verse system. AT&T apparently turns off the set-top box if the box doesn't receive any commands after some number of hours. When this happens the box takes so long to turn on that it doesn't process the lirc IR channel change command. I've rewritten my channel changer to add a lockfile, and added a cron entry to kick off an entry to just "ping" the set-top box once an hour. But, OK, I'd like to play the bandwidth saving game and not do this if there isn't anything in the "record" table.
So, how would I write a script that will check the number of rows in the "record" table in the "mythconverg" database and exit if there are zero rows? I'm afraid I don't know how to even start this. Here is my "keepalive.sh" script that does the pinging:
Code: #!/bin/sh #if there are no rows in the record table, just exit this script # lock the lockfile - MUST be same one as channel lock while [ `lockfile "/tmp/mythchanlock.lck"` ]
I need to reconfigure my php to have Sybase support. However, I am not sure which library to use. I'll try freetds but I am not sure if it will work. I used it before with Microsoft MSSQL.
I'm attempting to get freetds and sybase up and running on my centos server, mainly for nagios - MSSQL checks. I've installed freetds freetds-devel ok but am having issues getting SYBASE installed. I've had a go via cpan but get a failure on the sybase environment variable. I've set it to /etc where the conf file is located as well as trying /urr/lib64 for the tds libs, but no joy. Has anyone had much luck with this on centos?
#!/usr/bin/perl use DBI; my ($db, $user, $pw) = ('dbname', '****', '***********'); my $dbh = DBI->connect("DBI:mysql:$db",$user,$pw) or die "Cannot connect to $db: $DBI::errstr
[code].....
The error message is
[Wed Feb 24 13:03:27 2010] myscript.cgi: DBD::mysql::st execute failed: Column count doesn't match value count at row 1 at myscript.cgi. [Wed Feb 24 13:03:27 2010] myscript.cgi: DBI::db=HASH(0x8a30c60)->errstr
i just wanna know if there is some script out there for shutting down a certain service if the load exceeds a specified value?
I've a system with a DBI-Proxy running, most of the time the systems load is about 2~3...if a DB-connection dies, the load rapidly increases (very fast) and after some seconds the load is > 200 and i'm no longer able to shut down the DBI-Proxy manually...or do anything else via ssh...
Now i wanna have a script running in background that checks the system-load permanently and stops the DBI-Proxy if the load exceeds...well, lets say 10 or whatever.
I have installed a cluster computer with 10 nodes . The manufacturer is HP . All nodes and the master node have redhat enterprise linux installed in them . When I shutdown the nodes from the master terminal using "shutdown -h now" they get shutdown . But they dont get completely turned off . This issue bothers me when the power supply is given , all nodes boot up simultaneously generating a huge heat .
Thing to note : When we shutdown our PC they get completely turned off . When the power supply is given , a press on the Power On button is required to boot the system. But , why does it not happpen in the case of cluster? Is there any other way of completely turning off the nodes from the master terminal ?
I have a fileserver running 10.04 server 64bit and samba. I connect it to my desktop which is 10.04 desktop 64bit.I have the server mounted on my desktop in fstab as://10.0.0.2/share /media/share cifs guest, uid= 1000.Up until 30 June 2010 it was all fine. Now when I write the server it is very slow e.g. 2Mbps though when I read I get >100Mbps so I think my network is still ok. If i use nautilus smb://10.0.0.2/share I can write at >100Mbps and also read at >100Mbps...So any ideas why the write speed via the fstab mount samba has started to go really slowly in the last couple of days?
Is there a way to show or count how many CPU instructions a particular process is using or uses? In my work we develop a web application and I'm responsible of maintaining the web server. The app lets you handle data online so each client that uses the web application has a folder associated to it, where his data is stored. (/var/www/html/test) for example. The idea is to get how many CPU instructions the httpd process for that particular folder is having. Is there a way to do this?
I have two servers running Linux 2.6.9 kernel.When i telnet to server1 , the telnet will be disconnected only after 3 login failures. While, when i telnet to server2, telnet will be disconnected after the first login failure.expect server2 to behave the same way as server1 when telnet is executed.Kindly tell me where i should tweak my servers so that i could achieve what i expect.
Previously I had posted a question on how to make it run every 7 minutes between 7 and and 11pm.However now I found out what I really need is every 7 minuted between 7:30 and 11pm BUT it has to be every 7 minutes, it cannot reset itself on the top of every hour, so the */7 wont work.How can it that it will be every 7 minutes, so it will go at 7:30, 37,44,51, 58, 8:05, etc..
i need to prepare a presentation for that i have to copy a table from [URL] to my power point slide. but when i am copying it i am just getting a table with single column. is there a method to import the contents from web page table to my presentation table?
Kmail 1.13.2 Problem on startup, error is from nepomuk, data storage. "cannot find Redland backend, nepomuk is disabled until fixed. Also see the following error from the akonadi console:
100503 10:00:15 [Note] Plugin 'ndbcluster' is disabled. 100503 10:00:15 InnoDB: Started; log sequence number 0 31413862 100503 10:00:15 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without
At work we have a Sybase Adaptiver Server 9.0 database running, it has to stay there for now, and we are developing a web application that will connect to it using PHP.I was already able to make it work using ODBC on Windows and using odbc_connect on PHP.But now we are moving to Ubuntu, and we are trying to get it to work on it.I already have Apache2 and PHP5 up and running.There are two ways (I can think of) we can do this, one is using ODBC and then use "odbc_connect" and the other is making "sybase_connect" work on PHP. Being the latter probably the best one since you wouldn't have ODBC as an intermediary.
Either way, as long as it works I'm happy. ODBC would be fine to meet our requirements for now.I already have ODBC Data Source Administrator but no idea how to create/include/add the Sybase driver.We also tried setting freetds up, but that didn't work either, we might be missing something.
I'm trying to install Sybase ASE EXpress 15.5 on Ubuntu and am getting the following error message: ./startserver: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory.
Code: # /usr/local/etc/freetds.conf # $Id: freetds.conf,v 1.12 2007/12/25 06:02:36 jklowden Exp $ # # This file is installed by FreeTDS if no file by the same # name is found in the installation directory.
I had sybase server running on my desktop but after the upgrade it does not seam to start properly. tried to restart the server many times but does not seam to help
The logs are displaying as below 00:00000:00001:2010/11/19 13:53:08.21 server Recovery complete. 00:00000:00010:2010/11/19 13:53:08.26 kernel Initializing Job Scheduler Task 00:00000:00010:2010/11/19 13:53:08.39 kernel Installed Job Scheduler sequencer code version 0.27 - 27 tokens
i get some trouble setting up good environment in linux.i have problem regarding connecting php(under linux) to a sybase server(under windows)is there anyway connecting this two technologies?.
I have a query in which i need to display the part of query output in bold
Example: select 'Previous NAV value for the fund is '+ CONVERT(VARCHAR(50),@prevNav) OUTPUT:Previous NAV value for the fund is 12345 so i need to display the output in BOLD like
Previous NAV value for the fund is 12345 OR
Previous NAV value for the fund is 12345
either the value can be in bold or the text can be in bold
I get some trouble setting up good environment in linux.. i have problem regarding connecting php(under linux) to a sybase server(under windows),,, is there anyway connecting this two technologies?..
I want to freely download and install sybase-openclient-11.1.1.3 either source or rpm package sybase-common-11.9.2-3.i386 either source or rpm package Sybase Adaptive Server Enterprise versions 11.9.2 or 11.0.3.3 for Linux. I searched a lot but didn't get it,
