Re: Kernel panic when mysql stop command issued

[Jeremy Zawodny]

On Sat, Aug 14, 2004 at 03:01:06PM -0700, Demetrios Stavrinos wrote:
> Kernel panic: Fatal exception in interrupt...In Interrupt handler - not
> syncing
> message appears when the mysql-max stop is issued. Other than that everything
> works. I changed hardware (everything new) and re-installed Linux and MySQL
> and upgraded to latest 2.6.3 from mdk (It was happening with the previous
> 2.6.3 also). Problem is repeatable 4 out of 5 tries.
> 
> Linux 2.6.3-15mdkenterprise #1 SMP Fri Jul 2 20:07:05
> mysql MySQL-Max-4.0.20-3mdk.
> 
> Has any one heard or seen anything like it? 

Try a different kernel.  If MySQL is able to screw with the kernel,
it's a kernel bug--or a weird hardware problem manifesting itself as
one.

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

[book] High Performance MySQL -- http://highperformancemysql.com/

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.X binary for FC2?

[Kurt Hansen]

Hi,
I just tried to install the 4.0 binary compiled with the Intel compiler 
on Fedora Core 2 (FC2). I wasn't able to get it running. When I tried to 
start it, I got the error:

Fatal error: Can't change to run as user 'mysql' ;  Please check that 
the user exists!

I discovered that this is a known, yet recent, bug.
http://bugs.mysql.com/bug.php?id=4408
From reading this, I get the impression there is no pre-compiled binary 
for version 4.X of mySQL on Fedora Core 2.

Did I read that correctly?
If not, where can I find a binary for Fedora Core 2 or how can I fix 
this bug? Are there some libraries I can install, where do I find them, 
and where do I install them?

Or, are my only choices compiling my own (yuck) or using an RPM (bigger 
yuck) on Fedore Core 2?

Thank you!
Take care,
Kurt Hansen
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ASP Connection to Mysql fails

[Michael Stassen]

Then I misunderstood you.  Sorry.  Just to be certain, you are using the 
same user and password in both cases, right?  Beyond that, I have no idea. 
ASP is really not my area.  Perhaps someone else will have an answer.

Michael
Paul Stearns wrote:
Actually I can connect from the web server to the DB server using DSN (the odbc tool 
under windows). What I cannot do is connect from ASP in the same way.
I have a work around, but I still would like to determine what the problem is with a 
DSNless connection.
The work around is to use a DSN entry and call it, for example;
conn.open "dsn=myodbcconn; user=myuser; password=mypassword"
where myodbcconn is a "System DSN"
Why doesn't;
conn.open "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=myserver.com; USER=myuser; 
PASSWORD=mypassword; DATABASE=myDB; PORT:3307; OPTION=35;"
work?
Yes the port number really is 3307.
Paul

-Original Message-
From: Michael Stassen [EMAIL PROTECTED];]
Sent: 8/15/2004 8:05:23 PM
To: [EMAIL PROTECTED]
Subject: Re: ASP Connection to Mysql fails
If I understand you correctly, you can connect to both mysql servers from 
localhost, but not to one from the other.  To mysql, a user is a combination 
of user and connecting host, so I think your problem translates as you can 
connect as [EMAIL PROTECTED], but you cannot connect as [EMAIL PROTECTED] 
You probably need to add a mysql user to allow this.  See the manual for 
the details:  and 
.

Michael
Paul Stearns wrote:

Ignore the sentence that starts Remember...
When I telnet to port 3307 on the DB server from the web server I get the version, a 
few characters of garbage and it disconnects.
Paul
-Original Message-
From: Paul Stearns [EMAIL PROTECTED];]
Sent: 8/15/2004 6:01:59 PM
To: [EMAIL PROTECTED]
Subject: ASP Connection to Mysql fails
I have an ASP application running on a server with a mysql DB, everything works great. 
I connect using localhost, no problems.
I have a second mysql DB on another server. I connect to it via the odbc Data Source 
Administrator from the web server with no problems.
When I try to connect from an ASP script from the web server using the following;
=
Set connMailServer = Server.CreateObject("ADODB.Connection")
ConnectString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=myserver.com; USER=root; 
PASSWORD=rootPW; DATABASE=myDB; PORT:3307; OPTION=35;"
IntDebug=connMailServer.Open(ConnectString)
=
The server, user, password, database and port are what I used in the odbc Data Source 
Administrator. Remember I can connect to my local DB from ASP.
I receive the following error;
==
Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'myserver.com' (10061)
=
The environment is w2k server on both computers. The MYSql version on remote server is 
4.0.17.
I'm so confused...
Paul


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: ASP Connection to Mysql fails

[Paul Stearns]

Armando:

I tried the fully qualified domain name 'computer.domain.root', I also tried the IP 
address. Both worked on the odbc test, but not on the connect string.

I have already gone the DSN route and it works, but it bugs me that the DSNless method 
doesn't work.

My current hypothesis is that the odbc driver is confusing (or ignoring)either the ip 
address or port # for the local mysql DB with what I want for the remote.

Paul


-Original Message-
From: Armando [EMAIL PROTECTED];]
Sent: 8/15/2004 11:35:44 PM
To: [EMAIL PROTECTED]
Subject: RE: ASP Connection to Mysql fails

Paul, when you say SERVER=myserver.com, are you specifying the FQDN
name? ie; thatcomputer.thatdomain.com

I know you mentioned you use the same settings in your ASP script as you
did in the ODBC data source test but if you didn't specify the FQDN, try
it and see what happens.

Failing that, try setting up a System DSN in your ODBC Data Sources
(since you said you could connect that way) and once the DSN is setup,
try setting your ASP connection string to connect to the remote server
using the DSN name rather than a DSN-less connection string and see what
happens there as well. Cheers.

Armando

-Original Message-
From: Paul Stearns [mailto:[EMAIL PROTECTED] 
Sent: August 15, 2004 4:39 PM
To: [EMAIL PROTECTED]
Subject: ASP Connection to Mysql fails


I have an ASP application running on a server with a mysql DB,
everything works great. I connect using localhost, no problems.

I have a second mysql DB on another server. I connect to it via the odbc
Data Source Administrator from the web server with no problems.

When I try to connect from an ASP script from the web server using the
following;

=
Set connMailServer = Server.CreateObject("ADODB.Connection")

ConnectString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=myserver.com;
USER=root; PASSWORD=rootPW; DATABASE=myDB; PORT:3307; OPTION=35;"

IntDebug=connMailServer.Open(ConnectString)
=

The server, user, password, database and port are what I used in the
odbc Data Source Administrator. Remember I can connect to my local DB
from ASP.

I receive the following error;

==

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'myserver.com'
(10061)

=

The environment is w2k server on both computers. The MYSql version on
remote server is 4.0.17.

I'm so confused...

Paul

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: DESCRRIBE ALL TABLES

[EP]

[EMAIL PROTECTED] wrote:

> some command like
> describe all tables
> 
> so that i can see structure of all tables in database.



I use a script to do this, if it's a help you are welcome to it:

http://paradigmb.com/describe_MySQL.htm

It produces a html page showing the database structure (all columns for all tales in 
the database)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

DESCRRIBE ALL TABLES

[Remember14a]

Dear friends,

I have a database spec, I have pasted details from command prompt, to see 
structure of table I use following commands.

use spec
show tables
describe account

The last command displays the structure of table,

Now can you guide me to a command, where in I can see structure of all tables 
with that command.

Like I use 
describe account

some command like
describe all tables

so that i can see structure of all tables in database.

Guidance, please.


-
Details of database and table structure and commands
--
mysql> use spec
Database changed
mysql> show tables
-> ;
++
| Tables_in_spec |
++
| account|
| datag  |
| developmentkashmir |
| kashmirturmoil |
| monthlyexpenses|
| quiz   |
| words  |
++
7 rows in set (0.02 sec)

mysql> describe account;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| username  | varchar(50) |  | | |   |
| password  | varchar(50) |  | | |   |
| email | varchar(50) |  | | |   |
| confirmed | smallint(6) |  | | 0   |   |
| random| varchar(50) |  | | |   |
+---+-+--+-+-+---+
5 rows in set (0.04 sec)

mysql>

Count even when empty

[Bill Easton]

SELECT dbo.lists_.Name_, COUNT(dbo.members_.EmailAddr_) AS nojgid
FROM  dbo.lists_
INNER JOIN dbo.topics_ ON dbo.lists_.Topic_ = dbo.topics_.Title_
LEFT JOIN  dbo.members_  ON dbo.members_.List_ = dbo.lists_.Name_
GROUP BY dbo.lists_.Name_,

The first inner join gives you a row for every list.
The left join gives you a row for every (member, list) pair plus a row (with
a null) for every list with no member.
The COUNT will count the non-null things
Note that you want to select/group on dbo.lists_.Name_, not
dbo.members_.List_, which may be null.


HTH

= Original Message Follows =

From: "John Berman" <[EMAIL PROTECTED]>
Subject: Count even when empty
Date: Sun, 15 Aug 2004 01:02:52 +0100

Further to my earlier query

Im using this

SELECT dbo.members_.List_, COUNT(dbo.members_.EmailAddr_) AS nojgid
FROM dbo.members_ INNER JOIN
  dbo.lists_ ON dbo.members_.List_ = dbo.lists_.Name_
INNER JOIN
  dbo.topics_ ON dbo.lists_.Topic_ = dbo.topics_.Title_
WHERE (dbo.members_.jgid IS NULL)
GROUP BY dbo.members_.List_

This works but I want to get a 0 when dbo.members_.jgid IS NULL so my output
shows a 0 for a list, currently is does not show the list when its empty
(obviously because I use is null)


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Count of two fields

[Bill Easton]

select ListName, count(*), sum(Info is not null)
from ListTable
group by ListName

= Original Message Follows =

From: "John Berman" <[EMAIL PROTECTED]>
Subject: Count of two fields

Wonder if you can help

I have a table with a number of fields but the 

List Name

Member

Info

Ever member in the table has a list and some members have something in the
info field, Im after a count by list name

So for instance the result im after would be something like

List1 55 3

So  for list1 there are 55 members associated with is and out of the 55 3
have something in the info field

Help appreciated

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Re: ASP Connection to Mysql fails

[Paul Stearns]

Actually I can connect from the web server to the DB server using DSN (the odbc tool 
under windows). What I cannot do is connect from ASP in the same way.

I have a work around, but I still would like to determine what the problem is with a 
DSNless connection.

The work around is to use a DSN entry and call it, for example;

conn.open "dsn=myodbcconn; user=myuser; password=mypassword"

where myodbcconn is a "System DSN"

Why doesn't;

conn.open "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=myserver.com; USER=myuser; 
PASSWORD=mypassword; DATABASE=myDB; PORT:3307; OPTION=35;"

work?

Yes the port number really is 3307.

Paul



-Original Message-
From: Michael Stassen [EMAIL PROTECTED];]
Sent: 8/15/2004 8:05:23 PM
To: [EMAIL PROTECTED]
Subject: Re: ASP Connection to Mysql fails

If I understand you correctly, you can connect to both mysql servers from 
localhost, but not to one from the other.  To mysql, a user is a combination 
of user and connecting host, so I think your problem translates as you can 
connect as [EMAIL PROTECTED], but you cannot connect as [EMAIL PROTECTED] 
You probably need to add a mysql user to allow this.  See the manual for 
the details:  and 
.

Michael

Paul Stearns wrote:

> Ignore the sentence that starts Remember...
> 
> When I telnet to port 3307 on the DB server from the web server I get the version, a 
> few characters of garbage and it disconnects.
> 
> Paul
> 
> 
> -Original Message-
> From: Paul Stearns [EMAIL PROTECTED];]
> Sent: 8/15/2004 6:01:59 PM
> To: [EMAIL PROTECTED]
> Subject: ASP Connection to Mysql fails
> 
> I have an ASP application running on a server with a mysql DB, everything works 
> great. I connect using localhost, no problems.
> 
> I have a second mysql DB on another server. I connect to it via the odbc Data Source 
> Administrator from the web server with no problems.
> 
> When I try to connect from an ASP script from the web server using the following;
> 
> =
> Set connMailServer = Server.CreateObject("ADODB.Connection")
> 
> ConnectString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=myserver.com; USER=root; 
> PASSWORD=rootPW; DATABASE=myDB; PORT:3307; OPTION=35;"
> 
> IntDebug=connMailServer.Open(ConnectString)
> =
> 
> The server, user, password, database and port are what I used in the odbc Data 
> Source Administrator. Remember I can connect to my local DB from ASP.
> 
> I receive the following error;
> 
> ==
> 
> Microsoft OLE DB Provider for ODBC Drivers error '80004005' 
> 
> [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'myserver.com' (10061)
> 
> =
> 
> The environment is w2k server on both computers. The MYSql version on remote server 
> is 4.0.17.
> 
> I'm so confused...
> 
> Paul
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ASP Connection to Mysql fails

[Michael Stassen]

If I understand you correctly, you can connect to both mysql servers from 
localhost, but not to one from the other.  To mysql, a user is a combination 
of user and connecting host, so I think your problem translates as you can 
connect as [EMAIL PROTECTED], but you cannot connect as [EMAIL PROTECTED] 
   You probably need to add a mysql user to allow this.  See the manual for 
the details:  and 
.

Michael
Paul Stearns wrote:
Ignore the sentence that starts Remember...
When I telnet to port 3307 on the DB server from the web server I get the version, a 
few characters of garbage and it disconnects.
Paul
-Original Message-
From: Paul Stearns [EMAIL PROTECTED];]
Sent: 8/15/2004 6:01:59 PM
To: [EMAIL PROTECTED]
Subject: ASP Connection to Mysql fails
I have an ASP application running on a server with a mysql DB, everything works great. 
I connect using localhost, no problems.
I have a second mysql DB on another server. I connect to it via the odbc Data Source 
Administrator from the web server with no problems.
When I try to connect from an ASP script from the web server using the following;
=
Set connMailServer = Server.CreateObject("ADODB.Connection")
ConnectString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=myserver.com; USER=root; 
PASSWORD=rootPW; DATABASE=myDB; PORT:3307; OPTION=35;"
IntDebug=connMailServer.Open(ConnectString)
=
The server, user, password, database and port are what I used in the odbc Data Source 
Administrator. Remember I can connect to my local DB from ASP.
I receive the following error;
==
Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'myserver.com' (10061)
=
The environment is w2k server on both computers. The MYSql version on remote server is 
4.0.17.
I'm so confused...
Paul

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: ASP Connection to Mysql fails

[Paul Stearns]

Ignore the sentence that starts Remember...

When I telnet to port 3307 on the DB server from the web server I get the version, a 
few characters of garbage and it disconnects.

Paul


-Original Message-
From: Paul Stearns [EMAIL PROTECTED];]
Sent: 8/15/2004 6:01:59 PM
To: [EMAIL PROTECTED]
Subject: ASP Connection to Mysql fails

I have an ASP application running on a server with a mysql DB, everything works great. 
I connect using localhost, no problems.

I have a second mysql DB on another server. I connect to it via the odbc Data Source 
Administrator from the web server with no problems.

When I try to connect from an ASP script from the web server using the following;

=
Set connMailServer = Server.CreateObject("ADODB.Connection")

ConnectString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=myserver.com; USER=root; 
PASSWORD=rootPW; DATABASE=myDB; PORT:3307; OPTION=35;"

IntDebug=connMailServer.Open(ConnectString)
=

The server, user, password, database and port are what I used in the odbc Data Source 
Administrator. Remember I can connect to my local DB from ASP.

I receive the following error;

==

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'myserver.com' (10061)

=

The environment is w2k server on both computers. The MYSql version on remote server is 
4.0.17.

I'm so confused...

Paul

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ASP Connection to Mysql fails

[Paul Stearns]

I have an ASP application running on a server with a mysql DB, everything works great. 
I connect using localhost, no problems.

I have a second mysql DB on another server. I connect to it via the odbc Data Source 
Administrator from the web server with no problems.

When I try to connect from an ASP script from the web server using the following;

=
Set connMailServer = Server.CreateObject("ADODB.Connection")

ConnectString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=myserver.com; USER=root; 
PASSWORD=rootPW; DATABASE=myDB; PORT:3307; OPTION=35;"

IntDebug=connMailServer.Open(ConnectString)
=

The server, user, password, database and port are what I used in the odbc Data Source 
Administrator. Remember I can connect to my local DB from ASP.

I receive the following error;

==

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'myserver.com' (10061)

=

The environment is w2k server on both computers. The MYSql version on remote server is 
4.0.17.

I'm so confused...

Paul

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can't start mysql server automatically

[Michael Stassen]

Well, clearly LD_LIBRARY_PATH isn't set at startup.  That's one of the 
reasons LD_LIBRARY_PATH isn't really the Solaris way, and is not 
recommended.  With a proper setup, you should never need LD_LIBRARY_PATH in 
Solaris.

In any version of Solaris, you can build with
  -R /usr/local/lib
to create executables which know to look in /usr/local/lib to find libraries 
at run time.

Starting with Solaris 8, you can use crle to add /usr/local/lib to the 
dynamic linker's path.

Michael
McAfee wrote:
I configured MySQL to start automatically on a Sun Ultra10 running 
Solaris 9 as per the installation instructions installing the following 
scripts/links:

- /etc/init.d/mysql
- /etc/rc3.d/S99mysql
- /etc/rc0.d/K01mysql
The MySQL daemon however failed to start at system startup. The .err log 
file contained the following...

040814 21:27:55  mysqld started
ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libstdc++.so.5: open 
failed: No such file or directory
040814 21:27:56  mysqld ended


libstdc++.so.5 does exist (located in '/usr/local/lib') and is set in 
LD_LIBRARY_PATH.
I can however start/stop/interact successfully with MySQL from the 
command line!?!

I don't know how to correct this libstdc++.so.5 error...it exists. 
GR:-(

Any help greatly appreciated.
Thanks
Graeme

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Cannot be null problem

[Mark Matthews]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Schalk Neethling wrote:
| When sending form data via a form I get the following SQL error
|
| ERROR:-- SQLException - Message: The url cannot be null
| SQLState: 08001
| ErrorCode :0
|
| What does this mean? The row url, is not set to be not null.
|
What is the _full_ stacktrace here? This doesn't look like it's coming
from the JDBC driver (we don't have a message like this that I can see).
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 332 0507
www.mysql.com
MySQL Guide to Lower TCO
http://www.mysql.com/it-resources/white-papers/tco.php
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.3 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBH6JxtvXNTca6JD8RAt8/AKDBSDgHDBkXWiWxHi7hCzYNFiOOqQCePNre
dnyhLOhalSmxisfjhq7W//8=
=rhPr
-END PGP SIGNATURE-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: recommended books for web app.

[Kerry Frater]

Thanks Mike,

your recommendations are very much noted.

Kerry

-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: 15 August 2004 17:22
To: [EMAIL PROTECTED]
Subject: Re: recommended books for web app.


Kerry,

At 08:09 AM 8/12/2004, you wrote:
>I am looking to port an app from an existing web environment to MySQL. The
>requirement is relatively easy. The Tables are read only and the data is to
>be only accessed via login & password. The login will give a limited view
of
>records based on a master/detail table relationship. I need to be aware of
>securing the database and have been told by others that I should look to
use
>PHP.
>
>I know my local bookstore has the following publications (based on asking
>about MySQL & PHP)
>Beginning PHP, Apache MySQL Web Development published by Wrox
>
>PHP & MySQL written by Larry Ullmen

I'd recommend this one first (actually he has 2 books on PHP & MySQL, an
intro and an advanced version) because it will get you the basics for using
PHP and MySQL. You can also finish each one in about a week because it is
not that large.


>PHP & MySQL Web Development written by Luke Welling & Laura Thomsan

Read this book next because it is quite thorough and will take some time to
get through.

Mike


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can't start mysql server automatically

[McAfee]

I configured MySQL to start automatically on a Sun Ultra10 running 
Solaris 9 as per the installation instructions installing the following 
scripts/links:

- /etc/init.d/mysql
- /etc/rc3.d/S99mysql
- /etc/rc0.d/K01mysql
The MySQL daemon however failed to start at system startup. The .err log 
file contained the following...

040814 21:27:55  mysqld started
ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libstdc++.so.5: open 
failed: No such file or directory
040814 21:27:56  mysqld ended


libstdc++.so.5 does exist (located in '/usr/local/lib') and is set in 
LD_LIBRARY_PATH.
I can however start/stop/interact successfully with MySQL from the 
command line!?!

I don't know how to correct this libstdc++.so.5 error...it exists. GR:-(
Any help greatly appreciated.
Thanks
Graeme

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: recommended books for web app.

[mos]

Kerry,
At 08:09 AM 8/12/2004, you wrote:
I am looking to port an app from an existing web environment to MySQL. The
requirement is relatively easy. The Tables are read only and the data is to
be only accessed via login & password. The login will give a limited view of
records based on a master/detail table relationship. I need to be aware of
securing the database and have been told by others that I should look to use
PHP.
I know my local bookstore has the following publications (based on asking
about MySQL & PHP)
Beginning PHP, Apache MySQL Web Development published by Wrox
PHP & MySQL written by Larry Ullmen
I'd recommend this one first (actually he has 2 books on PHP & MySQL, an 
intro and an advanced version) because it will get you the basics for using 
PHP and MySQL. You can also finish each one in about a week because it is 
not that large.


PHP & MySQL Web Development written by Luke Welling & Laura Thomsan
Read this book next because it is quite thorough and will take some time to 
get through.

Mike 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: recommended books for web app.

[Kerry Frater]

Peter,

If you put any in your email reply - none came through.

Kerry


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 15 August 2004 05:21
To: [EMAIL PROTECTED]
Subject: Re: recommended books for web app.






-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]