src/freenet/trustlistrequester.cpp

   1 #include "../../include/freenet/trustlistrequester.h"\r
   2 #include "../../include/option.h"\r
   3 #include "../../include/stringfunctions.h"\r
   4 #include "../../include/freenet/trustlistxml.h"\r
   5 \r
   6 #ifdef XMEM\r
   7         #include <xmem.h>\r
   8 #endif\r
   9 \r
  10 TrustListRequester::TrustListRequester()\r
  11 {\r
  12         Initialize();\r
  13 }\r
  14 \r
  15 TrustListRequester::TrustListRequester(FCPv2 *fcp):IIndexRequester<long>(fcp)\r
  16 {\r
  17         Initialize();\r
  18 }\r
  19 \r
  20 const bool TrustListRequester::HandleAllData(FCPMessage &message)\r
  21 {\r
  22         DateTime now;\r
  23         SQLite3DB::Statement st;\r
  24         SQLite3DB::Statement trustst;\r
  25         std::vector<std::string> idparts;\r
  26         long datalength;\r
  27         std::vector<char> data;\r
  28         TrustListXML xml;\r
  29         long identityid;\r
  30         long index;\r
  31 \r
  32         now.SetToGMTime();\r
  33         StringFunctions::Split(message["Identifier"],"|",idparts);\r
  34         StringFunctions::Convert(message["DataLength"],datalength);\r
  35         StringFunctions::Convert(idparts[1],identityid);\r
  36         StringFunctions::Convert(idparts[2],index);\r
  37 \r
  38         // wait for all data to be received from connection\r
  39         while(m_fcp->Connected() && m_fcp->ReceiveBufferSize()<datalength)\r
  40         {\r
  41                 m_fcp->Update(1);\r
  42         }\r
  43 \r
  44         // if we got disconnected- return immediately\r
  45         if(m_fcp->Connected()==false)\r
  46         {\r
  47                 return false;\r
  48         }\r
  49 \r
  50         // receive the file\r
  51         data.resize(datalength);\r
  52         m_fcp->ReceiveRaw(&data[0],datalength);\r
  53 \r
  54         // parse file into xml and update the database\r
  55         if(xml.ParseXML(std::string(data.begin(),data.end()))==true)\r
  56         {\r
  57                 // find the identity name and public key of the identity publishing the trust list\r
  58                 std::string publisherid="";\r
  59                 st=m_db->Prepare("SELECT Name,PublicKey FROM tblIdentity WHERE IdentityID=?;");\r
  60                 st.Bind(0,identityid);\r
  61                 st.Step();\r
  62                 if(st.RowReturned())\r
  63                 {\r
  64                         std::string publishername="";\r
  65                         std::string publisherpublickey="";\r
  66                         st.ResultText(0,publishername);\r
  67                         st.ResultText(1,publisherpublickey);\r
  68                         publisherid=publishername;\r
  69                         if(publisherpublickey.size()>4)\r
  70                         {\r
  71                                 publisherid+=publisherpublickey.substr(3,44);\r
  72                         }\r
  73                 }\r
  74                 st.Finalize();\r
  75 \r
  76                 // drop all existing peer trust from this identity - we will rebuild it when we go through each trust in the xml file\r
  77                 st=m_db->Prepare("DELETE FROM tblPeerTrust WHERE IdentityID=?;");\r
  78                 st.Bind(0,identityid);\r
  79                 st.Step();\r
  80                 st.Finalize();\r
  81 \r
  82                 st=m_db->Prepare("SELECT IdentityID FROM tblIdentity WHERE PublicKey=?;");\r
  83                 trustst=m_db->Prepare("INSERT INTO tblPeerTrust(IdentityID,TargetIdentityID,MessageTrust,TrustListTrust,MessageTrustComment,TrustListTrustComment) VALUES(?,?,?,?,?,?);");\r
  84                 \r
  85                 SQLite3DB::Statement idinsert=m_db->Prepare("INSERT INTO tblIdentity(PublicKey,DateAdded,AddedMethod) VALUES(?,?,?);");\r
  86                 \r
  87                 // loop through all trust entries in xml and add to database if we don't already know them\r
  88                 for(long i=0; i<xml.TrustCount(); i++)\r
  89                 {\r
  90                         int id;\r
  91                         std::string identity;\r
  92                         std::string messagetrustcomment="";\r
  93                         std::string trustlisttrustcomment="";\r
  94                         identity=xml.GetIdentity(i);\r
  95 \r
  96                         st.Bind(0,identity);\r
  97                         st.Step();\r
  98                         if(st.RowReturned()==false)\r
  99                         {\r
 100                                 idinsert.Bind(0,identity);\r
 101                                 idinsert.Bind(1,now.Format("%Y-%m-%d %H:%M:%S"));\r
 102                                 idinsert.Bind(2,"trust list of "+publisherid);\r
 103                                 idinsert.Step(true);\r
 104                                 id=idinsert.GetLastInsertRowID();\r
 105                                 idinsert.Reset();\r
 106                         //      m_db->ExecuteInsert("INSERT INTO tblIdentity(PublicKey,DateAdded,AddedMethod) VALUES('"+identity+"','"+now.Format("%Y-%m-%d %H:%M:%S")+"');",(long &)id);\r
 107                         }\r
 108                         else\r
 109                         {\r
 110                                 st.ResultInt(0,id);\r
 111                         }\r
 112                         st.Reset();\r
 113 \r
 114                         //insert trust for this identity\r
 115                         trustst.Bind(0,identityid);\r
 116                         trustst.Bind(1,id);\r
 117                         if(xml.GetMessageTrust(i)==-1)\r
 118                         {\r
 119                                 trustst.Bind(2);\r
 120                         }\r
 121                         else\r
 122                         {\r
 123                                 trustst.Bind(2,xml.GetMessageTrust(i));\r
 124                         }\r
 125                         if(xml.GetTrustListTrust(i)==-1)\r
 126                         {\r
 127                                 trustst.Bind(3);\r
 128                         }\r
 129                         else\r
 130                         {\r
 131                                 trustst.Bind(3,xml.GetTrustListTrust(i));\r
 132                         }\r
 133                         messagetrustcomment=xml.GetMessageTrustComment(i);\r
 134                         trustlisttrustcomment=xml.GetTrustListTrustComment(i);\r
 135                         // limit comments to 50 characters each\r
 136                         if(messagetrustcomment.size()>50)\r
 137                         {\r
 138                                 messagetrustcomment.erase(50);\r
 139                         }\r
 140                         if(trustlisttrustcomment.size()>50)\r
 141                         {\r
 142                                 trustlisttrustcomment.erase(50);\r
 143                         }\r
 144                         trustst.Bind(4,messagetrustcomment);\r
 145                         trustst.Bind(5,trustlisttrustcomment);\r
 146                         trustst.Step();\r
 147                         trustst.Reset();\r
 148 \r
 149                 }\r
 150                 trustst.Finalize();\r
 151                 st.Finalize();\r
 152 \r
 153                 st=m_db->Prepare("INSERT INTO tblTrustListRequests(IdentityID,Day,RequestIndex,Found) VALUES(?,?,?,'true');");\r
 154                 st.Bind(0,identityid);\r
 155                 st.Bind(1,idparts[4]);\r
 156                 st.Bind(2,index);\r
 157                 st.Step();\r
 158                 st.Finalize();\r
 159 \r
 160                 m_log->WriteLog(LogFile::LOGLEVEL_DEBUG,"TrustListRequester::HandleAllData parsed TrustList XML file : "+message["Identifier"]);\r
 161         }\r
 162         else\r
 163         {\r
 164                 // bad data - mark index\r
 165                 st=m_db->Prepare("INSERT INTO tblTrustListRequests(IdentityID,Day,RequestIndex,Found) VALUES(?,?,?,'false');");\r
 166                 st.Bind(0,identityid);\r
 167                 st.Bind(1,idparts[4]);\r
 168                 st.Bind(2,index);\r
 169                 st.Step();\r
 170                 st.Finalize();\r
 171 \r
 172                 m_log->WriteLog(LogFile::LOGLEVEL_ERROR,"TrustListRequester::HandleAllData error parsing TrustList XML file : "+message["Identifier"]);\r
 173         }\r
 174 \r
 175         // remove this identityid from request list\r
 176         RemoveFromRequestList(identityid);\r
 177 \r
 178         return true;\r
 179 \r
 180 }\r
 181 \r
 182 const bool TrustListRequester::HandleGetFailed(FCPMessage &message)\r
 183 {\r
 184         DateTime now;\r
 185         SQLite3DB::Statement st;\r
 186         std::vector<std::string> idparts;\r
 187         long identityid;\r
 188         long index;\r
 189 \r
 190         now.SetToGMTime();\r
 191         StringFunctions::Split(message["Identifier"],"|",idparts);\r
 192         StringFunctions::Convert(idparts[1],identityid);\r
 193         StringFunctions::Convert(idparts[2],index);     \r
 194 \r
 195         // if this is a fatal error - insert index into database so we won't try to download this index again\r
 196         if(message["Fatal"]=="true")\r
 197         {\r
 198                 st=m_db->Prepare("INSERT INTO tblTrustListRequests(IdentityID,Day,RequestIndex,Found) VALUES(?,?,?,'false');");\r
 199                 st.Bind(0,identityid);\r
 200                 st.Bind(1,idparts[4]);\r
 201                 st.Bind(2,index);\r
 202                 st.Step();\r
 203                 st.Finalize();\r
 204 \r
 205                 m_log->WriteLog(LogFile::LOGLEVEL_ERROR,"TrustListRequester::HandleGetFailed fatal error requesting "+message["Identifier"]);\r
 206         }\r
 207 \r
 208         // remove this identityid from request list\r
 209         RemoveFromRequestList(identityid);\r
 210 \r
 211         return true;\r
 212 \r
 213 }\r
 214 \r
 215 void TrustListRequester::Initialize()\r
 216 {\r
 217         std::string tempval="";\r
 218         m_fcpuniquename="TrustListRequester";\r
 219         Option::Instance()->Get("MaxIdentityRequests",tempval);\r
 220         StringFunctions::Convert(tempval,m_maxrequests);\r
 221         if(m_maxrequests<1)\r
 222         {\r
 223                 m_maxrequests=1;\r
 224                 m_log->WriteLog(LogFile::LOGLEVEL_ERROR,"Option MaxTrustListRequests is currently set at "+tempval+".  It must be 1 or greater.");\r
 225         }\r
 226         if(m_maxrequests>100)\r
 227         {\r
 228                 m_log->WriteLog(LogFile::LOGLEVEL_WARNING,"Option MaxTrustListRequests is currently set at "+tempval+".  This value might be incorrectly configured.");\r
 229         }\r
 230         m_tempdate.SetToGMTime();\r
 231 }\r
 232 \r
 233 void TrustListRequester::PopulateIDList()\r
 234 {\r
 235         DateTime date;\r
 236         int id;\r
 237         std::string sql;\r
 238 \r
 239         date.SetToGMTime();\r
 240 \r
 241         // select identities we want to query (we've seen them today and they are publishing trust list) - sort by their trust level (descending) with secondary sort on how long ago we saw them (ascending)\r
 242         sql="SELECT IdentityID FROM tblIdentity ";\r
 243         sql+="WHERE Name IS NOT NULL AND Name <> '' AND PublicKey IS NOT NULL AND PublicKey <> '' AND LastSeen>='"+date.Format("%Y-%m-%d")+"' AND PublishTrustList='true' AND LocalTrustListTrust>=(SELECT OptionValue FROM tblOption WHERE Option='MinLocalTrustListTrust') AND ( PeerTrustListTrust IS NULL OR PeerTrustListTrust>=(SELECT OptionValue FROM tblOption WHERE Option='MinPeerTrustListTrust') )";\r
 244         sql+="ORDER BY LocalTrustListTrust DESC, LastSeen;";\r
 245 \r
 246         SQLite3DB::Statement st=m_db->Prepare(sql);\r
 247         st.Step();\r
 248 \r
 249         m_ids.clear();\r
 250 \r
 251         while(st.RowReturned())\r
 252         {\r
 253                 st.ResultInt(0,id);\r
 254                 m_ids[id]=false;\r
 255                 st.Step();\r
 256         }\r
 257 }\r
 258 \r
 259 void TrustListRequester::StartRequest(const long &identityid)\r
 260 {\r
 261         DateTime now;\r
 262         FCPMessage message;\r
 263         std::string publickey;\r
 264         int index;\r
 265         std::string indexstr;\r
 266         std::string identityidstr;\r
 267 \r
 268         SQLite3DB::Statement st=m_db->Prepare("SELECT PublicKey FROM tblIdentity WHERE IdentityID=?;");\r
 269         st.Bind(0,identityid);\r
 270         st.Step();\r
 271 \r
 272         if(st.RowReturned())\r
 273         {\r
 274                 st.ResultText(0,publickey);\r
 275 \r
 276                 now.SetToGMTime();\r
 277 \r
 278                 SQLite3DB::Statement st2=m_db->Prepare("SELECT MAX(RequestIndex) FROM tblTrustListRequests WHERE Day=? AND IdentityID=?;");\r
 279                 st2.Bind(0,now.Format("%Y-%m-%d"));\r
 280                 st2.Bind(1,identityid);\r
 281                 st2.Step();\r
 282 \r
 283                 index=0;\r
 284                 if(st2.RowReturned())\r
 285                 {\r
 286                         if(st2.ResultNull(0)==false)\r
 287                         {\r
 288                                 st2.ResultInt(0,index);\r
 289                                 index++;\r
 290                         }\r
 291                 }\r
 292                 st2.Finalize();\r
 293 \r
 294                 StringFunctions::Convert(index,indexstr);\r
 295                 StringFunctions::Convert(identityid,identityidstr);\r
 296 \r
 297                 message.SetName("ClientGet");\r
 298                 message["URI"]=publickey+m_messagebase+"|"+now.Format("%Y-%m-%d")+"|TrustList|"+indexstr+".xml";\r
 299                 message["Identifier"]=m_fcpuniquename+"|"+identityidstr+"|"+indexstr+"|"+message["URI"];\r
 300                 message["ReturnType"]="direct";\r
 301                 message["MaxSize"]="1000000";                   // 1 MB\r
 302 \r
 303                 m_fcp->SendMessage(message);\r
 304 \r
 305                 m_requesting.push_back(identityid);\r
 306         }\r
 307         st.Finalize();\r
 308 \r
 309         m_ids[identityid]=true;\r
 310 \r
 311 }\r