PHP MYSQL Admin question
Trying the latest phpMYAdmin on Mac OS X. Everything is set up correct but I get #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) And I am telling config.php where the mysql.sock file is located. Help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
JOomla Administrator
Hello, we are trying to move a Joomla Site and the administrator does nowrk. Using MySQL 5.1.36 on MAC OS X Server. How can I fix this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL Community Server 5.1.35 has been released
On Thu, Jun 04, 2009 at 01:27:34PM -0600, Timothy Smith wrote: Dear MySQL users, MySQL Community Server 5.1.35, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.35 is recommended for use on production systems. For an overview of what's new in MySQL 5.1, please see http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html For information on installing MySQL 5.1.35 on new servers or upgrading to MySQL 5.1.35 from previous MySQL releases, please see http://dev.mysql.com/doc/refman/5.1/en/installing.html MySQL Server is available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ Not all mirror sites may be up to date at this point in time, so if you can't find this version on some mirror, please try again later or choose another download site. We welcome and appreciate your feedback, bug reports, bug fixes, patches, etc.: http://forge.mysql.com/wiki/Contributing For information on open issues in MySQL 5.1, please see the errata list at http://dev.mysql.com/doc/refman/5.1/en/open-bugs.html The following section lists the changes in the MySQL source code since the previous released version of MySQL 5.1. It may also be viewed online at http://dev.mysql.com/doc/refman/5.1/en/news-5-1-35.html Enjoy! Timothy Smith The MySQL build team at Sun Microsystems === This release of MySQL has two known outstanding issues for Windows: * The .msi installer does not detect an existing root password on the initial configuration attempt. To work around this, install and configure MySQL as normal, but skip any changes to security. (There is a checkbox that allows this on the security screen of the configuration wizard.) Then check your settings: + If the old root password and security settings are okay, you are done and can proceed to use MySQL. + Otherwise, reconfigure with the wizard and make any changes on the second configuration attempt. The wizard will properly prompt for the existing root password and allow changes to be made. This issue has been filed as Bug#45200: http://bugs.mysql.com/45200 for correction in a future release. * The Windows configuration wizard allows changes to InnoDB settings during a reconfiguration operation. For an upgrade, this may cause difficulties. To work around this, use one of the following alternatives: + Do not change InnoDB settings. + Copy files from the old InnoDB location to the new one. This issue has been filed as Bug#45201: http://bugs.mysql.com/45201 for correction in a future release. Bugs fixed: * Important Change: Replication: The transactional behavior of STOP SLAVE has changed. Formerly, it took effect immediately, even inside a transaction; now, it waits until the current replication event group (if any) has finished executing, or until the user issues a KILL QUERY or KILL CONNECTION statement. This was done in order to solve the problem encountered when replication was stopped while a nontransactional slave was replicating a transaction on the master. (It was impossible to roll back a mixed-engines transaction when one of the engines was nontransactional, which meant that the slave could not safely re-apply any transaction that had been interrupted by STOP SLAVE.) (Bug#319: http://bugs.mysql.com/319, Bug#38205: http://bugs.mysql.com/38205) See also Bug#43217: http://bugs.mysql.com/43217. * Partitioning: When a value was equal to a PARTITION ... VALUES LESS THAN (value) value other than MAXVALUE, the corresponding partition was not pruned. (Bug#42944: http://bugs.mysql.com/42944) * Replication: Unrelated errors occurring during the execution of RESET SLAVE could cause the slave to crash. (Bug#44179: http://bugs.mysql.com/44179) * Replication: The --slave-skip-errors option had no effect when using row-based logging format. (Bug#39393: http://bugs.mysql.com/39393) * Replication: The following erors were not correctly reported: + Failures during slave thread initialization + Failures while initializing the relay log position (immediately following the starting of the slave thread) + Failures while processing queries passed through the --init_slave option. Information about these types of failures can now be found in the output of SHOW SLAVE STATUS. (Bug#38197: http://bugs.mysql.com/38197) * Replication: Killing the thread executing a DDL statement, after it had finished its execution but before it had written the binlog event, caused the error code in the binlog event to be set
Re: Upgrade Mysql
On Wed, May 20, 2009 at 10:27:51AM +0200, Webmaster Studio Informatica wrote: Hi, I need to upgrade Mysql 4 to Mysql 5 on Linux. I will uninstall version 4 and install version 5. With uninstallation usually database files remain in /var/lib/mysql/ I want to know if with the installation of Mysql 5 those database will be recognized and imported to work with the new version automatically. Thank You. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. Your best path is to If 4.0, Compile 4.1 Follow upgrade procedure If 4.1 Compile 5.0 Follow upgrade procedure If 5.0 Compile 5.1 Follow upgrade procedure. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Problem compiling mysql-5.1.33
make all-am Making all in mysql-test Making all in lib/My/SafeProcess g++ -DHAVE_CONFIG_H -I. -I../../../../include -O3 -fno-implicit-templates -fno-exceptions -fno-rtti -MT safe_process.o -MD -MP -MF .deps/safe_process.Tpo -c -o safe_process.o safe_process.cc In file included from safe_process.cc:48: /usr/include/sys/resource.h:63: field `ru_utime' has incomplete type /usr/include/sys/resource.h:64: field `ru_stime' has incomplete type why is this taking place? Compile options ./configure --prefix=/usr/contrib --localstatedir=/usr/contrib/mysqld --without-innodb --disable-debug --with-ssl=/usr/contrib --enable-thread-safe-client -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
BSD/OS and 5.1
I mean MySQL 5.1 I compile MySQL 5.1.32 and on tests I got gmake -k test cd unittest gmake test gmake[1]: Entering directory `/usr/src/contrib/mysql/mysql-5.1.32/unittest' perl unit.pl run mytap mysys ../storage/archive ../storage/blackhole ../storage/csv ../storage/example ../storage/federated ../storage/heap ../storage/myisam ../storage/myisammrg ../plugin/daemon_example ../plugin/fulltext Running tests: mytap mysys ../storage/archive ../storage/blackhole ../storage/csv ../storage/example ../storage/federated ../storage/heap ../storage/myisam ../storage/myisammrg ../plugin/daemon_example ../plugin/fulltext mytap/t/basic-t..Useless use of string in void context at -e line 1. mytap/t/basic-t.. No subtests run mysys/bitmap-t...Useless use of string in void context at -e line 1. mysys/bitmap-t... No subtests run mysys/base64-t...Useless use of string in void context at -e line 1. mysys/base64-t... No subtests run mysys/my_atomic-tUseless use of string in void context at -e line 1. mysys/my_atomic-t No subtests run Test Summary Report --- mytap/t/basic-t (Wstat: 0 Tests: 0 Failed: 0) Parse errors: No plan found in TAP output mysys/bitmap-t (Wstat: 0 Tests: 0 Failed: 0) Parse errors: No plan found in TAP output mysys/base64-t (Wstat: 0 Tests: 0 Failed: 0) Parse errors: No plan found in TAP output mysys/my_atomic-t (Wstat: 0 Tests: 0 Failed: 0) Parse errors: No plan found in TAP output Files=4, Tests=0, 1 wallclock secs ( 0.07 usr 0.10 sys + 0.00 cusr 0.10 csys = 0.27 CPU) Result: FAIL Failed 4/4 test programs. 0/0 subtests failed. gmake[1]: *** [test] Error 255 gmake[1]: Leaving directory `/usr/src/contrib/mysql/mysql-5.1.32/unittest' gmake: *** [test-unit] Error 2 cd mysql-test ; \ /usr/bin/perl ./mysql-test-run.pl --mysqld=--binlog-format=mixed Logging: ./mysql-test-run.pl --mysqld=--binlog-format=mixed 090310 10:53:13 [ERROR] Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 090310 10:53:13 [ERROR] Aborting mysql-test-run: *** ERROR: Could not find version of MySQL gmake: *** [test-ns] Error 1 cd mysql-test ; \ /usr/bin/perl ./mysql-test-run.pl --ps-protocol --mysqld=--binlog-format=row Logging: ./mysql-test-run.pl --ps-protocol --mysqld=--binlog-format=row 090310 10:53:14 [ERROR] Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 090310 10:53:14 [ERROR] Aborting mysql-test-run: *** ERROR: Could not find version of MySQL gmake: *** [test-pr] Error 1 gmake: Target `test' not remade because of errors. Is this safe to deploy or are patches going to be needed? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Conficker
Does anyone know if Conficker is suppose to affect MySQL? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Odd error
Customer has tested his site in Mysql 5.1 and we are running Mysql 4.1 . His test works but over here we get: Warning: DOMDocument::__construct() [function.DOMDocument---construct]: Malloc(88) in /usr/home/vesna/html/pryvit/church_maps/data_genxml.php on line 5 Warning: DOMDocument::__construct() [function.DOMDocument---construct]: Malloc(88) Ok in /usr/home/vesna/html/pryvit/church_maps/data_genxml.php on line 5 Warning: DOMDocument::__construct() [function.DOMDocument---construct]: Malloc(4) in /usr/home/vesna/html/pryvit/church_maps/data_genxml.php on line 5 Warning: DOMDocument::__construct() [function.DOMDocument---construct]: Malloc(4) Ok in /usr/home/vesna/html/pryvit/church_maps/data_genxml.php on line 5 Warning: DOMDocument::__construct() [function.DOMDocument---construct]: Malloc(6) in /usr/home/vesna/html/pryvit/church_maps/data_genxml.php on line 5 Warning: DOMDocument::__construct() [function.DOMDocument---construct]: Malloc(6) Ok in /usr/home/vesna/html/pryvit/church_maps/data_genxml.php on line 5 Warning: DOMDocument::createElement() [function.DOMDocument-createElement]: Malloc(60) in /usr/home/vesna/html/pryvit/church_maps/data_genxml.php on line 7 Warning: DOMDocument::createElement() [function.DOMDocument-createElement]: Malloc(60) Ok in /usr/home/vesna/html/pryvit/church_maps/data_genxml.php on line 7 Warning: DOMDocument::createElement() [function.DOMDocument-createElement]: Malloc(8) in /usr/home/vesna/html/pryvit/church_maps/data_genxml.php on line 7 Warning: DOMDocument::createElement() [function.DOMDocument-createElement]: Malloc(8) Ok in /usr/home/vesna/html/pryvit/church_maps/data_genxml.php on line 7 Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'vesna'@'localhost' (using password: YES) in /usr/home/vesna/html/pryvit/church_maps/data_genxml.php on line 13 Not connected : Access denied for user 'vesna'@'localhost' (using password: YES) Warning: Unknown: Freed(8) Ok in Unknown on line 0 Warning: Unknown: Freed(60) Ok in Unknown on line 0 Warning: Unknown: Freed(4) Ok in Unknown on line 0 Warning: Unknown: Freed(6) Ok in Unknown on line 0 Warning: Unknown: Freed(88) Ok in Unknown on line 0 The username and password are correct. What could be the problem? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Maximizing number of connections per client session
REcently my mysql server has been overload with a lot of connections; in fact losing the mysql.user table and one whole database. How can this be prevented? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Suddenly : mysqld: Can't create/write to file PID
I am suddenly seeing this in my error log: 070418 08:43:57 mysqld started 070418 8:43:57 [ERROR] /usr/contrib/libexec/mysqld: Can't create/write to file '/usr/contrib/var/doctor.nl2k.ab.ca.pid' (Errcode: 13) 070418 8:43:57 [ERROR] Can't start server: can't create PID file: Undefined error: 0 070418 08:43:57 mysqld ended HOw is this fixed? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Suddenly : mysqld: Can't create/write to file PID
On Wed, Apr 18, 2007 at 12:42:56PM -0500, Gerald L. Clark wrote: Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: I am suddenly seeing this in my error log: 070418 08:43:57 mysqld started 070418 8:43:57 [ERROR] /usr/contrib/libexec/mysqld: Can't create/write to file '/usr/contrib/var/doctor.nl2k.ab.ca.pid' (Errcode: 13) 070418 8:43:57 [ERROR] Can't start server: can't create PID file: Undefined error: 0 070418 08:43:57 mysqld ended HOw is this fixed? The mysql user must have execute and write privilege on /usr/contrib/var and all subdirectories. Fixed. Also Gerald for your information. SpamCheck: spam, SpamAssassin (not cached, score=13.112, required 5, BOTNET 5.00, BOTNET_CLIENT 0.00, BOTNET_CLIENTWORDS 0.00, BOTNET_IPINHOSTNAME 0.00, FH_HOST_EQ_D_D_D_D 1.99, RDNS_DYNAMIC 0.10, RELAY_CHECKER 6.00, RELAY_CHECKER_IPHOSTNAME 0.01, RELAY_CHECKER_KEYWORDS 0.01) -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrade issue
On Mon, Oct 23, 2006 at 01:49:14PM +0100, Ben Clewett wrote: MySQL, I am trying to upgrade from 4.1 to 5.1. Your manual states I should run mysql_upgrade. But there is no such program in our pre-compiled binary, only a man page! $ find . -name mysql_upgrade* ./mysql-5.1.11-beta-aix5.2-powerpc-64bit/man/man1/mysql_upgrade.1 However the on-line manual states the follows does the same thing: $ mysqlcheck --check-upgrade --all-databases --auto-repair $ mysql_fix_privilege_tables Is this safe? I only ask because the last time I tried to upgrade, MySQL core-dumped every few minutes when an unknown user connected. So I am looking at every incontinuity to try and work out if this is the reason. Thanks for any help, Ben Clewett. Go from 4.1 to 5.0 to 5.1 . This is safer. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Drupal and MySQL
Has anyone heard of drupal breaking under a minor upgrade from Mysql 4.1.1X to 4.1.2X ? I have a weird one. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Drupal and MySQL
On Thu, Aug 31, 2006 at 09:52:37AM +1000, Colin Charles wrote: Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: Has anyone heard of drupal breaking under a minor upgrade from Mysql 4.1.1X to 4.1.2X ? MySQL 4.1.18 to 4.1.21 No, upgrading between versions should be OK. Want to provide the exact version numbers, in the /rare/ event that the ABI broke (which really shouldn't affect Drupal, unless PHP itself is to be blamed) PHP 5.0.5 -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http://forge.mysql.com/ -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Compiling MySQL to work with OpenSSL
Question, I specify with openssl is with --wth-openssl=/usr/contrib and the config script chokes. What is this happening? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Chemistry search
On Thu, Aug 24, 2006 at 12:43:56AM -0400, Rhino wrote: - Original Message - From: Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, August 23, 2006 10:15 PM Subject: Chemistry search Has anyone come up with searching a chemicals based database using mols or smilies? Huh? What do you mean by mols - molar weights? And why would anyone search for anything to do with chemicals based on smilies? How would :-) or symbols like that help? Or is this some other sense of the word smilies than the customary Internet one? mols and sils are acepted XML chemical formats! Please look up Chemical MArkup Language. -- Rhino -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.11.5/425 - Release Date: 2006-08-22 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Chemistry search
Has anyone come up with searching a chemicals based database using mols or smilies? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Search Engine type search
On Tue, Aug 22, 2006 at 10:42:52AM +, Neil Tompkins wrote: On my website I'm looking to add a search box. I have a number of different database fields. Does anyone have any recommendations about how I can perform a search engine type search including the text fields. Have you looked at for exampole mnogosearch? Regards Neil _ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: non-text data
On Mon, Aug 14, 2006 at 02:29:41PM +1000, Chris wrote: Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: On Mon, Aug 14, 2006 at 10:42:50AM +1000, Chris wrote: Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: I use SELECT all from * ... and one row is a gif. How do I get that gif to appear as a gif and not text? In your connecting programming language. Mysql doesn't know or care whether it's a gif, pdf, word doc or anything else. Whatever programming language you are using to connect to mysql and fetch the data will be able to convert that binary data and display an image. PHP? http://www.php.net/gd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. All right, so how would one set up a select where rows 1 and 2 are text and row 3 is a blob and for argument sake assume jpg for the moment. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: non-text data
On Mon, Aug 14, 2006 at 10:42:50AM +1000, Chris wrote: Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: I use SELECT all from * ... and one row is a gif. How do I get that gif to appear as a gif and not text? In your connecting programming language. Mysql doesn't know or care whether it's a gif, pdf, word doc or anything else. Whatever programming language you are using to connect to mysql and fetch the data will be able to convert that binary data and display an image. PHP? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
non-text data
I use SELECT all from * ... and one row is a gif. How do I get that gif to appear as a gif and not text? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help !!!!
Please help to compile !!! My system is Solaris 5.9 i`m instal OpenSSl and now i wish compile MySQL with him : ./configure --prefix=/opt/mysql --with-mysqld-user=mysql --with-openssl --with-openssl-includes=/usr/local/ssl/include --with-openssl-libs=/usr/local/ssl/lib --with-extra-charsets=complex make . if gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../include -I/usr/local/ssl/include -O3 -DDBUG_OFF-D_FILE_OFFSET_BITS=64 -DHAVE_RWLOCK_T -MT test-ssl.o -MD -MP -MF .deps/test-ssl.Tpo -c -o test-ssl.o test-ssl.c; \ then mv -f .deps/test-ssl.Tpo .deps/test-ssl.Po; else rm -f .deps/test-ssl.Tpo; exit 1; fi /bin/bash ../libtool --preserve-dup-deps --mode=link gcc -O3 -DDBUG_OFF -D_FILE_OFFSET_BITS=64 -DHAVE_RWLOCK_T-o test-ssl test-ssl.o ../dbug/libdbug.a libvio.a ../mysys/libmysys.a ../strings/libmystrings.a -L/usr/local/ssl/lib -lssl -lcrypto -lpthread -lthread -lposix4 -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread mkdir .libs gcc -O3 -DDBUG_OFF -D_FILE_OFFSET_BITS=64 -DHAVE_RWLOCK_T -o test-ssl test-ssl.o ../dbug/libdbug.a libvio.a ../mysys/libmysys.a ../strings/libmystrings.a -L/usr/local/ssl/lib -lssl -lcrypto -lpthread -lthread -lposix4 -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread Undefined first referenced symbol in file dlsym /usr/local/ssl/lib/libcrypto.a(dso_dlfcn.o) (symbol belongs to implicit dependency /usr/lib/libdl.so.1) dlopen /usr/local/ssl/lib/libcrypto.a(dso_dlfcn.o) (symbol belongs to implicit dependency /usr/lib/libdl.so.1) dlclose /usr/local/ssl/lib/libcrypto.a(dso_dlfcn.o) (symbol belongs to implicit dependency /usr/lib/libdl.so.1) dlerror /usr/local/ssl/lib/libcrypto.a(dso_dlfcn.o) (symbol belongs to implicit dependency /usr/lib/libdl.so.1) ld: fatal: Symbol referencing errors. No output written to test-ssl collect2: ld returned 1 exit status *** Error code 1 make: Fatal error: Command failed for target `test-ssl' Current working directory /export/home/mor/mysql-4.1.12/vio *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /export/home/mor/mysql-4.1.12 *** Error code 1 make: Fatal error: Command failed for target `all' # # crle Configuration file [version 4]: /var/ld/ld.config Default Library Path (ELF): /usr/lib:/usr/local/ssl/lib:/usr/local/lib Trusted Directories (ELF):/usr/lib/secure (system default) Command line: crle -c /var/ld/ld.config -l /usr/lib:/usr/local/ssl/lib:/usr/local/lib System mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Openssl 0.9.8 and Mysql
Will MySQL 4.0 + bt OpenSSL 0.9.8 compliant? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: No Longer Receiving Emails
On Fri, May 27, 2005 at 08:48:38PM +0200, Rob Cochrane wrote: Works Rob Tucker, Gabriel wrote: Hi I have not received anything from this list for a couple of days. I just tried to re-register, and that did not help. If anyone reads this, please reply to ME so I can determine if the problem is with my account or with the list. Thanks Gabe There are no problems, only solutions. Gabe Tucker Bloomberg LP (609) 750 6668 - P (646) 268 5681 - F -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Check your spam restrictions with your ISP. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 table or 2?
I am trying to set up a chem structures table. column 1 is the key, column 2 is the description, column 3 is the structure which is a blob. In PHP the first 2 columns comes out as text as expected, but the 3rd I am trying to tell PHP please ignore this initially since this is a blob. Should I be using 1 or 2 tables? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PArtial help needed
I was able to set up a table no problem. On one of the blobs, it is coming up on the web page like a mess and not like an interpreted object as one would expect. Using Mysql 3.23.58 with php 4.3.9 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Setting up a Chemical database
I have a customer who has sent my close to 300 chemical products in word format? How do I translate this into mysql tables? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql_fix_privilege_tables again
On Sat, Oct 02, 2004 at 08:25:49PM -0500, Paul DuBois wrote: At 16:31 -0600 10/2/04, Dave Shariff Yadallee - System Administrator a.k.a. The Root wrote: New error WITH password implemented: Apparently the ownership of the mysql database and/or the files in it is not set such that the files are accessible to the Unix account that you're using to run mysqld. For example, perhaps you're running the server as the mysql login user, but the files are owned by root. That's a common problem. Here is an ls -Fail or the mysql directory and the one above it: Script started on Sun Oct 3 06:06:54 2004 doctor.nl2k.ab.ca//usr/contrib/var/mysql$ ls -Fail total 160 7301121 drwx-- 2 mysql wheel 512 Oct 3 06:06 ./ 5904388 drwxr-xr-x 77 root wheel 2048 Oct 2 16:11 ../ 7301139 -rw-rw 1 mysql wheel 274 Jun 11 2003 columns_priv.MYD 7301138 -rw-rw 1 mysql wheel 3072 Jun 11 2003 columns_priv.MYI 7301137 -rw-rw 1 mysql wheel 8778 Jun 11 2003 columns_priv.frm 7301124 -rw-rw 1 mysql wheel 1963 Jun 11 2003 db.MYD 7301123 -rw-rw 1 mysql wheel 3072 Jun 11 2003 db.MYI 7301122 -rw-rw 1 mysql wheel 8982 Jun 11 2003 db.frm 7301133 -rw-rw 1 mysql wheel 0 Jun 11 2003 func.MYD 7301132 -rw-rw 1 mysql wheel 1024 Jun 11 2003 func.MYI 7301131 -rw-rw 1 mysql wheel 8641 Jun 11 2003 func.frm 7301127 -rw-rw 1 mysql wheel 0 Jun 11 2003 host.MYD 7301126 -rw-rw 1 mysql wheel 1024 Jun 11 2003 host.MYI 7301125 -rw-rw 1 mysql wheel 8958 Jun 11 2003 host.frm 7301136 -rw-rw 1 mysql wheel 1140 Jun 11 2003 tables_priv.MYD 7301135 -rw-rw 1 mysql wheel 3072 Jun 11 2003 tables_priv.MYI 7301134 -rw-rw 1 mysql wheel 8877 Jun 11 2003 tables_priv.frm 7301372 -rw-r--r-- 1 root wheel 0 Oct 3 06:06 typescript 7301130 -rw-rw 1 mysql wheel 4387 Aug 9 08:59 user.MYD 7301129 -rw-rw 1 mysql wheel 2048 Aug 9 08:59 user.MYI 7301128 -rw-rw 1 mysql wheel 9148 Jun 11 2003 user.frm doctor.nl2k.ab.ca//usr/contrib/var/mysql$ ls -Fail .. total 19150 5904388 drwxr-xr-x 77 root wheel 2048 Oct 2 16:11 ./ 376960 drwxr-xr-x 23 root wheel 512 Oct 3 05:49 ../ 5904389 -rwx-- 1 mysql wheel 724529 Jun 11 2003 020607* 5975817 drwx-- 2 mysql wheel 512 Apr 18 2003 111/ 8043141 drwx-- 2 mysql wheel 512 Jul 5 18:04 ParticipatoryDemocracy/ 8027270 drwx-- 2 mysql wheel 1536 Oct 2 15:01 TMGDATA/ 5979790 drwx-- 2 mysql wheel 512 Oct 2 14:55 addata/ 5983752 drwx-- 2 mysql wheel 4096 Oct 2 14:55 adriannos/ 6015506 drwx-- 2 mysql wheel 512 Oct 2 14:55 avena/ 6019462 drwx-- 2 mysql wheel 512 Oct 2 14:55 banner/ 6023438 drwx-- 2 mysql wheel 512 Apr 18 2003 bargainboyz/ 6027402 drwx-- 2 mysql wheel 512 Oct 2 14:55 bezko/ 6031365 drwx-- 2 mysql wheel 512 Oct 2 14:55 blueflower/ 7440009 drwx-- 2 mysql wheel 512 Oct 2 14:58 busdir/ 6039305 drwx-- 2 mysql wheel 4608 Oct 2 14:55 catalog/ 6071044 drwx-- 2 mysql wheel 512 Oct 2 14:55 ccdb/ 6075010 drwx-- 2 mysql wheel 512 Oct 2 14:55 cclinks/ 6078986 drwx-- 2 mysql wheel 512 Oct 2 14:55 ccmp/ 6082961 drwx-- 2 mysql wheel 512 Oct 2 14:55 chess/ 6090888 drwx-- 2 mysql wheel 2048 Oct 2 14:55 codeabout/ 6098824 drwx-- 2 mysql wheel 1536 Oct 2 14:55 communityupdates/ 6114695 drwx-- 2 mysql wheel 1024 Oct 2 14:55 consortiamath/ 6122652 drwx-- 2 mysql wheel 512 Oct 2 14:55 darius/ 6126597 drwx-- 2 mysql wheel 512 Apr 18 2003 database01/ 6134535 drwx-- 2 mysql wheel 512 Oct 2 14:55 ddsnews/ 8023297 drwx-- 2 mysql wheel 512 Jun 24 21:03 democracy/ 7527307 drwx-- 2 mysql wheel 2048 Oct 2 14:59 digital4rt/ 7551114 drwx-- 2 mysql wheel11264 Oct 2 14:59 dkpostnuke/ 5904393 -rw-r--r-- 1 mysql wheel0 Oct 2 04:10 doctor.log 5904536 -rw-r--r-- 1 mysql wheel 3044467 Oct 2 03:32 doctor.log.0.gz 5904402 -rw-r--r-- 1 mysql wheel 1082868 Sep 18 04:10 doctor.log.1.gz 5904391 -rw-r--r-- 1 mysql wheel 1100202 Sep 11 03:58 doctor.log.2.gz 5904392 -rw-r--r-- 1 mysql wheel 1563416 Sep 4 02:11 doctor.log.3.gz 5904394 -rwxr-xr-x 1 mysql wheel 1887 Jun 11 2003 doctor.nk.ca.err* 5904395 -rwxr-xr-x 1 mysql wheel 379810 Oct 2 15:57 doctor.nl2k.ab.ca.err* 7642370 drwx-- 2 mysql wheel 1024 Oct 2 14:59 elkisland/ 6646402 drwx-- 2 mysql wheel 1536 Oct 2 14:56 facouncil/ 6654338 drwx-- 2 mysql wheel 2560 Oct 2 14:56 freetradenk/ 7443983 drwx-- 2 mysql wheel 6144 Oct 2 14:59 gamershaven/ 6360707 drwx-- 2 mysql wheel12800 Oct 2 14:56 goatboy/ 7519371 drwx-- 2 mysql wheel 512 Oct 2 14:59 horde/ 7650306 drwx-- 2 mysql wheel10752 Oct
Problem with mysql_fix_privelege_tables
I am trying to convert from 3.23 to 4.0 This is what I am getting with or with root: Script started on Sat Oct 2 16:11:30 2004 doctor.nl2k.ab.ca//usr/contrib/var$ man su [25;1H[KSU(1)BSD Reference Manual SU(1) [1mNAME[0;10m [1msu[0;10m - substitute user identity [1mSYNOPSIS[0;10m [1msu[0;10m [[1m-fKlm[0;10m] [[1m-a[0;10m [4mauth-type[m] [[1m-c[0;10m [4mlogin-class[m] [[4mlogin[m [[4margument[m [4m...[m]] [1mDESCRIPTION[0;10m [1mSu[0;10m requests the Kerberos password for [4mlogin[m (or for ``[4mlogin[m.root'', if no login is provided), and switches to that user and group ID after obtain- ing a Kerberos ticket granting ticket. A shell is then executed. [1mSu[0;10m will resort to the local password file to find the password for [4mlogin[m if there is a Kerberos error, or if the system is not configured for Ker- beros. If [1msu[0;10m is executed by root, no password is requested and a shell with the appropriate user ID is executed; no additional Kerberos tickets are obtained. By default, the environment is unmodified with the exception of USER, LOGNAME, HOME, and SHELL. HOME and SHELL are set to the target login's default values. USER and LOGNAME are set to the target login, unless the target login has a user ID of 0 and the [1m-l[0;10m flag was not specified, in which case it is unmodified. The invoked shell is the target login's. This is the traditional behavior of [1msu[0;10m. [25;1H[K[7msu.0 (27%)[m[25;1H[25;1H[K If not using [1m-m[0;10m and the target login has a user ID of 0 then the PATH variable and umask value (see umask(2)) are always set according to the [4m/etc/login.conf[m file (see login.conf(5)). The options are as follows: [1m-a[0;10m Specify an authentication type. [1m-c[0;10m Specify a login class. You may only override the default class if you're already root. [1m-f[0;10m If the invoked shell is csh(1), this option prevents it from reading the ``[4m.cshrc[m'' file. (The [f] option may be passed as a shell argument after the login name, so this option is redundant and obsolescent.) [1m-K[0;10m Do not attempt to use Kerberos to authenticate the user. [1m-l[0;10m Simulate a full login. The environment is discarded except for HOME, SHELL, PATH, TERM, LOGNAME, and USER. HOME and SHELL are modified as above. USER and LOGNAME are set to the target login. PATH is set to the path specified in the [4m/etc/login.conf[m file. TERM is imported from your current environment. The invoked [25;1H[K[7msu.0 (52%)[m[25;1H[25;1H[K shell is the target login's, and [1msu[0;10m will change directory to the target login's home directory. [1m-m[0;10m Leave the environment unmodified. The invoked shell is your lo- gin shell, and no directory changes are made. As a security pre- caution, if the target user's shell is a non-standard shell (as defined by getusershell(3)) and the caller's real uid is non-ze- ro, [1msu[0;10m will fail. The [1m-l[0;10m and [1m-m[0;10m options are mutually exclusive; the last one specified overrides any previous ones. Any arguments after the login name are passed to the shell. This feature may be used to execute commands as another user without starting up an interactive shell, which may be especially useful in the rc(8) script. Only users in group 0 (normally ``wheel'') can [1msu[0;10m to ``root''. By default (unless the prompt is reset by a startup file) the super-user prompt is set to ``[1m#[0;10m'' to remind one of its awesome power. [1mEXAMPLES[0;10m su daemon /usr/contrib/lib/shell-script arguments su news -c 'cd /var/spool/news; du -s * | mail usenet' [25;1H[K[7msu.0 (76%)[m[25;1H[25;1H[K [1mSEE[0;10m [1mALSO[0;10m csh(1), kerberos(1), kinit(1), setusercontext(3), group(5), login.conf(5), passwd(5), environ(7), login(8), sh(1) [1mENVIRONMENT[0;10m Environment variables used by [1msu[0;10m: HOME Default home directory of real user ID unless modified as specified above. LOGNAME Same as USER. PATH Default search path of real user ID unless modified as specified above. TERM Provides terminal type which may be retained for the substituted user ID. USER The user ID is always the effective ID (the target user ID) after an [1msu[0;10m unless the user ID is 0 (root) and the [1m-l[0;10m flag was not speci- fied. [25;1H[K[7msu.0 (93%)[m[25;1H[25;1H[K[1mHISTORY[0;10m A
mysql_fix_privilege_tables again
New error WITH password implemented: Script started on Sat Oct 2 16:28:59 2004 command sent This scripts updates the mysql.user, mysql.db, mysql.host and the mysql.func tables to MySQL 3.22.14 and above. This is needed if you want to use the new GRANT functions, CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23 If you get 'Access denied' errors, you should run this script again and give the MySQL root user password as an argument! Converting all privilege tables to MyISAM format ERROR 1036 at line 1: Table 'user' is read only ERROR 1036 at line 2: Table 'db' is read only ERROR 1036 at line 3: Table 'host' is read only ERROR 1036 at line 4: Table 'func' is read only ERROR 1036 at line 5: Table 'columns_priv' is read only ERROR 1036 at line 6: Table 'tables_priv' is read only If your tables are already up to date or partially up to date you will get some warnings about 'Duplicated column name'. You can safely ignore these! ERROR 1036 at line 1: Table 'user' is read only ERROR 1036 at line 2: Table 'user' is read only Creating Grant Alter and Index privileges if they don't exists You can ignore any Duplicate column errors ERROR 1036 at line 1: Table 'user' is read only ERROR 1036 at line 2: Table 'host' is read only ERROR 1036 at line 3: Table 'db' is read only Setting default privileges for the new grant, index and alter privileges ERROR 1036 at line 1: Table 'user' is read only ERROR 1036 at line 2: Table 'db' is read only ERROR 1036 at line 3: Table 'host' is read only Adding columns needed by GRANT .. REQUIRE (openssl) You can ignore any Duplicate column errors ERROR 1036 at line 1: Table 'user' is read only ERROR 1036 at line 6: Table 'user' is read only Creating the new table and column privilege tables Changing name of columns_priv.Type - columns_priv.Column_priv You can ignore any Unknown column errors from this ERROR 1036 at line 1: Table 'columns_priv' is read only Fixing the func table You can ignore any Duplicate column errors ERROR 1036 at line 1: Table 'func' is read only Adding new fields used by MySQL 4.0.2 to the privilege tables You can ignore any Duplicate column errors ERROR 1036 at line 1: Table 'user' is read only Updating new privileges in MySQL 4.0.2 from old ones ERROR 1036 at line 1: Table 'user' is read only ERROR 1036 at line 1: Table 'user' is read only ERROR 1036 at line 1: Table 'db' is read only ERROR 1036 at line 4: Table 'host' is read only ERROR 1036 at line 1: Table 'db' is read only ERROR 1036 at line 2: Table 'host' is read only ERROR 1036 at line 3: Table 'user' is read only ERROR 1036 at line 4: Table 'tables_priv' is read only ERROR 1036 at line 5: Table 'tables_priv' is read only ERROR 1036 at line 6: Table 'columns_priv' is read only ERROR 1036 at line 8: Table 'db' is read only ERROR 1036 at line 9: Table 'host' is read only ERROR 1036 at line 10: Table 'user' is read only ERROR 1036 at line 11: Table 'func' is read only ERROR 1036 at line 12: Table 'tables_priv' is read only ERROR 1036 at line 13: Table 'columns_priv' is read only doctor.nl2k.ab.ca//usr/contrib/var$ exit exit Script done on Sat Oct 2 16:29:27 2004 Say what?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Did I mess up MySQL?
I had MySQL 3.23.52-3 installed on RH Linux 8.0 (default that comes with it). I decied to install 4.0 and used this command to install it: rpm -Uvh --nodeps MySQL-server-4.0.18-0.i386.rpm I didn't see any obvious errors thereafter. After rebooting noticed that looks like the mysql daemon is running: $ ps -ef|grep mysql root 1620 1 0 15:52 pts/000:00:00 /bin/sh /usr/bin/mysqld_safe --d mysql 1655 1620 0 15:52 pts/000:00:00 /usr/sbin/mysqld --basedir=/ --d However the file /usr/bin/mysql no longer exists so how do I actually get a command line interface to MySQL? Or is there something else I need to install that I have neglected? Or am I just hosed? :) Thanks, lk www.theNewAgeSite.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Did I mess up MySQL?
On Tue, 24 Feb 2004, Paul DuBois wrote: There are different RPMs containing different parts of the installation. You just need to install the client RPM and you should be fine. Thanks! (Dooh! :) lk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: web hosting quesiong (slightly off topic)
On Wed, Jan 07, 2004 at 08:09:50AM -0600, Chris W wrote: I was wondering if anyone could recommend a good web hosting company for an Apache - php - MySQL project. I don't need much bandwidth or disk space to start out, but may need more if the site gets big. I would also like to have ssh access to the server, preferably a linux server. Chris W -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] I run a BSD server with the requirements you are looking for. http://www.nk.ca for more information . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[jstarnaud@zenderford.com: sql error]
What should I do to correct his? Looks like a slippage in MySQl. Using phpMyAdmin to correct this error. - Forwarded message from - Hi Dave, we get an error when we try to post or reply to any post on our forums,,www.gamershaven.ca/Forums mySQL query error: INSERT INTO ibf_topics (title,description,state,posts,starter_id,starter_name,start_date,last_p oster_id,last_poster_name,last_post,icon_id,author_mode,poll_state,last_ vote,views,forum_id,approved,pinned) VALUES ('test','test','open','0','1','Opea','1061918106','1','Opea','1061918106 ','0','1','0','0','0','2','1','0') mySQL error: Duplicate entry '580' for key 1 mySQL error code: 1062 Date: Tuesday 26th of August 2003 05:15:06 PM - End forwarded message - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Restricting user access to databases
Just wondering, how do I limit a user to one database but let the administrator have universal access? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need help with an update
Here is the scenario. I was running 3.23.39 that came with BSD/OS 4.3 , All the databases were running active. I upgraded to BSD/OS 5.0 which has Mysql 3.23.49 and suddenly NO databases are seen. Everything is where is is supposed to be, but the mysqld is not seeing the DBs that were running with 3.23.39. What do I need to do to correct this?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FRom MYsql 3.23.39 to mysql 3.23.49
I installed from the BSDOS distribution. However, with the upgrade, nysql may not be seeing the Databases. Why? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[ADMIN] Mailing lists back in service.
Hello again, MySQL list subscriber! We have completed the first phase of maintenance on the mailing lists, and mail should now start flowing on the lists again. Along with upgrading the hardware serving the lists, we have put in place new systems to help combat spam. One part of this system requires that non-subscribers to the mailing list confirm that they are a real person before their message is let through to the list. (And depending on how your local systems are configured, even some subscribers may be required to go through this one-time confirmation.) We will be keeping a close eye on things to make sure no real emails get dropped by the new systems, but please bear with us in the event that a few pieces of spam email slip through in the meantime. The mailing list archives at http://lists.mysql.com/ have also received the first phase of a facelift, and we will be rolling out additional improvements there in the weeks to come. If you encounter any difficulties with the lists, please don't hesitate to drop us a line at [EMAIL PROTECTED] Again, we're sorry about the interruption and inconvenience, and thanks in advance for your patience as we work the kinks out of the new systems! - The MySQL Team -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[ADMIN] Mailing list maintenance this weekend.
Hello, MySQL list subscriber! We will be performing maintenance on the servers hosting the MySQL mailing lists this weekend, which will result in some periods of unavailability, and possible delays in mail delivery. Sorry about the interruption and inconvenience, and thanks for your patience! We will send another message to the lists once the work has been completed. - The MySQL 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
[reidbryn@doctor.nl2k.ab.ca: Re: help]
Looks as if security got tightened and now next to no databases with Web/php are geting accessed. What needs to be fixed? Customers are yelling. Rectification needed ASAP! forwarded message -- Hi , I corrected the core mysql tables (there was nothing in them) Your root password for mysql is '@!#@$#%' Because there was no user information stored, you'll need to restore their details so they'll be able to access their databases again. -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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: [reidbryn@doctor.nl2k.ab.ca: Re: help]
since my of my customers are reporting that they are getting: Search Results for 'T5Y1M4' Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)No results were found for 'T5Y1M4'. Searching again for the two-digit postal code 'T5'. WHAT must I do to correct his?? On Sat, Nov 09, 2002 at 08:04:45AM -0700, System Administrator a.k.a. The Root of the Problem wrote: Looks as if security got tightened and now next to no databases with Web/php are geting accessed. What needs to be fixed? Customers are yelling. Rectification needed ASAP! forwarded message -- Hi , I corrected the core mysql tables (there was nothing in them) Your root password for mysql is '@!#@$#%' Because there was no user information stored, you'll need to restore their details so they'll be able to access their databases again. -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED]http://www.nl2k.ab.ca 990-3244 - 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 -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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
Permissions problems
USually all the databases sets up fine BUT recently, I have had to adjust databases to 0777 in order to get them to work and change the ownership. I prefer the more secure model of mysql. How can I fix this? -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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
Problems in compiling Mysql-3.23.49. on AIX 4.2
Dear Sir/Madam! I tried compiling the MySQL-3.23.39 on AIX 4.2 but I failed. Attached please find : 1.A script (aixconf) that I used to compile the software: aixconf file. 2.The error messages obtained when running the script: config.log file. 3.OS version: AIX 4.2 0051482C400 I hope this infromation enough to solve this problem. I should be grateful if you can help me what has gone wrong. Thank you very much for your help. Best regards, Gabor Sipos EGIS Pharmaceutical Ltd. 2002. 06. 11. aixconf: export CC=xlC_r -ma -O3 -qstrict -qoptimize=3 -qmaxmem=8192 export CXX=xlC_r -ma -O3 -qstrict -qoptimize=3 -qmaxmem=8192 export CFLAGS=-I /usr/local/include export LDFLAGS=-L /usr/local/lib export CPPFLAGS=$CFLAGS export CXXFLAGS=$CFLAGS ./configure --prefix=/usr/local --localstatedir=/var/mysql --sysconfdir=/etc /mysql --sbindir='/usr/local/bin' --libexecdir='/usr/local/bin' --enable-thr ead-safe-client --enable-large-files config.log: This file contains any messages produced by compilers while running configure, to aid debugging if configure makes a mistake. configure:682: checking host system type configure:703: checking target system type configure:721: checking build system type configure:756: checking for a BSD compatible install configure:809: checking whether build environment is sane configure:844: checking whether make sets ${MAKE} configure:890: checking for working aclocal configure:903: checking for working autoconf configure:916: checking for working automake configure:929: checking for working autoheader configure:942: checking for working makeinfo configure:1050: checking whether to enable maintainer-specific portions of Makefiles configure:1074: checking whether build environment is sane configure:1091: checking whether make sets ${MAKE} configure:1159: checking for gawk configure:1159: checking for mawk configure:1159: checking for nawk configure:1191: checking for gcc configure:1304: checking whether the C compiler (xlC_r -ma -O3 -qstrict -qoptimize=3 -qmaxmem=8192 -I usr/local/include -L /usr/local/lib) works configure:1320: xlC_r -ma -O3 -qstrict -qoptimize=3 -qmaxmem=8192 -o conftest -I /usr/local/include -I /usr/local/include -L /usr/local/lib conftest.c 15 ./configure[1319]: xlC_r: not found configure: failed program was: #line 1315 configure #include confdefs.h main(){return(0);} - 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
suddenly mysql is up and down
Since 020606 mysql has been crashing and then I have to manually restart. The error log is below: 020607 00:46:27 mysqld started /usr/contrib/libexec/mysqld: ready for connections 020607 19:30:58 mysqld restarted /usr/contrib/libexec/mysqld: ready for connections A mysqld process already exists at Fri Jun 7 19:31:14 MDT 2002 A mysqld process already exists at Sat Jun 8 09:00:35 MDT 2002 020608 09:01:30 mysqld started /usr/contrib/libexec/mysqld: File './doctor.log' not found (Errcode: 13) 020608 9:01:31 Could not use doctor.log for logging (error 0) /usr/contrib/libexec/mysqld: ready for connections Status information: Current dir: /usr/contrib/var/ Current locks: lock: 8a259d4: lock: 8a5b1d4: lock: 89e91e0: lock: 8a1d9d4: lock: 8a0d1d4: lock: 8a2e1d4: lock: 8a039d4: lock: 8a261d4: lock: 8a529d4: lock: 8a32dd4: lock: 8a739d4: lock: 8a521d4: lock: 8a5fdd4: lock: 8a549d4: lock: 81e09d4: lock: 81e1dd4: lock: 8a731d4: lock: 8a541d4: lock: 8a2d9d4: lock: 8a671d4: lock: 8a001d4: lock: 8a311d4: lock: 8a0a5d4: lock: 8a359d4: lock: 89fb9d4: lock: 8a30de0: lock: 8a885e0: lock: 8a151e0: lock: 89f0de0: lock: 8a4a9e0: lock: 8a911e0: lock: 8a349e0: lock: 81e01e0: lock: 8a859e0: lock: 8a081d4: lock: 8a8b1d4: lock: 89fc9d4: lock: 89fc1d4: lock: 89e99d4: lock: 8a5a9d4: lock: 8a5a1d4: lock: 8a591d4: lock: 8a0a9d4: lock: 8a01dd4: lock: 8a0a1d4: lock: 89fe1d4: lock: 8a689d4: lock: 8a4e9d4: lock: 8a8d9d4: lock: 8a639d4: lock: 8a459d4: lock: 8a471d4: lock: 8a3a9d4: lock: 8a3d1d4: lock: 8a7a5d4: lock: 8a091d4: lock: 8a3b1d4: lock: 8a64dd4: lock: 8a1c5d4: key_cache status: blocks used: 990 not flushed: 0 w_requests: 1805 writes: 1704 r_requests: 99548 reads: 973 handler status: read_key: 2944 read_next: 2843694 read_rnd340282 read_first:658 write: 3299360 delete 57 update:107 Table status: Opened tables:510 Open tables: 61 Open files: 120 Open streams: 0 020609 05:28:08 mysqld restarted /usr/contrib/libexec/mysqld: File './doctor.log' not found (Errcode: 13) 020609 5:28:08 Could not use doctor.log for logging (error 0) /usr/contrib/libexec/mysqld: ready for connections A mysqld process already exists at Sun Jun 9 05:28:27 MDT 2002 020609 13:07:46 mysqld restarted /usr/contrib/libexec/mysqld: File './doctor.log' not found (Errcode: 13) 020609 13:07:46 Could not use doctor.log for logging (error 0) /usr/contrib/libexec/mysqld: ready for connections A mysqld process already exists at Sun Jun 9 13:10:23 MDT 2002 Questions and fixes needed. Running mysql 3.23.49 -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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: Apache 2.0
On Sun, Jun 09, 2002 at 11:55:29AM -0400, Jeff Whitman wrote: Dear Sir or Ms. Is there a stable version of MySQL that runs on Apache 2.0? Thanks for your time. Question is is httpd-2.0.X stable?? Jeff Whitman Managing Member JW NetSource, LLC Contact Information: Jeff Whitman JW NetSource, LLC PO Box 702 115 East Main Manchester, MI 48158-0702 734-428-7770 877-341-7770 734-428-1777 (fax) a href= http://www.JWNetSource.com JW NetSource.com/a a href= mailto:[EMAIL PROTECTED] E-Mail/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 -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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: Foam King
On Fri, Mar 15, 2002 at 05:30:57PM -0700, Kelly Grainger wrote: Dave, I'm being pressured by Don at the Foam King to get things working asap. Any progress? Here is what I get. Script started on Fri Mar 15 18:52:36 2002 doctor.nl2k.ab.ca/~$ mysql dir *.ansi sh: dir: command not found doctor.nl2k.ab.ca/~$ ls -Fail *,ansi ls: *,ansi: No such file or directory doctor.nl2k.ab.ca/~$ ls -Fail *,ansiansi[K.ansi 206479 -rw--- 1 root wheel 728 Mar 15 18:51 dbo.tblOrder.ansi 206484 -rw--- 1 root wheel 658 Mar 15 18:51 dbo.tblProducts.ansi 206486 -rw--- 1 root wheel 478 Mar 15 18:51 dbo.tblTempOrder.ansi doctor.nl2k.ab.ca/~$ ls -Fail *.ansi oen ls: *.oen: No such file or directory doctor.nl2k.ab.ca/~$ ls -Fail *.oen m 206482 -rw--- 1 root wheel 728 Mar 15 18:51 dbo.tblOrder.oem 206485 -rw--- 1 root wheel 658 Mar 15 18:51 dbo.tblProducts.oem 206487 -rw--- 1 root wheel 478 Mar 15 18:51 dbo.tblTempOrder.oem doctor.nl2k.ab.ca/~$ mysql *.ansi sh: *.ansi: ambiguous redirect doctor.nl2k.ab.ca/~$ mysql *.ansi.ansi[Kd.ansib.ansio.ansi..ansit.ansib.ansil.ansiO.ansid.ansi.ansi[Kr.ansid.ansie.ansir.ansi ERROR 1064 at line 1: You have an error in your SQL syntax near 'if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblOrder]'' at line 1 doctor.nl2k.ab.ca/~$ mysql dbo.tblOrder.ansisi oem ERROR 1064 at line 1: You have an error in your SQL syntax near 'if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblOrder]'' at line 1 You have new mail in /var/mail/root doctor.nl2k.ab.ca/~$ mysql dbo.tblOrder.oem.oem[K.oem[K.oem[K.oem[K.oem[KP.oemr.oemo.oemd.oemu.oemc.oemt.oems.oem ERROR 1064 at line 1: You have an error in your SQL syntax near 'if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblProduct' at line 1 doctor.nl2k.ab.ca/~$ mysql dbo.tblProducts.oem ansi ERROR 1064 at line 1: You have an error in your SQL syntax near 'if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblProduct' at line 1 doctor.nl2k.ab.ca/~$ mysql dbo.tblProducts.ansi.ansi[K.ansi[K.ansi[K.ansi[K.ansi[K.ansi[K.ansi[K.ansi[KT.ansiY.ansie.ansim.ansio.ansip.ansi.ansi[K.ansi[K.ansi[K.ansi[K.ansi[Ke.ansim.ansip.ansiO.ansir.ansid.ansie.ansir.ansiProducts.oem[KTempOrder.ansi ERROR 1064 at line 1: You have an error in your SQL syntax near 'if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblTempOrd' at line 1 doctor.nl2k.ab.ca/~$ mysql dbo.tblTempOrder.ansi oem ERROR 1064 at line 1: You have an error in your SQL syntax near 'if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblTempOrd' at line 1 doctor.nl2k.ab.ca/~$ exit exit Note I am using mysql. Can you fix this? Script done on Fri Mar 15 18:54:08 2002 Kelly Grainger, Webmaster, SSI Solutions. -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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: HTML dumping into browser...
I am having trouble convincing my SQL admin at the hosting company that something is wrong with the server / speed. It is really odd, but in myPhpAdmin for example, on the left hand side the list of databases comes out properly for about 95% of the list, then it starts dumping HTML into the frame. I thought this was just poor coding and a burp / hiccup, however, when the tech tried to perform the same functions in Vancouver, and also via a server in Florida, he did not have the problem. However, when tried from home on a DSL line, and from a phone line in rural Ontario(canada) not only the PHPadmin is farting, but some of my code as well Has anyone experienced this problem? (HTML code just being dumped to the page) losing buttons / hyperlinks and having them replace d with text... (sporadically) Patrick Egan Egan Consulting 15 Elvina Gardens Toronto, Ontario M4P 1X7 [EMAIL PROTECTED] 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
Where do I place a notice that my server hosts mysql databases?
Could someone tell me where I could post/announce this question? I am an ISP being in busniness for 7 years. I support MySQL on my server and would welcome those of you who want to host their database on our system. -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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
Some PHP - mySQL help please ... new to both (Along same lines)
Along the same lines, I have run some scripts that give a similar error that time out is there something in php.ini or mysql that will alow the timing to not stop after 60seconds or 30seconds or something. Had a script to run and pull keywords from a massive db, and it kept timing out. Hope that make since, thanks. - 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: storing files in mySQL
This is how we did it with PHP Remove the mysql packet size limitation. By default, mysql only accepts packets that are smaller than 1 MB. You have to restart your database with some parameters, which will remove the limitations. /usr/local/bin/safe_mysqld -O key_buffer=16M -O table_cache=128 -O sort_buffer=4M -O record_buffer=1M -O max_allowed_packet=24M If you are using Unix, check out your init-tree and change the corresponding startup file. See this page for more detail... http://www.phpbuilder.com/columns/florian19991014.php3?page=2 Patrick Egan Egan Consulting 15 Elvina Gardens Toronto, Ontario M4P 1X7 T] 416 630 4982 F] 416 488 7187 C] 416 726 4832 Pager] 416 377 9031 E] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] W] www.eganconsulting.com http://www.eganconsulting.com -Original Message- From: Anton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 6:13 AM To: 'Mysql List (E-mail)' Subject: RE: storing files in mySQL Why not rather have pointers to the files on a directory and store this in a db field ? Saves you a lot of DB space ? Ant -Original Message- From: Dang Nguyen [mailto:[EMAIL PROTECTED]] Sent: 04 March 2002 09:05 To: Mysql List (E-mail) Subject: storing files in mySQL Hi everyone, I'd like to know how to load files, such as MS-Word documents or PDF documents, in a mySQL database. I've setup a blob type in a table, but where do I go from there? The purpose of this is to store files uploaded from a web page and processed with Java servlets. Then, the files should be retrievable (displayed or downloaded) back to a client browser. My environment: Apache Web server 1.3.x on Solaris 2.8 with Java servlets environment. Thanks for any help, Dang Nguyen - 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
PHP and MySQL for a Collaboration project
Hello All, I have been lurking here for the past couple of weeks and learning a bunch, thank you for all of your posts, just listening to you guys is great. We are developing a web based file management interface for collaboration and security. - Login script - Add three levels of security - Admin - Allows editing of files with file locking - User Specific can view some of the files, not all... - Guest - can only view a few files. - Add / Remove users and permissions to view / edit... - Add / Remove files with file description / size and type We are using PHP and MySQL for this, however, I am concerned about the security of some of the more sensitive files. We would like to have them simply in an HTACCESS protected folder, however, we want to use PHP to add and remove the users through a web interface, we don't want people to just be able to type in the URL of the file and get it again, for two reasons, 1. General Privacy 2. Maybe someone has it checked out and editing it. I have read the post about containing images within a MySQL database. Should we store the files inside the DB, using the posted method of storing an image, and relying on MySQL inherent security, the HTACCESS method or does anyone have a better suggestion? Patrick Egan Egan Consulting 15 Elvina Gardens Toronto, Ontario M4P 1X7 T] 416 630 4982 F] 416 488 7187 C] 416 726 4832 Pager] 416 377 9031 E] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] W] www.eganconsulting.com http://www.eganconsulting.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
HTML dumping into browser...
I am having trouble convincing my SQL admin at the hosting company that something is wrong with the server / speed. It is really odd, but in myPhpAdmin for example, on the left hand side the list of databases comes out properly for about 95% of the list, then it starts dumping HTML into the frame. I thought this was just poor coding and a burp / hiccup, however, when the tech tried to perform the same functions in Vancouver, and also via a server in Florida, he did not have the problem. However, when tried from home on a DSL line, and from a phone line in rural Ontario(canada) not only the PHPadmin is farting, but some of my code as well Has anyone experienced this problem? (HTML code just being dumped to the page) losing buttons / hyperlinks and having them replace with text... (sporadically) Patrick Egan Egan Consulting 15 Elvina Gardens Toronto, Ontario M4P 1X7 T] 416 630 4982 F] 416 488 7187 C] 416 726 4832 Pager] 416 377 9031 E] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] W] www.eganconsulting.com http://www.eganconsulting.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: admin privilege problems
On Fri, Feb 15, 2002 at 12:16:01PM +0200, Egor Egorov wrote: System, Friday, February 15, 2002, 5:38:51 AM, you wrote: jr i made the mistake of changing my root password manually in the mysql jr database. after doing so, i 'flushed privileges'. jr now i'm unable to log on using the root. i've tried to log on using the new jr password a number of times, but i'm always denied access. strangely enough, jr other users (that have passwords) can log on successfully without providing jr a password. does anybody have any recommendations for logging on as the root jr user ... and fixing this privileges problem? Look at: http://www.mysql.com/doc/R/e/Resetting_permissions.html It will help you. SAakaTRotP What if you run into: SAakaTRotP Script started on Thu Feb 14 20:35:44 2002 SAakaTRotP doctor.nl2k.ab.ca//var$ mysqladmin -h localhost -u root password 'Nathan84' SAakaTRotP mysqladmin: unable to change password; error: 'You must have privileges to update tables in the mysql database to be able to change passwords for others' SAakaTRotP doctor.nl2k.ab.ca//var$ exuit it SAakaTRotP exit Did you run mysql at first time? The recomended way to change password and privileges is to use GRANT statement. SAakaTRotP Script done on Thu Feb 14 20:35:56 2002 Further I try: Script started on Fri Feb 15 08:48:41 2002 doctor.nl2k.ab.ca//var$ exitmysql -u root mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'columns_priv' Didn't find any fields in table 'db' Didn't find any fields in table 'func' Didn't find any fields in table 'host' Didn't find any fields in table 'tables_priv' Didn't find any fields in table 'user' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 to server version: 3.23.48-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql exit Bye doctor.nl2k.ab.ca//var$ quit sh: quit: command not found doctor.nl2k.ab.ca//var$ exit exit Script done on Fri Feb 15 08:48:49 2002 -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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: admin privilege problems
On Tue, Feb 05, 2002 at 07:10:01PM +0200, Victoria Reznichenko wrote: jeremy, Tuesday, February 05, 2002, 6:40:29 PM, you wrote: jr hello, jr i made the mistake of changing my root password manually in the mysql jr database. after doing so, i 'flushed privileges'. jr now i'm unable to log on using the root. i've tried to log on using the new jr password a number of times, but i'm always denied access. strangely enough, jr other users (that have passwords) can log on successfully without providing jr a password. does anybody have any recommendations for logging on as the root jr user ... and fixing this privileges problem? Look at: http://www.mysql.com/doc/R/e/Resetting_permissions.html It will help you. jr thx jr jeremy -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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 - 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 if you run into: Script started on Thu Feb 14 20:35:44 2002 doctor.nl2k.ab.ca//var$ mysqladmin -h localhost -u root password 'Nathan84' mysqladmin: unable to change password; error: 'You must have privileges to update tables in the mysql database to be able to change passwords for others' doctor.nl2k.ab.ca//var$ exuit it exit Script done on Thu Feb 14 20:35:56 2002 -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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
[spamreply@orbz.org: Re: [Momo.Yu: Multi-function Digital Camera - PDC-31]]
Getting more problems again? - Forwarded message from ORBZ Spam Report Reply [EMAIL PROTECTED] - Return-Path: [EMAIL PROTECTED] Received: from orbz.org ([EMAIL PROTECTED] [205.231.149.25]) by doctor.nl2k.ab.ca (8.12.2/8.12.2) with SMTP id g0FGCG2O011901 for [EMAIL PROTECTED]; Tue, 15 Jan 2002 09:12:16 -0700 (MST) Received: (qmail 22686 invoked by uid 1017); 15 Jan 2002 16:12:46 - Date: 15 Jan 2002 16:12:46 - Message-ID: [EMAIL PROTECTED] From: ORBZ Spam Report Reply [EMAIL PROTECTED] Subject: Re: [Momo.Yu: Multi-function Digital Camera - PDC-31] To: [EMAIL PROTECTED] X-processor: spam Results for 204.209.81.1: br bWarning/b: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in b/home/ian/orbz-apache/htdocs/functions.php/b on line b35/bbr br bWarning/b: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in b/home/ian/orbz-apache/htdocs/functions.php/b on line b36/bbr br bWarning/b: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in b/home/ian/orbz-apache/htdocs/functions.php/b on line b36/bbr br bWarning/b: MySQL: A link to the server could not be established in b/home/ian/orbz-apache/htdocs/functions.php/b on line b36/bbr br bWarning/b: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in b/home/ian/orbz-apache/htdocs/functions.php/b on line b40/bbr br bWarning/b: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in b/home/ian/orbz-apache/htdocs/functions.php/b on line b40/bbr br bWarning/b: MySQL: A link to the server could not be established in b/home/ian/orbz-apache/htdocs/functions.php/b on line b40/bbr br bWarning/b: Supplied argument is not a valid MySQL result resource in b/home/ian/orbz-apache/htdocs/functions.php/b on line b41/bbr br bWarning/b: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in b/home/ian/orbz-apache/htdocs/functions.php/b on line b58/bbr br bWarning/b: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in b/home/ian/orbz-apache/htdocs/functions.php/b on line b58/bbr br bWarning/b: MySQL: A link to the server could not be established in b/home/ian/orbz-apache/htdocs/functions.php/b on line b58/bbr This IP has been added to the queue for checking. Results for 127.0.0.1: This is a private IP and will not be added. - End forwarded message - -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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: any good web hosting with php and mysql support?
We do this as well. http://www.nk.ca . My question: Is anyone tracking MYSQL-php supported Hosting sites? On Mon, Jan 14, 2002 at 12:57:58PM -0600, Mike(mickalo)Blezien wrote: Check out Just Lightning: http://www.justlightening.net On Mon, 14 Jan 2002 13:55:00 -0500, NDPTAL85 [EMAIL PROTECTED] wrote: On Monday, January 14, 2002, at 01:17 PM, Gurhan Ozen wrote: Hi All, I am currently looking for a reliable web host to host my personal website. I know there are millions of web hosting companies that have PHP and MYSQL support but I just can't trust any of the fully-assured and confident webhosting ads anymore. I would like to get a service from a company for which someone can vouch. I did started hosting my web site at a webhoster that promised 99.99% uptime and my site is hardly ever up and running. They don't answer my emails either. IS there anyone who have web sites hosted at webhosting service for a reasonably long time without any problems? IF yes, can you please contact me and tell me about it? This might be kind of off-topic for both lists, and i apologize to both lists, so you might want to reply to my email rather than sending it to list(s). Thank you very much. Gurhan Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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 -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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: Access to MYSQL via ODBC?
Hello all, I just installed a Suse 7.2 Linux, with MySql.. MySQL runs, but when i try to access it, i get the following message: cleopatra:/usr/bin # mysql -h localhost -u root -p Enter password: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) cleopatra:/usr/bin # mysql -h localhost -u root -p Enter password: ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) is there any way to change/reset the password if any or am i doing something wrong ? -- Best regards, SAE's System Administrator [EMAIL PROTECTED] World Council of Hellenes Abroad 2 Komotinis str. 54655 - Thessaloniki GREECE --__--__--__-- This message was passed through SAE's Mailgate Server. Our MailGate Server employs the latest antivirus antispam technology. Please report any errors to [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[2]: Access to MYSQL via ODBC?
Hello Carsten, Tuesday, November 13, 2001, 9:48:56 PM, you wrote: CHP Try running w/o -p cleopatra:/usr/bin # mysql -h localhost -u root ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) ;( -- Best regards, SAE's System Administrator [EMAIL PROTECTED] World Council of Hellenes Abroad 2 Komotinis str. 54655 - Thessaloniki GREECE --__--__--__-- This message was passed through SAE's Mailgate Server. Our MailGate Server employs the latest antivirus antispam technology. Please report any errors to [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: /usr/local/mysql/var/ bin files
Hello Leon, Thursday, October 18, 2001, 5:09:13 PM, you wrote: LN A quick query, in the directory /usr/local/mysql/var there are LN machinename-bin.001, 002, 003 etc files that are being created. What are LN these files and what do they do. Can I get rid of them as they are taking up LN massive amounts of space. these files are created in Master server in a replication scheme... -- Best regards, SAE's System Administrator [EMAIL PROTECTED] World Council of Hellenes Abroad 2 Komotinis str. 54655 - Thessaloniki GREECE --__--__--__-- This message was passed through SAE's Mailgate Server. Our MailGate Server employs the latest antivirus antispam technology. Please report any errors to [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
mysql-3.23.33
Please solve the problem : # uname -a SunOS mail.chiangmai.ac.th 5.7 Generic_106541-02 sun4m sparc SUNW,SPARCstation-10 # make -v GNU Make version 3.78.1, by Richard Stallman and Roland McGrath. Built for sparc-sun-solaris2.7 # pwd /export/home0/mysql-3.23.33 # make # make install Making install in include make[1]: Entering directory `/export/home0/mysql-3.23.33/include' make[2]: Entering directory `/export/home0/mysql-3.23.33/include' make[2]: Nothing to be done for `install-exec-am'. /bin/sh ../mkinstalldirs /usr/local/mysql/include/mysql mkdir /usr/local/mysql mkdir /usr/local/mysql/include mkdir /usr/local/mysql/include/mysql .././install-sh -c -m 644 dbug.h /usr/local/mysql/include/mysql/dbug.h . . . creating support-files/Makefile Can't open ./support-files/Makefile.in creating mysql-test/Makefile Can't open ./mysql-test/Makefile.in creating include/mysql_version.h creating config.h config.h is unchanged Thank you very much [EMAIL PROTECTED] (THAILAND) - 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-3.23.33
Please solve the problems : # uname -a SunOS Adviser.chiangmai.ac.th 5.7 Generic_106541-02 sun4m sparc SUNW,SPARCstation-10 # gcc -v Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.1/specs gcc version 2.95.1 19990816 (release) # pwd /export/home0/mysql-3.23.33 # # ./configure --prefix=/usr/local/mysql creating cache ./config.cache checking host system type... sparc-sun-solaris2.7 checking target system type... sparc-sun-solaris2.7 checking build system type... sparc-sun-solaris2.7 checking for a BSD compatible install... ./install-sh -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... yes checking for working aclocal... missing checking for working autoconf... missing checking for working automake... missing checking for working autoheader... missing checking for working makeinfo... missing checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes . . . reating Docs/Makefile creating support-files/Makefile Can't open ./support-files/Makefile.in creating mysql-test/Makefile Can't open ./mysql-test/Makefile.in creating include/mysql_version.h creating config.h MySQL has a Web site at http://www.mysql.com/ which carries details on the Thank you [EMAIL PROTECTED] (THAILAND) - 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-3.22.33
Please solve the problems # # groupadd mysql # useradd -g mysql mysql # cd /export/home0 # gunzip mysql-3.23.33.tar.gz | tar xvf - # cd mysql-3.23.33 # ./configure --prefix=/usr/local/mysql # make make all-recursive Making all in include Making all in Docs Making all in readline Making all in libmysql Making all in client Making all in strings Making all in dbug Making all in mysys Making all in extra Making all in regex Making all in isam . . . /usr/bin/rm -f copy-db copy-db-t /usr/bin/sed \ -e 's!@''benchdir''@!/usr/local/mysql/sql-bench!g' \ -e 's!@''bindir''@!/usr/local/mysql/bin!g' \ -e 's!@''scriptdir''@!/usr/local/mysql/bin!g' \ -e 's!@''prefix''@!/usr/local/mysql!g' \ -e 's!@''datadir''@!/usr/local/mysql/share!g' \ -e 's!@''localstatedir''@!/usr/local/mysql/var!g' \ -e 's!@''libexecdir''@!/usr/local/mysql/libexec!g' \ -e 's!@''PERL''@!/usr/local/bin/perl!' \ -e 's!@''VERSION''@!3.23.33!' \ -e 's!@''MYSQL_SERVER_SUFFIX''@!!' \ copy-db.sh copy-db-t /usr/bin/chmod +x copy-db-t /usr/bin/mv copy-db-t copy-db Making all in mysql-test make: Fatal error: Don't know how to make target `all' Current working directory /export/home0/mysql-3.23.33/mysql-test *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /export/home0/mysql-3.23.33 *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' 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
Re: Major MySQL problem
Quickly what needs to be accomplished? On Tue, Sep 25, 2001 at 09:00:08AM -0600, Virag, Thomas wrote: Hello, The recently upgraded MySQL denies any access to my previously perfectly working database. I learned that in this version new Privilege/Grant tables have to be set up before database and table can be accessed. But I don't have access to these Grant Tables. I would like to know how to set up a database and user privileges correctly at NetKnow with this version of MySQL? Do I have access to user: root or only to my default: tvirag ? When I try to access the Grant Tables get the I get the following message: doctor: {36} % mysql -u root mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'columns_priv' Didn't find any fields in table 'db' Didn't find any fields in table 'func' Didn't find any fields in table 'host' Didn't find any fields in table 'tables_priv' Didn't find any fields in table 'user' If I try to add my user id (tvirag) to the grant tables - it is denied: GRANT command is not available. If I connect as tvirag to the database mercury (as I used to) I get the following message: mysql connect mercury; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'associator' Didn't find any fields in table 'audit' Didn't find any fields in table 'codes' Didn't find any fields in table 'contract' Didn't find any fields in table 'hits' Didn't find any fields in table 'journal' Didn't find any fields in table 'product' Didn't find any fields in table 'provider' Didn't find any fields in table 'request' Didn't find any fields in table 'session' Didn't find any fields in table 'users' Connection id:299 Current database: mercury Tables are not accessible, I can't drop and re-create tables, I can't drop and re-create database. I can't drop and re-create my own default MySQL user id. What can I do? Probably the best would be to delete my mercury database and delete and reset all my MySQL setting. Could you do this for me? Does NetKnow have some - site specific - instruction how to set up a database and MySQL user privileges? What are the assumptions and restrictions? What NetKnow will set up and what I'm supposed to set up? Thank you Thomas Virag Tel: 412-3659 -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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: Major MySQL problem
You should have acess to your own MYsql DB. Attn Mysql users, is that a change from 3.23.41 to 3.23.42? On Tue, Sep 25, 2001 at 09:32:08AM -0600, Virag, Thomas wrote: Probably the best would be to delete my mercury database and reset all my (tvirag) MySQL settings. Do I have to set up my own userid and privileges in MySQL or NetKnow does it?? I have to know this -Original Message- From: System Administrator a.k.a. The Root of the Problem [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 9:21 AM To: Virag, Thomas Cc: [EMAIL PROTECTED] Subject:Re: Major MySQL problem Quickly what needs to be accomplished? On Tue, Sep 25, 2001 at 09:00:08AM -0600, Virag, Thomas wrote: Hello, The recently upgraded MySQL denies any access to my previously perfectly working database. I learned that in this version new Privilege/Grant tables have to be set up before database and table can be accessed. But I don't have access to these Grant Tables. I would like to know how to set up a database and user privileges correctly at NetKnow with this version of MySQL? Do I have access to user: root or only to my default: tvirag ? When I try to access the Grant Tables get the I get the following message: doctor: {36} % mysql -u root mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'columns_priv' Didn't find any fields in table 'db' Didn't find any fields in table 'func' Didn't find any fields in table 'host' Didn't find any fields in table 'tables_priv' Didn't find any fields in table 'user' If I try to add my user id (tvirag) to the grant tables - it is denied: GRANT command is not available. If I connect as tvirag to the database mercury (as I used to) I get the following message: mysql connect mercury; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'associator' Didn't find any fields in table 'audit' Didn't find any fields in table 'codes' Didn't find any fields in table 'contract' Didn't find any fields in table 'hits' Didn't find any fields in table 'journal' Didn't find any fields in table 'product' Didn't find any fields in table 'provider' Didn't find any fields in table 'request' Didn't find any fields in table 'session' Didn't find any fields in table 'users' Connection id:299 Current database: mercury Tables are not accessible, I can't drop and re-create tables, I can't drop and re-create database. I can't drop and re-create my own default MySQL user id. What can I do? Probably the best would be to delete my mercury database and delete and reset all my MySQL setting. Could you do this for me? Does NetKnow have some - site specific - instruction how to set up a database and MySQL user privileges? What are the assumptions and restrictions? What NetKnow will set up and what I'm supposed to set up? Thank you Thomas Virag Tel: 412-3659 -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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 From Web Site
I am getting a Warning: Supplied argument is not a valid MySQL result resource in /usr/home/tsguide/html/ssi/phpfunctions.php on line 48 No results were found ... Pointers please. -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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
Installation problsm - Can't locate DBI.pm
I get the following error message when trying to run-all-test. Any help would be greatly appreciated. /usr/local/mysql/sql-bench # ./run-all-tests Can't locate DBI.pm in @INC (@INC contains: /opt/perl5/lib/5.00503/PA-RISC1.1 /opt/perl5/lib/5.00503 /opt/perl5/lib/site_perl/ 5.005/PA-RISC1.1 /opt/perl5/lib/site_perl/5.005 .) at ./run-all-tests line 36. BEGIN failed--compilation aborted at ./run-all-tests line 36. Thanks, Eric White - 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
Installation Problems - HP-UX 10.20
When I run ./scripts/mysql_install_db I get the following error message, any help resolving this issue would be greatly appreciated. /usr/local/mysql # ./scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ./scripts/mysql_install_db[292]: 12773 Memory fault(coredump) Installation of grant tables failed! -- Eric White System Administrator [EMAIL PROTECTED] http://www.open.org/community.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
Password Issues with 3.23.41
Is anyone running into Database login problems with Mysql 3.23.41? -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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
Access denied
How can one rectify the following? Warning: Access denied for user: 'myuser@localhost' (Using password: YES) in /usr/home/lee24/html/therapytables/new/lib/dblib.php on line 24 Can't connect to localhost as myuser MySQL Error: Access denied for user: 'myuser@localhost' (Using password: YES) This script cannot continue, terminating. -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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 error
On Thu, Sep 06, 2001 at 12:50:47PM -0700, Adams, Bill TQO wrote: Mike Ryerse wrote: I have resently installed mysql 3.23.41 on Redhat 7.1 When I installed it, I could access the example databases 'mysql' and 'test'. Mysql said to change the root password right away with : mysqladmin -h host -u root -p password 'new password' Note, do not put a space between the -p and the password normally: mysqladmin -h host -u root -ppassword OR mysqladmin -h host -u root --password=password That may be why you cannot connect. I tried it with 3.23.41 and BACKFIRE. so I did it, but now mysql won't let me log in as any user, not even root. Did you really put a space in the password? Or was that for demonstration purposes only? I have tried to re-install with rpm -i --force, and uninstall with rpm -e, neither will change the permissions of mysql. What should I do? As Gerald Clark said, the manual has a section on how to reset the password. --Bill - 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 -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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
ISP Usage
IS their and ISP tracking list for MySQL adopters? -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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 compile on BSDI
On Wed, Sep 05, 2001 at 04:44:01PM +0300, Sinisa Milivojevic wrote: De-install gcc 2.7.2.1 and install 2.95.2 or gcc 3. Stay with gcc 2.95.X until 3 is fixed! -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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 -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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
Placing directory structure under GNU GPL
I wonder whether the default directory structure of all future mysql releases could also be GPL'led. That would prevent others from placing the releases on directories of their own choice. This would be a very useful restriction, as then changing OSes would be lot easier, rather than remember which is the directory structure for which OS and so on. Raju - 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 server crashes every minute; php scripts that worked on
solaris server now return sql errors Description: MySQL server crashes every minute and restarts. Also, php scripts that worked on our former server (solaris) now return errors, except for one. How-To-Repeat: This line is where the error occurs in the script: $number=MYSQL_NUMROWS($result); it says it is not a valid result resource Fix: trying to fix possible permissions problems but syntax in manual doesn't always work correctly. Nothing seemed to stop it from crashing every minute. Submitter-Id: submitter ID Originator:System Administrator Organization: Mono Lake Committee support: none Synopsis: mysql server crashes every minute and some old scripts don't work on new server Severity critical Priority: high Category: mysql Class: sw-bug support Release: mysql-3.23.39 (Source distribution) Environment: System: BSD/OS monolake.media3.net 4.1 BSDI BSD/OS 4.1 Kernel #0: Wed Aug 30 09:56:00 MDT 2000 [EMAIL PROTECTED]:/usr/src/sys/compile/GENERIC i386 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/contrib/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version egcs-2.91.66 19990314 (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: -r--r--r-- 1 bin bin 1619382 Nov 22 1999 /usr/lib/libc.a -r--r--r-- 1 bin bin 8561 Nov 22 1999 /usr/lib/libc.except Configure command: ./configure --disable-shared Perl: This is perl, version 5.005_03 built for i386-bsdos - 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
Simple question
I've installed Mysql server version 3.23.36 from source distribution (*.tar.gz). When I show the php4 credits (?phpinfo(); ?) in my browser it shows: MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 3.23.22-beta Why it display other version of client api than I install. It would be nice that You answer me. Adrian Grygier - 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
Convert data to mysql format
I have set up an Excel Spreadsheet and an Access database and wish to convert tthem to mysql. How can I do this? -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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
It was working
I was logged into my mysql and just kicking right along, then my telnet session got disconnected, I logged back on, and found defunct processes from my last login. I removed those processes, and tried again, ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111), same error, I restarted mysql, then rebooted the server and still get the same error, I know my password is right?? Probabally been addressed before but David - 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: need help
Right, I trying to compile MySQL latest stable on FreeBSD 4.2 but I get stuck sql_yacc.cc .. Any pointers? -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 414-5359 - 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