In regards to building the source distribution of MySQL on a Solaris/Intel system
(i.e. Solaris 8 for Intel), I have successfully 'built' and installed MySQL 3.23.40,
and found the following tasks need to be performed:
As Phil Dibowitz stated:
You need to have your LD_LIBRARY_PATH set.
Would the submitter of this Email to the list (seen below as
mailto:[EMAIL PROTECTED]) please fix your /etc/hosts file to
display your 'real' system name and 'domain'...
Also, you should create an account for yourself on the system, and send
your emails to the list as that user (how is anyone
You did not mention what the 'client' or the 'server' were (i.e. NT, UNIX,
Mac), or what the 'distance' between the 2 was (over the Internet ?, thru
firewalls, etc).
If you're trying to connect over any distance on a network, make sure you
DON'T use 'telnet' or 'ftp' (or you will find your
Ick !!!
This question had come up on the list about 2 weeks ago...
I like:
WinVI (I know that the Emacs lovers will respond soon) at:
http://www.winvi.de/en/
For other versions and 'ports' of VI, see The VI Lovers Homepage at:
mysqldump creates an 'SQL' script, which you 'run' to recreate the tables
and data within them.
Something like this should do the trick...
mysql -u root -p password NewDataBaseName file.mysql
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July
You should use the 'startup script' supplied with the 'source' distribution
(named server.sh in the subdirectory support-files).
To 'boot' without starting any applications or daemons, type boot -s at
the 'boot prompt' (Lilo's boot prompt if you have installed lilo). This
will boot the system
If you had read the installation instructions, you would have seen
statements that looked like this...
cd /usr/local/mysql
./bin/mysql_install_db
Make sure that the var directory that is created grants access to the
'user' that MySQL is running as... (otherwise I'm sure we'll be
You might have had a 'distribution' that was installed via the 'RPM' method.
You can see if the RPM packages are installed by typing:
rpm -q -a | grep -i mysql
If some package appear (as 'mysql-something), remove each one by typing:
rpm --erase 'mysql-something'
Otherwise, if
I think you meant that you're Sun server is using version 3.22.xx...
The files with the .ISD and .ISM extensions belong to the 3.22.xx
family of MySQL Isam file version types... (while the newer myisam have
the .MYD and .MYI extensions).
You would either have to 'upgrade' the MySQL version on
It's nice to see that someone has an 'auto-response' setup for incoming
infected messages...
BUT, by the looks of the original Email (at the bottom of this message), it
was an intentional attack on the list...
P.S. Database
- Original Message -
From: Bulk Mail Response [EMAIL
Here's another one that appears to be a 'carrier' for something devious...
(though I didn't see any attachments)
How did it get thru the list without any of the necessary 'words' ?
Perhaps someone should block this Email address from the list:
[EMAIL PROTECTED]
P.S. Database
- Original
Depending on the 'environment' (i.e. O/S you're using), the tools available
might be different...
But, using Linux (and I'm sure any other 'flavor' of Unix), my company
used the latest 'libmcrypt' to encrypt the credit card numbers (as well as
the user passwords) within a PHP function prior
AND, you'd want to 'protect' the data from viewing if you've 'dumped' the
database or backed it up to an 'insecure' media or location (to
tape/disk)... Encrypting the data, with the 'key' or 'salt' located
somewhere else, would allow you to 'transport' the tables containing the
sensitive data
What directory are you in when you 'unpack' the source distribution ?
What directory are you in when you issue the 'make' command ?
What directory are you in when you issue the 'scripts/mysql_install_db'
command ? (I usually go to the 'installed' directory /usr/local/mysql and
type
What about the version of the file which should be in
/usr/local/mysql-3.23.39-pc-solaris2.8-i386/bin ?? (which is the one you
should be running from the 'mysql' directory as ./bin/mysql_install_db )
- Original Message -
From: Wu, Steve [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Sfikas,
More RAM never hurts (as long as you're using it, which you might be able to
influence by your other option of optimizing the server variables).
I've always had the opinion, that the faster you service the queries, the
more queries you can handle with existing resources. This might be best
Don't forget that WinVI exists and can be found (and downloaded) at:
http://www.winvi.de/en/
And for those who like the 'code warrior' or 'slickedit' type of stuff
(where different types of 'statements' are highlighted in different colors),
there's Code Genie available at:
--
From: Steve Brazill [EMAIL PROTECTED]
Reply-To: Steve Brazill [EMAIL PROTECTED]
Date: Mon, 16 Jul 2001 10:48:08 -0700
Don't forget that WinVI exists and can be found (and
downloaded) at:
http://www.winvi.de/en/
And for those who like the 'code warrior' or 'slickedit
Here comes my 2 cents...
The 'advantage' of installing a package such as MySQL on your system as
root, is that the root user would be the only one able to 'modify'
permissions on the installed files. You'd still create a mysql user and
mysql group, which would be assigned to the var (default
First, I'd like to say that it's great that a Solaris for Intel version
of the binaries are now available (or was it my poor eyesight that hadn't
seen it before).
There's a possibility that the fact that you've used a 'symbolic' link for
/usr/local/mysql is causing a problem (though it works on
I'd think that someone would have to had created a 'package' for Solaris
installations, BUT, you'd have to identify which version of Solaris you
were using, and whether you're running it on a SPARC or Intel based
system
I haven't seen them on the site (you could download the source
%2FSUNWasup%2Ftoc%2FPACKINSTALL%3APACKINSTALL%3AcloseDwebQuer
y=package+OR+creationoqt=package+creationscope=BOOKAb2Lang=CAb2Enc=iso-8
859-1
- Original Message -
From: Mike Jimenez [EMAIL PROTECTED]
To: Steve Brazill [EMAIL PROTECTED]; Mysql [EMAIL PROTECTED]
Sent: Tuesday, July 10, 2001 9:43 AM
Just checked the site, and only see version 3.22.26a (very old) on the
site...
- Original Message -
From: Ravi Raman [EMAIL PROTECTED]
To: Mike Jimenez [EMAIL PROTECTED]; Steve Brazill [EMAIL PROTECTED];
Mysql [EMAIL PROTECTED]
Sent: Tuesday, July 10, 2001 10:24 AM
Subject: RE: Solaris
Oh, and if you're going to use this system as a server for
intranet/internet resources, why do you have a Win98 drive installed ??
You won't be able to use it if you're going to keep the system up, running
Linux...
- Original Message -
From: Steve Brazill [EMAIL PROTECTED]
To: Gavin
Here it is at bookpool.com (my favorite source for tech books) for $31.95
http://www.bookpool.com/.x/nqmc5ymle4/sm/0735709211
And an interesting one on PHP and MySQL that I haven't seen 'reviewed'
yet...
http://www.bookpool.com/.x/nqmc5ymle4/sm/0672317842
- Original Message -
From:
Could you list (exactly) what commands you are using to 'unpack',
'configure', 'build', and 'install' the distribution (which package have you
downloaded ?) ??
- Original Message -
From: Aditya Dhekney [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 21, 2001 12:19 PM
s I
use.- Original Message -----From: "Aditya Dhekney"
[EMAIL PROTECTED]To: "'Steve Brazill'" [EMAIL PROTECTED];
,[EMAIL PROTECTED]Sent: Thursday, June 21, 2001 12:50
PMSubject: RE: mysql installation from source
-Original Message- From: Steve Brazill
[mailt
You didn't mention how many 'transactions per second/minute/hour' you
expect... (on those 25 connections)
A Sun Ultra 10 is just a PC built by Sun (but with a Ultra-SPARC CPU and
other nice enhancements). I don't know if Sun has made it possible to
attach ANY brand of disk drive (that they
Perhaps the 'replication' of 'user' data (and/or other MySQL 'control' data)
doesn't perform the necessary 'refresh' (which occures when you do a flush
privileges), but was 'triggered' when you changed the users' password
Turtle wrote:
Ok.. even more bizarre... IN addition to what I told
Someone else asked this question last week, and it turned out that she had downloaded
the Sun/SPARC version (as you did) and tried to install it on a Sun/Intel system...
If you type uname -a, what does the display tell you ??
zhiheng_huang wrote:
Hi,
I try to install
If you're trying to check a 'remote' system, you can 'telnet' to port 3306
(IF you have remote 'telnet' access to the MySQL service, and IF it's
listening on the default port 3306) which will display some garbage containing
the version number
telnet yubby.dubby.com 3306
In case you're not aware of it yet, Linux (and other UNIX operating systems)
are not 'binary file compatible' with Microsoft products (including Windows
98).
You should always 'dump' your database contents (using mysqldump) before
'moving' the data to build another database (unless you're
It's looking for the host table (physical files) within the 'mysql' data area
(not your own data area).
Did you run mysql_install_db after installing the new version ? (or copy the
mysql subdirectory from the old version)
Guy Smith wrote:
I just upgraded from 3.23.27 to 3.23.32 (can't go
Is it 'exactly' once every 10 times ??
You should check to make sure it's not an 'external' issue.
- Do you have a 'series' of DNS servers (like 10) that you use to lookup
system names (and 1 of them isn't working properly ?)
Try some other service (like 'pinging' the MySQL server from the
response.
Barbara Baughman
X2157
On Mon, 11 Jun 2001, Steve Brazill wrote:
You might have issues with the 'environment' you're setup with...
What 'shell' are you using (especially when you performed the
installation)
??
Isn't /export an 'NFS mounted' area ? (will this cause issues
You might have issues with the 'environment' you're setup with...
What 'shell' are you using (especially when you performed the installation)
??
Isn't /export an 'NFS mounted' area ? (will this cause issues with the
installation ?)
Can you 'resolve' (lookup) your system name yourself ? (i.e.
When you 'copied' the data directory (and/or contents), did you make sure
that the directory and file 'ownerships' and 'permissions' remained the same
? Did you check the 'ownership' and 'permissions' on the new MySQL 'parent'
directory ?
- Original Message -
From: Mike Jimenez [EMAIL
-xr-x
- Original Message -
From: Mike Jimenez [EMAIL PROTECTED]
To: Steve Brazill [EMAIL PROTECTED]
Sent: Wednesday, June 06, 2001 2:57 PM
Subject: RE: How to upgrade from source version to RPM version
Yeah the permissions were the same from the previous version which ran as
root but I
What type of installation is your corrent MySQL config ?? (i.e. RPM, source,
etc)
I find that the best way to manage updates, and be able to 'save' different
versions for 'fallback' or testing, is to always use the 'source'
distribution (not the source RPM).
I 'config' the package with the
Perhaps the physical layout of your disk drives are contributing to the
'slowness'...
- Are the 12 drives making up the SCSI RAID 5 array the only drives in the
system ?
- Do you have the O/S and/or the 'temp' area being used by MySQL on
different drive devices than the RAID array ? (is the
For MySQL databases, is there any ability (or method) to construct
'record layouts' which
would provide alternate fields within the record ?
I'd like to create a codes table, where different types of reference
'codes' would be stored (i.e. payment terms, tax authorities,
credit card types,
You should split the data-fields into tables containing 'categories' of
fields.
* 'textual' (or informational) fields would be the main 'item' table
* 'quantity' and other 'numeric' fields that are updated frequently (i.e.
quantity sold, quantity on-hand) would be in the table that
Oh, and response time should be 'faster', since you can locate the different
tables on separate storage devices, allowing for concurrent drive access to the
different parts of the item.
Steve Brazill wrote:
You should split the data-fields into tables containing 'categories' of
fields
You should get an identical 20gig IDE drive to 'mirror' the O/S partitions,
and since you have a SCSI setup for the data areas, you should get at least
2 more of those, and 'stripe' the data across them (or at least get a second
drive to 'mirror' those partitions as well).Though 'mirroring'
Can you give more info on what type of system this is ??
Is this really a 'server' type machine, or an HP Vectra PC ?? (of the
'XU' series ?)
Does it have the onboard SCSI controller (what size drives, and are they
SCSI drives ?)
- If they're SCSI, you might want to get 4 drives, and
Do you 'refresh' your tables before each test ? If so, is it possible that
you're writing over the same disk space each time (which would point to a
drive surface problem). Is it possible that the larger runs of 'inserts'
are using more RAM than the smaller tests, and you're hitting a bad
Before you listen to anyone else (and spend any money on a commercial SSH client)
download and try PuttySSH, which is a free 'telnet like' SSH client (it WILL
do straight telnet if you want it to) that works fabulously (at least for me at
home and work for the past year). You can also download
If you look at the 'text' file you created with the 'dump', you'll see that
it contains all of the 'SQL commands' to recreate the tables and 'insert' the
data you've extracted.
So you simply type:
mysql mydbf_db /mydir/mydbf.backup
(you might have to insert/add the -u and a username and
It looks like they're running Sun Solaris version 2.6 (SunOS 5.6) on an
Intel-based system (as apposed to a SPARC based Sun server). The MySQL
site only shows binaries available for the SPARC version of Solaris, so
you'll have to download and compile the 'source' distribution...
-
Look on Ebay for Compaq 1850R 'rackmount' servers...
You can find one with 'dual' Pentium II CPU's, dual power supplies (which you can
plug into 2 different circuits or UPS's), and enough SCSI drive slots to provide the
disk space (and the different number of storage devices to 'mirror' and
Just a note. If you're requesting telnet or ftp access to your
'colocated' systems, the issue isn't only with your 'ISP'. I just got
finished assisting another MySQL user in rebuilding his system (for the 2nd or
3rd time) who has been using telnet and ftp to remotely administer his
systems
I personally use SSH (running as a server on the Unix/Linux system running
MySQL, and which is now included in the RedHat 7 release series) which is
configured to accept only 'ranges' of IP address (subnets that my dialup
ISP might assign me, like 207.25.33.* 207.25.34.*).That should
I find it humorous that you're Email address is perl_programmer2001, yet
you don't know how to set your PATH variable...
Type echo $PATH and see if /usr/local/bin is included in it. If so, you
can do what I usually do, which is to add 'symbolic links' from there to
programs that I want to
Marc S. Bragg wrote:
How does one redirect mysql to a data directory location different than
the default. . . . and if possible, only for a particular database.
You can find the 'official' notes on how to relocate tables or entire
databases at:
"l0phthcrack" should work, since the "rocket scientists" in Redmond have still
retained the "NetBIOS" version of the password (the old "Windows for Workgroups"
version) in the SAM. So much for improved security...
(HA HA HA HA HA HA HA )
Roel Vanhout wrote:
Do you have code on how it is
OR, you can do what I usually do, and create a 'symbolic' link from
"/usr/local/bin" to programs 'outside' of your path, that you feel are safe to
run 'automatically' (i.e. "cd /usr/local/bin; ln -s
/usr/local/mysql/bin/mysql ")
Brian Warn wrote:
Make sure in (solaris + ksh) /etc/profile
There's some good documentation (a lot of it in the form of 'warnings') on
security aspects of the "mysql" database.
http://mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html#Privilege_system
But, here's some quick notes:
Anyone who has 'modify' permissions to the
Unfortunately, you're using MySQL on a Microsoft product, and you've probably
run into one of those issues where Redmond decided what's best for you (changing
the 'case' of the filenames).
BUT, in both the Microsoft and UNIX realm of products, 'packaging' files (on
UNIX using 'tar' and 'gzip',
Maybe they just seeing if MySQL is 'as open' as Interbase...
http://www.securityfocus.com/frames/?content=/templates/advisory.html%3Fid%3D3152
There are a lot of 'robotic probes' going on out there (most commonly looking
for FTP access).
Just 'batten down the hatches' and keep monitoring...
One thing you should do to protect your MySQL 'instance' , is have it running
on a system 'behind' your 'front line' defenses (i.e. Firewall) and not 'on
it'.
Setup MySQL to listen only on the interface that your webserver or other
'client' is communicating on (we have a 'private' network
My company is using it for all database functions. We're an online
'collection' agency and have been using it for the past 6 months (versions
3.22.23 upgraded to 3.23.36). In comparison with Borland's
"Interbase" ("Ibase"), which I supported at the late "Money Store"
corporation for all 100 of
61 matches
Mail list logo