date:20010429

show table status command in MySQL

2001-04-29 Thread Mark Lo \(3\)


Hi,

 For show table status command in MySQL, which field is indicate the
table size?  Or, Which command is to find out the database size.

Thanks in advance

mark



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Fw: Errcode: 13 with mysqlimport

2001-04-29 Thread Bombardier Systems Consulting


I am sending this again since the first time I sent it I wasn't entirely
signed in to the list.


> I am running RedHat linux 7.1 and MySQL 3.23.37.  I am trying to use
> mysqlimport and am getting an error message "mysqlimport: Error: Can't get
> STAT of  /path/to/file/file (Errorcode: 13) , when using table:
table_name".
>
> I looked the error up in the on-line documentation and changed the UMASK
and
> restarted MySQL and am still getting the error.  I created a new directory
> and moved the file in there and still the same.
>
> Suggestions?
>
> Thanks for the help
>
> Jim
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: problem of MySQL Installation

2001-04-29 Thread Rolf Hopkins


If you're using gnorpm, you'll find ncurses will come under a library.  It's
to do with C anyway, so you should be able to find it there somewhere.

- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "???" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, April 30, 2001 14:08
Subject: Re: problem of MySQL Installation


> On Mon, Apr 30, 2001 at 02:02:53PM +0800, ??? wrote:
> > which RPM should  installed ?
>
> Not sure. I don't really use them. But I'm sure if you got into
> whatever directory they are stored in and run something like:
>
>   ls *curses*
>   ls *termcap*
>
> You'll find them pretty quickly, no?
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951
>
> MySQL 3.23.29: up 117 days, processed 721,570,412 queries (71/sec. avg)
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

suggestion needed about du command run on PHP

2001-04-29 Thread Mark Lo \(3\)


Hi,

 I would like to run a du command to find out how many bytes of each
databases is consuming under PHP+ Apache.  But, the problem is I am not able
to count the bytes of the databases in MySQL, because the user and group is
set to MySQL.  On the other hand, My Web server is running on user nobody
and group nobody.  So, What suggestion will you give me in order to count
the bytes of each database is consuming using apache + PHP.

Should I change the apache's user and group to mysql or Should I make the
mysql database world readable.

Any Suggestions is helpful.


Thanks in Advance

Mark



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: problem of MySQL Installation

2001-04-29 Thread Jeremy Zawodny


On Mon, Apr 30, 2001 at 02:02:53PM +0800, ??? wrote:
> which RPM should  installed ?

Not sure. I don't really use them. But I'm sure if you got into
whatever directory they are stored in and run something like:

  ls *curses*
  ls *termcap*

You'll find them pretty quickly, no?

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951

MySQL 3.23.29: up 117 days, processed 721,570,412 queries (71/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: problem of MySQL Installation

2001-04-29 Thread 李茂華


which RPM should  installed ?

- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "§õZµØ" <[EMAIL PROTECTED]>
Cc: "MySQL°ÝÃD" <[EMAIL PROTECTED]>
Sent: Monday, April 30, 2001 1:12 PM
Subject: Re: problem of MySQL Installation


> On Mon, Apr 30, 2001 at 12:53:39PM +0800, §õZµØ wrote:
> > Dear Sir,
> >
> > I tried MySQL installation in RedHat 7.0 and get finally version
> > mysql-3.23.37.When I was installing with 1st step run "./configure
> > --prefix=/usr/local/mysql --with-charset=big5" and got flowing
> > message and can not continue .
> >
> > error message
> > "checking for termcap functions  library... configure: error:  No
curses/termcap library found
>
> You need to install the curses library on your RedHat system. Surely
> it comes with the necessary RPM file. It just wasn't installed.
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951
>
> MySQL 3.23.29: up 116 days, processed 721,509,613 queries (71/sec. avg)


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Newbie win 2000 install question

2001-04-29 Thread Brent and Maria


Hello,
 I just ran into some problems with the mysql setup on win2000.  I 
start mysql as a service.  If you go into your control 
panel->administrative tools->services, you can start mysql.

One more thing (if you didn't see it a couple days ago when I posted it):
If you have problems inserting/deleting when you start mysql as a service, 
here is the fix that I use.

In the administrative tools->services control panel.  Select the mysql 
service, right click, and select properties.  Select the "Log On" 
tab.  Select Log on as: This account (and select the account you are logged 
in as using the browse button).

Hope this helps,
 Brent

At 08:09 PM 4/29/2001 , you wrote:
>Did you install mysql as a service? If you did, the MySQL Monitor should
>come up when you open a Command prompt and type: mysql {enter}
>
>- Original Message -
>From: "Rhasaun Campbell" <[EMAIL PROTECTED]>
>To: "mysql list" <[EMAIL PROTECTED]>
>Sent: Sunday, April 29, 2001 8:47 PM
>Subject: Newbie win 2000 install question
>
>
> > Ok so here's the deal, I'm trying to check if mysql is working on my
>machine
> > so I open up the dos command prompt, type cd c:\mysql\bin and everything's
> > fine
> >
> > then it try to create a test database by  typing mysqladmin create testDB,
> > it try's to connect but it gives me an error message
> >
> >  "Can't connect to mySQL server on 'localhost' <10061>'
> > then it says check that mysqld is running on localhost and that the port
>is
> > 3306
> >
> > I tried to telnet to 3306 and of course iut's not running, so here's my
> > question How do I get the mySQL server to start running on my machine.
> > ohh btw I'm on a w2k workstation. I know it's something that's probably
> > simple, which I'm overlooking, but I could use some help figuring it out.
> > The install went fine, I just need some help with starting mysql...please
> >
> > tia
> >
> > Rhasaun Campbell
> > Web Consultant
> > Urban Graphics
> > 110 Camden St.
> > Roselle Pk, NJ 07204
> > c. 908.531.9418
> > t.908.245.1161
> > [EMAIL PROTECTED]
> > www.urbangraphics.tv
> >
> >
> >
>
>
>
>
>
>
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: problem of MySQL Installation

2001-04-29 Thread Jeremy Zawodny


On Mon, Apr 30, 2001 at 12:53:39PM +0800, §õZµØ wrote:
> Dear Sir,
>
> I tried MySQL installation in RedHat 7.0 and get finally version
> mysql-3.23.37.When I was installing with 1st step run "./configure
> --prefix=/usr/local/mysql --with-charset=big5" and got flowing
> message and can not continue .
> 
> error message
> "checking for termcap functions  library... configure: error:  No curses/termcap 
>library found

You need to install the curses library on your RedHat system. Surely
it comes with the necessary RPM file. It just wasn't installed.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951

MySQL 3.23.29: up 116 days, processed 721,509,613 queries (71/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Errcode: 13 with mysqlimport

2001-04-29 Thread Bombardier Systems Consulting


I am running RedHat linux 7.1 and MySQL 3.23.37.  I am trying to use
mysqlimport and am getting an error message "mysqlimport: Error: Can't get
STAT of  /path/to/file/file (Errorcode: 13) , when using table: table_name".

I looked the error up in the on-line documentation and changed the UMASK and
restarted MySQL and am still getting the error.  I created a new directory
and moved the file in there and still the same.

Suggestions?

Thanks for the help

Jim


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

problem of MySQL Installation

2001-04-29 Thread 李茂華


Dear Sir,
I tried MySQL installation in RedHat 7.0 and get finally version 
mysql-3.23.37.When I was installing 
with 1st step run "./configure  --prefix=/usr/local/mysql --with-charset=big5"
and got flowing message and can not continue .

error message
"checking for termcap functions  library... configure: error:  No curses/termcap 
library found

 Pls tell me about this soluation , Thanks!
  §õZµØ ( Ken Lee) ±Ò}°ê»Ú¸ê°TªÑ¥÷¦³¤½¥q 
  Oracle Instructor ¥x¥_¥«106´°¤Æ«n¸ô¤@¬q331¸¹3¼Ó 
  ¡@ TEL¡G02-2755-0560 Ext 360 (¥´¤F¨S?)
 
  FAX¡G02-2703-9039

Can't install MySQL

2001-04-29 Thread Chris Beach


Hi,

I am trying to install MySQL 3.23.37 from the RPM distribution..  At the point where 
the rpm installs the default tables it hangs:

[root@teaparty src]# rpm -i MySQL-3.23.37-1.i386.rpm
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
**HANGS indefinately**

The process list shows:

 3678 pts/0T  0:00 sh /usr/bin/mysql_install_db -IN-RPM
 3683 pts/0S  0:00 /usr/sbin/mysqld --bootstrap --skip-grant-tables --ba
 3684 pts/0S  0:00 /usr/sbin/mysqld --bootstrap --skip-grant-tables --ba
 3685 pts/0S  0:00 /usr/sbin/mysqld --bootstrap --skip-grant-tables --ba

top shows the processes idle, and there is plenty of RAM free..

I'm running RedHat 6.0

Any help would be appreciated..

Thanks,

Chris.

Re: Newbie win 2000 install question

2001-04-29 Thread Gerald R. Jensen


Did you install mysql as a service? If you did, the MySQL Monitor should
come up when you open a Command prompt and type: mysql {enter}

- Original Message -
From: "Rhasaun Campbell" <[EMAIL PROTECTED]>
To: "mysql list" <[EMAIL PROTECTED]>
Sent: Sunday, April 29, 2001 8:47 PM
Subject: Newbie win 2000 install question


> Ok so here's the deal, I'm trying to check if mysql is working on my
machine
> so I open up the dos command prompt, type cd c:\mysql\bin and everything's
> fine
>
> then it try to create a test database by  typing mysqladmin create testDB,
> it try's to connect but it gives me an error message
>
>  "Can't connect to mySQL server on 'localhost' <10061>'
> then it says check that mysqld is running on localhost and that the port
is
> 3306
>
> I tried to telnet to 3306 and of course iut's not running, so here's my
> question How do I get the mySQL server to start running on my machine.
> ohh btw I'm on a w2k workstation. I know it's something that's probably
> simple, which I'm overlooking, but I could use some help figuring it out.
> The install went fine, I just need some help with starting mysql...please
>
> tia
>
> Rhasaun Campbell
> Web Consultant
> Urban Graphics
> 110 Camden St.
> Roselle Pk, NJ 07204
> c. 908.531.9418
> t.908.245.1161
> [EMAIL PROTECTED]
> www.urbangraphics.tv
>
>
>






> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: reports

2001-04-29 Thread Gary Huntress


MySQL does not have a built in report generator.   I use the commercial
product Crystal Reports as my report generator.   It is quite powerful,
buggy in early versions, but they seem to be getting better.  Try here
http://www.crystaldecisions.com/products/crystalreports/

Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org

- Original Message -
From: "maritza sepulveda" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 29, 2001 10:52 PM
Subject: reports


hello there,

I am currently using MS Access to develop reports and I am looking for  a
new avenue to develop these reports.  I have been looking into MySql and so
far I am very interested.  my question is what are the limitation of MySql
in comparison to MS Access and how does one develop reports in MySql?  Does
mySql have a report generator?

Thank you,



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

reports

2001-04-29 Thread maritza sepulveda


hello there,

I am currently using MS Access to develop reports and I am looking for  a new avenue 
to develop these reports.  I have been looking into MySql and so far I am very 
interested.  my question is what are the limitation of MySql in comparison to MS 
Access and how does one develop reports in MySql?  Does mySql have a report generator?

Thank you,

Re: Replication question -

2001-04-29 Thread Jeremy Zawodny

On Mon, Apr 30, 2001 at 02:24:53PM +1200, Desmond Armstrong wrote:
> Hi everyone,
> 
> I was wondering if anyone could help me/or has come across the following
> problem:

It appears to have nothing to do with MySQL, so you might try asking
in a more on-topic forum.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951

MySQL 3.23.29: up 116 days, processed 721,262,890 queries (71/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Replication question -

2001-04-29 Thread Desmond Armstrong


Hi everyone,

I was wondering if anyone could help me/or has come across the following
problem:

It's to do with replication - Scenario:

We have a publisher/subscriber as the same server. Using MERGE replication
with 2 subscribers. The publisher database is our co-operate database with
many records being deleted/inserted/updated.

The subscriber database is very rarely changed. When doing a merge I get the
following error messages in the conflict viewer.
[Type of errors below]
The row was inserted at 'PNT_DB1.mwrcdb' but could not be inserted at
'nec_4.mwrcdb'. INSERT statement conflicted with TABLE FOREIGN KEY
constraint 'trs_emp_activity_fk1'. The conflict occurred in database
'mwrcdb', table 'trs_tsheet_header'.
This row no longer exists in '[dbo].[trs_emp_activity]'.

The row was inserted at 'PNT_DB1.mwrcdb' but could not be inserted at
'nec_4.mwrcdb'. INSERT statement conflicted with COLUMN FOREIGN KEY
constraint 'trs_emp_activity_detail_fk1'. The conflict occurred in database
'mwrcdb', table 'trs_emp_activity', column 'emp_activity_id'.
This row no longer exists in '[dbo].[trs_emp_activity_detail]'.

For some strange reason - the conflicting records were deleted from PNT_DB1
which was the central database. Non of the these records would have been
changed in the subscribers. Changes to these tables would only have come
from the Publisher database.

We are running SQL Server 7.0 SP3, on NT 4.0 SP5 - subscribers are running
SQL Server Desktop SP3, Win 2000 prof SP1

Any help would much be appreciated.

Thanks Des


--
This email is not an official statement of horizons.mw unless otherwise stated.
If you are not the intended recipient, please delete this email and inform the sender

Phone 0508-4HORIZONS (0508-4467496) 
Fax 06-9522929
Email [EMAIL PROTECTED]

For information about horizons.mw visit http://www.horizons.govt.nz
--

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: question

2001-04-29 Thread Jeremy Zawodny

On Sun, Apr 29, 2001 at 09:47:49PM -0400, [EMAIL PROTECTED] wrote:
>
> how do you uninstall mySQL (v3.23.37) from a linux system?

If using an RPM, do it the way you normally would with any RPM.

If using the source install, follow the instructions that is comes
with. See the INSTALL-SOURCE file.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951

MySQL 3.23.29: up 116 days, processed 721,201,086 queries (71/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Newbie win 2000 install question

2001-04-29 Thread Rhasaun Campbell


Ok so here's the deal, I'm trying to check if mysql is working on my machine
so I open up the dos command prompt, type cd c:\mysql\bin and everything's
fine

then it try to create a test database by  typing mysqladmin create testDB,
it try's to connect but it gives me an error message

 "Can't connect to mySQL server on 'localhost' <10061>'
then it says check that mysqld is running on localhost and that the port is
3306

I tried to telnet to 3306 and of course iut's not running, so here's my
question How do I get the mySQL server to start running on my machine.
ohh btw I'm on a w2k workstation. I know it's something that's probably
simple, which I'm overlooking, but I could use some help figuring it out.
The install went fine, I just need some help with starting mysql...please

tia

Rhasaun Campbell
Web Consultant
Urban Graphics
110 Camden St.
Roselle Pk, NJ 07204
c. 908.531.9418
t.908.245.1161
[EMAIL PROTECTED]
www.urbangraphics.tv




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

question

2001-04-29 Thread Sardaukars


how do you uninstall mySQL (v3.23.37) from a linux system?

thanks,

Justin Stern

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MERGE Tables

2001-04-29 Thread Matthew Shaw


Hi,

I have already posted this message but I got no reply I am really stuck
on this topic - if anybody knows anything help would be greatly
appreciated.

I have only just joined this list today any help would be greatly
appreciated.
I have implemented the new MERGE table feature as part of my new install
on version 3.23.
I am finding a few small problems with usage of this functionality as
follows.

There are 4 identical tables namely asic_cache1, asic_cache2,
asic_cache3, asic_cache4. Each table is structured identically as
follows:

 field_index int(11)PRI  DEFAULT 0
 subject   varchar(16)PRI
 search_type varchar(8) PRI
 segmentchar(3)
 grp_code   int(11) DEFAULT  0
 field_nr   int(11)  DEFAULT 0
 value  text  DEFAULT NULL
 segment_header int(1)   DEFAULT 0
 record_nr  int(11) DEFAULT 0

There is one index on each table and that is the primary key (subject,
search_type, field_index).
Each table contains approximately 20 000 000 rows. Hence my reason for
using merge :)
The merge table created is called asic_cache. It has exactly the same
structure as above except there are no keys what so ever. My
understanding is that there is no need for keys on the merge
table as the table handler uses the keys on each individual table when
doing the lookups. The keys on each table are of type ref.

Here's the interesting part:
I performed the following query and got a result in 0.2 secs approx.
Qry = select * from asic_cache where subject = '10920411' and
search_type = 'CE C' limit 10.

When I run the following query without the limit clause mysql appears to
go into a tail spin and the process runs on my linux machine for over 5
minutes!
Qry = select * from asic_cache where subject = '10920411' and
search_type = 'CE C'.
I am guessing that it is doing a full table scan on each of the four
table but I'm not sure and if so why?

Thirdly, the following query has the same effect as above and blows the
time of the query over 5 mintues.
Qry = select * from asic_cache where subject = '10920411' and
search_type = 'CE C'
order by subject, search_type, field_index.

Looking at the mysql doco on merge tables on one hand it says there is
no need for indexes on the merge table itself but in the example in the
doco it uses a key? This has got me really confused and I'm not sure if
this is contributing to the above issues. Has anyone got any ideas on
the
matter??

Thanks in advance,

Matthew.

--
Matthew Shaw
IT Specialist / Project Leader
Australian Business Research (ABR)
Ph. (07) 3837 1391
Mob. 0402 894 797
Email. [EMAIL PROTECTED]

RE: Ordinary users can crash mysql server

2001-04-29 Thread Chris DiBona


These points are all well considered, but the point is that I operate
under the assumption that the bad guys out there already have this
information, and that only legit people don't have it becuse they do not
operate in those circles. And yes, if you are  operating a service on the
internet, you should be expected to act  immediately on such news. There
are too many out there ready to exploit holes in systems to the detriment
of the entire internet.

In essence as a sytem administrator you have to be ready to either a) act
immediately or b) take your chances during the time you don't act. I see
ful ldisclosure as a big heads up and I think it is more valuable than the
downside of letting more bad people know of the problem, as, I noted, I
see the black hats as already having the knowledge.

I know it is an imprefect world, and , legitimately, the way most routers
are set up, monday will be just fine for locking down the bug, bug I'm
glad I know...

But your points are well taken, I am just more pessimistic about the state
of knowledge in the cracker community.

 Chris

> Hi Chris,
>
> You should not forget those users who depend greatly on the tech support
> (patches) of the manufacturer. Given your expertise and knowledge you might
> be able to protect yourself, but not everybody is (as a matter of fact even
> Gustavo said he isn't). In addition, to make things worse, today is Sunday,
> and given the usual working hours in most countries, there's a very small
> chance that someone from AB Konsulting has read this. On the other hand,
> quite a number of hobby vandals, who spend their free days looking for
> holes, might have found a nice new toy to play with, and Gustavo even
> provided the "how-to" .
>
> I agree with you on the first point: If this is a known bug, it has to be
> part of the "known-bug-list" and given it's severity, be stated clearly on
> the MySQL web site. Crashed server applications often bear the risk of
> allowing a hacker to execute his own code, thus making such a bug really
> dangerous, especially for web applications.
>
> Your third point is a bit optimistic... Are you really prepared to react
> immediately to all known or unknown security risks? If you have 10.000 users
> using your application on a daily basis, or if you have 100 sites running
> with it, every modification of a core component of your databases requires
> good planning and careful handling. On a production server you usually don't
> have the freedom to experiment a lot with your home-made patches.
>
> Don't get me wrong, I am not at all opposed to disclosure. This is what
> makes programs like MySQL, Linux etc. so powerful and more secure than
> closed-source software. Remember the problems with Interbase, or Hotmail
> (even better!) or the countless problems on Microsoft programs. It's
> indispensable to search for bugs, but again, give the manufacturer at least
> a chance to look into a matter before giving hackers a doorway to crash your
> machine and worse steal or destroy your data.
>
> Markus Gieppner
> MGF International Inc.
>
>
>
>
>
>
>
>
> -Original Message-
> From: Chris DiBona [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 29, 2001 6:08 PM
> To: Markus Gieppner
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Ordinary users can crash mysql server
>
>
> I disagree with you markus, and here is why..
>
> 1gustavo probably isn't the only person who has noticed this, so it's
> fair to say it's already made the round amongst those who arent so nice.
>
> 2this _is_ the mysql list.
>
> 3this way, people can plan for such a problem and button things up
> until a fix is forthcoming.
>
> 4whether he went to the manufacturer or not, I personally am happy
> that he posted it, it made me batte ndown a hatch or two.
>
>  Chris
>
> --
> Marketing Manager, OSDN Events  |   http://www.osdn.com
> Grant Chair, Linux International. |   http://www.li.org
> Co-editor, Open Sources |   http://www.dibona.com
>
> On Sun, 29 Apr 2001, Markus Gieppner wrote:
>
> > Bom dia, Gustavo,
> >
> > I am not in a position to comment nor to verify your warning. However, I
> am
> > pretty annoyed by the way you make it public to the world. Unless I missed
> > something here, but when someone discovers a security hole in any program,
> > it's common standard to contact the manufacturer immediately, directly and
> > offlist and give him a chance to comment and/or release a patch within a
> > reasonable timeframe. If then, after a couple of weeks, you didn't get any
> > response from the manfacturer, you should go public. I don't know if you
> did
> > that, if you did I apologize and ask to ignore this message.
> >
> > Just imagine what doors you might open to hackers and vandals who always
> > monitor these lists. (Where else could they get inspiration and necessary
> > info for their sick minds???)! A major security bug could threaten
> thousands

Re: can't write to pid file?

2001-04-29 Thread Marc Bragg




Marc Bragg wrote:

> Running mysql 3.23.22-beta on Redhat 7.0 w/apache and php4, and getting
> the following error message:
>
> /usr/libexec/mysqld: Can't create/write to file /var/run/mysql.pid
> (Errcode: 13)
>
> Tried to upgrade mysql to no avail, anyway, can  connect locally on the
> server terminal, but when try to connect over the net, get:
>
> Warning: MySQL Connection Failed: Can't connect to local MySQL server
> through socket '/var/lib/mysql/mysql.sock' (111)
> in lib.inc.php3 on line 255
> Error
>
> Help?
>
> Thanx
>
> Marc
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: New filter

2001-04-29 Thread rpruitt

I know Sasha has been involved with the email police for awhile. I gotta
tell ya, my opinion is negative. Sure, I understand the dynamics. 
Unwanted emails are intrusive. They waste bandwidth. They squander
resources. Those type arguments, however, do not justify the intrusion 
the security squad impose on the innocents, in the name of protection 
and security. Freedom comes with a price tag, and one I would prefer to
pay, as opposed to living in a controlled atmosphere, where freedoms
dissipate in the name of security. Freedom is more valuable than
security. Now, sure, there must be some security in life. But, there
must also be a reasonable balance. And every security measure can be
defeated, which eventually leads to tighter, stricter security. And did
you ever notice, we never get asked we get told?

This is email. It's not a bomb on a plane. Choices exist for a digest,
or a newsgroup. Freedom has a price. I am more than willing to pay it.

Just my opinion.

Thanks,
Robert
MySQL,sql,database,query

Jeremy Zawodny wrote:

> On Sat, Apr 07, 2001 at 10:42:09AM -0600, Sasha Pachev wrote:
>
> > I have now installed the new spam filter on this list. It is very
> > simple - instead of having bad words, we now have good words. You
> > must mention one of the following: sql, database, query in the body
> > of your message to get past the filter. Substrings are ok, and check
> > is case-insensitive so if you say MySQL, it will work.
>
> Having had a few of my posts bounced, I have two questions:
>
>   (1) Does it count properly separated signatures "-- \n" as part of
>   the body?
>
>   (2) Can it be taught to grok a header? Maybe "X-MySQL-On-Topic: yes"
>   or something?
>
> I've already solved my problem if the answer to #1 is yes, but #2
> seems like a nice clean and unobtrusive approach.
>
> Thanks,
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951
>
> MySQL 3.23.29: up 115 days, processed 716,992,956 queries (71/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Ordinary users can crash mysql server

2001-04-29 Thread Markus Gieppner

Hi Chris,

You should not forget those users who depend greatly on the tech support
(patches) of the manufacturer. Given your expertise and knowledge you might
be able to protect yourself, but not everybody is (as a matter of fact even
Gustavo said he isn't). In addition, to make things worse, today is Sunday,
and given the usual working hours in most countries, there's a very small
chance that someone from AB Konsulting has read this. On the other hand,
quite a number of hobby vandals, who spend their free days looking for
holes, might have found a nice new toy to play with, and Gustavo even
provided the "how-to" .

I agree with you on the first point: If this is a known bug, it has to be
part of the "known-bug-list" and given it's severity, be stated clearly on
the MySQL web site. Crashed server applications often bear the risk of
allowing a hacker to execute his own code, thus making such a bug really
dangerous, especially for web applications.

Your third point is a bit optimistic... Are you really prepared to react
immediately to all known or unknown security risks? If you have 10.000 users
using your application on a daily basis, or if you have 100 sites running
with it, every modification of a core component of your databases requires
good planning and careful handling. On a production server you usually don't
have the freedom to experiment a lot with your home-made patches.

Don't get me wrong, I am not at all opposed to disclosure. This is what
makes programs like MySQL, Linux etc. so powerful and more secure than
closed-source software. Remember the problems with Interbase, or Hotmail
(even better!) or the countless problems on Microsoft programs. It's
indispensable to search for bugs, but again, give the manufacturer at least
a chance to look into a matter before giving hackers a doorway to crash your
machine and worse steal or destroy your data.

Markus Gieppner
MGF International Inc.

-Original Message-
From: Chris DiBona [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 29, 2001 6:08 PM
To: Markus Gieppner
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Ordinary users can crash mysql server

I disagree with you markus, and here is why..

1gustavo probably isn't the only person who has noticed this, so it's
fair to say it's already made the round amongst those who arent so nice.

2this _is_ the mysql list.

3this way, people can plan for such a problem and button things up
until a fix is forthcoming.

4whether he went to the manufacturer or not, I personally am happy
that he posted it, it made me batte ndown a hatch or two.

 Chris

--
Marketing Manager, OSDN Events|   http://www.osdn.com
Grant Chair, Linux International. |   http://www.li.org
Co-editor, Open Sources   |   http://www.dibona.com

On Sun, 29 Apr 2001, Markus Gieppner wrote:

> Bom dia, Gustavo,
>
> I am not in a position to comment nor to verify your warning. However, I
am
> pretty annoyed by the way you make it public to the world. Unless I missed
> something here, but when someone discovers a security hole in any program,
> it's common standard to contact the manufacturer immediately, directly and
> offlist and give him a chance to comment and/or release a patch within a
> reasonable timeframe. If then, after a couple of weeks, you didn't get any
> response from the manfacturer, you should go public. I don't know if you
did
> that, if you did I apologize and ask to ignore this message.
>
> Just imagine what doors you might open to hackers and vandals who always
> monitor these lists. (Where else could they get inspiration and necessary
> info for their sick minds???)! A major security bug could threaten
thousands
> of sites all over the world. Responsible and fair handling is a must.
>
> Obrigado.
>
> Markus Gieppner
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 29, 2001 11:13 AM
> To: [EMAIL PROTECTED]
> Subject: Ordinary users can crash mysql server
>
>
> >Description:
>   When a ordinary users tries to analyze bin log using a remote host (-h
> ip_address) mysql server daemons crahes.
> >How-To-Repeat:
>   Just use mysqlbinlog to analyze a remote host binlog.
>   mysql -h ip_address -u user -p pass file
>
>   For instance (My environment):
>   shell> mysql -h 192.168.1.11 -u awp -p root etosha-bin.001
>
> >Fix:
>   I lack the required level of expertise to fix it, sorry!
>
> >Submitter-Id:
> >Originator:  Gustavo Rios
> >Organization:Ifour Sistemas
>
> >MySQL support: [none]
> >Synopsis:
> >Severity:[ critical ]
> >Priority:[ high ]
> >Category:mysql
> >Class:
> >Release: mysql-3.23.37 (Source distribution)
> >Server: /usr/local/bin/mysqladmin  Ver 8.19 Distrib 3.23.37, for
> unknown-freebsdelf4.3 on i386
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY.

Max connections on Freebsd

2001-04-29 Thread Patric de Waha Lists


Hi,
Is there someone who incremented the max_connection
value to something above 100 (200) (300) on Freebsd 4.2?

I had problems with mysql on freebsd 4.0, hooked up
after some days without any good reason :). 
Some people told me thread libraries on freebsd 4.0
suck a bit. So I wonder if 4.2's thread libraries 
are stable enough to handle 200 concurrent threads?!.

Thanks in advance

Regards,
Patric de Waha


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Ordinary users can crash mysql server

2001-04-29 Thread Chris DiBona


I disagree with you markus, and here is why..

1gustavo probably isn't the only person who has noticed this, so it's
fair to say it's already made the round amongst those who arent so nice.

2this _is_ the mysql list.

3this way, people can plan for such a problem and button things up
until a fix is forthcoming.

4whether he went to the manufacturer or not, I personally am happy
that he posted it, it made me batte ndown a hatch or two.

 Chris

--
Marketing Manager, OSDN Events|   http://www.osdn.com
Grant Chair, Linux International. |   http://www.li.org
Co-editor, Open Sources   |   http://www.dibona.com

On Sun, 29 Apr 2001, Markus Gieppner wrote:

> Bom dia, Gustavo,
>
> I am not in a position to comment nor to verify your warning. However, I am
> pretty annoyed by the way you make it public to the world. Unless I missed
> something here, but when someone discovers a security hole in any program,
> it's common standard to contact the manufacturer immediately, directly and
> offlist and give him a chance to comment and/or release a patch within a
> reasonable timeframe. If then, after a couple of weeks, you didn't get any
> response from the manfacturer, you should go public. I don't know if you did
> that, if you did I apologize and ask to ignore this message.
>
> Just imagine what doors you might open to hackers and vandals who always
> monitor these lists. (Where else could they get inspiration and necessary
> info for their sick minds???)! A major security bug could threaten thousands
> of sites all over the world. Responsible and fair handling is a must.
>
> Obrigado.
>
> Markus Gieppner
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 29, 2001 11:13 AM
> To: [EMAIL PROTECTED]
> Subject: Ordinary users can crash mysql server
>
>
> >Description:
>   When a ordinary users tries to analyze bin log using a remote host (-h
> ip_address) mysql server daemons crahes.
> >How-To-Repeat:
>   Just use mysqlbinlog to analyze a remote host binlog.
>   mysql -h ip_address -u user -p pass file
>
>   For instance (My environment):
>   shell> mysql -h 192.168.1.11 -u awp -p root etosha-bin.001
>
> >Fix:
>   I lack the required level of expertise to fix it, sorry!
>
> >Submitter-Id:
> >Originator:  Gustavo Rios
> >Organization:Ifour Sistemas
>
> >MySQL support: [none]
> >Synopsis:
> >Severity:[ critical ]
> >Priority:[ high ]
> >Category:mysql
> >Class:
> >Release: mysql-3.23.37 (Source distribution)
> >Server: /usr/local/bin/mysqladmin  Ver 8.19 Distrib 3.23.37, for
> unknown-freebsdelf4.3 on i386
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
>
> Server version3.23.37-log
> Protocol version  10
> ConnectionLocalhost via UNIX socket
> UNIX socket   /tmp/mysql.sock
> Uptime:   1 hour 49 min 17 sec
>
> Threads: 1  Questions: 10  Slow queries: 0  Opens: 10  Flush tables: 1  Open
> tables: 4 Queries per second avg: 0.002
> >Environment:
>
> System: FreeBSD etosha.ifour.com.br 4.3-STABLE FreeBSD 4.3-STABLE #0: Fri
> Apr 27 13:46:06 GMT 2001
> [EMAIL PROTECTED]:/usr/obj/usr/src/sys/ETOSHA  i386
>
>
> Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc
> /usr/bin/cc
> GCC: Using builtin specs.
> gcc version 2.95.3 [FreeBSD] 20010315 (release)
> Compilation info: CC='gcc'  CFLAGS=''  CXX='gcc'
> CXXFLAGS='-felide-constructors -fno-exceptions -fno-rtti'  LDFLAGS=''
> LIBC:
> -r--r--r--  1 root  wheel  1174494 Apr 27 13:26 /usr/lib/libc.a
> lrwxr-xr-x  1 root  wheel  9 Apr 27 13:26 /usr/lib/libc.so -> libc.so.4
> -r--r--r--  1 root  wheel  561548 Apr 27 13:26 /usr/lib/libc.so.4
> Configure command:
> ./configure  --without-perl --without-debug --with-mit-threads=no --with-lib
> wrap --with-charset=latin1 --with-extra-charsets=none --enable-assembler --w
> ith-berkeley-db --with-innodb --localstatedir=/var/db/mysql
> Perl: This is perl, version 5.005_03 built for i386-freebsd
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Tr

Re: Ordinary users can crash mysql server

2001-04-29 Thread Jeremy Zawodny

On Sun, Apr 29, 2001 at 03:12:51PM +, [EMAIL PROTECTED] wrote:
> >Description:
>   When a ordinary users tries to analyze bin log using a remote host (-h 
>ip_address) mysql server daemons crahes.
> >How-To-Repeat:
>   Just use mysqlbinlog to analyze a remote host binlog.
>   mysql -h ip_address -u user -p pass file
> 
>   For instance (My environment):
>   shell> mysql -h 192.168.1.11 -u awp -p root etosha-bin.001

Do you store your binary logs in the datadir (the same directory which
contains your database sub-directories)?

If so, relocating the binary log files is probably the most
straightforward solution until the MySQL team can verify and fix the
problem.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951

MySQL 3.23.29: up 116 days, processed 720,915,358 queries (71/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Ordinary users can crash mysql server

2001-04-29 Thread Markus Gieppner


Bom dia, Gustavo,

I am not in a position to comment nor to verify your warning. However, I am
pretty annoyed by the way you make it public to the world. Unless I missed
something here, but when someone discovers a security hole in any program,
it's common standard to contact the manufacturer immediately, directly and
offlist and give him a chance to comment and/or release a patch within a
reasonable timeframe. If then, after a couple of weeks, you didn't get any
response from the manfacturer, you should go public. I don't know if you did
that, if you did I apologize and ask to ignore this message.

Just imagine what doors you might open to hackers and vandals who always
monitor these lists. (Where else could they get inspiration and necessary
info for their sick minds???)! A major security bug could threaten thousands
of sites all over the world. Responsible and fair handling is a must.

Obrigado.

Markus Gieppner



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 29, 2001 11:13 AM
To: [EMAIL PROTECTED]
Subject: Ordinary users can crash mysql server


>Description:
When a ordinary users tries to analyze bin log using a remote host (-h
ip_address) mysql server daemons crahes.
>How-To-Repeat:
Just use mysqlbinlog to analyze a remote host binlog.
mysql -h ip_address -u user -p pass file

For instance (My environment):
shell> mysql -h 192.168.1.11 -u awp -p root etosha-bin.001

>Fix:
I lack the required level of expertise to fix it, sorry!

>Submitter-Id:  
>Originator:Gustavo Rios
>Organization:  Ifour Sistemas

>MySQL support: [none]
>Synopsis:
>Severity:  [ critical ]
>Priority:  [ high ]
>Category:  mysql
>Class:
>Release:   mysql-3.23.37 (Source distribution)
>Server: /usr/local/bin/mysqladmin  Ver 8.19 Distrib 3.23.37, for
unknown-freebsdelf4.3 on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  3.23.37-log
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 hour 49 min 17 sec

Threads: 1  Questions: 10  Slow queries: 0  Opens: 10  Flush tables: 1  Open
tables: 4 Queries per second avg: 0.002
>Environment:

System: FreeBSD etosha.ifour.com.br 4.3-STABLE FreeBSD 4.3-STABLE #0: Fri
Apr 27 13:46:06 GMT 2001
[EMAIL PROTECTED]:/usr/obj/usr/src/sys/ETOSHA  i386


Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.3 [FreeBSD] 20010315 (release)
Compilation info: CC='gcc'  CFLAGS=''  CXX='gcc'
CXXFLAGS='-felide-constructors -fno-exceptions -fno-rtti'  LDFLAGS=''
LIBC:
-r--r--r--  1 root  wheel  1174494 Apr 27 13:26 /usr/lib/libc.a
lrwxr-xr-x  1 root  wheel  9 Apr 27 13:26 /usr/lib/libc.so -> libc.so.4
-r--r--r--  1 root  wheel  561548 Apr 27 13:26 /usr/lib/libc.so.4
Configure command:
./configure  --without-perl --without-debug --with-mit-threads=no --with-lib
wrap --with-charset=latin1 --with-extra-charsets=none --enable-assembler --w
ith-berkeley-db --with-innodb --localstatedir=/var/db/mysql
Perl: This is perl, version 5.005_03 built for i386-freebsd

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Unix_TimeStamp()

2001-04-29 Thread Jeremy Zawodny


On Sun, Apr 29, 2001 at 05:30:58PM +0200, Noor Dawod wrote:
> 
> Does the function Unix_TimeStamp() work in MySQL under Windows NT?
> It doesn't seem to work here in simple queries, such as this query:
> Select Unix_TimeStamp();

What about

  SELECT UNIX_TIMESTAMP(NOW())

?
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951

MySQL 3.23.29: up 116 days, processed 720,891,755 queries (71/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

configure fails: checking size of char... 0

2001-04-29 Thread aotto


>Description:

>How-To-Repeat:

>Fix:


>Submitter-Id:  
>Originator:
>MySQL support: none
>Synopsis:  configure fails: checking size of char... 0
>Severity:  non-critical
>Priority:  low
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.37 (Source distribution)

>Environment:
System: SunOS flame 5.7 Generic sun4m sparc sun4m
Architecture: sun4

Some paths:  /usr/bin/perl /usr/ccs/bin/make /usr/local/bin/gmake /usr/local/bin/gcc 
/usr/ucb/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc'  CFLAGS=''  CXX='gcc'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
-rw-r--r--   1 bin  bin  1664040 Sep  1  1998 /lib/libc.a
lrwxrwxrwx   1 root root  11 Mar  4  2000 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x   1 bin  bin  1090280 Sep  1  1998 /lib/libc.so.1
-rw-r--r--   1 bin  bin  1664040 Sep  1  1998 /usr/lib/libc.a
lrwxrwxrwx   1 root root  11 Mar  4  2000 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x   1 bin  bin  1090280 Sep  1  1998 /usr/lib/libc.so.1
Configure command: ./configure  --with-unix-socket-path=/var/tmp/mysql.sock 
--with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client 
--with-berkeley-db --with-innodb
Perl: This is perl, version 5.004_04 built for sun4-solaris

This is the last bit of the config.log file:

configure:6424: gcc -c -O3 -DDBUG_OFF   -DHAVE_CURSES_H -I/tmp/mysql-3.23.37/include 
-DHAVE_RWLOCK_T  conftest.c 1>&5
configure:6445: checking whether time.h and sys/time.h may both be included
configure:6459: gcc -c -O3 -DDBUG_OFF   -DHAVE_CURSES_H -I/tmp/mysql-3.23.37/include 
-DHAVE_RWLOCK_T  conftest.c 1>&5
configure:6480: checking whether struct tm is in sys/time.h or time.h
configure:6493: gcc -c -O3 -DDBUG_OFF   -DHAVE_CURSES_H -I/tmp/mysql-3.23.37/include 
-DHAVE_RWLOCK_T  conftest.c 1>&5
configure:6516: checking size of char
configure:6535: gcc -o conftest -O3 -DDBUG_OFF   -DHAVE_CURSES_H 
-I/tmp/mysql-3.23.37/include -DHAVE_RWLOCK_T   conftest.c -lz -lcrypt -lgen -lsocket 
-lnsl -lm  -lpthread -lthread 1>&5
configure: failed program was:
#line 6524 "configure"
#include "confdefs.h"
#include 
main()
{
  FILE *f=fopen("conftestval", "w");
  if (!f) exit(1);
  fprintf(f, "%d\n", sizeof(char));
  exit(0);
}


if you compile this little progrem by hand, it creates a file named conftestval with 
the number 1 in it.

Reply to: [EMAIL PROTECTED]

Thanks

Adrian Otto

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

error reading communication packets

2001-04-29 Thread Patric de Waha Lists


Hi,
I've site with heavy traffic, freebsd 4.2
php 4.0pl1,  mysql 3.23.36.. ALL persistent connections.

I've nearly every second this error in the logfile:

10429 22:31:00  Aborted connection 2361 to db: 'alexv2' user: 'av2' host:
`localhost' (Got an error reading communication packets)

Is this a problem with php and mysql?
or is it simply the user which hits ESC while loading page?

I need to say that I compiled php 4.0pl1 with the library/includes
of mysql 3.23.35.


Thanks in advance

Regards,
Patric de Waha



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: File Not Found Error

2001-04-29 Thread oltra jean-michel


On Wed, 25 Apr 2001, newsgroups wrote:

> Date: Wed, 25 Apr 2001 20:15:07 -0400
> From: newsgroups <[EMAIL PROTECTED]>
> To: MySQL-Group <[EMAIL PROTECTED]>
> Subject: File Not Found Error
> 
> Sorry to be such an everything newbie.  Perhaps this a unix error and not
> MySQL but a simple Describe statement reports that a *.frm file is missing,
> yet that file exists in the same folder.  What could be wrong?  Sorry about
> the long LS.  TIA,  John ...
> 
> # mysql -p mysql
> 
> Didn't find any fields in table 'adminedit'
> Didn't find any fields in table 'levelone'
> Didn't find any fields in table 'members'
> 
> mysql> show tables;
> +-+
> | Tables_in_mysql |
> +-+
> | adminedit   |
> | columns_priv|
> | db  |
> | func|
> | host|
> | levelone|
> | members |
> | tables_priv |
> | user|
> +-+
> 9 rows in set (0.00 sec)
> 
Bonjour,
It sometimes happens to me with mysql 3.22.32 (rpm) on mandrake 7.1.
Somes files become uid/gid root/root instead of mysql/mysql. So I need to
change file permissions.
May be someone get an answer?
I apologize for my poor english...

-- 
jean-michel


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mod_auth_mysql & password trading

2001-04-29 Thread Joel Gwynn


Is there a simple way to prevent password trading on an apache system
using mod_auth_mysql?  I've already got the module installed and
working.  It would be nice if a directory of flat files could be
protected, without having any kind of SSI's, CGI's, etc.

anyone ... anyone?

--
[Joel-Gwynn]-[[EMAIL PROTECTED]]===
A train station is where a train stops.
A bus station is where a bus stops.
So now you know why they call this a workstation.




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

can't write to pid file?

2001-04-29 Thread Marc Bragg


Running mysql 3.23.22-beta on Redhat 7.0 w/apache and php4, and getting
the following error message:

/usr/libexec/mysqld: Can't create/write to file /var/run/mysql.pid
(Errcode: 13)

Tried to upgrade mysql to no avail, anyway, can  connect locally on the
server terminal, but when try to connect over the net, get:

Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111)
in lib.inc.php3 on line 255
Error

Help?

Thanx

Marc


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Ordinary users can crash mysql server

2001-04-29 Thread gustavo


>Description:
When a ordinary users tries to analyze bin log using a remote host (-h 
ip_address) mysql server daemons crahes.
>How-To-Repeat:
Just use mysqlbinlog to analyze a remote host binlog.
mysql -h ip_address -u user -p pass file

For instance (My environment):
shell> mysql -h 192.168.1.11 -u awp -p root etosha-bin.001

>Fix:
I lack the required level of expertise to fix it, sorry!

>Submitter-Id:  
>Originator:Gustavo Rios
>Organization:  Ifour Sistemas
 
>MySQL support: [none]
>Synopsis:  
>Severity:  [ critical ]
>Priority:  [ high ]
>Category:  mysql
>Class: 
>Release:   mysql-3.23.37 (Source distribution)
>Server: /usr/local/bin/mysqladmin  Ver 8.19 Distrib 3.23.37, for 
>unknown-freebsdelf4.3 on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  3.23.37-log
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 hour 49 min 17 sec

Threads: 1  Questions: 10  Slow queries: 0  Opens: 10  Flush tables: 1  Open tables: 4 
Queries per second avg: 0.002
>Environment:

System: FreeBSD etosha.ifour.com.br 4.3-STABLE FreeBSD 4.3-STABLE #0: Fri Apr 27 
13:46:06 GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/ETOSHA  i386


Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.3 [FreeBSD] 20010315 (release)
Compilation info: CC='gcc'  CFLAGS=''  CXX='gcc'  CXXFLAGS='-felide-constructors 
-fno-exceptions -fno-rtti'  LDFLAGS=''
LIBC: 
-r--r--r--  1 root  wheel  1174494 Apr 27 13:26 /usr/lib/libc.a
lrwxr-xr-x  1 root  wheel  9 Apr 27 13:26 /usr/lib/libc.so -> libc.so.4
-r--r--r--  1 root  wheel  561548 Apr 27 13:26 /usr/lib/libc.so.4
Configure command: ./configure  --without-perl --without-debug --with-mit-threads=no 
--with-libwrap --with-charset=latin1 --with-extra-charsets=none --enable-assembler 
--with-berkeley-db --with-innodb --localstatedir=/var/db/mysql
Perl: This is perl, version 5.005_03 built for i386-freebsd

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Help! Replication MySQL <-> MS SQL Server 7

2001-04-29 Thread Simon John


The company I work for is MS SQL Server mad - they use it as the core for one
of their software products and pretty much all of their operation is based
around it - sad isn't it?! ;o)

Anyway, they now want a website with online ordering etc. and of course they
want it to be linked via MS-SQL to their stock ordering and accounts systems.

I only code for Linux when it comes to websites (WinNT/2K is just for offices
as far as I'm concerned) so I usually use PHP/Perl and MySQL.

The setup will be:
MS-SQL server in warehouse (stock control)
MS-SQL server in office (accounts)
MySQL on web server (orders)

The so-called 'Technical' Director wants any orders from the website to
reduce the stock levels on the DB in the warehouse, and all of this to
replicate with the DB in the office.

Any ideas how I can do this?

I know SybaseCT and FreeTDS enables PHP to connect to MS-SQL Servers, but do
they do replication?

I've also heard IBM have a UNIX<->NT database linking package, but I don't
know what this is called.

I don't need real-time replication, probably a 15mins (or nightly?) cron job
would do, or maybe even just a table containing changes to the online
database that would somehow apply those changes to the offline DB's..?

TIA ;o)

-- 
Simon E. John, BA(Hons), DipM

Email:   [EMAIL PROTECTED]  | Websites designed, 
Business: www.suit-u-sir.com   | developed and hosted
Personal: www.the-jedi.co.uk   | including e-commerce

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Is there mysql client under Windows?

2001-04-29 Thread Steve Brazill


That link is now:
http://www.urbanresearch.com/software/utils/urbsql/

- Original Message -
From: "j.urban" <[EMAIL PROTECTED]>
To: "Sofiane Sakhri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, April 29, 2001 9:43
Subject: Re: Is there mysql client under Windows?


> Yes, try urSQL -- http://www.urbanresearch.com/ursql
>
> There is also mysqlgui from
> http://www.mysql.com/downloads/gui-clients.html and several more listed at
> http://www.mysql.com/downloads/contrib.html#SEC569
>
> On Sun, 29 Apr 2001, [iso-8859-1] Sofiane Sakhri wrote:
>
> > Hello,
> > Is there a windows mysql client to manage a distant
> > unix mysql server?
> > Thanx
> > Sofiane
> >
> > ___
> > Do You Yahoo!? -- Pour faire vos courses sur le Net,
> > Yahoo! Shopping : http://fr.shopping.yahoo.com
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Is there mysql client under Windows?

2001-04-29 Thread Gerald R. Jensen


Check out MySQLFront ... http://www.mysqlfront.de

- Original Message -
From: "Sofiane Sakhri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 29, 2001 10:11 AM
Subject: Is there mysql client under Windows?


> Hello,
> Is there a windows mysql client to manage a distant
> unix mysql server?
> Thanx
> Sofiane
>
> ___
> Do You Yahoo!? -- Pour faire vos courses sur le Net,
> Yahoo! Shopping : http://fr.shopping.yahoo.com
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Is there mysql client under Windows?

2001-04-29 Thread j.urban


Yes, try urSQL -- http://www.urbanresearch.com/ursql

There is also mysqlgui from
http://www.mysql.com/downloads/gui-clients.html and several more listed at
http://www.mysql.com/downloads/contrib.html#SEC569

On Sun, 29 Apr 2001, [iso-8859-1] Sofiane Sakhri wrote:

> Hello,
> Is there a windows mysql client to manage a distant
> unix mysql server?
> Thanx
> Sofiane
> 
> ___
> Do You Yahoo!? -- Pour faire vos courses sur le Net, 
> Yahoo! Shopping : http://fr.shopping.yahoo.com
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Password security

2001-04-29 Thread B. van Ouwerkerk



>How do you keep MySQL password out of view of "visitors" when needed in 
>PHP to access the db. The password is in plain english in all the php 
>files, and can be easily downloaded by anyone.

PHP is parsed so should show the password etc to the world. It's better to 
use an include and put that file outside the document root. So Apache can't 
serve but PHP can include.. Just in case someone start playing with apache 
settings and .php files are shown as textfile..

Bye the way, this question does belong on one of the PHP lists..

Bye,


B.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Indexing, Perl DBI

2001-04-29 Thread David Keeney



Thank you to those of you who have responded to my inquiry about 
indexing.

Here is more complete information about the tables involved.

++

describe Tiger_main

Field   TypeNullKey Default Extra
tlidvarchar(10) PRI 
rdidvarchar(10) MUL 
rdidseg smallint(6) 0   
namevarchar(30) MUL 
symid   varchar(30) 
fipsvarchar(5)  MUL 
cfccchar(3) 
fromlat decimal(13,6)   MUL 0.00
fromlongdecimal(13,6)   MUL 0.00
tolat   decimal(13,6)   MUL 0.00
tolong  decimal(13,6)   MUL 0.00
shapeptstextYES 
length  decimal(10,4)   YES 



show index from Tiger_main

Table   Non_unique  Key_nameSeq_in_index
Column_name Collation   Cardinality Sub_part
Packed  Comment
Tiger_main  0   TLID1   tlidA   
Tiger_main  1   fips1   fipsA   
Tiger_main  1   tolong  1   tolong  A   
Tiger_main  1   tolat   1   tolat   A   
Tiger_main  1   fromlong1   fromlong A  
Tiger_main  1   fromlat 1   fromlat A   
Tiger_main  1   name1   nameA   
Tiger_main  1   speed   1   rdidA   
Tiger_main  1   speed   2   symid   A   


explain select * from Tiger_main where symid > '' and rdid = '' limit 1

table   typepossible_keys   key key_len ref rows   
Extra
Tiger_main  ref speed   speed   10  const   5376
where used

+

The explain output indicates that the speed index will be used, as it 
should.   But the actual query performance is very slow, taking over 
5 seconds.  For comparison, other queries on the same table using 
the tolong and tolat fields (also indexed)  take well under one second.

I would appreciate either insight into how the optimizer is choosing 
whether or not to use the index, or information on how to further 
investigate actual server performance and diagnose the problem.

Thank you
David

David Keeney   [EMAIL PROTECTED]
Travel By Road http://www.travelbyroad.net


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: problem with LAST_INSERT_ID();

2001-04-29 Thread sw


I have found the solution for my 'select LAST_INSERT_ID();' problem.
I must check the 'Change BIGINT columns to INT' option in the
ODBC entry options in my NT server and everything work fine.

Why this ?
This means that I never use BIGINT columns in my Database ?

Thanks.
Regards.

Is there mysql client under Windows?

2001-04-29 Thread Sofiane Sakhri


Hello,
Is there a windows mysql client to manage a distant
unix mysql server?
Thanx
Sofiane

___
Do You Yahoo!? -- Pour faire vos courses sur le Net, 
Yahoo! Shopping : http://fr.shopping.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Password security

2001-04-29 Thread Philippe Louis Houze


Hi,

How do you keep MySQL password out of view of "visitors" when needed in PHP to access 
the db. The password is in plain english in all the php files, and can be easily 
downloaded by anyone.

Philippe

ex:

Re: ZipSlack 486 installation problems

2001-04-29 Thread B. van Ouwerkerk



>MY PROBLEMS SO FAR
>All versions of MySQL I have tried so far have come in RPM format which I 
>have rpm2targz to set up. Then I have
>gunzip/tar or tar xzf to unpack the archive. The archive unpacks in 
>different folders to those that the scripts expect and
>this is a problem for a start. Also some files seem to be missing, in 
>particular mysql.sock . In summary, I am not sure if this
>unpacking process is working correctly and maybe this explains my problems.

I've compiled several 3.23.36 on Slackware 7.1.0 without any problem at all.

I don't like RPM stuff.. always compile from source.

Missing mysql.sock is caused by settings in /etc/my.cnf (of the top of my 
head). Or by rights issues (not correct user/group) or cause it's just not 
running.

Nice tutor on www.devshed.com

Bye,

B.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Unix_TimeStamp()

2001-04-29 Thread Noor Dawod


Hi,

Does the function Unix_TimeStamp() work in MySQL under Windows NT? It
doesn't seem to work here in simple queries, such as this query:
Select Unix_TimeStamp();

Thanks

Noor


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Problem with LAST_INSERT_ID();

2001-04-29 Thread sw


The context is Active Server Pages application over IIS in NT server.
This code is in a file named DatiPrev.asp :
Open the connection using ODBC (I use MyODBC):
> set objConn = Server.CreateObject("adodb.connection")
> objConn.Open Application("Connection1_ConnectionString")
and this is the instruction :
> mSql = "Insert into ordinit (ID_Ordine, Cod_Cliente, Data_Ordine,
Ora_Ordine, Evaso, Tipo, PercSconto, ImpSconto, TotImp, TotIVA,
ImpTotale, Status) values(NULL, " & mCodCliente & "," & sDate & ",
'" & sTime & "', 'N', '" & mTipo & "', 0, 0, " & mTotImp & ", " &
mTotIVA & ", " & mTotImp + mTotIVA & ", 'de');"
> set objRS = objConn.Execute (mSql)

> mSql = "select last_insert_id();"
> set objRS = objConn.Execute (mSql)
> response.write(objRS.Fields(0))
This is the error:
>Microsoft OLE DB Provider for ODBC Drivers error '80020009'
>[Microsoft][ODBC Driver Manager] Il driver non supporta questo parametro.
  The driver not support this parameter.
I think that the problem is MyODBC.
But I have tried also with MySQLGUI client and the return value is zero.:-(

Regards.
Nino.







> Weird. I've used them often (on ISAM tables) and it works just fine.
>
> Do you use the same connection for the 'LAST_INSERT_ID' query as for
> the INSERT query? The LAST_INSERT_ID is kept per connection and until
> another INSERT is done.





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

GROUP BY a function

2001-04-29 Thread Igor Podlesny



Hello, everybody!

Can MYSQL understand this (GROUPing BY FUNCTION(column))?

-- 
Best regards,
 Igor  mailto:[EMAIL PROTECTED]



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Problem with LAST_INSERT_ID();

2001-04-29 Thread Fred van Engen

On Sun, Apr 29, 2001 at 03:38:07PM +0200, [EMAIL PROTECTED] wrote:
> My insert query look like your
> 'INSERT INTO ordinit(ID_ordine, Cod_Cliente) VALUES (NULL, 10);';
> after the query I look into the table 'ordinit' and always looks fine: the value of 
> ID_ordine is really incremented.
> But the following 'select LAST_INSERT_ID()' return zero :-((

Weird. I've used them often (on ISAM tables) and it works just fine.

Do you use the same connection for the 'LAST_INSERT_ID' query as for
the INSERT query? The LAST_INSERT_ID is kept per connection and until
another INSERT is done.

Regards,

Fred.

> >What does your INSERT query look like? It should specify NULL
> >for ID_ordine, e.g.:
> 
> >INSERT INTO ordinit(ID_ordine, Cod_Cliente) VALUES (NULL, 10);
> 
> >Any other value for ID_ordine will not assign an auto_increment
> >value.
> 
> 

-- 
Fred van Engen  XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC  Almere
fax: +31 36 5462424 The Netherlands

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: What is SSL ?

2001-04-29 Thread B. van Ouwerkerk



>I am a Java developper, I use Mysql and TOmcat,
>
>I want to know what SSL is?

Nothing_to_do_with_mysql.

ssl=secure socket layer

More info? type ssl into the seach field of you favorite searchengine.

Bye,

B.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL++

2001-04-29 Thread Jeremy Zawodny

On Sun, Apr 29, 2001 at 04:44:10PM +0300, Sinisa Milivojevic wrote:
> 
> I saw your mail on our WWW bug for MySQL++ manual.
> 
> Do you use MySQL++ at Yahoo! ??

I believe so. The work I do is mostly in Perl. The person who
maintains all our charting code uses the C interface to MySQL. But
there's also a group working on storing portfolio data in MySQL, and
I'm pretty sure they're using MySQL++ (most of their code is already
C++).

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951

MySQL 3.23.29: up 116 days, processed 719,142,990 queries (71/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: what is SSL?

2001-04-29 Thread sw


Hi,

>Hello,
>I am a Java developper, I use Mysql and TOmcat,
>I want to know what SSL is?
>Thanx

SSL is Secure Socket Layer.
Is a technology to encrypt and decrypt message (HTML pages or other)
over Internet.

Best regards.

RE: Problem with LAST_INSERT_ID();

2001-04-29 Thread sw


My insert query look like your
'INSERT INTO ordinit(ID_ordine, Cod_Cliente) VALUES (NULL, 10);';
after the query I look into the table 'ordinit' and always looks fine: the value of 
ID_ordine is really incremented.
But the following 'select LAST_INSERT_ID()' return zero :-((
It looks like a bug ?

Best regards.

>What does your INSERT query look like? It should specify NULL
>for ID_ordine, e.g.:

>INSERT INTO ordinit(ID_ordine, Cod_Cliente) VALUES (NULL, 10);

>Any other value for ID_ordine will not assign an auto_increment
>value.

Re: MySQL++

2001-04-29 Thread Sinisa Milivojevic




I saw your mail on our WWW bug for MySQL++ manual.

Do you use MySQL++ at Yahoo! ??

Just curious  ;o)


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: What is SSL ?

2001-04-29 Thread Jeremy Zawodny


On Sun, Apr 29, 2001 at 03:36:14PM +0200, Sofiane Sakhri wrote:
> 
> I want to know what SSL is?

http://www.google.com/search?q=SSL

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951

MySQL 3.23.29: up 116 days, processed 719,102,925 queries (71/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

What is SSL ?

2001-04-29 Thread Sofiane Sakhri


Hello,
I am a Java developper, I use Mysql and TOmcat,

I want to know what SSL is?
Thanx

___
Do You Yahoo!? -- Pour faire vos courses sur le Net, 
Yahoo! Shopping : http://fr.shopping.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

how to measure databases

2001-04-29 Thread Mark Lo


Hi,

 I would like to know how to measure how many MB of one particular
databases is taken in PHP command.  I know I can always use the command of
du ... .  But this command is not work under apache because the user and
group are nobody, while the user and group for mysql is mysql, also the
permission is set to read and write only for mysql user and group.  I would
like to know is there any other method to measure the databases then post it
on the web.

Thank you

Mark


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Problems with MySQL++

2001-04-29 Thread Sinisa Milivojevic


Sander Pilon writes:
> The 5_Class.html file online is only a few lines and only describes the
> manipulators, as opposed to the old 5_Class.html file distributed with
> 1.7.5 and the downloadable one, which is 300Kb and contains descriptions
> of much, much more. 
> 
> Manipulators is (the only) section 5.1 in the on-line version, whereas
> it is section 5.66 (!) in the downloadable manual. 
> 
> As far as I can see the downloadable manual is fine, but the on-line
> version is - unless my proxy hasn't updated in 6 months - not. 
> 


Our WWW people will fix it ASAP.


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Problems with MySQL++

2001-04-29 Thread Jeremy Zawodny


On Sun, Apr 29, 2001 at 02:45:06PM +0200, Sander Pilon wrote:
>
> The 5_Class.html file online is only a few lines and only describes
> the manipulators, as opposed to the old 5_Class.html file
> distributed with 1.7.5 and the downloadable one, which is 300Kb and
> contains descriptions of much, much more.
> 
> Manipulators is (the only) section 5.1 in the on-line version, whereas
> it is section 5.66 (!) in the downloadable manual. 
> 
> As far as I can see the downloadable manual is fine, but the on-line
> version is - unless my proxy hasn't updated in 6 months - not.

It's not just you. I see it just as you described.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951

MySQL 3.23.29: up 116 days, processed 718,812,371 queries (71/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Problems with MySQL++

2001-04-29 Thread Sander Pilon

The 5_Class.html file online is only a few lines and only describes the
manipulators, as opposed to the old 5_Class.html file distributed with
1.7.5 and the downloadable one, which is 300Kb and contains descriptions
of much, much more. 

Manipulators is (the only) section 5.1 in the on-line version, whereas
it is section 5.66 (!) in the downloadable manual. 

As far as I can see the downloadable manual is fine, but the on-line
version is - unless my proxy hasn't updated in 6 months - not. 

> -Original Message-
> From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] 
> Sent: 29 April 2001 14:32
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Problems with MySQL++
> 
> 
> Sander Pilon writes:
> > > 
> > > It is fine and complete will all chapters and in  all formats.
> > > 
> > 
> > This page used to have lots of cool documentation...
> > 
> > http://www.mysql.com/documentation/mysql++/5_Class.html
> > 
> > 
> > 
> 
> Yes, and there two versions of manual. One for on-line 
> browsing and the one for download.
> 
> Both are fine and complete.
> 
> 
> Regards,
> 
> Sinisa
> 
>     __ _   _  ___ ==  MySQL AB
>  /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
>/*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
>   /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
>   /*/^^^\*\^^^
>  /*/ \*\Developers Team
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Problems with MySQL++

2001-04-29 Thread Sinisa Milivojevic


Sander Pilon writes:
> > 
> > It is fine and complete will all chapters and in  all formats.
> > 
> 
> This page used to have lots of cool documentation... 
> 
> http://www.mysql.com/documentation/mysql++/5_Class.html
> 
> 
> 

Yes, and there two versions of manual. One for on-line browsing and
the one for download.

Both are fine and complete.


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Problems with MySQL++

2001-04-29 Thread Sander Pilon


> 
> It is fine and complete will all chapters and in  all formats.
> 

This page used to have lots of cool documentation... 

http://www.mysql.com/documentation/mysql++/5_Class.html



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Problems with MOD

2001-04-29 Thread Sinisa Milivojevic


Braxton Robbason writes:
> isn't this the expected behavior?
> 
> (1008306000-988344000)/86400 = 231.04
> 
> select mod(231.04,7);
> 0
> 
> 231.04 mod 7 is .04, rounded down to 0. 7*33=231
> 
> the mod function rounds the result - that's expected, right? Other than that
> I don't see what the problem is.
> 
> braxton


Hi!

MOD() function works with integers only.


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Problems with MySQL++

2001-04-29 Thread Sinisa Milivojevic

Sander Pilon writes:
> > Howdy,
> >  ./ChangeLog
> > 
> >   Indeed, those don't appear to be in the tar archive.
> > 
> >   Any ideas?
> 
> Do you need them?
> 
> tar xfz mysql++.tar.gz
> cd mysql++- 
> ./configure; make; make install
> 
> Voila.
> 
> And yes, the mysql online manual has been broken for over 6 months now
> :) 
> According to mysql people, "it will be fixed soon." (Which was something
> they said.. em.. 5 months ago.)
> 

Hi!

Actually, those above are only warnings and should be disregarded.

Regarding a manual, it has been fixed and put on MySQL++ for download,
few months ago !

So, just go and get it from there !!

It is fine and complete will all chapters and in  all formats.

Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: SU permission definition

2001-04-29 Thread Daniel BI


just put the -p flag first :)

Daniel BI

=
Original message

Attempting to define an admin user that can connect from any host.

Host='%', user='admin',  password=PASSWORD(xxx), all _priv values are 'Y'

when launching "./mysql -u admin -p mysql" and entering password, I get:

"./mysqladmin: connect to server at 'localhost' failed
"error: 'Access denied for user: 'admin@localhost' (Using password: YES)'

I thought '%' in host means "any host".  
What am I missing?  

(and I DID read The Fine Manual...)

Regards,
Fred
Atlanta



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

SSL, mysql, update

2001-04-29 Thread Daniel BI


As far as I know, 'update' is a reserved word
and you should quote it with reversed quotes
(you know they are on my keyboard near '1').

I hope it helps.

Daniel BI

> Hi,
>I'm useing mysql php and SSL on a colbalt raq, the problem I'm having
is
 > that when ever I use the update query it doesn't always update, say just
>
> UPDATE table SET f1 = 'update' WHERE id = '2'
>
> some times when I first run the page it works but then other times it
doesn't
..


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: newbie unable to connect to mysql

2001-04-29 Thread Daniel BI


Your question IS for this list, as far as it concerns
MySQL. I do understand it like this, and I think many
people think this way here. Many of us strated here
with 'stupid' questions. These lists are a great thing,
I think, it's like a bread for newbies, and a way to join
also advanced users.. and anybody can take use of
these information exchanges. Otherwise would have
been much more difficult to get such a broad spread
of knowledge and experience. Thanx to the MySQL
team, also! They are doing a great job! And is for free!..

Regarding to your question:

you must identify what is the user and group
name (mysql? on RH7) of your mysqld, then issue a
command like

chgrp yourgrp -R mysql_dir

( ?  chgrp mysql -R /usr/share/mysql )

if you don't know where your mysql directories are,
issue:

find / -name mysql

it simply does not have enough permissions to
write there. try it on all your mysql directories.

Daniel BI

> I hope this question isn't too elementary for this list. I am brand new to
> mysql. Working off redhat linux 7.0. I run "safe_mysql &" I get a message
> saying it is connecting and then a message "mySql daemon ended." When I
run
> "./bin/mysqladmin create testDB" I get the following message:
>
>   ..."connect to server at 'localhost' failed
>   error: can't connect to local mySql server through
>  socket '/tmp/mysql.sock(111)'"
>
> What am I doing wrong? Any help very much appreciated.




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

indexing

2001-04-29 Thread Selvin Sakal



i'm makin a search engine the table looks like this -

---
| number | name | keywords | description | url | rank |
---

query's are made to against keywords, and description which are a blob's. I 
want to index both of them but i don't know if i should use php index 
function to create the index or make one myself which could look like this

-
word | site |
-
site would contain the number's of the row which have the queryed word in 
their keyword or description.

can some tell which way is faster or is there no difference and can someone 
tell me a better way if there is any and also any possible idea's on the php 
script required to ran a query for words

thanks



_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Compilation problem with libmysqlclient.a shared lib

2001-04-29 Thread Treuf


Hi,

I am trying to compile Apache with PHP4/MySQL support.
PHP4 compiles/installs fine, but when I compile Apache with PHP4/MySQL
support, I get an error when linking the MySQL shared library
libmysqlclient.a.
Here is the compile log, after that are the various compilation options.

*Snippet of Apache compilation logs :
egcs -O9 -funroll-loops -ffast-math -malign-double -mcpu=pentiumpro -
march=pentiumpro -fomit-frame-p
ointer -fno-exceptions -DLINUX=22 -I/usr/local/src/php-4.0.4pl1 -I/usr/
local/src/php-4.0.4pl1/main -
I/usr/local/src/php-4.0.4pl1/main -I/usr/local/src/php-4.0.4pl1/Zend -I/
usr/local/src/php-4.0.4pl1/Z
end -I/usr/local/src/php-4.0.4pl1/TSRM -I/usr/local/src/php-4.0.4pl1/TSRM
-I/usr/local/src/php-4.0.4
pl1 -DMOD_PERL -DUSE_PERL_SSI -Dbool=char -DHAS_BOOL -I/usr/local/include
-DUSE_EXPAT -I./lib/expat-
lite -DNO_DL_NEEDED -DDYNAMIC_MODULE_LIMIT=0 `./apaci`\
  -o httpd buildmark.o modules.o modules/php4/libphp4.a modules/perl/
libperl.a modules/experimen
tal/libexperimental.a modules/standard/libstandard.a modules/extra/
libextra.a main/libmain.a ./os/un
ix/libos.a ap/libap.a  lib/expat-lite/libexpat.a  -Wl,-rpath,/usr/local/
mysql/lib/mysql  -rdynamic -
L/usr/local/mysql/lib/mysql -Lmodules/php4 -L../modules/php4 -L../../
modules/php4 -lmodphp4  -lpam
-ldl -lmm -lmysqlclient -lresolv -lm -ldl -lcrypt -lnsl  -lresolv   -lm -
lcrypt -ldb -rdynamic  -L/u
sr/local/lib /usr/lib/perl5/5.00503/i386-linux/auto/DynaLoader/
DynaLoader.a -L/usr/lib/perl5/5.00503
/i386-linux/CORE -lperl -lnsl -ldl -lm -lc -lposix -lcrypt
/usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_uncompress':
my_compress.o(.text+0x97): undefined reference to `uncompress'
/usr/local/mysql/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_compress_alloc':
my_compress.o(.text+0x12b): undefined reference to `compress'
collect2: ld returned 1 exit status
make[2]: *** [target_static] Error 1
make[2]: Leaving directory `/usr/local/src/apache_1.3.19/src'
make[1]: *** [build-std] Error 2
make[1]: Leaving directory `/usr/local/src/apache_1.3.19'
make: *** [build] Error 2

*MySQL latest stable is setup and running on the box, and have been
compiled with the following options :
- From mysqlbug :
  System: Linux intranet.par.sports.com 2.2.19 #2 Fri Apr 27 13:30:43
CEST 2001 i686 unknown
  Architecture: i686
  Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /
usr/bin/cc
  GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-
2.91.66/specs
  gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
  Compilation info: CC='gcc'  CFLAGS='-O9 -mpentiumpro -fomit-frame-
pointer'  CXX='c++'  CXXFLAGS=''
  LDFLAGS=''
  LIBC:
  lrwxrwxrwx1 root root   13 Apr 19 22:15 /lib/libc.so.6
-> libc-2.1.3.so
  -rwxr-xr-x1 root root  4101836 Jan 15 16:49 /lib/libc-2.1.3.so
  -rw-r--r--1 root root 20273324 Jan 15 16:49 /usr/lib/libc.a
  -rw-r--r--1 root root  178 Jan 15 16:49 /usr/lib/libc.so
  Configure command: ./configure  --prefix=/usr/local/mysql --enable-
assembler --with-mysqld-ldflags=-all-static --disable-shared --with-
extra-charset=complex
  Perl: This is perl, version 5.005_03 built for i386-linu

- Compilations environment variables I used :
  CFLAGS="-O9 -mpentiumpro -fomit-frame-pointer -funroll-loops"
  CC=egcs
  CXX=egcs
  CXXFLAGS="-O9 -mpentiumpro -fomit-frame-pointer -funroll-loops -felide-
constructors -fno-exceptions -fno-rtti"
  ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-
ldflags=-all-static

*PHP4pl1 compilation options :
/configure \
--disable-debug \
--with-apache=../apache_1.3.19/ \
--enable-safe-mode \
--with-mysql \
--with-mm \
--enable-inline-optimization \
--with-gnnu-ld \
--enable-memory-limit \
--enable-track-vars \
--with-mysql=/usr/local/mysql

*Apache 1.3.19 compilation options :
CC="egcs" \
OPTIM="-O9 -funroll-loops -ffast-math -malign-double -mcpu=pentiumpro -
march=pentiumpro -fomit-frame-pointer -fno-exceptions" \
CFLAGS="-DDYNAMIC_MODULE_LIMIT=0" \
/configure \
--mandir=/usr/man \
--add-module=src/modules/experimental/mod_mmap_static.c \
--add-module=src/modules/standard/mod_auth_db.c \
--activate-module=src/modules/php4/libphp4.a \
--enable-module=php4 \
--activate-module=src/modules/perl/libperl.a \
--enable-module=perl \
--disable-module=userdir \
--disable-module=asis \
--disable-module=imap \
--disable-module=actions

Thanks in advance for advices/help ...

--
Mathieu Masseboeuf - Responsable Systèmes et Réseaux
http://sports.com/fr
Tous les sports en direct et en coutinu sur Internet.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Index use, Perl DBI

2001-04-29 Thread Jeremy Zawodny

On Sat, Apr 28, 2001 at 08:47:11PM -0600, David Keeney wrote:
> 
> I have a situation where a query should be using an index, running
> the query from the mysql terminal using the explain ... command
> indicates it will use the index, but the actual execution speed
> tells me the index is not being used: Execution is very slow.

The ouput of EXPLAIN only tells you which index(es) MySQL will
consider using. It does not tell you for sure that it will use them
all:

  http://www.mysql.com/doc/E/X/EXPLAIN.html

Have you tried running an OPTIMIZE TABLE to see if that helps?

Of course, if you show us the table structure and the output of
EXPLAIN, we may be able to suggest something.

> Is there a way, through the Perl DBI interface, to determine whether
> a given SELECT query is using indexes?

Not that I know of, no.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951

MySQL 3.23.29: up 116 days, processed 717,559,724 queries (71/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql 'top' application

2001-04-29 Thread Jeremy Zawodny


On Fri, Apr 27, 2001 at 07:21:38PM -0700, Soren Ragsdale wrote:
>
> I purchase web space on www.phpwebhosting.com, which offers PHP and
> mySQL services in a shared server environment.  Each user gets their
> own database, in which they can create their own tables.  Today,
> someone is using a LOT of resources: mysqld is pegged at 96% CPU
> utilisation, and I'm getting 'running out of connections' errors.
> 
> How can I tell which user on the system is responsible for the lag?
> Ideally there would be a command like 'top' that would show which
> databases are being accessed most frequently, or taking the most
> time to access.

I use mytop:

  http://public.yahoo.com/~jzawodn/mytop/

Of course, I wrote it, so I'm biased. :-)

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951

MySQL 3.23.29: up 116 days, processed 717,556,262 queries (71/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

71 matches

Mail list logo