There's a rub of my Dapper Server, especially for the Argo Data, at the beginning, it is Ok , but suddenly it can't be access to DODS or Dchart, and the error of DODS is:
"Error connecting to Climate Data Portal
There was an error connecting to the Climate Data Portal. The error was:
Database SQL CDP error
Please try again later "
I have try many ways, reload the data, reinstall the Dapper server,but still can't make it work. Would you please tell me how to deal with it?
One possibility is that your
One possibility is that your MySQL server is either not running or was restarted while Dapper was running. Try this:
1) Shut down Dapper
2) Restart (or start) MySQL
3) Start Dapper
Unfortunately, Dapper currently doesn't handle stale connections to MySQL well -- if you restart MySQL, you also have to restart Dapper.
If that doesn't appear to be the problem, send me your log file (in dapper/jakarta/logs/catalina.out) and I'll see if I can fiture out what's going on.
- Joe
catalina.out
Thank you,Joe.
I had try but it didn't work. I remove all the old databases,create new db and ds: "insitu argo1"and"insitu argo2",load the data,and restart MySQL, there were the same error as before.
I can peek at data list with "dapperload.sh...ls...",but i can't find the database with "show databases;"in MySQL.
There's part of my catalinna.out:
"Got request:/dods/insitu/
Directory check for:insitu
isRoot?false
Directory name was:insitu
isDirectory?true
Adding database insitu
Connecting to database with JDBC URL jdbc:mysql://gdosdc.scsio.ac.cn/insitu?autoReconnect=true
java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: null, message from server: "Host 'gdosdc.scsio.ac.cn' is not allowed to connect to this MySQL server"'."
I am a student of South Chian Sea Institute of Oceanology(SCSIO),and i am very interested in DChart/Dapper.You also can e-mail me by xccumt@scsio.ac.cn
Thanks for help.
MySQL config
This appears to be a MySQL configuration problem.
Can you connect to the server using the command line?
mysql -h gdosdc.scsio.ac.cn -u -p insitu
If not, then that's your problem. You can try localhost instead of gdosdc.scsio.ac.cn.
You can find more info on MySQL access controls and configuration at http://dev.mysql.com/doc/refman/5.1/en/privilege-system.html
Problem-solving
Hi,Joe.
There's no problem about the MySQL.I have found the rub. It was the wrong configuration of the etc/dapper.properties. So i verified itwith the same values for hostname, user, password, and database as the ones I used when I ran dapperload. And the "hostname" was the promblem.
Okay,now I got Dods running OK. Thank you for your help again.
xc
still a rub
hi,Joe. Thanks for your last reply.
I can connect to MySQL, but the rub is still as the first one. There are LAS and DChart in my server, and i can access data from LAS,but can't access data from DChart,so i was confused.And the following information maybe will help you to find the answer for me:
"mysql> select host,user,password,select_priv from mysql.user;
+-----------------------+----------+------------------+-------------+
| host | user | password | select_priv |
+-----------------------+----------+------------------+-------------+
| localhost | root | 6f062b3e2f77e493 | Y |
| localhost.localdomain | root | | Y |
| localhost.localdomain | | | N |
| localhost | | | N |
| localhost.localdomain | las | 51cca9f95577687a | Y |
| 127.0.0.1 | las | 51cca9f95577687a | Y |
| % | mipuchun | 6f062b3e2f77e493 | N |
+-----------------------+----------+------------------+-------------+
7 rows in set (0.00 sec)"
and would you please tell me what's the problem?
It should work if you use the
It should work if you use the same host,user, and password as you used for las.