perfSONAR User Q&A and Other Discussion

[Aaron Brown <>]

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.
>>>>>> 
>>>>>> 
>>> 
>> 
>