-- Database : nom de la base de données -- Logfile_name : nom du fichier log défini dans les propriétés de la base USE Database GO DBCC SHRINKFILE(Logfile_name, 1) BACKUP LOG Database WITH TRUNCATE_ONLY DBCC SHRINKFILE(Logfile_name, 1) GO
//superformance.blogspot.com
import org.apache.jmeter.util.JMeterUtils;
import org.apache.jmeter.samplers.SampleResult;
import org.apache.jmeter.assertions.AssertionResult;
import java.sql.DriverManager;
import org.hsqldb.jdbcDriver;
import java.sql.SQLException;
import java.sql.*;
db_url = "jdbc:mysql://localhost/jmeter";
driver = "com.mysql.jdbc.Driver";
user = "jmeter";
password = "jmeter";
Class.forName(driver);
Connection con = DriverManager.getConnection(db_url,user,password);
try {
long newlong = sampleResult.getStartTime();
String str = Long.toString(newlong);
String str3 = str.substring(0,(str.length()-3));
long lts = Long.parseLong(str3);
PreparedStatement pstmt = con.prepareStatement("INSERT INTO test (name ,host ,resp_code ,resp_time, request_time, stamp, resp_size ) VALUES (?, ?, ?, ?,FROM_UNIXTIME(?),?, ? ) ");
pstmt.setString(1, sampleResult.getSampleLabel() );
pstmt.setString(2, sampleResult.getURL().getHost());
pstmt.setString(3, sampleResult.getResponseCode() );
pstmt.setLong(4, sampleResult.getTime() );
pstmt.setLong(5,lts );
pstmt.setLong(6,sampleResult.getStartTime() );
pstmt.setInt(7,sampleResult.getBytes() );
int i = pstmt.executeUpdate();
print(i);
}
catch ( e ) {
e.printStackTrace();
}
catch (SQLException s) {
print(s.getSQLState());
}
finally {
con.close();
}
[SQL Server Native Client 11.0] Description=Microsoft SQL Server ODBC Driver V1.0 for Linux Driver=/opt/microsoft/sqlncli/lib64/libsqlncli-11.0.so.1790.0 Threading=1 UsageCount=1
<?php
$conn=odbc_connect("DRIVER={SQL Server Native Client 11.0};Server=IPADDRESS;Database=DATABASE","USERNAME","PASSWORD");
$sql="SELECT 'OK' as test";
$rs=odbc_exec($conn,$sql);
odbc_fetch_row($rs);
echo odbc_result($rs,"test");
?>
fichier test_odbc_pdo.php (si extention pdo_odbc)<?php
$dbh= new PDO('odbc:DRIVER={SQL Server Native Client 11.0};Server=IPADDRESS;Database=DATABASE', 'username', 'password');
$query = "SELECT 'OK' as test";
$stmt = $dbh->prepare("$query");
$stmt->execute();
while ($row = $stmt->fetch()) {
print_r($row["test"]);
}
unset($dbh); unset($stmt);
?>
Les scripts PHP ci dessus doivent renvoyer "OK" Si tout fonctionne sinon... tout un tas d'erreurs ! Les problèmes les plus courants sont liés à l'authentification, vérifier la connexion dans SQL Server et qu'elle a des droits suffisants sur la base, (par défaut public n'est pas suffisant !)apt-get install console-setup
LoadModule proxy_module modules/mod_proxy.so LoadModule proxy_balancer_module modules/mod_proxy_balancer.so LoadModule proxy_connect_module modules/mod_proxy_connect.so
#definition du groupe de serveurs
<Proxy balancer://load_test>
BalancerMember http://192.168.1.1:8080/test loadfactor=33 route=serveur1
BalancerMember http://192.168.1.2:8080/test loadfactor=33 route=serveur2
BalancerMember http://192.168.1.3:8080/test loadfactor=33 route=serveur3
BalancerMember http://192.168.1.4:8080/test loadfactor=33 route=serveur4 status=D
</Proxy>
# stickysession
#Si Application java JSESSIONID
#Si application php phpsessid
#sinon on cree un cookie contenant le nom du serveur
#Header add Set-Cookie "ROUTEID=.%{BALANCER_WORKER_ROUTE}e; path=/" env=BALANCER_ROUTE_CHANGED
ProxyPass /test balancer://load_test stickysession=JSESSIONID|jsessionid nofailover=Off timeout=45 failonstatus=503
ProxyPassReverse /test http://192.168.1.1:8080/test
ProxyPassReverse /test http://192.168.1.2:8080/test
ProxyPassReverse /test http://192.168.1.3:8080/test
ProxyPassReverse /test http://192.168.1.4:8080/test
# definition de l'interface d'administration
<Location /balancer-manager>
SetHandler balancer-manager
Order Deny,Allow
Allow from 127.0.0.1
</Location>
awk '{if ($9 != "200") {a[$7"$"$9]+=1} } END{for (i in a) {split(i,b,"$" ); print a[i] " " b[1] " " b[2] " " } }' /var/log/httpd/access_log
@echo off
rem
echo Backup Firefox profile
echo http://superformance.blogspot.com
rem
set datapath=%~dp0data\
Set counterfile=%datapath%%username%.txt
set logpath=%~dp0%log\
set outputpath=%datapath%%username%\
if not exist %datapath% mkdir %datapath%
if not exist %logpath% mkdir %logpath%
if not exist %outputpath% mkdir %outputpath%
for /f "tokens=2,3 delims=/ " %%a in ('echo %date%') do set logfile=%logpath%%%b-%%a-%username%.log
call :Logadd "Debut de %~nx0"
set counter=0
if exist %counterfile% for /f %%a in ('type %counterfile%') do set counter=%%a
if %counter% LSS 0 set counter=0
if %counter% GTR 15 set counter=0
set /a counter=counter+1
echo %counter% > %counterfile%
set outputfile=%outputpath%%username%-profile-%counter%.zip
if exist %outputfile% del %outputfile%
call :Logadd "Archive N° %counter%"
set ffoxpath=%appdata%\Mozilla\firefox\
if not exist %ffoxpath% goto :eof
for /f "tokens=2 delims==" %%a in ('type %ffoxpath%profiles.ini ^| find /i "path"') do set ffprofile=%ffoxpath%%%a
call :Logadd "Creation de l'Archive %outputfile%"
if exist %outputfile% del %outputfile%
"C:\Program Files\7-Zip\7z.exe" a -tzip %outputfile% %ffprofile%\
if %errorlevel% NEQ 0 call :Logadd "Erreur dans la Creation de l'archive"
call :Logadd "Fin de %~nx0"
goto :eof
:Logadd
Echo %date% - %time% - %~1
Echo %date% - %time% - %~1 >> %logfile%
goto :eof
set PATH=%PATH%;c:\unxutils\usr\local\wbin\;c:\unxutils\binAttention aux commandes qui portent le même nom et qui font des choses différentes :
Apachetop -f /var/log/httpd/access.log
LoadModule status_module modules/mod_status.so ExtendedStatus On <Location /server-status> SetHandler server-status Order deny,allow Deny from all Allow from 127.0.0.1 </Location>
Attention : la config ci dessus utilise du filtrage IP, du coup la page n'est accessible que sur la machine locale. Pour sécuriser on peut aussi mettre un htaccess/htpasswd en plus.On voit que le serveur n'est chargé ici, on a un maximum de symbole "_" et 1 seul "W" (normal je suis tout seul sur mon serveur !). En cas de problème de charge, c'est l'inverse ! très peu de "_" et beaucoup de "W",'R',"K" etc..
- 1 requests currently being processed, 149 idle workers
________________________________________________________________ ________________________________________________________________ _____________________WScoreboard Key:
"_" Waiting for Connection, "S" Starting up, "R" Reading Request,
"W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup,
"C" Closing connection, "L" Logging, "G" Gracefully finishing,
"I" Idle cleanup of worker, "." Open slot with no current process
for /f "tokens=1,2 delims=;" %a in (fichier.csv) do echo %a %bCe que fait cette commande : affiche les colonnes 1 (variable %a) et 2 (variable %b) de fichier.csv dont le séparateur est ;
for /f %a in (' date /t') do set date=%aCe que fait cette commande : exécute la commande date /t et stocke le résultat dans une variable %date%