WikiTeki /  Modifications de « AlexandreDomont/ToDo »

--> proftpd
A attendant de faire une page dédiée
10.72.1.42 sur vzauf2.fr.auf
/srv/ftp
utilisateur écriture: xerox
utilisateur lecture : anonymous

# -*- coding: utf-8 -*-

from datetime import datetime
import MySQLdb 
import os, sys, time
import logging
import smtplib
from email.MIMEText import MIMEText
from email.Utils import COMMASPACE


db_source=MySQLdb.connect(host="localhost",user="lecturegrr",passwd="hihihhihi",db="grr")
cursor = db_source.cursor()

send_to= ['alexandre.domont@auf.org','david.violette@auf.org','pascal.sanel@auf.org']
code_visio = '%9@@29@OUI@%'
code_ordi = '%27@@28@0@%'
code_video = '%30@@9@OUI@%'


def sendmail(sujet):
        mail = MIMEText("http://reservations.fr.auf/week_all.php?year=2010&month=06&day=22&area=1")
        mail['From'] = "GRR"
        mail['Subject'] = sujet
        mail['To'] = COMMASPACE.join(send_to)
        smtp = smtplib.SMTP()
        smtp.connect()
        smtp.sendmail("GRR", send_to, mail.as_string())
        smtp.close()

def interro(code, type):
        # les visio prévues dans l'heure (3600)
        if code == code_ordi:
                sql="select id, start_time, start_time-UNIX_TIMESTAMP(), name, overload_desc, UNIX_TIMESTAMP() from grr_entry where overload_desc not like'" + code +"'and start_time-(UNIX_TIMESTAMP()+7200)>0 and start_time-(UNIX_TIMESTAMP()+7200)<3600"
        else:
                sql="select id, start_time, start_time-UNIX_TIMESTAMP(), name, overload_desc, UNIX_TIMESTAMP() from grr_entry where overload_desc like'" + code +"'and start_time-(UNIX_TIMESTAMP()+7200)>0 and start_time-(UNIX_TIMESTAMP()+7200)<3600"

        cursor.execute(sql)
        result = list(cursor.fetchall())
        
        for row in result:
                if result != None:
                        print row[3] 
                        print datetime.fromtimestamp(row[1])
                        #print datetime.fromtimestamp(row[5])

                        H = (row[2]/3600) - 1
                        T = datetime.fromtimestamp(row[1])
                        T = str(T.hour) + ':' + str(T.minute)
                        # print T
                        S = 'GRR ATTENTION ' + type +' : ' + row[3] + '--> ' + str(T)
                        sendmail(S)



#
interro(code_visio,'VISIO')
interro(code_ordi,'ORDINATEUR')
interro(code_video,'VIDEO_PROJECTEUR')

db_source.close()

http://www.flumotion.net/

• http://blog.nicolargo.com/2008/06/flumotion-le-streaming-libre.html

• http://www.lephpfacile.com/annuaire-rss/1-informations/2-actualites/58-planet-libre/267314-nicolargo-configuration-pas-a-pas-d-un-serveur-de-streaming-flumotion