libmysqlclient_r.so not being created

2006-06-06 Thread jabbott
Any idea why libmysqlclient_r.so is not being created when I compile after a configure --without-server? I did two other boxes this morning and everything went just fine. Now this one (RH 9) is not getting it's libraries created. The compile/install looks like it works just fine. --ja --

Re: MySQL Read_only Mode

2006-06-28 Thread jabbott
Only allow your users select rights. --ja On Wed, 28 Jun 2006, Clyde Lewis wrote: > All, > > Does MySQL have an option where the database can startup in READ-ONLY > mode? The idea is to have the server running with users connected, > but now allowing any updates to me applied to the databas

replication general question

2005-06-23 Thread jabbott
I have two mysql boxes setup. Fast machines, I think they are dual 3ghz with boat loads of ram. They are not real busy servers but they have some pretty good sized tables, one of them with a few million rows. My question is, I have Nagios setup to monitor the seconds behind master on the bac

Re: replication general question

2005-06-23 Thread jabbott
PROTECTED] jabbott]# more secondsBehind.sh #!/bin/sh mysql -pMYSECRET -e "show slave status\G" | grep Seconds Then I have this that I run in the rc.local. This sets up a port that listens for a connection on port 5151. I have hole open in my firewall into my dmz for port 5151 [EMAI

help with query

2005-10-22 Thread jabbott
I have a table of votes with four fields, a primary key, and userID, that are just there for tracking purposes. But then I have questionID and vote fields. For each question, a user could pick a number of it's importance from 1 to 5. That number is what gets stored in the vote field. So,

sum of time?

2005-10-23 Thread jabbott
I have a table doing time tracking. I don't use timestamps, I use datetime fields to record punch in times and punch out times. I have this query that computes the amount of time between a punch in and punch out: select SEC_to_time(unix_timestamp(TTendTime) - unix_timestamp(TTstartTime)) as e

Re: sum of time?

2005-10-24 Thread jabbott
On Mon, 24 Oct 2005 [EMAIL PROTECTED] wrote: > "Martijn Tonies" <[EMAIL PROTECTED]> wrote on 10/24/2005 10:16:21 AM: > > > > > > > > Michael Stassen wrote: > > > > > > > Second, no, it won't overflow: > > > > > > > > mysql> SELECT SEC_TO_TIME(60*60*24*5); > > > > +-

Re: Can't start server after power outage

2006-02-08 Thread jabbott
That happens sometimes. Do a mysqladmin shutdown and then try to restart it. It should start just fine. --ja On Wed, 8 Feb 2006, Michael Satterwhite wrote: > I use a local MySQL server (we're using 4.0) for development. It's been > running cleanly for months - and the configuration file has

return integer for positive values

2007-04-05 Thread jabbott
I have a table with a list of pollutants. I have a table of locations, site names, counties, etc. I can join the these tables together and get a list of of all the pollutants at a site. But, what I am really wanting is a list of all the pollutants with a integer field, zero for pollutant not

RE: return integer for positive values

2007-04-05 Thread jabbott
I am at a higher level than that. Here is my query: SELECT distinct emt.group_name FROM epa.aq_ambient_nad83 aq_, epa.aq_ambient_pollutants pol, epa.emtb_pollutant_group emt, epa.pollutant pt WHERE (aq_.siteid = pol.siteid) AND (emt.group_code = pt.ambient_group_code) AND (pol.paramcode

replication, table db already exists

2005-02-24 Thread jabbott
Hello All, Here is a problem I have been trying to debug for a few days. I had a mysql server running for about a month. I did a mysql dump of all the tables on the master and setup a second machine to be the slave, loading all the tables. I set the replication stuff up in the slave my.cnf.

something is pegging mysql

2005-04-05 Thread jabbott
It has been a rough day today. I am using mysql with coldfusion. Something somehwere on my site is causing mysql to take up 100% of the cpu. This causes coldfusion to lock. Is there any sort of query log I can look at to see what queries have run in, say, the last hour? If I see what queri

query question

2005-04-27 Thread jabbott
I have a table that the important parts look something like: keynum int, entryDate datetime, amount varchar(10) What I want to do is a query that gets me every day of the year and just has null values for the days that don't have anything in the amount column. Is something like that possible w

RE: email notification

2005-05-31 Thread jabbott
If we get triggers in mysql 5, couldn't you setup something like this? --ja On Tue, 31 May 2005, Philip Denno wrote: > I doubt you would find this feature in any database. You would have to > implement at the application code level. Basically whenever you insert > into a table have the applicat

query help?

2005-06-01 Thread jabbott
I have two tables, cutting out the extra stuff they boil down to: users: userID int, username varchar(11), realname varchar(40) logins: ID int, lastLogin timestamp So, what I am doing is: select user.id, username, realname, lastLogin from users left join logins on users.id = logins.id group

replication stopped

2005-06-03 Thread jabbott
I took a couple of days vacation last week and naturally the /data partition of my database server filled up because of something I was running and had forgotten about. So my backup guy, thinking to help out, gzipped all my .bin logs. Now I am noticing replication seems to have stopped on my

can't seem to reset password

2003-12-05 Thread jabbott
I have been reading and following the instructions from: http://www.mysql.com/doc/en/Resetting_permissions.html But, if I do: ./bin/mysqld_safe --skip-grant-tables And then I: mysqladmin -u root password 'mypassword' I get: mysqladmin: unable to change password; error: 'You must have privileges t

Re: sloooow sql query

2004-02-10 Thread jabbott
Got any indexes? --ja On Wed, 11 Feb 2004, nyem wrote: > Hello, > > I have this table which stores an ever changing price of items. > > CREATE TABLE shop ( >articleINT(4) UNSIGNED ZEROFILL NOT NULL default '', >date DATE NOT NULL default '-00-00', >price DOU

Re: AND + OR Logic

2004-02-12 Thread jabbott
On Thu, 12 Feb 2004, John Berman wrote: Try adding some ()s: > SELECT * FROM marriage WHERE (groom_surname like ('"& globsurname & "') or > bride_surname like ('"& globsurname & "')) and community like ('"& community > & "') > -- -- MySQL General Mailing List For list archives: http://

RE: Images

2004-09-28 Thread jabbott
I have heard also that it helps to keep the table with the blobs having a low number of fields. Like just a primary key and the blob field. Have all your other metadata in a seperate table. Especially if you are going to be occasionally doing queries of just the metadata and don't want to al

Error 1043 Bad handshake

2004-11-16 Thread jabbott
I have done some looking in the archive for this but can't seem to find anything recent that seems to apply. I have a brand new install of 4.1.7 on a Redhat 9 box. I compiled it with: CFLAGS="-O3 -mcpu=pentiumpro" CXX=gcc CXXFLAGS="-O3 -mpentiumpro -felide-constructors -fno-exceptions -fno-rtt

Re: Error 1043 Bad handshake

2004-11-17 Thread jabbott
An answer to my own question. I have solved this problem which seems to be due to the way mysql 4.1.7 stores it's passwords. I used the mysql function OLD_PASSWORD to make mysql store it's passwords in the pre 4.1.x method. Basically the syntax is: mysql> UPDATE mysql.user SET Password = OLD

Need help with a select. Regex?

2004-07-20 Thread jabbott
What I am trying to do is select the hostname out of a refering url. Such as: http://www.google.com/search?hl=en&ie=UTF-8&q=%22Third+Park+Point+Beach+Water+Contact+Advisory+Posted%3B+May+Indicate+Long-Term+Problem%22&btnG=Google+Search All I really want to get is: http://www.google.com/ So I h

compile problem

2003-10-06 Thread jabbott
Hope I am posting to the right list. I am new here. I have a sun system: SunOS spot 5.6 Generic_105181-05 sun4u sparc SUNW,Ultra-4 With gcc installed: # gcc -v Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.7.2.3/specs gcc version 2.7.2.3 I am trying to compile: mysql-4.1.0-a

Re: Easy (?) conditional SELECT

2003-10-08 Thread jabbott
Subqueries don't show up until v4.1 which I have running on one of my servers. Runs great and I have it into production. --ja On Wed, 8 Oct 2003, Rory McKinley wrote: > Problem 1 : Your query contains a subquery : > SELECT MAX( plan_submission_number ) > > FROM 'artifacts' > > WHERE product_

Re: MySQL 3.23.58 and sub-seletcs

2003-10-09 Thread jabbott
I am running it on a production server for about two weeks. So far it has been very stable. --ja On Thu, 9 Oct 2003, boka wrote: > Bob Brands wrote: > > > No, its supported by version 4.1 > > MySQL 4.1 -- Alpha release (use this for new development) ... is this > stable enough to use it on

Re: SQL Injections

2003-10-09 Thread jabbott
As I understand it, and I confess I am not totally sure I do, sql injection is more of a problem in your page code than what database (/version) you run. --ja On Thu, 9 Oct 2003, Dwight Trumbower wrote: > Are there any SQL injection threats for MySQL less than 4.1? > > Dwight Trumbower > > T

Re: Fixed Font

2003-10-17 Thread jabbott
I dunno, the font seems fairly fixed when I view it in pine --ja On Fri, 17 Oct 2003, Jerry Rocteur wrote: > Hi, > > I'm new to the list and I am just wondering.. > > Why don't you guys use a fixed font when pasting mysql queries.. > > Wouldn't it better to see something like this 'Monac

count max days

2003-10-17 Thread jabbott
I have a database where I want to count the number of days where a field gets to a certain value. Right now I am using: SELECT count(DISTINCT aqiValues.readingDate) as greenCount FROMaqiRegions, aqiSites, aqiValues WHERE aqiRegions.aqiRegionID = aqiSites.aqiRegionID AND

count max days (fwd)

2003-10-20 Thread jabbott
I sent this out on last friday but I never actually saw it post to the list so maybe I messed up the address. If this is showing up a second time, sorry. I have a database where I want to count the number of days where a field gets to a certain value. I am using two seperate queries to count t

Re: AW: count max days (fwd)

2003-10-20 Thread jabbott
The trouble with this is it returns 1. It seems to pick the max value for the year instead of by day. --ja On Mon, 20 Oct 2003, Franz, Fa. PostDirekt MA wrote: > Hi, > > maybe I didn't understand the question wrong. > > >I have tried to work in the MAX(aqiNumber) into the query but I get a

query time in ~3M row table

2003-11-04 Thread jabbott
I have a question about how long queries should be taking and if my server is too small for what I want to be doing. I have a table setup to record stats from an apache web server. I import the file currently once per month. Here is my table: mysql> describe hitStats; +-+-

Re: query time in ~3M row table

2003-11-04 Thread jabbott
Yes, it is an indexed field: mysql> explain select count(*) from hitstats where year(apacheDate) = 2003 and -> month(apacheDate) = 9; ++-+--+---+---+---+-+--+-+--+ | id | select_type | table| type

Re: OS X

2003-11-05 Thread jabbott
Download http://cocoamysql.sourceforge.net/ It's really great. Painless install. I spent hours trying to get mysqlcc to install and I was ending up playing the "one library short" game where it seems like if you install just one more thing it will work, but then it never does. cocoamysql in

a different compile error

2003-11-06 Thread jabbott
I am having some compile problems too: make[4]: Entering directory `/usr/src/mysql-4.1.0-alpha/sql' source='sql_lex.cc' object='sql_lex.o' libtool=no \ depfile='.deps/sql_lex.Po' tmpdepfile='.deps/sql_lex.TPo' \ depmode=gcc /bin/bash ../depcomp \ gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/lo

Re: Dirt Slow Query On Datetime Range

2003-11-11 Thread jabbott
Change your query to use BETWEEN rather that <= and >=. --ja On Tue, 11 Nov 2003, Michael Shuler wrote: > OK, I give up. To anyone out there who can help me, please explain why this > query runs slower than dirt. The table has about 1,300,000 records in it, > which is not supposed to be a big

Re: BLOB's - General Guidance

2004-05-19 Thread jabbott
I have an application where I serve out blobs. I store the PDF files in blob fields for two reasons. 1. I want to make an interface where staff can upload pdf's into the server but not actually give them access to the server. I use my code to maintain the security of who gets to write to wh

Re: BLOB's - General Guidance

2004-05-20 Thread jabbott
You might want to read it again. He is saying the performance and consistancy exists in the database whereas it doesn't in a file system. --ja On Thu, 20 May 2004, David Blomstrom wrote: > > [EMAIL PROTECTED] wrote: > > > Another perspective on the subject of BLOB vs. > > Links. > > > > >

Fresh 4.1.2 install on Redhat 9

2004-06-18 Thread jabbott
Hello List, I have done some googling around but can't find an answer to this one. Brand new box, installed with RedHat 9 and trying to run 4.1.2. This is what I get. --ja [EMAIL PROTECTED] mysql]# scripts/mysql_install_db --user mysql --log Installing all prepared tables 040618 11:06:51 Wa