Re: Compling on RedHat 9
You might want to check that the developer tools were installed with Red Hat 9; if not, you'll have trouble. The RPM is easiest to use, works like a charm. Jeremy Zawodny [EMAIL PROTECTED]To: Peter Koutsoulias [EMAIL PROTECTED] om cc: [EMAIL PROTECTED] Subject: Re: Compling on RedHat 9 09/11/2003 06:24 PM Please respond to mysql On Thu, Sep 11, 2003 at 10:22:13AM -0400, Peter Koutsoulias wrote: I couldn't find an appropriate mailing list for compiling MySQL, so I thought I'd try here. anyone successfully compile MySQL 4 on RedHat 9? I keep getting errors on libmysql.c during the make step. Google doesn't reveal a whole lot about compiling MySQL on RedHat which leaves me to believe most people use RPMs. A while ago, when I had access to a RH9 box I compiled it without much trouble--at least none that I still remebmer. You might post compilation the errors you're seeing... Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 165,947,775 queries (450/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Command not found
Also make sure you installed both the server and the client for MySQL. And of course if you're not running bash, put the path to the MySQL directory in the correct shell file. For example, I prefer the tsch shell, so I would put it in the .tcshrc file in my home directory. If you're not familiar with Linux, take a look at some of the commands at http://www.reallylinux.com/docs/consult.shtml. If you want a book, http://www.amazon.com/exec/obidos/ASIN/0972679006/qid%3D1041438546/sr%3D11-1/ref%3Dsr%5F11%5F1/103-4038995-5196662 will get you a quick start. Parker Morse [EMAIL PROTECTED]To: [EMAIL PROTECTED] m cc: [EMAIL PROTECTED] Subject: Re: Command not found 09/05/2003 09:24 AM On Friday, Sep 5, 2003, at 00:51 US/Eastern, [EMAIL PROTECTED] wrote: I installed the MySQL 4.0 on my Linxus machine (red hat 7.3). The installation shows no problem, and I can see that the 'mysqld' server is actually runing through a command like ./bin/mysqladmin version. However, it just does not allow me to switch to the mysql client program from my login shell. Whenever I try to do so, it also says that bash: mysql: command not found. I don't know how to deal with it. Could some MySQL experts please kindly help me with this? It's not a MySQL issue, it's a Linux issue. If your MySQL binaries are installed in a directory like /usr/local/mysql/bin/, they're not in one of the directories your shell (probably bash) looks in for commands. (To see which directories are being searched, type echo $PATH at the shell prompt.) You'll need to edit the .bashrc file in your home directory to add the /usr/local/mysql/bin directory to the search path if you want to avoid typing the full path. Another alternative is to place links to the binaries in one of the directories already in the path, like /usr/bin/. pjm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Personal Servers
I'd recommend Apache, www.apache.org, but be aware that Windows OSes come with a personal version of IIS that can be used as a single server (i.e., no virtuals). Check Windows Components in Add/Remove Programs. The Apache site has good documentation and some IIS info can be found in the Windows help files. Prabu Subroto [EMAIL PROTECTED]To: [EMAIL PROTECTED] oo.com cc: Subject: Re: Personal Servers 09/04/2003 08:06 AM Many... but try Xitami and Apache. They're great. BTW, XP? Try SuSE, far better then Windoof. --- Nicola Hartland [EMAIL PROTECTED] wrote: I am not sure this is the right place for this question but I am trying to find a personal server that I can install on my PC, I run XP that I can have to test the web pages. Does anyone have any suggestions and how to configure them. thanks in advance Nicci __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Handling Arrays
Yes, it should. Check it yourself by printing out array values: echo array[2]; echo array[3]; etc. If it's a really long array and you want to print the whole thing, look at foreach, http://us2.php.net/manual/en/control-structures.foreach.php John Macon [EMAIL PROTECTED]To: [EMAIL PROTECTED] net cc: Subject: Handling Arrays 09/02/2003 09:40 PM I have a quick question about arrays. I know that this is probably pretty easy for most of you out there, so here it goes. If you remove $array[2], would $array[3] then automatically become the new $array[2]? Thanks in advance for your help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Crystal Decisions Report Application Server Problem
Sounds like a problem authenticating the host the queries are coming from. Try using the grant command with like john@%, which allows any host to connect. (replace john with the username you want.) As a historical note, we tried using Crystal RAS with Lotus Notes and concluded it was too slow and too inflexible in generating reports. Because we wanted to try FileMaker, we switched to that with better results, but my team still thinks it's slow. So I'm getting ready to recommend a switch to MySQL and PHP, which I know will be blazing fast, and it will be simple to design whatever reports are desired. [EMAIL PROTECTED] ics.ca To: [EMAIL PROTECTED] cc: 09/02/2003 09:50 Subject: Crystal Decisions Report Application Server Problem AM I'm writing to get some help on the following problem: We're running MySql (1.4.1 version) with MyODBC (version 3.51.06) and the Report Application Server 9 (RAS) from Crystal Decisions. We're having a problem getting the Report Application Server to connect to the MySql database via MyODBC. We have two databases going - an Oracle database and a MySQL database. We wrote a simple report for each and we're trying to run the report via the RAS sample web page (e-portfolio lite). The oracle report works fine - RAS manages to display it and access the database. The MySql report fails to connect to the database - it asks for a user name and password, but always fails to connect to the database (it prompts for another user name and password). However, Crystal Reports itself run the report fine. There seems to be a disconnect between how RAS connects to the database versus Crystal Reports. Anyone able to get RAS to work? Kristina -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: multiple databases creation
My recommendation would be to use phpmyadmin, http://www.phpmyadmin.net/. Takes just a few minutes to pull out the original database schema then feed it back to create new tables. Or you can do it with command-line instructions. 2000 small databases shouldn't be a problem as long as the server it's on can handle the load. Kai Li [EMAIL PROTECTED]To: [EMAIL PROTECTED] .comcc: Subject: multiple databases creation 08/05/2003 08:12 PM Hi, I know that Mysql handles large database very well, but there is a project that requires more than 2000 small databases(about 20 talbes with a few rows) to be created within a Mysql server. Could somebody tell me does it make sense? Thanks for your consideration. likai _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Form values are truncated
Functions can be looked up at www.php.net, trim is at
http://us2.php.net/manual/en/function.trim.php
James Johnson
[EMAIL PROTECTED]To: [EMAIL PROTECTED]
s.com cc:
Subject: RE: Form values are truncated
08/11/2003 12:00
PM
Hi Dan, all,
I don't know PERL, just coming back to speed on PHP after 3+ years with
ColdFusion.
Trim() is a function listed in my PHP Functions book, not something I
wrote.
It's supposed to: removes all whitespace characters from both the left and
right ends of a string... A space (ASCII 32) is considered a char to
remove, but since it's in the middle of the string, I don't understand why
it's being removed.
or you could fix or replace the trim function with one that does not
remove
that data.
Is there a library of PHP user defined functions out there?
Thanks,
James
-Original Message-
From: Dan Muey [mailto:[EMAIL PROTECTED]
Sent: Monday, August 11, 2003 9:02 AM
To: James Johnson; [EMAIL PROTECTED]
Subject: RE: Form values are truncated
All,
Howdy,
I'm building a member signup form. Fields that contain more
than one word are being truncated when being inserted into
the MySQL table.
I'm using this code that I got from one of my PHP books.
$as_addr1 = addslashes($_POST['addr1']);$tr_addr1 = trim($as_addr1);
I think trim is trimming off the stuff after the first whitespace? What is
the trim function supposed to do?
Mysql isn't doing it your PHP is.
Use Perl and I bet it starts working :) ok, or you could fix or
replace the trim function with one that does not remove that data.
HTH
DMuey
So, if I post 1122 Boogie St. it gets inserted as 1122.
If I remove the addslashes portion, only using trim, I get
the same result.
Here's the query:
$query = INSERT INTO subscribers
(email,password,fName,lName,addr1)
VALUES
('$tr_email','$tr_pass','$tr_fName','$tr_lName','$tr_addr1';
echo $query;
Here's the echo:
INSERT INTO subscribers (email,password,fName,lName,addr1)
VALUES('[EMAIL PROTECTED]','','Jim','Johnson','78797 State')
I have other fields in the table that are doing the same
thing. All fields are varchars of varying length. Field
addr1 is varchar(50).
Suggestions?
Thanks,
James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Bookmarks
I think you're going to have trouble doing this with .asp. I know it can be done with Perl or PHP, so you might want to look into those programming languages. MySQL won't do it automatically. Shahid M. Syed [EMAIL PROTECTED]To: Paul DuBois [EMAIL PROTECTED] rs.com cc: [EMAIL PROTECTED] Subject: Re: Bookmarks 07/23/2003 09:04 PM At 8:45 +0500 7/23/03, Shahid M. Syed wrote: Hello Does any version (production or future) of mysql supports Bookmarks? What is Bookmark capability in a database context? You can use the Bookmark property to set a bookmark (Bookmark: A property of a Recordset object or a form that contains a binary string identifying the current record.) that uniquely identifies a particular record in the form's underlying table, query, or SQL statement. Read/write Variant. Example: In VB6, I can read a bookmark in a variant like varBookmark = rsName.Bookmark Where varBookmark is a variant and rsName is a adodb recordset. Later I can go back to the same record by rsName.Bookmark = varBookmark In ASP, I'm trying to come up with a better solution where there is too much data in recordset to display at once in a web page. Exactly like when you search on Yahoo and at bottom its gives links like: Next, Next 10 and also page links like 1,2,3 14. If you know any other or better way for doing this, please let me know. Regards Shahid M. Syed Karachi, Pakistan http://members.tripod.com/shahid_syed -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FileMaker Pro
Check out http://www.fmpdev.com/fmp2mysql.html, found in Google search for filemaker to mysql David Shugarts [EMAIL PROTECTED]To: MySQL List [EMAIL PROTECTED] ve.com cc: Subject: Re: FileMaker Pro 07/12/2003 05:09 PM FM is no problem. You can output from it to a tab-delimited file and then INSERT it into a mySQL DB. Or, a number of mySQL clients, including myPHPAdmin, allow you to import a text file, such as a tabbed file (or CSV, etc.). You must first set up your mySQL datatbase and be sure that the field types from FM are appropriate. In addition, on the high end, there is some software that will let you interface FM Pro with mySQL directly, so that you can work in FM on your local machine and then pump the data to the server transparently. It's about $250. --Dave Shugarts Does anyone know how to export a FileMaker Pro Database so that MySQL can use it? Anyone ever do something like this? Thanks, -- -Steve Marquez Marquez Design [EMAIL PROTECTED] www.marquez-design.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems connecting to server
Description: I have just installed MySQL 4.0.4 on Linux kernel 2.4.2-2 on a Hewlett-Packard Kayak machine. I ran the mysql_install_db script with no problems, but am unable to create a root password as directed by the script. I have started MySQL with ./bin/mysqld_safe as directed by the script, but when I try to create a root user with ./bin/mysqladmin -u root password 'thepword', I get: ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! This is the first install of MySQL on this server (and my first try at installing). I'm also wondering where you copy the support-files/mysql.server in Linux? How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:root Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-4.0.4-beta (Official MySQL binary) Environment: machine, os, target, libraries (multiple lines) System: Linux klinux 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/mh/perl /usr/bin/mh/make /usr/bin/mh/gmake /usr/bin/mh/gcc /usr/bin/mh/cc GCC: Reading specs from /usr/bin/mh/../lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro ' CXX='gcc' CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 May 26 16:12 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1236396 Apr 6 2001 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 Apr 6 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 6 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql ' --with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-local-infile --enable-assembler --disable-shared --with-client-ldfl ags=-all-static --with-mysqld-ldflags=-all-static 'CFLAGS=-O2 -mcpu=pentiumpro ' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-const ructors' CXX=gcc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Followup on 1054 error
Thanks for all the responses to my posting below.
I was using phpmysqladmin to check on updating the database, and I finally
figured out that phpmysqladmin was misconfigured, with the same database on
two different servers but with different column names. Naturally I was
sending the query to the database with the wrong column name, which is why
I got the error. Once I figured it out (by command line calls to mysql),
all was well.
I appreciate the advice from the list and I've changed some of the column
names as responders suggested to avoid other problems. So thanks much!
Mike Kent The Indianapolis Star - Information
Technology
Internet mail:AOL messenger: mkent INI
[EMAIL PROTECTED]
- Forwarded by Mike Kent/INI on 08/07/01 01:42 PM -
Mike Kent
To: [EMAIL PROTECTED]
08/06/01 cc:
11:56 AM Subject: 1054 error
I'm new to MySQL and I get a 1054 error on this SQL query sent by a PHP 4
script:
1054: Unknown column 'pricerange' in 'field list'
$sql is INSERT INTO CCC_reviews (restname, type, specialties, address,
phone, hours, pricerange, creditcards, reservations, rating, miscinfo,
area, wheelchair, maplink, byline, date, reviewsum, review) VALUES
('Junkyard dog', 'Bakery', 'dogburgers', 'who cares', 'none', 'none',
'Moderate', 'Y', 'N', '1 1/2', 'Place stinks', 'North', 'N', 'somewhere',
'By Junkyard Bob', 'August 6, 2001', 'blah blah blah sum', 'blah blah blah
real thing')
The column pricerange does exist, and I've verified there's no trailing
space or the like.
Anyone know what's wrong?
Thanks.
Mike Kent The Indianapolis Star - Information
Technology
Internet mail:AOL messenger: mkent INI
[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
1054 error
I'm new to MySQL and I get a 1054 error on this SQL query sent by a PHP 4
script:
1054: Unknown column 'pricerange' in 'field list'
$sql is INSERT INTO CCC_reviews (restname, type, specialties, address,
phone, hours, pricerange, creditcards, reservations, rating, miscinfo,
area, wheelchair, maplink, byline, date, reviewsum, review) VALUES
('Junkyard dog', 'Bakery', 'dogburgers', 'who cares', 'none', 'none',
'Moderate', 'Y', 'N', '1 1/2', 'Place stinks', 'North', 'N', 'somewhere',
'By Junkyard Bob', 'August 6, 2001', 'blah blah blah sum', 'blah blah blah
real thing')
The column pricerange does exist, and I've verified there's no trailing
space or the like.
Anyone know what's wrong?
Thanks.
Mike Kent The Indianapolis Star - Information
Technology
Internet mail:AOL messenger: mkent INI
[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
