Re: how to get a script to run/work
Hi, If you type mysql at the prompt you must interactively type commands at the mysql prompt and type quit to exit. However I think it's generally better in cases like yours to run in batch mode. Type: mysql pet.mysql. This will read the script from the file and execute it. If you want the output to be redirected to a file also add pets.out. In batch mode by default a concise format is used, but if you want tables to be drawn around the output like in interactive mode use the -t switch. Finally if you want the output to contain your typed commands use the -vvv switch. So you end up with: c:\mysql\scripts mysql -t -vvv pets.mysql pets.out I have only started using MySQL and only run it on a stand-alone system. If you are designing a database for a web site etc then you may need to provide extra parameters like the hostname. Hope this helps. Regards, Saqib Shaikh Email: [EMAIL PROTECTED] Web site: http://www.saqibshaikh.com/ - Original Message - From: Barbara Ferrell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, November 11, 2001 3:47 AM Subject: how to get a script to run/work i want to convert my access database to mysql. and then it will run on a linux server if i ever figure out how to run these darn scripts though i downloaded mysql for windows 98. i have tried for a week to run these scripts and even reinstalled mysql and even tried it on another computer with nt4.0. this is where i saved mysql and the title of the script i want to run. C:\mysql\scripts\pet.sql i am sitting at the mysql prompt and i have the server/daemon running in the background. Please exactly what do i type after the mysql prompt?? - 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
Can't compile 3.23.44 Help
Hi everybody there!
I'm trying to compile mysql-3.23.44 on redhat linyx 7.1 box
I got this result before and compile gcc direct from the source
thinking that could be anithing wrong on the rpm gcc that came with
redhat but he result is the same. Please anybody has an idea about
this error. Any help will be hightly appreciated
-Jose ALbert
fi
*last output lines of configure
checking if struct dirent has a d_ino member... yes
checking whether signal handlers are of type void... yes
checking for tgetent in -lncurses... no
checking for tgetent in -lcurses... no
checking for tgetent in -ltermcap... no
checking for termcap functions library... configure: error: No
curses/termcap library found
**config.log***
last lines
int main() {
tgetent()
; return 0; }
configure:8312: checking for tgetent in -ltermcap
configure:8331: gcc -o conftest -O3 -DDBUG_OFF -rdynamic
conftest.c -ltermcap -lpthread -lcrypt -lnsl -lm -lpthread 15
/usr/bin/ld: cannot find -ltermcap
collect2: ld returned 1 exit status
configure: failed program was:
#line 8320 configure
#include confdefs.h
/* Override any gcc2 internal prototype to avoid an error. */
/* We use char because int might match the return type of a gcc2
builtin and then its argument prototype would still apply. */
char tgetent();
int main() {
tgetent()
; return 0; }
configure:8359: checking for termcap functions library
gcc Version
[root@lancelot mysql-3.23.44]# gcc -v
Reading specs from /usr/local/lib/gcc-lib/i686-pc-linux-
gnu/3.0.2/specs
Configured with: ../gcc-3.0.2/configure --with-gnu-as
Thread model: single
gcc version 3.0.2
-
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: Can't compile 3.23.44 Help
[EMAIL PROTECTED] wrote: I got this result before and compile gcc direct from the source thinking that could be anithing wrong on the rpm gcc that came with redhat but he result is the same. Please anybody has an idea about this error. Any help will be hightly appreciated *last output lines of configure checking if struct dirent has a d_ino member... yes checking whether signal handlers are of type void... yes checking for tgetent in -lncurses... no checking for tgetent in -lcurses... no checking for tgetent in -ltermcap... no checking for termcap functions library... configure: error: No curses/termcap library found /usr/bin/ld: cannot find -ltermcap I don't believe this has anything to do with gcc at all. Those errors point to your machine not having the termcap, nor the [n]curses packages installed. You need those for MySQL. And they are not part of gcc. Look for the termcap, libtermcap and ncurses rpms and install those. -- H | Life is the art of drawing without an eraser. - John Gardner + Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 Director of Internet Operations / SysAdmin. 800.441.3873 x130 Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave, #6 http://www.pcraft.com . . .. Boulder, CO 80303, U.S.A. - 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
ODP: how to get a script to run/work
i want to convert my access database to mysql. and then it will run on a linux server if i ever figure out how to run these darn scripts though i downloaded mysql for windows 98. i have tried for a week to run these scripts and even reinstalled mysql and even tried it on another computer with nt4.0. this is where i saved mysql and the title of the script i want to run. C:\mysql\scripts\pet.sql i am sitting at the mysql prompt and i have the server/daemon running in the background. Please exactly what do i type after the mysql prompt?? Well, on mw win machine I would: 1) go to system prompt 2) c:enter 3) cd \mysql\scripts\ 4) start mysql 5) use your_database; 6) \. pet.sql; This should run your script ... - Pawe Szczerba mailto:[EMAIL PROTECTED] +48 603 651 731 - 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 with 3.23.44 and 4.0 alpha post install
I an running Slackware with the 2.4.5 kernel on a Dual PII system. I have run mySQL versions from 3.20.something to 3.23.29 (or so) under kernels from 2.0x-2.2.19 with no real problems. I always compile from source when possible. I have down;oaded the mysql source tarballs for 3.23.44 and 4.0 alpha and have configured and compiled with and without Innodb support using different installation directories and compile flags (my regular set and the recommended set from the Installation hints). I run as root with no mySQL password (single user development). The problem appears after running the mysql_install_db script. When I attempt to start the server using mysql.server or safe_mysqld it starts and shuts down immediately. In the var directory I find mojo.index mojo-bin.001 mojo.err for my server (named mojo) The error file message is always the same (/usr/local/mysql and /local/mysql are the paths I have tried using, shifting to a different disk in case I had bad sectors I didn't know about) e.g. 01 04:07:36 mysqld started \a/local/mysql/libexec/mysqld: File './mojo-bin.1' not found (Errorcode: 13) 01 4:07:36 Could Not use mojo-bin for logging (error13) and then additional lines with similar messages about not being able to create or write or find : the pid file or the frm file or the Innodb data file, etc and then it ends politely. The err file is in the correct place, so I can't imagine I have a permissions problem as root. I was wondering if anyone can help with this. - 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: renaming a database
Hi! Can you rename a database? If so, how does it handle all the tables inside it? By shutting down the server, renaming the directory of that database and restarting the server. The server will be able to handle the change just fine. Sorry, but InnoDB tables do not get renamed inside the internal data dictionary of InnoDB this way. For them currently the way is, for exapmle, to create the tables to the new database and use INSERT INTO new_database.table1 SELECT * FROM old_database.table1. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq Regards, Heikki http://www.innodb.com/ibman.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: Securing username and password in script file
I don't think there is a secure way of running php on a shared server. I have a dedicated server which uses this 'property' to have a single shared php codebase for about 20 domains and subdomains. I looked at ways of securing it but, fundamentally, php under apache runs the same user for everyone, so if anyone can read the config file, everyone can, if they know where it is. Not sure if php under cgi runs as the user. If you could configure the webserver to run as the user (and so different for each domain) rather than nobody this would cure it. Don't know if this is possible. This is a problem which could do with addressing really. Any thoughts anybody? Peter -Original Message- From: Tim Hewitt [mailto:[EMAIL PROTECTED]] Sent: 11 November 2001 01:32 To: [EMAIL PROTECTED] Subject: Securing username and password in script file How does one go about securing database access username and password information that's kept in a script's config file? Most of the PHP and Perl applications floating around Sourceforge, as well as most of the commercially available scripts, store the database access username and password in a config file. This can be called anything, and can be kept either inside or outside the htdocs area on website. It doesn't matter for my example. This file needs to be readable by the process running the web server (typically nobody on Linux shared servers running Apache). Once I know where this file is stored by the application relative to the user's root directory, and it's name, on most if not all the shared server configurations hosting websites around the world, I can simply open the file using the pathname to the file and read and display it, or require it and then display the username and password variables, etc. This of course I'm doing from another user account on the server. In the case of a popular forum script written in PHP, I was able to discover more than one other config file on my server and read it's contents. I notified the owner of the site that I was able to do this, however I had no suggestions for him to protect his information from anyone else who might want to do the same. In a shared server environment where the files must be readable by the webserver process, and there is one web server user on the shared server, how can you protect this information? Are you simply screwed? If so, than much of the world is screwed... Any ideas on how to secure this situation? Thanks, -Tim - 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
MySQL installation problem
Hello! I install MySQL 3.23.43 on SCO Open Server 3.2 v5.0.4 Other software: FSU Pthreads 3.5, gcc 98q2, GNU Make 3.78.1 Output of make execution: gcc -03 -DDBUG_OFF -DSCO -O conf_to_src conf_tosrc.o -lcrypt -lsocket -lm Undefined first referenced symbol in file main /usr/ccs/lib/crt1.o conf_to_src: fatal error: Symbol referencing errors. No output written to conf_to_src ***Error code 1 (bu21) ***Error code 1 (bu21) ***Error code 1 (bu21) May be you are can help me to solve this problem? Thanks. Ivan Ponomariov. - 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: Large MySQL setup
Aaron Williams wrote : Joseph Bueno wrote: Hi, If you run a single query, MySQL will use only one processor. MySQL multithreading allows you to run multiple queries in parallel, one query per thread. Right, that I understand. Even while running up to 30 queries it pegs the first CPU at max, and no other CPUs are getting any data to process. Have you identified your bottleneck (CPU, filesystem I/O, swapping) ? At this point, it is the CPU. Running a constant iostat -dxz 2 to show disk usage, it is near zero for most of the time. It will occasionally jump up a bit briefly, but nothing near what would be causing a bottleneck. What does 'mysqladmin extended-status' tell you ? (Allocating 3Gb of key_buffer only makes sense if you really need them). Which part of the extended-status would you like to see? All of it? In response to Bill Adams and to this question: nearly the entire table is indexed. The purpose of this table is to store RADIUS accounting records. The data is inserted into the table once per day, and is then bits of the data are extracted from it in large sections three times per day. The key_buffer, according to the docs, should be 80% of the physical system memory. I was a bit conservative and set it to be 75%.. 3 of 4 gigs. As data is only inserted once, and nearly all of the use of this table is for SELECTing, we indexed nearly all of it for speed reasons. The insert is done by perl scripts called from cron in the middle of the night, so speed, at that point, isn't nearly as important as it is when called by humans during the day hours. Is your query optimized ? What does EXPLAIN tell you ? We just bought this new server last month. Prior to it, we were doing the same queries on a 2x200mhx with 2gigs of ram, with the same RAID setup. So, as you can imagine, the queries themselves are extremely optimized. For several months we tried, and succeeded mostly, at optimizing the scripts and the queries, instead of just throwing more hardware at the problem. It is hard to help you without any details since optimising my.cnf parameters not only depend your hardware configuration but also on your database usage pattern. Ok, you have the hardware configuration, and I have described somewhat of how the database pattern of use is above. But, just to recap everything: Hardware: Sun E4500, 4x400mhz 4 gigs of RAM DotHill 100+ GIG RAID w/ controller, currently getting 16-18 megs per second io. Database setup: MyISAM tables. Roughly 10-13 gig .MYIs (data) Roughly 2-3 gig .MYDs (indexes) About 1 million rows are inserted once per day in the early hours. Tables are rolled into new tables at the beginning of each month. Then, periodically throughout the day SELECTs are run on the data, for all days from the beginning of the month up through and including today. As you might imagine, the queries get slower and slower as the month goes on, which is expected. There are two styles of queries done, a select unique (which has shown to be faster than 'select foo group by foo'.. which goes against the docs, but has proven faster over and over again). The second style is used to just search one day. I use temp tables for this, so it runs really fast already. Again: It is not really the queries I am worried about, but are provided to show the pattern of use. I am very confident with the actual syntax of the queries. My main concern is the my.cnf and why MySQL isn't using the other CPUs on the machine, even with many queries running. In response to Bill Adams: InnoDB might help because it does have row-level locking. Right, we will definitely be looking at InnoDB now that it supports file sizes large enough for us. AFAIK, 3.23.x only supports one CPU per thread/select. Understandable. MySQL is only going to be able to send one query to one CPU, no doubt there. Our problem is that even with 30 queries, MySQL is still only sending them to the first CPU. I appreciate the help so far, and will gladly supply any other information needed to help you narrow down my best options. Also, I mentioned above that select unique is faster than a group by. Another thing I have benchmarked and proven, at least on our setup, that goes against documentation, is with the Perl DBI. While it may be off-topic of this forum, I know many use it with MySQL. fetchrow_array has proven to be faster than fetchrow_arrayref, which, according to the docs, should be faster. Just thought it interesting. You find such stuff when squeezing very last ounce of performance from your software, or at least trying to. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams[EMAIL PROTECTED] Black Raven.com http://www.backraven.com =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Hi, Here is what I understand: your queries are already very optimized, you have already played with
RE: Re: Can't compile 3.23.44 Help
Thanks very much Ashley! It works .. Thanks again. Jose Albert [EMAIL PROTECTED] wrote: I got this result before and compile gcc direct from the source thinking that could be anithing wrong on the rpm gcc that came with redhat but he result is the same. Please anybody has an idea about this error. Any help will be hightly appreciated *last output lines of configure checking if struct dirent has a d_ino member... yes checking whether signal handlers are of type void... yes checking for tgetent in -lncurses... no checking for tgetent in -lcurses... no checking for tgetent in -ltermcap... no checking for termcap functions library... configure: error: No curses/termcap library found /usr/bin/ld: cannot find -ltermcap I don't believe this has anything to do with gcc at all. Those errors point to your machine not having the termcap, nor the [n]curses packages installed. You need those for MySQL. And they are not part of gcc. Look for the termcap, libtermcap and ncurses rpms and install those. -- H | Life is the art of drawing without an eraser. - John Gardner + Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 Director of Internet Operations / SysAdmin. 800.441.3873 x130 Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave, #6 http://www.pcraft.com . . .. Boulder, CO 80303, U.S.A. --- -- 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 mysql-unsubscribe- [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
mysqladmin: error
Hi everybody! I just install mysql-3.23.44 from the source and compiled with gcc- 3.0.2 compiled from the source too. mysql engine works fine but mysqladmin looks like can't find libgcc_s.so.1 , I checked and is right there at '/usr/local/lib/' with all the others. ** This the output message mysqladmin: error while loading shared libraries: libgcc_s.so.1: cannot load shared object file: No such file or directory Have somebody an idea why this utility can not find it? Thanks in advance Jose ALbert - 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 with newbie (mis)understanding of related tables
When you design a couple of tables to be related to one another via keys do you have to manually enter in the key value from the other table? If I have 2 tables, say Table1 and Table2. Table1: Table1_ID Table1_value Table2: Table2_ID Table2_value Table1_ID so that I can relate the tables... when I'm entering data into Table2, do I have to enter in the corresponding value from Table1_ID? Is there a way to tell the database that those two fields are connected, and to just copy the info over??? Confused, Mike - 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 3.23.44 and 4.0 alpha post install
Andrew wrote: I an running Slackware with the 2.4.5 kernel on a Dual PII system. I have run mySQL versions from 3.20.something to 3.23.29 (or so) under kernels from 2.0x-2.2.19 with no real problems. I always compile from source when possible. I have down;oaded the mysql source tarballs for 3.23.44 and 4.0 alpha and have configured and compiled with and without Innodb support using different installation directories and compile flags (my regular set and the recommended set from the Installation hints). I run as root with no mySQL password (single user development). The problem appears after running the mysql_install_db script. When I attempt to start the server using mysql.server or safe_mysqld it starts and shuts down immediately. In the var directory I find mojo.index mojo-bin.001 mojo.err for my server (named mojo) The error file message is always the same (/usr/local/mysql and /local/mysql are the paths I have tried using, shifting to a different disk in case I had bad sectors I didn't know about) e.g. 01 04:07:36 mysqld started \a/local/mysql/libexec/mysqld: File './mojo-bin.1' not found (Errorcode: 13) 01 4:07:36 Could Not use mojo-bin for logging (error13) and then additional lines with similar messages about not being able to create or write or find : the pid file or the frm file or the Innodb data file, etc and then it ends politely. The err file is in the correct place, so I can't imagine I have a permissions problem as root. I was wondering if anyone can help with this. - 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 I found a 'user=mysql' entry in the my.cnf I adapted from the source Support files directory that I had not noticed. I also learned that my shadow file had a mysql user I didn't know about (new addition to the slackware setup now that they include mysql binaries with the install files). I now have mysql (4.0 alpha) running, but I had to add a '--skip-innodb' line to the startup. I get an Error 21 if I allow Innodb to be started. IS there a quick answer to this (like innodb needs to have the user specified somewhere) or will I have to go through all the Innodb documentation? Thanks for any help. - 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: OT: Securing username and password in script file
Hi
This is not really a problem for me now, because I have my own server, and
control who has access. This is a problem on virtual hosting, because
anybody could be on there.
It seems to be standard practice for ISPs to set up php as an Apache module
and leave it to run. I played around and could do directory listings and
all sorts. (I did it to see how secure my files were and wouldn't touch
anybody else's stuff).
I did put it to the ISP (unnamed!) who said they had never heard of it and
didn't believe it had ever been a problem.
In practice few people know about it, and you have to an account on the
server and the time and inclination to explore somebody else's (boring)
files. Beyond that it is a serious vulnerability.
I am working on some software that may be run on shared servers, so I will
look into the suexec (I am only an amateur Apache bod so thanx for that)
Peter
-Original Message-
From: Carl Troein [mailto:[EMAIL PROTECTED]]
Sent: 11 November 2001 14:25
To: [EMAIL PROTECTED]
Subject: Re: OT: Securing username and password in script file
Peter Lovatt writes:
I don't think there is a secure way of running php on a shared server.
If by 'shared' you mean that you have users, then there is a very
good way of doing it. Assuming that you use apache, have a look
at the suexec wrapper.
I looked at ways of securing it but, fundamentally, php under
apache runs
the same user for everyone, so if anyone can read the config
file, everyone
can, if they know where it is.
Ouch. Are your users aware of this? If you use suexec you could tell
them to make sure that they chmod config files to 600. The only
disadvantage of using suexec with php, is that you'll have to run
php as cgi, which means that you'll need shebangs ('#!') in your
files and make them executable and stuff, but it's not that big a
deal usually. There are cases where you're better off with the
module, but security-wise suexec can be better.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
-
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: mysqladmin: error
[EMAIL PROTECTED] writes: mysqladmin: error while loading shared libraries: libgcc_s.so.1: cannot load shared object file: No such file or directory Make sure /usr/local/lib is in your /etc/ld.so.conf, and then run ldconfig. Another solution is to have LD_LIBRARY_PATH include that directory. Have a look at the man page for ldconfig or search the web for LD_LIBRARY_PATH if you want to know more about them. //C - learning -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: help with newbie (mis)understanding of related tables
mbb writes: When you design a couple of tables to be related to one another via keys do you have to manually enter in the key value from the other table? [...] so that I can relate the tables... when I'm entering data into Table2, do I have to enter in the corresponding value from Table1_ID? Is there a way to tell the database that those two fields are connected, and to just copy the info over??? Well, there's absolutely no way for the database to know to what row in table1 the row in table2 should be connected unless you tell it. Thus, you must tell it. It's only one little number after all, at least as long as you use some form of INT for your primary keys. //C - hopes everything is clearer than his sinuses -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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 3.23.44 and 4.0 alpha post install
Hi! Andrew wrote: I an running Slackware with the 2.4.5 kernel on a Dual PII system. I have run mySQL versions from 3.20.something to 3.23.29 (or so) under kernels from 2.0x-2.2.19 with no real problems. I always compile from source when possible. I have down;oaded the mysql source tarballs for 3.23.44 and 4.0 alpha and have configured and compiled with and without Innodb support using different installation directories and compile flags (my regular set and the recommended set from the Installation hints). I run as root with no mySQL password (single user development). The problem appears after running the mysql_install_db script. When I attempt to start the server using mysql.server or safe_mysqld it starts and shuts down immediately. In the var directory I find mojo.index mojo-bin.001 mojo.err for my server (named mojo) The error file message is always the same (/usr/local/mysql and /local/mysql are the paths I have tried using, shifting to a different disk in case I had bad sectors I didn't know about) e.g. 01 04:07:36 mysqld started \a/local/mysql/libexec/mysqld: File './mojo-bin.1' not found (Errorcode: 13) 01 4:07:36 Could Not use mojo-bin for logging (error13) and then additional lines with similar messages about not being able to create or write or find : the pid file or the frm file or the Innodb data file, etc and then it ends politely. The err file is in the correct place, so I can't imagine I have a permissions problem as root. I was wondering if anyone can help with this. - 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 I found a 'user=mysql' entry in the my.cnf I adapted from the source Support files directory that I had not noticed. I also learned that my shadow file had a mysql user I didn't know about (new addition to the slackware setup now that they include mysql binaries with the install files). I now have mysql (4.0 alpha) running, but I had to add a '--skip-innodb' line to the startup. I get an Error 21 if I allow Innodb to be started. IS there a quick answer to this (like innodb needs to have the user specified somewhere) or will I have to go through all the Innodb documentation? Thanks for any help. --- I tried perror 21 on Linux: heikki@donna:~/mysql-max-3.23.44-pc-linux-gnu-i686/bin perror 21 Error code 21: Is a directory heikki@donna:~/mysql-max-3.23.44-pc-linux-gnu-i686/bin Maybe you have created a directory wihich conflicts with the innodb data file name ibdata1? Regards, Heikki http://www.innodb.com/ibman.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
Account Management Question
I've read over the section in the manual that covers grant/revoke but I still have a question. I want to make sure I'm not assuming anything before I start messing with 12000 user accounts. If I create a user by issuing: GRANT select, insert, update, delete, index, alter, create, drop ON somedatabase.* TO 'theuser'@'%' IDENTIFIED BY 'somepassword' and then subsequently revoke their rights (to temporarily suspend access to the db) REVOKE all on somedatabase.* from 'theuser'@'%' Can I then re-enable their account by issuing: GRANT select, insert, update, delete, index, alter, create, drop ON somedatabase.* TO 'theuser'@'%' Will this leave their old password intact? Regards, Gary SuperID Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - 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 reset the server-id
Hi! Paul == Paul Chilson [EMAIL PROTECTED] writes: Paul I am setting up a replication slave. Paul Master is server-id = 1 Paul Slave is server-id = 2 Paul Relevant section of /etc/my.cnf from the slave cut Paul My guess as to the problem: Paul ./mysqladmin variables reports the slave as being server-id = 1 Paul No matter what I can't change it. Paul Permissions have been checked and double checked. Paul Have been all around the globe on this one and can't figure it. Paul Master is running MySql version 3.23.34 Paul Slave is running MySql version 3.23.37 cut Paul All indications are that the setup is correct but no updates happen. I am Paul left to believe the server-id problem is causing this to not work. Paul I understand that the server-id's need to be different on the master and the Paul slave. Paul On a test system at home when I change the server-id and restart the server Paul the change takes. This test system is running MySql 3.23.43 Please upgrade your master from www.mysql.com; This is probably an incompatibility in the server protocol between the different versions. (We try to keep the protocol compatible but we have had to do a couple of small changes in the protocol to fix bugs in replication). Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.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
New fork of MySQL
Hi! DownloadFAST == DownloadFAST com [EMAIL PROTECTED] writes: DownloadFAST I have not read the MySQL license in detail. DownloadFAST Does it allow someone or a group to start another fork of the source that DownloadFAST is independent from the current developers? Yes, you are allowed to do a fork. You should however be aware of that it's normally a terrible idea to do a fork a successful GPL project and it will normally hurt the total project more than the benefit you get from it. As we here at MySQL AB work actively with the open source community and are not in the habit of rejecting patches, I don't see any reasons for doing a fork. Could you be kind and explain why you think a fork is necessary and what benefits this would bring you compared to the current situation ? DownloadFAST If yes, is any one else interested in starting a fork in which the primary DownloadFAST goal would be to improve the smaller todos and performance for small sites DownloadFAST (the majority who use MySQL)? I don't see how a fork would help you do that. It's much better to have a coordinate MySQL development to avoid that no one does duplicated work and also to ensure the quality of the server code. We here at MySQL AB are constantly working on adding new features to MySQL that is improving performance and stability for all MySQL users. We also have a open development model that allows anyone to take part of our development plan and also help us with things that they feel are important from them. If you really want to help with MySQL development, then the right way to do this is to email what you want to do and suggestions of how you plan to do this to [EMAIL PROTECTED] All core MySQL developers are on this list and we are actively responding to all emails that are sent to this lists with suggestions and new ideas. If you want to get your changes into the main MySQL version, you have to ensure that you don't break any existing code and that your patch doesn't tie our hands of how we want to do things into the future. You also have to get MySQL AB a shared copyright of the code. Up to date, very few patches of additions to MySQL has been reject (Some has been totally rewritten to better fit MySQL, but that is another story...) DownloadFAST It seems to me that the direction of MySQL is now heading more towards big DownloadFAST sites given the features in 4.0. We think that most MySQL users will greatly benefit from all features that we are adding to MySQL. What features on our todo are not interesting to you? We have 10+ developers that are actively working on extending MySQL in a lot of different ways. We are constantly adding both small and big features to MySQL, according to what our users (both paying and not paying) wants to have in MySQL. From where did you get the idea that we are only working on the MySQL 4.0 TODO and not paying attention of all other things that we have on our todo ? Have you every thought that there is a reason for why we do things in a certain order? (The answer is that if you do things in the right order, you don't have to recode everything when the underlying things changes) The reason we haven't done not DEFAULT checking in MYSQL yet are: a) Not many of the MySQL users have found this important. b) This will be much easier to do when we have done the basic changes we are doing in 4.0 You don't seem to have understood that 4.0 is mainly a format change release to make it easier to do the rest of the things we have on out TODO (like adding DEFAULT checking in a way that it doesn't cause problems with old MySQL applications) Could you please specify more explicitely which features you are interested in having in MySQL? DownloadFAST Since people in this list have challenged me, I have decided it would be DownloadFAST best to rise to their challenge and create a whole other fork if possible. No one I know of has challenged you to do a fork. It has come to my attention that some people has suggested that you should yourself add things that you require from MySQL into the MySQL source. This doesn't however in anyway implicate a fork, but instead that you should help the MySQL team with their work. I suggest you read Eric Raymonds books to understand the value of keeping open source project coordinated. DownloadFAST I also think we could create a community that is more tolerant of ideas and DownloadFAST dissent. We are MySQL AB are always ready to accept reasonable patches. What more can you ask from us ? DownloadFAST Again my proposal would be for a very small community of core developers, DownloadFAST and for a very narrow focus of basically taking the stable 3.23 release and DownloadFAST merely refining it. And try to make a product to sell for profit which DownloadFAST would be more targetted towards the newbie user who wants to pay $100 for a DownloadFAST database for his web site. And the core developers would share the DownloadFAST profits. We would
Fwd: [PHP] might be bugs on PHP 4.06 or mySQL 4.0
-- Forwarded Message -- Subject: [PHP] might be bugs on PHP 4.06 or mySQL 4.0 Date: Fri, 9 Nov 2001 13:37:32 -0500 From: Yamin Prabudy [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED], PHP [EMAIL PROTECTED] Hi there, I just try to install mySQL 4.0 then i install PHP, seems like somethings aint right,...i can do make install and there is error..upss sorry i forget about the error but it say about some unknow module on mysql then i change to mySQL 3.23.44 everything is OK did anyone success on insalling mySQL 4.0 and PHP 4.06 who know is me that mess up on installing Best Regards Yamin Prabudy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [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
How to Run SQL Commands from a Text File stably?
Hi, Buddies:
I used perl to run sql commands from a Text file, it always can't finish
totally and report error in unstable lines .
The error report that sql syntax error, but the syntax is same, just same,
and many sql lines;
Would you please tell me what this happen and how to resolve it?
Thanks in Advance!
Bill
PERL COMMANDS: system('mysql -uusername -ppassword database
pricfile.sql');
if pricfile.sql has 37871 lines sql commands like
update products set retail=43.00 where partno='123456';
then the perl program give
ERROR 1064 at line 37850: You have an error in your SQL syntax near
''99922' at line 1
if pricfile.sql has 1 lines, then the perl program give
ERROR 1064 at line 19932: You have an error in your SQL syntax near '' at
line 1
if pricfile.sql has 17872 lines sql commands like, then the perl program
give
ERROR 1064 at line 17848: You have an error in your SQL syntax near '' at
line
-
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
Benchmarking Tools for MYSQL
Does anyone know of any well-known Benchmarking tools for MYSQL database? Thanks S.M. - 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: Cannot add blob data to innodb table
Stephen, Hi, I have an Access97 table containing binary fields (gifs) that I would like to migrate to an innodb format via MyODBC (2.50.39) and MySQL-Max (3.23.44). The MySQL query log shows binary-like characters being received but there never seems to be progression to the next record. After 5 or so minutes, the append query in Access97 quits and an ODBC error window complaining about a lost connection pops-up. When I convert the table to myisam type, the append query works. Is there something in my.cnf I need to adjust to fix thisproblem? inserting binary BLOBs should work. What is an 'append' query in MS Access? Is it translated to an INSERT in MySQL? Could you paste a copy of what the MySQL query logs shows? How big is the BLOB? What is the CREATE TABLE statement? Note that a BLOB bigger than 64 kB needs to be defined a MEDIUMBLOB or LONGBLOB in the CREATE TABLE statement. If you try inserting an ASCII text file does that work? How big you have set max_allowed_packet in my.cnf? That restricts the size of rows communicated from a client to the server. Thanks, Stephen Regards, Heikki http://www.innodb.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: Cannot add blob data to innodb table
Steve, Date: Mon, 12 Nov 2001 08:52:54 To: [EMAIL PROTECTED] From: Heikki Tuuri [EMAIL PROTECTED] Subject: Re: Cannot add blob data to innodb table Stephen, Hi, I have an Access97 table containing binary fields (gifs) that I would like to migrate to an innodb format via MyODBC (2.50.39) and MySQL-Max (3.23.44). The MySQL query log shows binary-like characters being received but there never seems to be progression to the next record. After 5 or so minutes, the append query in Access97 quits and an ODBC error window complaining about a lost connection pops-up. When I convert the table to myisam type, the append query works. Is there something in my.cnf I need to adjust to fix thisproblem? inserting binary BLOBs should work. What is an 'append' query in MS Access? Is it translated to an INSERT in MySQL? Could you paste a copy of what the MySQL query logs shows? How big is the BLOB? What is the CREATE TABLE statement? Note that a BLOB bigger than 64 kB needs to be defined a MEDIUMBLOB or LONGBLOB in the CREATE TABLE statement. If you try inserting an ASCII text file does that work? How big you have set max_allowed_packet in my.cnf? That restricts the size of rows communicated from a client to the server. Thanks, Stephen Regards, Heikki http://www.innodb.com actually, are you running MySQL on Windows? Then the problem might be the bug introduced in 3.23.42: to access InnoDB tables you must use the same case of letters in the database name as you used in the CREATE TABLE statement. Make sure you consistently use lower case in database names. The bug is fixed in upcoming 3.23.45. Does mysql.err contain anything? Regards, Heikki - 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
Need to understand mysql mechanisms
I am sending this mail in order to get things straight about table corruption which I am experiencing with 4.0(as well as previous versions). 1)System specs: PIII x1000MHz, 1GB RAM, HD 37GB SCSI, AHA29160N SCSI controller 2) Database MyISam tables, BUT 21000 tables in the database(this is for performance reasons. I need for each such table to run a number of queries and in this way I already have 'VIEWS', except they are permament). I could split that in 4 different databases if it is a problem. 3) I import the data from mysqldumps(that is, the program that reads the data does not directly import them in the database, partly because of the corruption problems, but also partly because I want backups anyway and instead produces files that are importable just like mysqldumps. These files are of the form 'INSERT INTO TABLE1 (.);' conceivably for all 21000 tables. I assume corruption happens at the inverse mysqldump phase. Does this mean that if I break up the dump file into many smaller files, so that say one file consists of all imports TABLES1-100, the second files 101-200 etc corruption will not be a problem?? 4) Corruption is a tossup. The import always works. However, when I run the queries sometimes they all run fine, while other times I get an error 127 on the table it is working on. myisamchk NEVER manages a complete recovery of all records(typically 25% of the records). This makes it hard to tell for sure if this has anythingto do with the size of data imported, since the more files I import the larger the probability of having corruption. I have had corruption on a single import too though. 5)Before writing a bug report(the problem may be that this is erratic and even on my PC corruption is not consistent, e.g. I may import a file and get corruption, or I may import another file without corruption) and hence reproducibility may be problematic., I would appreciiate someone setting me straight on the filedescriptor issues(thanks Sinisa thus far): -It is not clear to me if the problem may be that when mysql is importing data, it may be having more files open than it(or the fs-reiser in this case) can handle. Could this be the reason for (table)corruption? -If so, accordingto the manual, there are 2 ways around: either decrease table_cache in /etc/my.cnf (currently 512) which however may also affect performance as I have a lot of tables or increase ulimit/open-files-limit -The question on this first option(table_cache) is: if now I have 2000 open files and reduce the cache to 256 does it mean I will be getting half the open files? -Regarding the more desirable option of increasing the limit, are the two ways equivalent(that is, does open- file-limit call ulimit?) Is changing either of them enough , or-as I assume does one really have to change ulimit? -I have a ulimit -a limit giving a 1024 open file limit while cat /proc/sys/fs/file-nr gives a hard limit of 8192. However, the man page says the system may not allow you to change ulimit I did a ulimit -n 8192 as root then ulimit -a limit says 8192 but when I open a window as a regular user, and do ulimit -a limit it is still 1024. Rebooting comes back with 1024 Is it at all possible to change it? -Also, if I can/have to change open-files-limit, do I need to do it in /etc/my.cnf /usr/bin/mysqld_safe /both? Last, I have a start_Mysql=yes in rc.config but in contrast to other systems used mysql, mysql does not start when the system boots. Any ideas why? Sorry for the many questions. Thanks in advance S.Alexiou - 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
C IDE for Windows...........?
Hi... I'm new to MySQL. I can play it by ODBC connectivity using JDBC-ODBC bridge. But I want to write code in C using MySQL native C-APIs. One reason for me to switch to MySQL is its C-APIs. I've been using Borland Turbo C/C++ 3.0 for a long time on DOS/Windows OS. When I try to include MySQL headers, it throws errors...which I guess is the problem of long header file names (not complaint with DOS 8.3 file name convention). I'm in search of an IDE that can support MySQL and that should not be much different from the one I'm used to. Could anybody help me out Cheers.. Ali - 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: C IDE for Windows...........?
Hi At 10:46 12/11/2001 +, Syed Ali Dost wrote: Hi... I'm new to MySQL. I can play it by ODBC connectivity using JDBC-ODBC bridge. But I want to write code in C using MySQL native C-APIs. One reason for me to switch to MySQL is its C-APIs. I've been using Borland Turbo C/C++ 3.0 for a long time on DOS/Windows OS. When I try to include MySQL headers, it throws errors...which I guess is the problem of long header file names (not complaint with DOS 8.3 file name convention). I'm in search of an IDE that can support MySQL and that should not be much different from the one I'm used to. Could anybody help me out #include windows.h before #include mysql.h Cheers.. Ali - 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: How to Run SQL Commands from a Text File stably?
12/11/2001 05:32:28, PI Xu [EMAIL PROTECTED] wrote:
Hi, Buddies:
I used perl to run sql commands from a Text file, it always can't finish
totally and report error in unstable lines .
The error report that sql syntax error, but the syntax is same, just same,
and many sql lines;
Would you please tell me what this happen and how to resolve it?
Thanks in Advance!
Bill
PERL COMMANDS: system('mysql -uusername -ppassword database
pricfile.sql');
if pricfile.sql has 37871 lines sql commands like
update products set retail=43.00 where partno='123456';
then the perl program give
ERROR 1064 at line 37850: You have an error in your SQL syntax near
''99922' at line 1
I think you should have a look at the lines 37849 and 37850.
The error could be that the previous one was wrongly terminated,
or the current one has an invalid value.
It could be a problem of unproper quoting.
Having a look at the lines involved could be helpful. How did you produce the file?
Bye
Giuseppe
if pricfile.sql has 1 lines, then the perl program give
ERROR 1064 at line 19932: You have an error in your SQL syntax near '' at
line 1
if pricfile.sql has 17872 lines sql commands like, then the perl program
give
ERROR 1064 at line 17848: You have an error in your SQL syntax near '' at
line
-
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
