Thanks for the idea, but I did get the right IP address on it. No DHCP.
Drew Burchett
United Systems & Software
Ph:(270)527-3293
Fax: (270)527-3132
-Original Message-
From: Barry Newton [mailto:[EMAIL PROTECTED]
Sent: Monday, April 23, 2007 11:17 AM
To: Drew Burchett
Cc: m
the machine several times in vain hopes that it
might kickstart something. I've also tried connecting from other
machines, which seems to work perfectly. Any suggestions on how to
proceed troubleshooting this?
Thanks,
Drew Burchett
United Systems & Software
Ph:(270)
varchar(50) | YES | | NULL|
(indexed)
| PAPER | varchar(50) | YES | | NULL|
(indexed)
| TURNAROUND| varchar(50) | YES | | NULL|
(indexed)
| SHAPE | varchar(50) | YES | | NULL|
(indexed)
Thanks,
Drew
Problem solved:
/usr/local/bin/mysql_fix_privilege_tables2
Drew Jenkins <[EMAIL PROTECTED]> wrote: Hi;
I rebuilt mysql and injected the database which had user "mysqluser" and a root
user. Both got wiped out. It looks like the data is intact other than that.
Look at this:
my
-ppass
ERROR 1045 (28000): Access denied for user 'dev'@'localhost' (using password:
YES)
2
mysql> use authdaemon;
Database changed
mysql> show tables;
Empty set (0.02 sec)
Is authdaemon the database that has the grant tables? What gives? How do I add
users that I ca
Never mind. I forgot this command:
/usr/local/bin/mysql_install_db --user=mysql
Drew2
Drew Jenkins <[EMAIL PROTECTED]> wrote: I built a new server at my server farm
because the old one was corrupt. I had a hunch it had to do with the new 500 GB
hard drive I bought. I told them to check
it I get this very
undescriptive error:
# Starting mysqld daemon with databases from /var/db/mysql
STOPPING server from pid file /var/db/mysql/server312.web.vi.pid
070309 17:19:12 mysqld ended
Helps a lot, doesn't it? Where do I begin with this?
TIA,
Drew
---
me maybe I should read the entire page :)
Turns out the manual is poorly written in this instance. The comments at the
bottom elucidated what to do:
* log onto mysql
* enter this command:
SET GLOBAL max_allowed_packet=1000;
Done!
Thanks all!
Drew
___
20- Original Message
From: ed <[EMAIL PROTECTED]>
To: Drew Jenkins <[EMAIL PROTECTED]>
Sent: Saturday, March 3, 2007 12:16:42 PM
Subject: Re: Can't Bind to Port
I figured it wouldn't hurt anything to change permissions on files, so I went
ahead and changed all the
- Original Message
From: Tommy Nordgren <[EMAIL PROTECTED]>
To: Drew Jenkins <[EMAIL PROTECTED]>
Sent: Saturday, March 3, 2007 1:39:14 PM
Subject: Re: Can't Bind to Port
Well, I don't know what you do with this one, Tommy. I just cut and pasted your
command, but w
- Original Message
From: ed <[EMAIL PROTECTED]>
To: Drew Jenkins <[EMAIL PROTECTED]>
Sent: Saturday, March 3, 2007 1:06:16 PM
Subject: Re: Can't Bind to Port
None of those directories existed on my system. So I decided to try and find
the ones to which you referred.
- Original Message
From: Tommy Nordgren <[EMAIL PROTECTED]>
To: Drew Jenkins <[EMAIL PROTECTED]>
Sent: Saturday, March 3, 2007 1:03:30 PM
Subject: Re: Can't Bind to Port
>You are probably using another shell than bash or another sh variant.
No, I'm using
- Original Message
From: Tommy Nordgren <[EMAIL PROTECTED]>
To: Drew Jenkins <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Saturday, March 3, 2007 12:34:37 PM
Subject: Re: Can't Bind to Port
>There is no need to be superuser to run find. But there can be p
- Original Message
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
To: Drew Jenkins <[EMAIL PROTECTED]>
Sent: Saturday, March 3, 2007 12:03:40 PM
Subject: Re: Can't Bind to Port
>At this point, make
>certain that the mysql instance that you started (pid
- Original Message
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
To: Drew Jenkins <[EMAIL PROTECTED]>
Sent: Saturday, March 3, 2007 11:25:37 AM
Subject: Re: Can't Bind to Port
I rebooted, then...
server312# ps wax|grep mysqld
server312# /usr/local/bin/mysq
26- Original Message
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
To: Drew Jenkins <[EMAIL PROTECTED]>
Sent: Saturday, March 3, 2007 10:53:45 AM
Subject: Re: Can't Bind to Port
>kill off the first instance, the port will/should free up and then you
>
- Original Message
From: ed <[EMAIL PROTECTED]>
To: Drew Jenkins <[EMAIL PROTECTED]>
Sent: Saturday, March 3, 2007 10:24:54 AM
Subject: Re: Can't Bind to Port
>be root/superuser;
>try it as "find / -name mysql" and then, (as in 2nd) send they instances
- Original Message
From: Tommy Nordgren <[EMAIL PROTECTED]>
To: Drew Jenkins <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Saturday, March 3, 2007 5:00:26 AM
Subject: Re: Can't Bind to Port
>Try the command:
>find / -name mysql 2>/dev/null
>then
26- Original Message
From: Tommy Nordgren <[EMAIL PROTECTED]>
To: Drew Jenkins <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Friday, March 2, 2007 7:32:16 PM
Subject: Re: Can't Bind to Port
server312# netstat -nlap tcp | grep 3306
tcp4
Oops. Forgot to add I passed it tcp as the protocol and it returned blank:
# netstat -nlp tcp| grep 3306
#
I presume that means nothing's listening on that port? If so, then why did nmap
return mysql on that port? At any rate, what do?
TIA,
- Original Message
From: Borokov Smith <[EMAIL PROTECTED]>
To: Drew Jenkins <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Friday, March 2, 2007 6:21:59 PM
Subject: Re: Can't Bind to Port
>netstat -nlp | grep 3306
Option p requires a protocol. What protocol sh
ntil it went to bind to the port. There's
no other MySQL running on the server, so why can't it connect to the port? This
server isn't yet set up with an URL, so if it's reading from rc.conf or what
have you, that could be
Thanks for the detailed feedback. I do not create the data so I can't
modify it. Your illustration of the table is correct. I'll try to
implement some of your feedback.
Thanks
On 9/25/06, Michael Stassen <[EMAIL PROTECTED]> wrote:
Jeff Drew wrote:
> I have a query wi
I have a query with a subquery which does not throw an error, but does not
return either. I've been testing the query using mysql Query Browser and
the poor dolphin jumps only once a minute or so ;) I use MYSQL's excellent
error documentation heavily so if the query doesn't throw an error, I'm
I'm apologize for posting an apparently simple question, but I'm stuck. I'm
trying to get my java application to connect to mysql on the same server.
The server is redhat with mysql 5.1.11. I'd done this with mysql 4.x in the
distant past.
I add a user with the command:
insert into user (user
ssage.
Thanks,
Drew
--
Be a Great Magician!
Visit The Alchemist's Warehouse
http://www.alchemistswarehouse.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sporadically, the last few entries of a batch are not written. I'm writing
to a mysql database using JDBC. Here's a short version of my code. Does
anyone have suggestions on possible causes or other diagnostics?
class DatabaseWriter{
int writeCount=0;
public DatabaseWriter(){
PreparedStat
ANNOUNCEMENT:
A RFD (REQUEST FOR DISCUSSION) has been posted for the creation of a
new Usenet newsgroup: comp.databases.mysql
The proposal and related discussion can be read in the Usenet group
news.groups ... feel free to weigh in and make any suggestions you
may have.
Message-ID: <[EMAI
Our Java application has several threads that use JDBC to write to several
tables. Currently, we use one JDBC connection. Would performance improve if
we used a connection per table? Is a single connection bad for some reason?
Since connection pooling is a hot topic, I'm wondering if we're mis
Hello I need to download a version of mySql v4, but I don't know which one
to download.
The Server I'm going to load the built database on to is running: Linux
2.4.19C13_v
As the server is mySql compatible they must already be running mySql on the
system.
So the catch is...
My home terminal
Can the the datadir be changed with a .rpm install on SuSE?
Our SA gave us a large partition on /export. We installed the .rpm and were
running fine with the datadir set to the default /var/lib path. So I need to
move the datadir to /export. Since we're just moving to Production, we do not
ne
unique
SELECT perid,prog,startdt,MAX(stopdt) FROM test GROUP BY perid,prog,startdt
or
SELECT perid,prog,MIN(startdt),MAX(stopdt) FROM test GROUP BY perid,prog
might do what you wnat
--
Drew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
I have 2 tables similar to
T1
---
ID | initial |
T2
--
initial | full_name |
I want output based on the T1.ID row which has a given ID=' X '
(If ID = 7 then pretend initial = initial3, as example)
The first or l
Hi has anyone seen a workaround for the following error:
Thanks in advance,
Drew.
Environment: Solaris 9 u1 (Kernel: 112233-02)
All GNU compilers & tools installed. output as follows:
gcc -DMYSQL_SERVER
-DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\""
-DDATADIR
tables: 207 Queries per second
avg: 17.618
We have a sort_buffer of 32M! Is this to big? Does anyone have any
recommendations of what size it should be?
Drew.
Andrew Toussaint
Richardson-Shaw Pty Ltd
[EMAIL PROTECTED
Hi all,
Why is it that some times in mySQL error logs the error
number is reported as Zero? Is this a common error or does it have
something to do with PHP.
Drew
Andrew Toussaint
Richardson-Shaw Pty Ltd
[EMAIL PROTECTED
Multiple CPU's with FreeBSD
4.2 or 4.3? Thanks for your help in advance.
Drew
Andrew Toussaint
Richardson-Shaw Pty Ltd
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php
d in the Subject I have FreeBSD4.1.
>How-To-Repeat:
>Fix:
>Submitter-Id: <[EMAIL PROTECTED]>
>Originator:Drew Toussaint
>Organization:
Richardson Shaw PTY LTD
>MySQL support: none
>Synopsis: ??
>Severity: non-critical
>Priority: l
freebsd
Any heap will be much appreciated. Thankyou in advance.
Drew
Andrew Toussaint
Richardson-Shaw Pty Ltd
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
error '/usr/libexec/ld-elf.so.1:
/usr/lib/libstdc++.so.3: Undefined symbol "__ti9exception"' I also
got the same error when I tried to run mysql using
/usr/local/mysql/bin/mysql as stated in the Subject I have
FreeBSD4.0. Any help regarding this would be much appreciated.
Than
>Fix:
>Submitter-Id:
>Originator:Drew Degentesh
>Organization:
>MySQL support: none
>Synopsis: mysql clients hung (cannot start)
>Severity: critical
>Priority: high
>Category: mysql
>Class:
>Release: mysql-3.23.27-b
the problem need to be asked I will try and
answer them. Thanks in advance.
Drew
Andrew Toussaint
Richardson-Shaw Pty Ltd
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php
erName
>AND t2.Group = 'Dedicated'
>AND t1.StopTime = 0
> WHERE t2.id IS NULL;
>
> --Greg Johnson
>
> -Original Message-
> From: Drew [mailto:[EMAIL PROTECTED]]
>
table2.Group != 'Dedicated'
You can see that I am trying to get the id's from the first table where
the stoptime is 0 and they do NOT have an entry in table2 that says
dedicated. There are multiple entries is table2 for each username...
Any suggestion
what does a 'show processlist' reveal?
On 17 Jan 2001 00:08:23 +, John Stumbles wrote:
> On Tue, 16 Jan 2001, Jeremy D. Zawodny wrote:
>
> > On Tue, Jan 16, 2001 at 08:21:19PM +, John Stumbles wrote:
> >
> > > I can't readily reproduce the first-time big difference
> > > scenario.
>
>
45 matches
Mail list logo
