Dear MySQL-ers,
Using MySQL 4.1.20, I'm trying to do a complex query on a subset; well,
complex to me, that is. :)
In Perl, I'm trying to get 4 random entries from a subset "WHERE processed
= '1'" and "columnId" is unique. Like so:
$sth = $dbh->prepare ("SELECT columnId FROM queue WHERE columnI
> -Original Message-
> From: Chris [mailto:[EMAIL PROTECTED]
> Sent: maandag 14 augustus 2006 3:55
> To: Mark
> Cc: mysql@lists.mysql.com
> Subject: Re: Random SELECT on subset
>
> > In Perl, I'm trying to get 4 random entries from a subset
>
> -Original Message-
> From: Chris [mailto:[EMAIL PROTECTED]
> Sent: maandag 14 augustus 2006 4:18
> To: Mark
> Cc: mysql@lists.mysql.com
> Subject: Re: Random SELECT on subset
>
> > Then I want to select 4 random columnIDs, but only from the
> > subse
> -Original Message-
> From: Chris [mailto:[EMAIL PROTECTED]
> Sent: maandag 14 augustus 2006 4:54
> To: Mark
> Cc: mysql@lists.mysql.com
> Subject: Re: Random SELECT on subset
Hmm, this still does not do what I want:
SELECT columnId FROM queue WHERE processed =
> -Original Message-
> From: Chris [mailto:[EMAIL PROTECTED]
> Sent: maandag 14 augustus 2006 6:32
> To: Mark
> Cc: mysql@lists.mysql.com
> Subject: Re: Random SELECT on subset
>
>
> Thanks to you, the query has been greatly simplified, but
> the result
27;s completely unusable now.
Thanks,
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e are in each month for the next ten years (that's what the 'invalid
date' test was supposed to do), and at what day of the week they start. In
MySQL 5.0.2 this really worked very well. Thank you! :)
> Hello Mark,
>
> in Versions of MySQL prior to 5.0.2 it is only checked
ivers abolutely need upgrading too. I
ran pretty complex database stuff on it, and all seems to work just fine.
Did I misunderstand the upgrade process? I mean, I don't mind that it
works fine; I just don't understand why. :)
Thanks,
- Mark
--
MySQL General Mailing List
For list archives
Dear MySQL-ers,
Using MySQL 5.0.24a, is there a quick way to determine which columns on a
table don't have an index?
I want to do sort of s recursive loop, and add indices for all columns
which don't have an index yet (and that over many databases).
Thanks,
- Mark
--
MySQL Gener
I have a field called name which stores a person's first, middle and
last name.
Previously, these names (17800 of them) were entered in the database by
different people so there was no consistency in the format used. There
are now names entered such as:
Smith, John S.
Doe - Jane W.
Doe John
? (FreeBSD). I'm ready to do away with phpMyAdmin.
Thanks,
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> > At any rate, does anyone know what I could use instead, as
> > semi-graphical interface, on Apache? (FreeBSD). I'm ready to
> > do away with phpMyAdmin.
> >
> > Thanks,
> >
> > - Mark
> Just a couple of hours ago Vittorio Zuccalà suggested
I didn't find any option for character-set-server so I add it under
mysqld as you've stated. I also found default-character-set so I also
set its value to utf8. It didn't work.
I tried adding a dash (utf-8) to it. It didn't work also.
Yes, I did restart MySQL after saving the configuration.
W
You're right. It is not related. The same output are shown as before.
However, the links you gave me was quite useful. I re-read and
re-read them over and over until this little query solved my dilemma, sort of:
SET NAMES 'utf8';
Thanks for the help! ^_^
useful links:
http://dev.mysql.com/do
userBid` IN ('SELECT `ID` FROM `users` WHERE
`status`='disabled')'
The query must be run on a mysql server version 4.0.24
Thanks for any help with this one,
Mark
Hi,
I need it some info to help a client defend against a legal challenge.
Is there a MySQL function that will allow me to ascertain the date and
time that a particular field's value was last updated. I can't find
anything in the MySQL documentation.
Thanks very much.
Mark
you that don't know what crack is, it's a drug
> that will fuck your life up.
>
> Ezra Taylor
Is there anyone who can shed some light on this without the anti-Orcacle
hysteronics? What will become of InnoDb once MySQL license runs out, is
still a pertinent question.
Thanks,
t;
> I then issue this command or statement:
>
> mysql>GRANT ALL PRIVILEGES ON *.* TO 'testUser'@'' IDENTIFIED
> BY 'some_password' WITH GRANT OPTION;
>
> I get the following returned:
>
> Query OK, 0 rows affected (0.00 sec)
>
> Why is
> -Original Message-
> From: Michael Stassen [mailto:[EMAIL PROTECTED]
> Sent: zondag 6 november 2005 6:26
> To: Mark
> Cc: 'Bruce Martin'; mysql@lists.mysql.com
> Subject: Re: Add New User
>
> > Because, afterwards, you forgot to say:
>
Can anyone tell me if it is possible to send an email from outlook to a DB so
it updates a record. I have a php tipping script hosted with a mysql DB but
would like users to email their tips instead of loggin on the site.
Mark
lt '',
`password` varchar(255) NOT NULL default '',
`phone` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`signup_date` datetime NOT NULL default '-00-00 00:00:00',
`last_login` datetime NOT NULL default '-00-00 00:00:00',
`activated` char(1) NOT NULL default '',
`first_name` varchar(50) NOT NULL default '',
`last_name` varchar(50) NOT NULL default '',
`avatar` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
}
?>
**
Regards MArk
ike to have is the Hyperdrive 5 from
> http://www.hyperossystems.co.uk/. It is a DDR SSD and each drive has
> slots for 8 DIMM's which means it can hold up to 32GB (64GB if you can
> find 8GB DDR2's) per drive.
Too bad these aren't SCSI drives, so they could be used w
-Original Message-
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: maandag 20 april 2009 10:28
To: p...@pwilson.net
Cc: mysql@lists.mysql.com; Cameron Rogers; step...@kionic.com
Subject: Re: A good US Hosting Site?
> www.awardspace.com
>
> I have both free and paid hosting and
-Original Message-
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: maandag 20 april 2009 17:22
To: Mark
Cc: mysql@lists.mysql.com
Subject: Re: A good US Hosting Site?
> Well,
>
> not a joke for free hosting.
>
> But it is, for me, by far the best hosting site
-Original Message-
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: maandag 20 april 2009 22:29
To: Mark
Cc: mysql@lists.mysql.com
Subject: Re: A good US Hosting Site?
> Mark wrote:
> > Yeah, but a "Maximum file size limit 500 KB," what can you do with
>
Okay, does anyone know of a hosting site that supports 'Image::Magick'?
(the Perl package). The salesrep at AwardSpace said they didn't have it.
P.S. This is probably getting a mite off-topic. So, feel free to reply to
me off-list, if you happen to know the answer.
Thanks,
- M
this (FreeBSD). Anyone any idea what's happening?
Thanks,
- Mark
Repairing tables
albatross.banned
Error: Incorrect key file for table 'banned'; try to repair it
error: Corrupt
albatross.bridge
Error: Incorrect key file for table 'bridge
C'mon, guys, there's gotta be someone who knows something about this. :)
Anyone? Anyone? Bueller? Bueller? I even did a complete mysqldump (from
the 5.0.77 mysqld) and imported it that way. To no luck, alas.
Thanks,
- Mark
-Original Message-----
From: Mark [mailto:ad...@asaria
st it can cause
crashes.
- Mark
From: zhu dingze [mailto:mysql.li...@gmail.com]
Sent: zondag 26 april 2009 16:40
To: Mark
Cc: mysql@lists.mysql.com
Subject: Re: Error : Incorrect key file for table 'X'
Hey Dude,
So many errors imply that there are some issues with your
ases first. After that, the import succeeds, and all errors are gone.
Odd. It's been quite quiet on this list of late. I expected at least
someone to know the answer. If this is indicative of people's interest in
MySQL these days, then maybe it really IS a good idea to start using
It would probably help if you told folks what MySQL version you are running.
:)
- Mark
-Original Message-
From: VeeJay [mailto:maan...@gmail.com]
Sent: dinsdag 28 april 2009 10:22
To: mysql@lists.mysql.com; VeeJay
Subject: 1135: Can't create a new thread (errno 35); if you are no
limit (and
'sysctl' it to higher if it's not sufficient). I'm always amazed how much
open files MySQL keeps. The amount of files MySQL reserves, way I recall,
is also directly related to max. connections; so you could lower that too,
temporarily, to see if it makes the error go
ow to Jörg's expertise on the matter. :)
- Mark
-Original Message-
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: dinsdag 28 april 2009 14:44
To: Joerg Bruehe; maan...@gmail.com
Cc: ad...@asarian-host.net; mysql@lists.mysql.com
Subject: RE: 1135: Can't create a new thread (er
into this.
- Mark
-Original Message-
From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com]
Sent: woensdag 29 april 2009 8:14
To: Mark; mysql@lists.mysql.com
Subject: Re: 1135: Can't create a new thread (errno 35); if you are not out
of available memory, you can consult the ma
t;
mysql>
mysql> show databases;
++
| Database |
++
| information_schema |
| hgallery |
++
2 rows in set (0.00 sec)
mysql>
Ok, so how do I disable that?
- Mark
-Original Message-
From: John Daisley [mailto:john.dais...@my
This isn't a MySL hell exclusively, btw. You'll get the same issue
upgrading PostgreSQL, or BerkeleyDB, etc. It's just the nature of the
beast.
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Depends on your OS, I guess. On FreeBSD you can just go to the
'php5-extensions' port, run a 'make config', and deselect everything but
the MySQL extension. Then it will only build mysql.so for you. Very easy.
:)
- Mark
From: Martin Gainty [mailto:mgai..
Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session?
- Mark
-Original Message-
From: Tim Johnson [mailto:t...@akwebsoft.com]
Sent: woensdag 19 oktober 2011 1:02
To: MySQL ML
Subject: mysql server does not recognize user password
using 5.1.57 on Mac Lion.
linked against libmysqlclient.so.15?
Thanks,
- Mark
key_buffer=128M -O sort_buffer=128M -O read_buffer=2M -O write_buffer=2M
/var/db/mysql/*/*.MYI
But that didn't seem to include the information_schema, though. How can I
fix these errors? So close to Xmax, I'm panicking a little.
Thanks,
- Mark
ed to this?
http://lists.mysql.com/internals/31016
Please, shed some light on this! The error does seem less dramatic than I
initially thought, but it still freaks me out some. :)
- Mark
-----Original Message-
From: Mark [mailto:[EMAIL PROTECTED]
Sent: zondag 23 december 2007 13:5
Is there an easy way to determine the largest sql query I can
pass between a perl/C app to my MySQL database? It seems to wig
out around the 1 meg range but without resorting to trial and
error I'm not sure how to get an exact figure.
Thanks,
Mark.
--
MySQL General Mailing List
For
host. Am I missing something here?
mark
* Please don't tell me to upgrade to 4.x. I'm working on some software, and
I do *not* want it to require Only The Latest Version. Since many distros
are still shipping with 3.23, I want it to be compatable with what they're
running, and
nect to URCMS database from localhost.
The problem is that I'm writing software, not just something for myself. I
want to have this be generic, so that if someone wants to install this
package on one system, and log into mysql *either* from the same machine
that it's running on, *or* fr
g about load_file? I do have the full path to the file to be
loaded into the TEXT column, and I've tried it with both single and double
quotes.
mark
--
FASCISM. A system of government that exercises a dictatorship of the
extreme right, typically through the merging of state
s.
Still don't understand why grant doesn't work with 3.23, and why I have to
do an update to the user table to give the correct permissions. The docs
*seem* to say that grant works, as of 3.22
mark
--
"Patriotism is the last refuge
of a scoundrel." --Samuel Johnson.
I have a site where members rate movies they've seen. I run a routine to
recommend 5 titles based on movies they've given a max 5 rating. It's
very slow, and I think a better MySQL query can speed it up. I'm running
MySQL 3.23.54.
Tables:
movies (unique id plus movie info)
subcats (movie id, subca
t
with the same subcategories as Star Wars.
- Mark
-Original Message-
From: Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 7:37 AM
To: Mark
Cc: MySQL List
Subject: Re: Faster version of Movie Search
Mark,
You're killing me because I can't visualize the source tabl
I started getting an error:
#1049: Too many connections
Around 10 hours ago, and I don't know what it means. My admin is sort of
a "go between" with the host provider, so I need to give him as much
information as possible to get the problem fixed.
I haven't made any changes to the site, although
/ and mirror sites.
Any reason there is no longer a 4.0.22 'standard' for FreeBSD? There is a
4.0.22 'max' for FreeBSD, but not standard.
Also, speaking of FreeBSD, is it not time to start compiling against
something higher than 4.7? Like 4.10? (or 4.9, perhaps).
Thanks,
-
Dan Nelson wrote:
> In the last episode (Oct 30), Mark said:
>>> MySQL 4.0.22, a new version of the popular Open Source/Free
>>> Software Database Management System has been released. It is now
>>> available in source and binary form for a number of platforms from
ecause I do not seem to have a whole lot of "Qcache free blocks".
Would decreasing the allocated qcache memory also decrease the
amount of free blocks?
Thanks,
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
tabase application.
I take it by "link" you mean something which describes your
database:user:password, etc? Please, show the error. And you are
not sharing the same database handle for multiple connection,
btw, right?
- Mark
System Administrator Asarian-host.org
---
&quo
hould be recompiled. If your client library is
at 4.0.18, and MySQL itself at, say, 4.0.23, you would still be okay;
but with an older client library, you may expect weirdness. ;)
I'm sure you already looked into this; but just in case you didn't...
- Mark
--
MySQL General Mailing
user, say, mysql, chown mysql:mysql /var/db/mysql/* (or
wherever your databases reside), chmod go-rwx /var/db/mysql/*, add "user =
mysql" to your my.cnf, and you're pretty much done.
Granted, you cannot have your pid in /var/run/ directly. So? Create a
subdir under /var/run/, owned b
> -Original Message-
> From: j [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 1 februari 2005 11:20
> To: Mark
> Cc: mysql@lists.mysql.com
> Subject: Re: Non root user MySQL install possible?
>
> Sorry, I don't mean running MySQL as root, I mean I do not have roo
ive_timeout system variable? See:
> http://dev.mysql.com/doc/mysql/en/server-system-variables.html
> http://dev.mysql.com/doc/mysql/en/gone-away.html
I believe he already answered that in part:
> > Also, my variable wait_timeout = 3600.
1 hour, that is, instead of the default 8 (28800).
the
amount of connections? It seems to say so, but since this is also said to
be a CACHE value, maybe not.
I have set table_cache to 256, max_connections to 512, and I have an
open_files_limit of 7408. Does that suffice?
Thanks,
- Mark
--
MySQL General Mailing List
For list archives: h
> -Original Message-
> From: Dathan Pattishall [mailto:[EMAIL PROTECTED]
> Sent: donderdag 3 februari 2005 1:21
> To: Mark; mysql@lists.mysql.com
> Subject: RE: Relationship between 'table_cache' and 'max_connections'
>
> Max_connections rel
CREATE TEMPORARY TABLES has something to do with it? I
think it came with an ugrade script once, for 3.32 to 4.0.x).
At any rate, any help would be appreciated,
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Mark wrote:
Indeed, I thought --safe-show-database was default now? Running MySql
4.0.21, I noticed, to my dismay, that phpMyadmin still shows the
databases the user has no access to! I have a user, call it testuser,
who has the following global privileges:
CREATE TEMPORARY TABLES, LOCK TABLES
And
st';
That did it! Solved. :) Thank you!!
Now that you mention it, yes, it makes perfect sense. I guess I never
suspected such global behavior change when I ran
"mysql_fix_privilege_tables" when I upgraded to 4.0.21 (from 3.23.58, I
believe).
Anyway, thank you!
- Mark
--
MySQL Gene
mysqlmysql8976 Aug 27 10:20 resources.frm
-rw-rw1 mysqlmysql134471560 Aug 28 09:33
resources.MYD
-rw-rw1 mysqlmysql61629440 Aug 28 10:23 resources.MYI
any tips are appreciated.
thanks,
- Mark
--
MySQL General Mailing List
For list archives: http://lists
Hi,
no - adding a limit doesn't really help.
thanks,
- Mark
On Thu, 28 Aug 2003 16:12:41 -0400, John Larsen wrote:
>Mark wrote:
>Why don't you just always put a limit 1000 on it, do you ever need
>more
>than that?
>
>>Hi,
>>I have a fulltext index on
nd my table_cache is higher than my # of tables.
I'm using 4-0-14 standard on Linux.
thanks,
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>Any chance you OS swapped out part of your key_buffer? See if any
of
>mysqld's memory is sitting in swap.
>
>Jeremy
Hi,
how exactly do I tell this on linux?
Thanks,
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:
uot;article_num", by the way, is not necessarily sequentially numbered, so
doing something from X-75 to X, will not work.
Thanks,
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, November 06, 2003 2:45 PM
Subject: Re: Last 75 entries from a table
>
> "SELECT article_num FROM $table order by \
> article_nu
updates? Is this
part of the current MySQL functionality by any chance?
Thank you,
Mark.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
upgrading? Or is it still too flaky? I run a news server
on it, and server mail client databases; so I really cannot afford an
unstable product.
Thanks,
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hat I will need less of
key_buffer_size space. Right?
Thanks!
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
known, say, 'key_buffer to query_cache_size' ratio?
Thanks,
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
28M query_cache_size). My guess is that I will need less of
key_buffer_size space. Right?
Thanks,
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Eamon Daly wrote:
> Short answer:
> Type 'cpan'
> Type 'install DBD::mysql'
Contrary to intuition, you should install DBI first! DBD::mysql will look
for DBI too.
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
BAO RuiXian wrote:
> Mark wrote:
>
>> Eamon Daly wrote:
>>
>>> Short answer:
>>>Type 'cpan'
>>>Type 'install DBD::mysql'
>>
>> Contrary to intuition, you should install DBI first! DBD::mysql will
>> look fo
Hello,
Just a quick question: running MySql 4.0.18, is a 64M query cache too large?
Thanks,
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
since 4.0.18.
Will that require an upgrade from Perl DBD drivers as well? (like when I did when I
moved from 3.23.58 to 4.0.18). I really hope not. :)
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
r's version?
Not sure any more. But, like I said, I believe it was the header changing stuff that
made upgrading a necessity.
> Or was that only Win32 problem?
Dunno. I am running FreeBSD 4.9R. ;)
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
:(
Can someone please tell me how to end this problem? I checked the databases
a zillion times, and they appear fully intact. I am gravely at a loss here.
:(
- Mark
-
Before posting, please check:
http://www.mysql.com/manual.p
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 26, 2002 4:44 PM
Subject: re: Lost connection to MySQL server during query
> Mark,
> Tuesday, November 26, 2002, 7:32:15 AM, you wrote:
&g
- Original Message -
From: "Mark Matthews" <[EMAIL PROTECTED]>
To: "Pae Choi" <[EMAIL PROTECTED]>
Cc: "Tonu Samuel" <[EMAIL PROTECTED]>; "Darney Lampert"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, Novemb
"using" it?
I know this thread became a bit trollish along the line, but I am genuinely
interested in knowing where I stand when a program of mine uses MySQL
connections.
- Mark
-
Before posting, please check:
commercial licences."
In other words: relax. :) Worried people who are asking questions here to
the effect of their program "using" MySQL requires a commercial licence, are
likely people who cannot afford a commercial licence anyway.
- Mark
Is Innodb still beta in MySQL-Max-3.23.54a? If not, I am thinking of making
the move. :)
Thanks!
- Mark
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
t help if you actually said what gets when corrupted in what query,
and what the corruption looks like.
- Mark
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 22, 2002 2:12 AM
Subject: Re: request
If it is not, his computer should probably not have been on to begin with.
:)
- Mark
> if it's not you have probably just shamed hi
aking a performance difference?".
I would rather reverse the question: is there ever a good reason NOT to use
an index?
- Mark
mysql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manua
nothing wrong with this query, and most of the times it executes just fine.
Could someone please tell me what I am doing wrong here? Why, when it fails,
would it fail here??
Thanks!
- Mark
-
Before posting, please check:
htt
- Original Message -
From: "Mark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 23, 2002 3:13 PM
Subject: What is wrong with this query?
> For month now I have been plagued by the "Lost connection to MySQ
> server during query" i
- Original Message -
From: "Michael T. Babcock" <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, December 23, 2002 8:14 PM
Subject: Re: SOLVED! (was: Re: What is wrong with this query?)
> >It seems th
(Parent Process Id) is 1, the 'init' process.
With the exception of being a child of the init process (like pretty much
every other process), the child is fully stand-alone.
I am not sure how to go about in C, but this is how it is done in Perl.
- Mark
-
CMC041/unixproc.html
What is interesting about it, that they use a "sleep 5" too, directly after
the fork () call. Apparently they reason Perl needs just a wee time to gets
its signals / pipes in order for the child. And that may just really be all
there is to it. Though it took
ehaved differently.
And if you set ownership to the the Perl scripts to the "nobody" user (and
run "chmod 551", for instance), then still everyone with access to running
pages on your web-daemon, will also have read-access to your Perl CGI
scripts.
Or am I missing something
- Original Message -
From: "Nicholas Elliott" <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>
Cc: "Octavian Rasnita" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, December 26, 2002 5:09 PM
Subject: Re: Hiding the pas
try and run your Perl scripts directly, and
not via a web-page. I have a nagging suspicion the errors will be gone.
- Mark
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
- Original Message -
From: "Chris Faust" <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, December 28, 2002 1:18 PM
Subject: RE: Desperate - failed: Lost connection to MySQL server during
query
> I really
ople face...
Perhaps those people should do what I do: create special MySQL users
(@localhost), unprivileged to the max, with only very narrow SELECT
privileges to the databases they are supposed to read data from, and use
those users to access the MySQL server in your CGI.
- Mark
--
- Original Message -
From: "wcb" <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Saturday, January 04, 2003 7:51 PM
Subject: Re: Hiding the password
> It isn't at all difficult to grasp. Please
her
words, when you lost the connection.
Sorry, that is all the usefulness I have to contribute, if at all. :)
- Mark
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
3.23.54a. I
was lazy this time, and (oh mother of all shames) used the precompiled
binary from the MySQL site. :) Worked like a charm though. Cool thing about
the binary is, that it runs "as is"; so you could just use that one binary
next to your existing distro.
- Mark
System Admi
1 - 100 of 1556 matches
Mail list logo
