コード例 #1
0
    def connectToDb(self):
        """
        """
        # FIXME:
        # set-variable=max_connections=500
        # set-variable=wait_timeout=200

        logging.debug("Connecting to database...")
        db = None

        try:
            if config.get("database", "type") == "mysql":
                logging.debug("Using MySQL driver")
                db = DB.connect(
                    host = config.get("database", "host"),
                    port = config.getint("database", "port"), 
                    user = config.get("database", "user"), 
                    passwd = config.get("database", "password"), 
                    db = config.get("database", "database") )
            else:
                logging.debug("Using Firebird driver")
                db = DB.connect(
                    host = config.get("database", "host"),
                    user = config.get("database", "user"), 
                    password = config.get("database", "password"), 
                    database = config.get("database", "database") )
 
            self.checkDbStatus(db)

            logging.debug("Connected to database")
        except DB.DatabaseError, exc:
            logging.error("DB connection: " + str(exc))
コード例 #2
0
    def __init__(self, HOST = '', PORT = 2468, rootPassword = ''):
        """ Constructor of the server

        Defines many variables

        @HOST = Which Adress to listen to, Default : listens on all available interfaces
        @PORT = Which Port to listen on, Default : 50007
        @rootPassword = Defines the root password, to administrate the server (shutdown, ...)

        <Returns nothing"""

        # Version
        self.version = version

        # Root password
        self.rootPassword = rootPassword

        # Connection informations
        self.HOST = HOST
        self.PORT = PORT

        # Connected clients and available rooms
        self.allNickNames = {}
        self.allRooms = {}

        # DB connection flag
        self.dbOk = False

        try:
            asyncore.dispatcher.__init__(self)

            self.create_socket(socket.AF_INET, socket.SOCK_STREAM)
            self.set_reuse_addr()
            self.bind((self.HOST, self.PORT))
            self.listen(5)
        except:
            logging.error("Error while starting: Network address and port already in use ?")
            sys.exit()

        if self.HOST == "":
            showHost = "All interfaces"
        else:
            showHost = self.HOST


        logging.info("Running on: %s" % showHost)
        logging.info("Port: %s" % self.PORT)

        self.db = self.connectToDb()
        if self.db is None:
            self.serverShutDown()

        self.timer = threading.Thread(target = self.timerThread, args=(self,))
        self.timer.start()
コード例 #3
0
    def stop(self, pid, restart, msg = None):

        logging.info("Stopping Palabre...")
        if not pid:
            if self.daemon:
                sys.stderr.write("Could not stop, Palabre is not running (pid file '%s' is missing).\n" % self.pidfile)
            logging.warning("Could not stop, Palabre is not running (pid file '%s' is missing)." % self.pidfile)
            if not restart:
                logging.shutdown()
                logfile.close()
                sys.exit(1)
        else:
            ## There should be a better way, but i'm too lazy to search... but
            ## i'm sure there's a better way
            
            # if we're not a daemon we should clean up before committing suicide
            if not self.daemon:
                os.remove(self.pidfile)
                logging.shutdown()
                logfile.close()
            try:
                #global topServer
                #topServer.notifyStop()
                #time.sleep(1)
                print "sending signal..."
                os.kill(pid, signal.SIGUSR1)
                #os.system("kill -USR1 %d" % pid)

                print "signal sent"
                while True:
                    print "in the signal loop", pid
                    os.kill(pid,SIGTERM)
                    os.kill(pid,signal.SIGKILL)
                    time.sleep(1)
            except OSError, e:
                if e.strerror.find("No such process") >= 0:
                    os.remove(self.pidfile)
                    if not restart:
                        logging.info("...stopped.")
                        logging.shutdown()
                        logfile.close()
                        sys.exit(0)
                else:
                    logging.error("%s" % e.strerror)
                    logging.shutdown()
                    logfile.close()
                    sys.exit(1)
            except Exception, e:
                    logging.error("%s" % e.strerror)
                    logging.shutdown()
                    logfile.close()
                    sys.exit(1)
コード例 #4
0
    def _clientLeft(self, uid):
        self.db.commit()

        self._showSessions()

        self.db.begin()
        c = self.db.cursor()
        s = "select id, sesid from sessions where userid = %d" % uid
        c.execute(s)

        rs = c.fetchone()
        if rs is None:
            logging.error("Disconnect was requested by user which does not have associated session (id='%d', sesId='unknown')" % (uid))
            return

        s = "delete from sessions where id = %d" % int(rs[0])
        c.execute(s)
        self.db.commit()

        self._showSessions()

        logging.info("User #%d successfully logged off" % uid)
コード例 #5
0
 def isBlocked(self, uid):
     rc = True
     try:
         c = self.db.cursor()
         c.execute("select isblocked from users where id = %d" % uid)
         rs = c.fetchone()
         if rs is None:
             raise InnerException(47, ERRORS[47] % uid)
         else:
             try:
                 if int(rs[0]) == 0:
                     rc = False
                 elif int(rs[0]) == 1:
                     rc = True
                 else:
                     raise InnerException(45, ERRORS[45])
                 
             except Exception, msg:
                 logging.error("Wrong value for isblocked = '%s'" % str(rs[0]))
                 raise Exception(msg)
     except:
         raise
     return rc