Another thought is to turn on logging on the mysql server, and see if
the requests are coming through and being denied, or if they are not
even reaching the server.
A.
On Jul 14, 2005, at 4:58, Philipp Rossmanith wrote:
hi,
did you do a fresh install of the mysql server? then, you should check
the configuration file, my.cnf. by default, mysql disallows remote
connections.
you can read more here:
http://www.webmasterworld.com/forum10/6141.htm
hope it helps.
ciao, philipp
Derek Hohls wrote:
Upayavira
This makes sense, except for the "mysql client" part.
My MachineB is the equivalent of your Windows (except it runs
Linux, but I assume that makes no difference); and my MachineA is
the equivalent of your chandra (and
also running mysql).
The only difference is that there is not a "mysql client"
running on MachineB - I am not the admin for this machine
and am not sure I can get a "mysql client" installed on it.
Is there any simple way to test the connection as you have done?
AFAIK I have created the permissions for the user on the remote
machine to access your database - as per Step 5
in my post below. (This is always the way I have done
it before but I have a nagging feeling there is now some subtle
difference somewhere in the new setup..)
Thanks
Derek
[EMAIL PROTECTED] 2005/07/13 03:16:05 PM >>>
I have Mysql running on Linux, on host Chandra.
I have the mysql client running on windows, host creatively named
win2k.
If I log onto win2k and run:
mysql -uroot -ppasswd -h chandra
I get: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
So, I logged onto chandra and did:
grant all privileges on *.* to [EMAIL PROTECTED] idenitifed by
'passwd';
Then I repeated the command from win2k, and it let me in to chandra.
Hope that makes sense.
So, have you set permissions for the user on the remote machine to
access your database?
Regards, Upayavira
Derek Hohls wrote:
Uh - if I try:
./mysql -u myname -ppasswd -h machineB.com
that gives me the error:
Access denied for user "machineA.com" (machine A is where I have
telnetted into [from MachineB]
... and is also where the database is located - this is in line
with the manual which states:
"If mysql -u root test works but mysql -h your_hostname -u root
results in Access denied (where your_hostname is the **actual
hostname of the local host***),
But I am trying to test the connection from machineB ??
Thanks
Derek
[EMAIL PROTECTED] 2005/07/13 02:36:21 PM >>>
Derek Hohls wrote:
Upayavira
Thanks for the heads-up.
I have now tried using the machine name as well... but with no
success.
Re the second approach - this is not clear to me. I would normally
telnet into the box, then run ./mysql -u myname -p to work with
sql. However, my understanding is that when I do this I am
essentially connecting to mysql from the localhost. How do I
connect
from the remote machine to the database server using the mysql
command as you suggest?
er, ./mysql -u myname -ppasswd -h hostname
:-)
Regards, Upayavira
[EMAIL PROTECTED] 2005/07/13 01:22:06 PM >>>
Could be that you need to grant authorisation by machine name
not by IP. I've had struggles with that sort of thing before.
Best to debug this by trying to login to remote host just using
the mysql command at the command line. Then, once you've got
that working, you can scale up to doing it with Cocoon.
Regards, Upayavira
Derek Hohls wrote:
I am struggling with getting a new server to communicate with a
mySQL database on another machine.
The database and queries work fine, when running on machine A,
where the database is installed,
as does the Cocoon application when running there.
However, when I try and emulate the Cocoon application on
machine B (same OS, same Cocoon version - Linux, C2.1.6),
I get a null pointer exception that I cannot seem to solve.
Here is what I have done.
1. Copied the mysql-connector-java-3.1.7-bin.jar file to tomcat
\webapps\cocoon\WEB-INF\lib\
2. Added an entry in web.xml for "com.mysql.jdbc.Driver"
3. Aded an entry in the cocoon.xconf for:
<jdbc name="mydb">
<pool-controller min="1" max="50"/>
<auto-commit>true</auto-commit>
<dburl>jdbc:mysql://dbserver.alias.com/mydbname</dburl>
<user>myuser</user>
<password>mypassword</password>
</jdbc>
4. Restarted Cocoon
5. Added a "myuser" entry to the mySQL user table on the
database machine, with
USE mysql;
GRANT USAGE ON *.* to myuser@"99.99.99.99" IDENTIFIED BY
'mypassword';
GRANT SELECT ON mydbname.* to ffpreporter@"99.99.99.99";
(obviously I am using the actual IP address of Machine B)
6. The pipeline in question looks like:
<map:match pattern="testproject">
<map:generate src="sql.xml"/>
<!-- === SQL Connector ==== --> <map:transform type="sql">
<map:parameter name="use-connection" value="mydb"/>
<map:parameter name="show-nr-of-rows" value="true"/>
<map:parameter name="clob-encoding" value="UTF-8"/> </
map:transform> <map:serialize type="xml"/>
</map:match>
7. the SQL file contains:
<?xml version="1.0" encoding="UTF-8" ?> <sq2:execute-query
xmlns:sq2="http://apache.org/cocoon/SQL/2.0";>
<sq2:query name="themes">
SELECT DISTINCT * FROM mytable
</sq2:query>
</sq2:execute-query>
8. The stacktrace from Cocoon is a
java.lang.NullPointerException;
looking in the error.log reveals:
ERROR (2005-07-13) 12:40.11:694 [sitemap.transformer.sql] (/
cocoon/myapp/testproject) http-8080-Processor4/
SQLTransformer.Query: Caught a SQLException
java.sql.SQLException: Failed to obtain connection. Made 5
attempts with 5000ms interval
How do I go about trying to pin down why this is happening?
Thanks
Derek
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED] For
additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
