|
 |
| Recent blog posts: | |
|
| They have birthday today: | |
|
| Forums: | | |
|
| Discuss: | |
|
| Recent forum topics: | |
|
| Recent forum comments: | |
|
| Модератор: | |
|
Sunday, 25 January 2009
|
| perl with mysql problem Mark 05:13:49 |
| | Hi,
Anyone have a solution to this problem. Using following code:
#!E:\Perl\bin\perl.exe
print "Content-type: text/html\n\n";
use strict;
use DBI();
print "<HTML><HEAD><TITLE>Waitingroomsite</TITLE></HEAD>";
print "<BODY BGCOLOR=\"#ffffff\"><TABLE BORDER=0 WIDTH=\"100\">";
print "<TR><TD><FONT
FACE=\"Helvetica,Verdana,Arial\"><B></B></FONT></TD>";
print "<TD><FONT FACE=\"Helvetica,Verdana,Arial\"></FONT></TD></TR>";
print "list of mysql databases:<p>";
my $dbh =
DBI->connect("DBI:mysql:database=waitingroom;host=138.68.26.210:3306",
"administrator", "admin",
{'RaiseError' => 1});
print "<TR><TD VALIGN=top><FONT FACE=\"Helvetica,Verdana,Arial\">";
print "</FONT></TD>";
print "<TD><FONT FACE=\"Helvetica,Verdana,Arial\"></A></FONT></TD>";
print "</TR>";
print "</TABLE></BODY></HTML>";
getting error:
cgi: runCGI (stderr) BI
connect('database=waitingroom;host=138.68.26.210:3306','administrator',...)
failed: Can't create TCP/IP socket (10106) at
C:\jakarta-tomcat-4.1.24\webapps\pds\WEB-INF\cgi\example.pl line 39
I'm wondering about a number of things:
don't tcp/ip require porting code; io:socket code
Is it easier like a configuration issue . i.e. configuring my.ini.
Any help is much appreciated.
**********************************************************************
This document is strictly confidential and is intended for use by
the addressee unless otherwise indicated.
Allied Irish Banks
**********************************************************************
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m.gmane.org
|
| |  3 answer | Add comment |
Monday, 5 January 2009
|
| Trying to install-getting DOSX.exe error? Vincent 07:27:39 |
| | I am trying to install MySQL 4.0.12-win on WinXP-Home Edition. I am using
the .zip file downloaded from www.mysql.com. I am getting the following
error when I launch setup.exe.
"The Win16 Subsystem was unable to enter Protected Mode, DOSX.EXE must be in
your AUTOEXEC.NT and present in your PATH."
I've done some searching and I do have dosx.exe in my path...and dosx.exe is
loaded in my autoexec.nt file. Any quick workarounds or fixes for this?
Has anyone gotten past it and how?
Thanks for any help.
Vincent
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
|
| | 2 answer | Add comment |
Saturday, 6 December 2008
|
| Performance degradation over time David French 17:45:13 |
| | I have a script written in python running on Suse linux using mySQL
3.23.32.
There are two tables each with an auto-increment key and one index.
Table 1 has a maximinum of 1,000,000 records and table 2 has a
maxminum of 20,000,000 records. The script performs a mixture of
inserts, updates, deletes and selects. it has an output line every 10
seconds saying how many records have been written since the last
sample.
I set it running @ 6.00 last friday and performance started @ 1200
transaction per second and degraded gradually to about 12 a second. I
then connected to mysql and asked for the count of both tables,
'select count(*) from table_name'. After the query, performance went
up to 700/sec degrading after an hour or so the aroung 500/sec.
Can anyone offer an explanation to this interesting result.
Dave French.
NOTICE & DISCLAIMER
This email including attachments (this "Document") is confidential and
may contain legally privileged information. If you have received this
Document in error please notify the sender immediately and delete this
Document from your system without using, copying, disclosing or
disseminating it or placing any reliance upon its contents. We cannot
accept liability for any breaches of confidence arising through use of
this Document.
The information contained in this Document is provided solely for
information purposes on an "as is" basis without warranty of any kind,
either express or implied, including without limitation any implied
warranty of satisfactory or merchantable quality, fitness for a
particular purpose or freedom from error or infringement. The user
relies on the information contained herein, and its accuracy or
otherwise, entirely at their own risk.
Any opinions expressed in this Document are those of the author and do
not necessarily reflect the opinions of Telsis. We will not accept
responsibility for any commitments made by our employees outside the
scope of our business.
---------------------------------------------------------------------
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 <mysql-thread123348@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-gcdmg-mysql=m.gmane.org@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
|
| | 6 answers | Add comment |
Tuesday, 2 December 2008
|
| Can't connect error 10061 - nothing but Mascon works remotely. Daevid Vincent 19:30:01 |
| | I'm having a strange problem connecting via remote to mySQL. This is an
internal LAN, so there should be no firewall issues. I'm running RedHat
8.0, but I've installed the latest mySQL rpms which I thought were
statically linked to avoid the earlier problem of this same nature. The
peculiar thing is that "Mascon" will connect and work just fine, but NO
other programs will, and I've tried: mySQL-front, DBTools-manager,
mySQL-GUI and mySQL AB's very own "myCC" (which I thought for sure would
work). This all started b/c I'm trying to get Datanamic's DeZign to
work.
It's always error '10061', and yes, my 'mysql' databse table permissions
are all correct AFAIK. Again, "Mascon" works just fine which is the
baffling part.
[root@daevid SAMBA]# rpm -qa | grep "mysql" -i
MySQL-client-3.23.53a-1
MySQL-Max-3.23.53a-1
MySQL-python-0.9.1-4
libdbi-dbd-mysql-0.6.5-2
MySQL-bench-3.23.53a-1
MySQL-devel-3.23.53a-1
perl-DBD-MySQL-2.1017-3
qt-MySQL-3.0.5-17
mod_auth_mysql-1.11-1
MySQL-shared-3.23.53a-1
php-mysql-4.1.2-7.3.4
MySQL-3.23.53a-1
I try to telnet to the port, and it 'looks' like it works, although
there's a bunch of gibberish at the end that makes me nervous, but mebbe
it's supposed to be like that?
[root@daevid SAMBA]# telnet 192.168.1.254 3306
Trying 192.168.1.254...
Connected to 192.168.1.254.
Escape character is '^]'.
-
3.23.53a-Max2qe%)<3(,
Connection closed by foreign host.
---------------------------------------------------------------------
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 <mysql-thread126728@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-gcdmg-mysql=m.gmane.org@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
|
| | 10 answers | Add comment |
Saturday, 29 November 2008
|
| Password protection BjГёrn Stave 03:13:00 |
| | Hi MySQL
I am a new user of your product, and so far everything looks great, except
for password protection...
I have completed a new setup on WinXP, with Mysqld-nt as a service, and
assigned a new password to root. However I am able to connect as root
without password, alter and even drop tables and complete databases with
the tool MySQLFront !!!
If I try to connect using MySQLadmin at the command prompt without password
I am rejected as expected.
Did I miss out on something important, or is there a commonly known
backdoor to the MySQLdb
A litle extra info
Server: WinXP, MySQL ver. 3.23.49nt (commandprompt rejects acces without pw)
Client: WinXP, MySQLFRONT ver. 2.2 from MySQLfront.de (acces without pw
granted)
Purpose of use: development of a servicemanagement/CRM application as ISV
Being a bit worried to continue developing, I look forward to hering from You.
Kind regards
BjГёrn D. W. Stave
Expressive.dk
---------------------------------------------------------------------
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 <mysql-thread126946@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-gcdmg-mysql=m.gmane.org@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
|
| | 9 answers | Add comment |
Tuesday, 14 October 2008
|
| ASP and MySQL Andrew H. Schwarz 16:40:44 |
| | I am using ASP to access a mySQL database and have found that mySQL does
not support nested select statements. How would I go about converting
the following standard SQL statement to work in mySQL/ASP? Any help
would be GREATLY appreciated.
Thank you,
Andy
strSql = "SELECT MA VisitorCount) FROM (SELECT LogYear, LogMonth,
LogDay, COUNT(pl_ipaddress) As VisitorCount FROM (SELECT DISTINCT
YEAR(pl_datetime) AS LogYear, MONTH(pl_datetime) AS LogMonth,
DAY(pl_datetime) AS LogDay, pl_ipaddress FROM " & strInstance & "PageLog
WHERE pl_datetime BETWEEN " & FormatDatabaseDate(datReportStart & "
00:00:00") " AND " & FormatDatabaseDate(datReportEnd & " 23:59:59") & "
) DT_PageLog " "GROUP BY LogYear, LogMonth, LogDay)"
Set rsCount = objConn.Execute(strSql)
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
|
| | 9 answers | Add comment |
Tuesday, 15 July 2008
|
| Can't find file: './mysql/host.frm' (errno: 13) Pushpinder Singh Garcha 09:13:18 |
| | Hello All,
I am installing MySQL on my Mac OS Jaguar system. I was having some
trouble with the starting up my MySQL Server. I kpt getting "mysqld
ended" error and my logs showed that file "user.MYI" was corrupted. So
I decided to uninstall MySQl and re-install it.
I installed MySQL (mysql-standard-4.0.13-apple-darwin6.4-powerpc) ...
but now I get this error in the log file and I am unable to still start
the MySQL Server.
------------------------------------------------------------------------
-
030623 15:59:05 mysqld started
030623 15:59:05 InnoDB: Started
030623 15:59:05 Fatal error: Can't open privilege tables: Can't find
file: './mysql/host.frm' (errno: 13)
030623 15:59:05 Aborting
030623 15:59:05 InnoDB: Starting shutdown...
030623 15:59:07 InnoDB: Shutdown completed
030623 15:59:07 /usr/local/mysql/bin/mysqld: Shutdown Complete
------------------------------------------------------------------------
-
Thanks in advance for any help on this matter.
--Pushpinder
|
| | 3 answer | Add comment |
Saturday, 5 July 2008
|
| SQL Injection Tony Thomas 20:19:02 |
| | Hi All,
I've been hearing a bit about SQL injection lately, but the only
documentation I can find refers to Microsoft or Oracle. Anyone know of
good articles about injection in MySQL? Prevention? Detection? Is MySQL
less vulnerable?
Thanks,
Tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 10 answers | Add comment |
Thursday, 26 June 2008
|
| RecordCount Peter Stöcker 14:57:03 |
| | Hi there!
I'm using MySQL with Delphi 5.
After running a query i get a recordcount of -1. But when I check the result there are records.
Can anybody help me?
Thanks,
peter
______________________________________________________________________________
FreeMail in der Premiumversion! Mit mehr Speicher, mehr Leistung, mehr
Erlebnis und mehr Pramie. Jetzt unter http://club.web.de/?mc=021105
---------------------------------------------------------------------
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 <mysql-thread112859@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-gcdmg-mysql=m.gmane.org@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
|
| | 22 answer | Add comment |
Wednesday, 25 June 2008
|
| Unsubcribe Kmlee 11:10:58 |
| | To whom it may concern,
Please help me to unsubscribe from this mailing list. Thank you.
LEE Kwei Mean
Project Manager
OpenFeel Pte Ltd
Email: kmlee@openfeel.com
HP : (+65) 9646 1132
Tel: (+65) 6334 5716
Fax: (+65) 6334 5718
|
| | 6 answers | Add comment |
Saturday, 7 June 2008
|
| mysqlhotcopy as a replication scheme Will Lowe 17:04:04 |
| | I've got an application that uses a fairly large (~50MM rows, ~1GB of
disk) table of read-only data. The table changes maybe once a month,
but when it changes, (almost) EVERY row in the table changes.
The app needs to be replicated into several datacenters worldwide
using relatively slow backend links. For this reason and others (I
need to be able to control when each datacenter picks up updates,
etc.) native MySQL replication isn't attractive. I'm considering
building a scheme where I insert the data into a table once and ship
around a gzipped mysqldump and load it into each datacenter -- this is
easy, uses less bandwidth, is easy to control via cron and fits well
into the rest of our infrastructure.
Then I found mysqlhotcopy. Neato! I've tested, and this seems to work:
1) use mysqlhotcopy to copy the table on the "replication master"
2) gzip the table/index/data files and ship them someplace remote
3) (on the slave) unzip them
4) LOCK TABLES foo WRITE
5) FLUSH TABLE foo
6) copy the unzipped data files over the running mysql data files for
the single table I'm intersted in. There's clearly a problem here if
the machine crashes during this step, but it can be worked out to just
3 calls to rename(2), which is atomic on a POSIX fs, so that's less an
issue than it could be.
7) FLUSH TABLE foo
8) profit! It looks like table foo now contains the new data. It
takes a LOT less time than reinserting all the data into the table.
Other than "you should really use mysql native replication", does
anyone have any comments on whether this is likely to be reliable, or
why it's a bad idea? I'm using 3.23.49 (Debian stable); Is FLUSH
TABLE likely to change in future versions in a way that will break
this?
--
thanks,
Will
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 2 answer | Add comment |
Wednesday, 28 May 2008
|
| SQLException with EOFException connecting to DB Arieh Bibliowicz 17:52:03 |
| | I am having problems connecting to my server provided DB.
When my programs tries to connec I get the following:
java.sql.SQLException: Communication link failure: java.io.EOFException,
underlying cause: null
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1319)
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1338)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:565)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1654)
at com.mysql.jdbc.Connection.<init>(Connection.java:432)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:40
0)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.vainolo.photoviewer.DBManager.<init>(DBManager.java:33)
at com.vainolo.photoviewer.GUI.TestManager.init(TestManager.java:36)
at com.vainolo.photoviewer.GUI.TestManager.main(TestManager.java:87)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1371)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:565)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1654)
at com.mysql.jdbc.Connection.<init>(Connection.java:432)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:40
0)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.vainolo.photoviewer.DBManager.<init>(DBManager.java:33)
at com.vainolo.photoviewer.GUI.TestManager.init(TestManager.java:36)
at com.vainolo.photoviewer.GUI.TestManager.main(TestManager.java:87)
java.lang.NullPointerException
at com.vainolo.photoviewer.GUI.TestManager.main(TestManager.java:88)
Exception in thread "main"
I am running inside a home network usign a router where most of the
incomming ports are closed. Could this be the problem?
Thanks.
Arieh.
--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=gcdmj-java@m.gmane.org
|
| | 4 answer | Add comment |
Thursday, 8 May 2008
|
| problem with mysqld Paizulaev Abdula 10:09:06 |
| | 040401 06:21:02 mysqld started
040401 6:21:03 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 10 4036416
InnoDB: Doing recovery: scanned up to log sequence number 10 4036416
040401 6:21:03 InnoDB: Flushing modified pages from the buffer pool...
040401 6:21:03 InnoDB: Started
/usr/local/mysql/libexec/mysqld: ready for connections
040401 6:21:04 InnoDB: Assertion failure in thread 7176 in file
../include/page0page.ic line 482
InnoDB: We intentionally generate a memory trap.
key_buffer_size=8388600
record_buffer=131072
sort_buffer=2097144
max_used_connections=0
max_connections=100
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0x685406c8, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x80c9d62
0x40027f75
0x8244028
0x81a44b9
0x8174c79
0x8171c4c
0x81721a8
0x8172b9a
0x81739d7
0x8173cfb
0x815a30e
0x81c673f
0x813dbed
0x40024fef
0x420e779a
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow
instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains
information that should help you find out what is causing the crash
Number of processes running now: 0
040401 06:21:04 mysqld restarted
040401 6:21:04 Can't start server: Bind on TCP/IP port: Address already in
use
040401 6:21:04 Do you already have another mysqld server running on port:
3306 ?
040401 6:21:04 Aborting
040401 6:21:04 /usr/local/mysql/libexec/mysqld: Shutdown Complete
what I can do for returning DB to online?
thank you.
---
Paizulaev Abdulla,
Electrosvyaz close corp.,
Makhachkala, Daghestan,
abdul@ellco.ru, icq 342000,
+78722608210, +79034984708
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 4 answer | Add comment |
Friday, 4 April 2008
|
| SQL Question Dawn Lockhart 17:15:36 |
| | Sorry, but I haven't used SQL in about 5 years and I don't remember
which type of join I need for this example.
Table 1 Table 2
ID ID
I need to write a query that returns all of the Table 1.ID records that
do not have a matching ID in Table 2.
Thanks!
Dawn
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/doc/ (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <java-thread4666@lists.mysql.com>
To unsubscribe, e-mail <java-unsubscribe-gcdmj-java=m.gmane.org@lists.mysql.com>
|
| | 106 answers | Add comment |
Monday, 24 March 2008
|
| Update Multiple Records Rich 17:28:55 |
| | Hi folks.
I want to set the status of 5 records to 'completed'. how do I go about
that without having to prepare 5 different instructions?
"update myTable set status = 'completed' where id=10 OR id=20 OR id=30
OR id=40 OR id=50"
I'm trying to reduce the number of instructions.
Cheers
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 8 answers | Add comment |
Sunday, 17 February 2008
|
| Plz provide some information Gopal Goyal 13:54:04 |
| | ----------------------------------------- (on mail.momentuminfocare.com)
email-body was scanned and no virus found
---------------------------------------------------------
Dear Sir/madam
In my project I m using XML,XSL as front end and MySQL as back end and
jdeveloper3.2.3. I am facing a problem in connectivity. I got the code
from some one. Whn I run the code, in
Class.forName("twz1.jdbc.mysql.jdbcMysqlDriver");, it gives the
following error---
ClassNotFoundException:
twz1.jdbc.mysql.jdbcMysqlDriver
==> SQLException:
Message: No suitable driver
SQLState: 08001
ErrorCode: 0
Pls help me out
gops
|
| | 1 answer | Add comment |
Tuesday, 5 February 2008
|
| Specified driver could not be loaded due to system error 5 (MySQL
ODBC 3.51 Driver) Damien Bargiacchi 01:49:51 |
| | I have installed and setup the mySQL server on my windows 2003 server. I am
trying to connect to the database from a C# app running on the same server
in IIS. I have been able to connect through the mySQL binary as well as by
clicking the test connection using the "Test Data Source" button in an ODBC
DSN on the mySQL server and on a remote computer.
When I try to connect to the database from the C# app I get the following
error message:
Specified driver could not be loaded due to system error 5 (MySQL ODBC 3.51
Driver).
I have tried to uninstall and reinstall the ODBC driver to no avail. I have
noticed that the installer places it's dlls etc into the current user's
Documents and Settings\WINDOWS\... Folder so I have moved the files it puts
into there to the real system32 directory to avoid the 126 error.
Any help would be greatly appreciated.
---------------------
Damien Bargiacchi
Vancouver, Canada
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org
|
| | 1 answer | Add comment |
Monday, 24 September 2007
|
| Crystal Reports 9 & ODBC Fred Dinkler 15:40:38 |
| | I defined an ODBC connection in Win2K Pro using 3.51 driver. Works fine in
Excel, Access and Word.
However, when defining a database connection within Crystal Report (v 9) it
can't find any tables. Thinks the db is empty.
Browsed this list's archives and didn't turn up anything.
Any ideas?
Fred Dinkler
Los Angeles
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org
|
| | 1 answer | Add comment |
Wednesday, 18 July 2007
|
| UNICODE Dienw 16:39:48 |
| |
Hi all,
I apologize if this is a frequent topic.
It just I don't find any answer in the archives regarding this,
and maybe my unicode knowledge is rather limited.
I'd like to know, how can I query the database containing
UNICODE character? My application will use wide char. I'm confused
with the interfacing to the mySQL through mysql++.
Currently for single-byte char, I was mostly using << operator to
set up a query.
With wide char, what should I do, just do it like that? Or should I
convert it into MBCS? And then when read I translated it back?
Or maybe there are some other things I should do?
Thanks in advance for any answers.
-Dien.
--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@m.gmane.org
|
| | 4 answer | Add comment |
Monday, 9 July 2007
|
| Security log fills up with ServicesActive failure audits Samuel 17:45:46 |
| | My Windows XP Security Events log is filling up with failure audit events,
but there is very little information about them. Based on when this began
happening, it might be caused by the MySQL service. If this problem has not
been encountered before by MySQL users, then it seems unlikely it is caused
by the MySQL, but the following is the information in case someone has any
information related to this problem being by caused by MySQL.
I get the log events whether MySQL has started or not. Within a few minutes,
the log is full. The failures are for the user I normally use, which does
not have Administrator privileges. I assume that the problem is that a
service is not installed properly. I have looked at the MySQL service and it
seems okay; it is run by the "Local System account" (the default). The
following is relevant information from a log event record.
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Description:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Operation ID: {0,611286}
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
|
| | 3 answer | Add comment |
Monday, 25 June 2007
|
| ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) Daqi Li 18:46:52 |
| | Hi,
After I installed the mysql3.23.54 on a NT4.0
(service pack6) workstation to C:\mysql directory,
when I tried to run mysql.exe, I got
"ERROR 2003: Can't connect to MySQL server on
'localhost' (10061)".
Then I created the C:\my.cnf file, which is a copy of
c:\mysql\my-medium.dnf and I added the following two
lines to its [mysqld] section:
basedir=C:\mysql
datadir=C:\mysql\data
But I still get same error. Any kind of ideas would be
greatly appreciated.
Thanks in advance,
Martin.
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail win32-thread10305@lists.mysql.com
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@lists.mysql.com instead.
|
| | 9 answers | Add comment |
Wednesday, 20 June 2007
|
MySQL Extremely Slow Starting Up  ONEinc 23:34:31 |
| | Hello Everybody,
I am using a Windows 2003 Web Edition Server running IIS and MySQL 4.1. I had to restart the server the other day and it took MySQL over an hour to come back up. I was watching it on my task manager and it went up to approximately 50,000k in 10k increments before I was able to access MySQL. My CPU usage was hovering around 3% all this time. Everything else came up on the server just fine. This happens every time I have to restart my server. The reason I have to restart my server most of the time, is because MySQL locks up on me.
Is there any settings I can change that would help me here? Any help would be greatly appreciated.
One more thing to add. I am using the default my.ini file. We have almost 100 different databases on the server and have around 20000 tables within all of these databases combined. The Memory Usage is at 857MB in use at this time.
Thank you in Advance,
ONEinc |
| | 1 answer | Add comment |
|
|
