Hi!
Sorry, I don't know manipulate mysql very well, but it was what
you want?
mysql> SELECT * FROM 20140909_NODES;
+----------------+---------------------------------------------+---------------------------------------------------------------------------+-------------------------------------+-----------------+------------+------------+
| node_id | node_name
| longname
| host
| addr | first | last |
+----------------+---------------------------------------------+---------------------------------------------------------------------------+-------------------------------------+-----------------+------------+------------+
| 364296845 | 200_159_254_115-3 | pS DPD,
PoP-RJ, Rio de Janeiro, RJ, BR |
vservice-vm10.pop-rj.rnp.br | 200.159.254.115 | 0 |
1410274224 |
| 803438530 | PERFSONAR_10G_AMPATH_NET |
perfsonar.ampath.net, Miami, FL, US
| perfsonar-10g.ampath.net | 190.103.184.153 | 0
| 1410274221 |
| 1419973889 | KNOPPIX |
local host
| 143.107.6.19 |
143.107.6.19 | 0 | 1410279509 |
| 1620213955 | 146_164_245_5-4 | UFRJ,
Rio de Janeiro, Rio de Janeiro, BR |
146.164.245.5 | 146.164.245.5
| 0 | 1410274210 |
| 1681816072 | PS_LT_SCIENCEDMZ_UFPE_BR-4 | UFPE, Recife,
Pernambuco, BR |
ps-lt.sciencedmz.ufpe.br | 150.161.116.3 | 0
| 1410274217 |
| 1789167457 | 200_133_192_50-3 | pS DPD,
PoP-SP, Sao Paulo, SP, BR |
200.133.192.50 | 200.133.192.50 |
0 | 1410274223 |
| 1893932271 | PERFSONAR_IF_UFRJ_BR | IF, UFRJ, Rio
de Janeiro, RJ, BR |
perfsonar.if.ufrj.br | 146.164.36.92
| 0 | 1410274216 |
| 2152962592 | 200_20_223_253-4 | MCTI -
Obervatorio Nacional, Rio de Janeiro, RJ, BR |
200.20.223.253 | 200.20.223.253 |
0 | 1410274207 |
| 2914748157 | 200_133_17_92-4 | IFPE,
Recife, Pernambuco, BR
| 200.133.17.92 | 200.133.17.92
| 0 | 1410274212 |
| 3131783261 | CCPERFSONAR2_IN2P3_FR-1 | LHC
ps
| ccperfsonar2.in2p3.fr |
193.48.99.76 | 0 | 1410274217 |
| 3428547912 | PSONAR4_FNAL_GOV-0 | LHC
ps
| psonar4.fnal.gov |
131.225.205.12 | 0 | 1410274216 |
| 3620397247 | 200_19_119_101-3 | pS DPD,
PoP-DF, Brasilia, DF, BR
| 200.19.119.101 | 200.19.119.101
| 0 | 1410274217 |
| 4103751309 | 146_164_245_5 | UFRJ,
Rio de Janeiro, Rio de Janeiro, BR |
146.164.245.5 | 146.164.245.5 |
1410275449 | 1410279509 |
+------------+----------------------------+------------------------------------------------------------+-----------------------------+-----------------+------------+------------+
13 rows in set (0.00 sec)
THanks.
Luís Felipe
On 09-09-2014 12:25, Aaron Brown wrote:
Hey Luis,
Could you try doing the following as root:
mysql owamp
and then, from the mysql client, run:
show tables;
and then:
select User from mysql.user;
Cheers,
Aaron
On Sep 9, 2014, at 11:18 AM, Luís Felipe wrote:
[root@psLT-USP: perfsonar] /etc/init.d/perfsonarbuoy_owp_master restart
Sent HUP to 2889
perfSONAR-BUOY OWAMP Measurement Service restarted
Before I do the restart, my .log had showed:
Sep 9 12:10:39 ps-lt owampd[2900]: FILE=sapi.c, LINE=303, Connection to ([143.107.6.19]:861) from ([143.107.6.19]:47983)
Sep 9 12:10:39 ps-lt owampd[2900]: FILE=sapi.c, LINE=466, ControlSession([143.107.6.19]:861) accepted from userid(nil):([143.107.6.19]:47983)
Sep 9 12:10:39 ps-lt owampd[1618]: FILE=policy.c, LINE=1811, ResReq ALLOWED: regular:request:bandwidth = 3360 (result = 3360, limit = 1000000)
Sep 9 12:10:39 ps-lt owampd[2926]: FILE=sapi.c, LINE=303, Connection to ([143.107.6.19]:861) from ([143.107.6.19]:54974)
Sep 9 12:10:39 ps-lt owampd[2926]: FILE=sapi.c, LINE=466, ControlSession([143.107.6.19]:861) accepted from userid(nil):([143.107.6.19]:54974)
Sep 9 12:10:39 ps-lt owampd[1618]: FILE=policy.c, LINE=1811, ResReq ALLOWED: regular:request:bandwidth = 3360 (result = 6720, limit = 1000000)
After, the .log is like the first e-mail I sent you:
Sep 9 12:12:47 ps-lt owampd[1618]: FILE=policy.c, LINE=1811, ResReq ALLOWED: regular:request:bandwidth = 3360 (result = 3360, limit = 1000000)
Sep 9 12:12:47 ps-lt owampd[2959]: FILE=sapi.c, LINE=303, Connection to ([143.107.6.19]:861) from ([143.107.6.19]:53893)
Sep 9 12:12:47 ps-lt owampd[2959]: FILE=sapi.c, LINE=466, ControlSession([143.107.6.19]:861) accepted from userid(nil):([143.107.6.19]:53893)
Sep 9 12:12:47 ps-lt owampd[1618]: FILE=policy.c, LINE=1811, ResReq ALLOWED: regular:request:bandwidth = 3360 (result = 6720, limit = 1000000)
Sep 9 12:13:47 ps-lt powcollector.pl[2966]: connect from [127.0.0.1]
Sep 9 12:13:47 ps-lt powcollector.pl[2966]: DBI connect('owamp:localhost','perfsonar',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /opt/perfsonar_ps/perfsonarbuoy_ma/bin/powcollector.pl line 631#012
Sep 9 12:13:47 ps-lt powcollector.pl[2966]: Connecting to database at /opt/perfsonar_ps/perfsonarbuoy_ma/bin/powcollector.pl line 631.#012
Sep 9 12:13:47 ps-lt powmaster.pl[2951]: Socket closed to server! at /opt/perfsonar_ps/perfsonarbuoy_ma/bin/powmaster.pl line 899.#012
Sep 9 12:13:47 ps-lt powmaster.pl[2951]: Server socket unwritable: : Closing at /opt/perfsonar_ps/perfsonarbuoy_ma/bin/powmaster.pl line 764.#012
Sep 9 12:13:47 ps-lt powmaster.pl[2951]: txfr() failed to transfer information to localhost at /opt/perfsonar_ps/perfsonarbuoy_ma/bin/powmaster.pl line 1091.#012
Sep 9 12:13:47 ps-lt powcollector.pl[2185]: handle_req:2966 exited: 65280
Thanks.
Luís Felipe
On 09-09-2014 12:12, Aaron Brown wrote:
Hey Luis,
Can you try doing “service perfsonarbuoy_owp_master restart”, and see if it spits any errors out?
Cheers,
Aaron
On Sep 9, 2014, at 11:05 AM, Luís Felipe wrote:
Yes. it does!
Thanks.
Luís Felipe
On 09-09-2014 12:01, Aaron Brown wrote:
Hey Luis,
Does /var/lib/mysql/mysql.sock exist?
Cheers,
Aaron
On Sep 8, 2014, at 4:22 PM, Luís Felipe
wrote:
I checked if the service is running and it is running normally. Could be other thing?
Thanks.
Luís Felipe
On 08-09-2014 08:47, Antoine Delvaux wrote:
Hi Luis,
Can you check your MySQL server is running? And if not restart it. That can be done with:
sudo service mysqld status
sudo service mysqld restart
If MySQL doesn't start, there'll probably be more information in the /var/log/messages file.
Cheers,
Antoine.
Le 5 sept. 2014 à 20:55, Luís Felipe
a écrit :
Hi, everyone!
When I acess the Graphs Services, all my tests appear inactive :(
In the .log the messages appear, but I don't know what they means:
Sep 5 17:49:39 ps-lt powcollector.pl[5141]: connect from [127.0.0.1]
Sep 5 17:49:39 ps-lt powcollector.pl[5141]: DBI connect('owamp:localhost','perfsonar',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /opt/perfsonar_ps/perfsonarbuoy_ma/bin/powcollector.pl line 631#012
Sep 5 17:49:39 ps-lt powcollector.pl[5141]: Connecting to database at /opt/perfsonar_ps/perfsonarbuoy_ma/bin/powcollector.pl line 631.#012
Sep 5 17:49:39 ps-lt powmaster.pl[4950]: Socket closed to server! at /opt/perfsonar_ps/perfsonarbuoy_ma/bin/powmaster.pl line 899.#012
Sep 5 17:49:39 ps-lt powmaster.pl[4950]: Server socket unwritable: : Closing at /opt/perfsonar_ps/perfsonarbuoy_ma/bin/powmaster.pl line 764.#012
Sep 5 17:49:39 ps-lt powmaster.pl[4950]: txfr() failed to transfer information to localhost at /opt/perfsonar_ps/perfsonarbuoy_ma/bin/powmaster.pl line 1091.#012
Sep 5 17:49:39 ps-lt powcollector.pl[2056]: handle_req:5141 exited: 65280
How can I repair this?
Thanks.
Luís Felipe.
-- --
Antoine Delvaux Skype: toninb
Systems Engineer
http://www.dante.net
DANTE
http://www.geant.net
+221.703368313 XMPP:
PGP fingerprint: DC65 0D8B 6938 9229 33C3 18CA 4EB6 09D3 A333 3378
DANTE is the trading name of Delivery of Advanced Network Technology
to Europe Limited registered in England & Wales. Registration Number
2806796. Registered Office - 9400 Garsington Road, Oxford Business
Park, Oxford OX4 2HN.
|
