gcc και mysql

[avr_freak]

Egrapsa to parakato programma se gcc (Centos 5)

Κώδικας: Επιλογή όλων

#include <mysql.h>
#include <stdio.h>
#include <stdlib.h>

MYSQL mysql;

int main&#40;&#41;
&#123;
if&#40;mysql_init&#40;&mysql&#41; == NULL&#41;
&#123;
printf&#40;"Nope &#40;init&#41;!\n"&#41;;
&#125;

if &#40;mysql_real_connect&#40;&mysql,"localhost","user,"pass","db",0,NULL,0&#41;==NULL&#41; 
&#123;
printf&#40;"Nope &#40;connect&#41;!\n"&#41;;

&#125;

else
&#123;
printf&#40;"OK !\n"&#41;;
mysql_close&#40;&mysql&#41;;
&#125;
	
&#125;

meta to kano compile (xoris lathoi) ... me tin entoli

Κώδικας: Επιλογή όλων

gcc -I/usr/include/mysql -L/usr/lib/mysql test.c -lmysqlclient

otan ekteleso ./a.out omos panta bgazei to "Nope (connect)!" meta apo polli ora ... blepete kanena lathos ?

PS : Ola afta ginonte san root kai se apomakrismeno server !!!

[avr_freak]

Kati prepei na pezei me to firewall giati
ama balw

Κώδικας: Επιλογή όλων

if(mysql_real_connect(&mysql,"127.0.0.1","root,"","test",0,NULL,0)==NULL) 

pezei kanonika !
opios xerei kati as postarei ...

[soteres2002]

mallon to port 3306 einai klisto stin apenanti pleura, kai i sindesi kanei timeout (des "...meta apo poli ora"). An exeis prosbasi sto router i sto apomakrismeno mihanima, des ta iptables rules (mipos blockarei eiserxomenes sindeseis apo kei kai tis kanei drop). an o mysql server einai apo shared hosting, sxedon panta klinoune to port. kai se merikes periptoseis boreis na kaneis forward to port mesa apo kapoio panel diaxeirisis, allios den pistebo kapoios sovaros administrator na dextei na anoiksei port oste na kaneis aplos dokimes remotely.

mathaineis tin libmysqlclient, i kaneis aplos dokimes tis bibliothikis?

[avr_freak]

Efxaristo katarxas gia tin apantisi soretes2002, tha to kitaxw, basika ptyxiaki kanw kai prepei na perno kapia dedomena sti db kai na kano kapious ypologismous kai statistikes

Kai o logos pou to klinoun to port ?

[soteres2002]

An skefteis oti se enan shared hosting periballon exoun enan server MySQL (i akoma kai cluster na itan dld) p exei oles tis baseis dedomenon ton pelaton tous, einai ligo administeriki mlk na anoigeis to port oste na dokimazei o kathenas me brute force texnikes na bei ston server apo apostasi. Akoma pio eukola, tha borousan na kanoune kai DDOS attacks ston server! Alla, fisika gia na apotrepsoune remote exploits ginetai perissotero (apo tis xeiroteres dld). Panta tha iparxoune kai alloi sovarou logoi gia na to klisei enas sysadmin. to zitima einai pos an iparxei enas logos na to kliseis, to klineis, kai den to klineis askopa.

einai dld san mia kibernisi na exei ena mihanima me mia basi pano, stin opoia exei ethnika mistika, kai exei anoikta ta ports oste na dieukolinei "hackers" na dokimazoune remote exploits enantion tis basis oste na klepsoune ta mistika, i aplos na parenoxloune ton server. Opote epivalete na probei kaneis se auto to basiko bima prostasias.

dokimase na to kaneis se ena topiko diktio xoris firewall rules ktl. An doulepsei ekei, tha doulepsei to idio kai sto internet (arkei na min iparxoune ki ekei pouthena configs p na se xalane, sto local kai remote end)

[avr_freak]

Mallon tha protino tou professora na to kano se php ....opote ola tha ta kanei o server ! Thanks xana gia tin apantinisi ...mou itan poli xrisimi !

[soteres2002]

auto to binary boreis na to kaneis na trexei san cgi script me forking. arkei na to kaneis na stelnei HTTP header gia to content-type tou output. Auto ginetai an baleis ena printf("Content-type: text/html\r\n\r\n"); prin exeis opoiadipote alli eksodo. To zitima einai ta dependencies apo bibliothikes opos libc kai i libmysqlclient na iparxoune kai ston hoster sou, i ekei tespa p tha baleis to binary gia na trexei. An exeis grapsei arketo kodika kai den exeis xrono gia metafora se PHP, checkare aplos ta dependencies apo bibliothikes tou binary me to ldd (px ldd binary), i kanto compile ekei ston server apephtias an exeis shell access.

[avr_freak]

basika apo php mporo na peraso orismata se ena binary arxeio xoris tin printf ?

[soteres2002]

basika apo php mporo na peraso orismata se ena binary arxeio xoris tin printf ?

den ktlb akribos ti ennoeis. an rotas to pos boreis na ekteleseis ena eksoteriko binary (me +x perms!!) tha borouses na kaneis:

Κώδικας: Επιλογή όλων

$ chmod +X ./somebinary

Κώδικας: Επιλογή όλων

<?php
print&#40;system&#40;"./somebinary -a A -b B"&#41;&#41;;
?>

[avr_freak]

Afto akribos ithela !