Re: lug-bg: problem: php/apache/mysql
Podoben sluchai imah pod Solaris, kogato MySQL beshe kompiliran ne sas tezi bilioteki, koito imah na mashinata, a sas drugi versii. Vij tova i ako triabva compilirai nanovo. HTH Peter Hello Ivan, Thursday, August 29, 2002, 6:15:27 PM, you wrote: Ivan Dimitrov> $dbh = mysql_connect('localhost','root','parola') or die("FUCK"); Ivan Dimitrov> $SQL = "show tables"; Ivan Dimitrov> if(!$result = mysql_db_query('base',$SQL,$dbh)) exit("OFFF"); Ivan Dimitrov> while($row=mysql_fetch_array($result)){ Ivan Dimitrov>echo $row[0].""; Ivan Dimitrov> } ?>> Ivan Dimitrov> EOF Ivan Dimitrov> se ochakva da mi izkara vsichki tablici v 'base', no mi vrushta: Ivan Dimitrov> --from web Ivan Dimitrov> Warning: Access denied for user: 'root@localhost' (Using password: NO) in Ivan Dimitrov> /www/a.php on line 2 Ivan Dimitrov> Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' Ivan Dimitrov> (Using password: NO) in /www/a.php on line 2 Ivan Dimitrov> FUCK Ivan Dimitrov> --stop:)-- Ivan Dimitrov> zabelejete che izpisva Using password: NO Ivan Dimitrov> i tuk idva strannoto, ot mysql.log Ivan Dimitrov> -- Ivan Dimitrov> 020829 15:04:07 8 Connect Access denied for user: 'root@localhost' (Using password: YES) Ivan Dimitrov> -- Ivan Dimitrov> i za iznenada na vsichki komandada: Ivan Dimitrov> mysql -pparola base -h localhost -u root Ivan Dimitrov> raboti! sirech, v mysql pravata sa pravelni Ivan Dimitrov> produljix da si igraq sas skripta kato smenix IP-to i usera, v Ivan Dimitrov> mysql.log-a produljavashe da mi izpisva root@localhost. nemoga da Ivan Dimitrov> predpoloja che sa nqkade hardcodenati neshtata zashtoto nesa nikade po Ivan Dimitrov> konfigite. sushtiq skript raboti na drugi mashini sas sushtata Ivan Dimitrov> konfiguracia. A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers). http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
Re: lug-bg: problem: php/apache/mysql
chmod 777 /www/a.php /s On Thu, 29 Aug 2002, Ivan Dimitrov wrote: > imam edin mnogo interesen sluchai, i zapochvam da se sduxvam che ne moga > da izmislq zashto se poluchava taka: > > apache 1.3.26 > php 4.2.2 > mysql 3.23.51 > > pri izpulnenie na tozi php skript > > cat >> a.php < EOF > $dbh = mysql_connect('localhost','root','parola') or die("FUCK"); > $SQL = "show tables"; > if(!$result = mysql_db_query('base',$SQL,$dbh)) exit("OFFF"); > while($row=mysql_fetch_array($result)){ >echo $row[0].""; > } > ?> > EOF > > se ochakva da mi izkara vsichki tablici v 'base', no mi vrushta: > > --from web > Warning: Access denied for user: 'root@localhost' (Using password: NO) in > /www/a.php on line 2 > > Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' > (Using password: NO) in /www/a.php on line 2 > FUCK > --stop:)-- > zabelejete che izpisva Using password: NO > i tuk idva strannoto, ot mysql.log > -- > 020829 15:04:07 8 Connect Access denied for user: 'root@localhost' (Using >password: YES) > -- > > i za iznenada na vsichki komandada: > mysql -pparola base -h localhost -u root > raboti! sirech, v mysql pravata sa pravelni > produljix da si igraq sas skripta kato smenix IP-to i usera, v > mysql.log-a produljavashe da mi izpisva root@localhost. nemoga da > predpoloja che sa nqkade hardcodenati neshtata zashtoto nesa nikade po > konfigite. sushtiq skript raboti na drugi mashini sas sushtata > konfiguracia. > > nadqvam se da ne vi oburkal s tezi obqsneniq... > predlojeniq? > blagodarq predvaritelno > > > > A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers). > http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora > To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html > > A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers). http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
Re: lug-bg: problem: php/apache/mysql
sheib: vij che scripta v deastvitelnost vrushta otgovor, inache shteshe da dava Internel Server Error:P* :) Peter: mysql ne sum kompiliral, direktno go izteglix kato debianski paket (sid). obache predi da pisha v grupata prekompilirax apache+php i removenax i posle pak installnax mysql-a. nqmashe promqna. sega mislq pak da napravq sushtiq fokus s mysql-a kato removena i basata i go ostavq da si sazdade svoqta nanovo. pojelaite mi uspex.:) Hi! I'm a .signature virus! Copy me into your ~/.signature, please! Ideas, like everything else in life, deserves to be free. On Thu, 29 Aug 2002, sheib wrote: > > chmod 777 /www/a.php > > /s > > > On Thu, 29 Aug 2002, Ivan Dimitrov wrote: > > > imam edin mnogo interesen sluchai, i zapochvam da se sduxvam che ne moga > > da izmislq zashto se poluchava taka: > > > > apache 1.3.26 > > php 4.2.2 > > mysql 3.23.51 > > > > pri izpulnenie na tozi php skript > > > > cat >> a.php < EOF > > > $dbh = mysql_connect('localhost','root','parola') or die("FUCK"); > > $SQL = "show tables"; > > if(!$result = mysql_db_query('base',$SQL,$dbh)) exit("OFFF"); > > while($row=mysql_fetch_array($result)){ > >echo $row[0].""; > > } > > ?> > > EOF > > > > se ochakva da mi izkara vsichki tablici v 'base', no mi vrushta: > > > > --from web > > Warning: Access denied for user: 'root@localhost' (Using password: NO) in > > /www/a.php on line 2 > > > > Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' > > (Using password: NO) in /www/a.php on line 2 > > FUCK > > --stop:)-- > > zabelejete che izpisva Using password: NO > > i tuk idva strannoto, ot mysql.log > > -- > > 020829 15:04:07 8 Connect Access denied for user: 'root@localhost' >(Using password: YES) > > -- > > > > i za iznenada na vsichki komandada: > > mysql -pparola base -h localhost -u root > > raboti! sirech, v mysql pravata sa pravelni > > produljix da si igraq sas skripta kato smenix IP-to i usera, v > > mysql.log-a produljavashe da mi izpisva root@localhost. nemoga da > > predpoloja che sa nqkade hardcodenati neshtata zashtoto nesa nikade po > > konfigite. sushtiq skript raboti na drugi mashini sas sushtata > > konfiguracia. > > > > nadqvam se da ne vi oburkal s tezi obqsneniq... > > predlojeniq? > > blagodarq predvaritelno > > > > > > > > A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers). > > http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora > > To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html > > > > > > > A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers). > http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora > To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html > > A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers). http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
Re: lug-bg: problem: php/apache/mysql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 29 August 2002 18:15, Ivan Dimitrov wrote: > --from web > Warning: Access denied for user: 'root@localhost' (Using password: NO) in > /www/a.php on line 2 > > Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' > (Using password: NO) in /www/a.php on line 2 > FUCK Problema ti e v nastrojkata na MySQL-a. Proveri si accountite za 'localhost'. Ako imash slednite zapisi : User | Host| Password | ... % localhost root localhost root localhost par0la moze da imash problem s validiraneto na user-a root. Problema se sastoi imenno v mnozestvoto zapisi i tochno koj ot tjax shte e purvi! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE9bzStaLnffbPBntcRAuu3AKDATxQwqUr+C4O1vAYeDyASfiDvSwCfQ37i NPKBtOqnttCnq5+9cxIIye0= =sjYd -END PGP SIGNATURE- A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers). http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
Re: lug-bg: problem: php/apache/mysql
i tova ne e, preinstalirax mysql otnovo, suzdadox nanovo bazite, tozi put ne sum daval dopulnitelni prava na nikoi, daje iztrix edin red za root@localhost, kato ostavix samo zapisa root@localhost pass=YES i pak sushtata rabota. pochvam da poluchavam glavobolie, analginche nqkoi da ima? nemoga da go sxvana, na mysql_connect mu davam izmisleni stoinosti za vsichki poleta: root2, localhost2, parola2 i pak v loga izpisva access denied for root@localhost Hi! I'm a .signature virus! Copy me into your ~/.signature, please! Ideas, like everything else in life, deserves to be free. On Fri, 30 Aug 2002, Dimitar Peikov wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Thursday 29 August 2002 18:15, Ivan Dimitrov wrote: > > --from web > > Warning: Access denied for user: 'root@localhost' (Using password: NO) in > > /www/a.php on line 2 > > > > Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' > > (Using password: NO) in /www/a.php on line 2 > > FUCK > > > Problema ti e v nastrojkata na MySQL-a. Proveri si accountite za 'localhost'. > Ako imash slednite zapisi : > > User | Host| Password | ... > % localhost > root localhost > root localhost par0la > > moze da imash problem s validiraneto na user-a root. Problema se sastoi imenno > v mnozestvoto zapisi i tochno koj ot tjax shte e purvi! > > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.0.6 (GNU/Linux) > Comment: For info see http://www.gnupg.org > > iD8DBQE9bzStaLnffbPBntcRAuu3AKDATxQwqUr+C4O1vAYeDyASfiDvSwCfQ37i > NPKBtOqnttCnq5+9cxIIye0= > =sjYd > -END PGP SIGNATURE- > > A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers). > http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora > To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html > > A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers). http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
Re: lug-bg: problem: php/apache/mysql
On Friday 30 August 2002 13:18, Ivan Dimitrov wrote: > i tova ne e, preinstalirax mysql otnovo, suzdadox nanovo bazite, tozi put > ne sum daval dopulnitelni prava na nikoi, daje iztrix edin red za > root@localhost, kato ostavix samo zapisa root@localhost pass=YES i pak kyde po-to4no go pravish tova? pro4eti vnimatalno /etc/init.d/mysql. Comments! vizh i /etc/mysql/my.cnf i debian.cnf da nqmash nqkyde stalled conf file v /var/lib/mysql, /root/.my.cnf, ~/.my.cnf P.S. pri Debian run depends i build depends sa must, versioning controla e strong, taka 4e razni a-la Solaris library breaks i slu4ajni mixove mnogo me symnqvat dori i za MySQL-a v Sid, no ako vse pak ima takiva breaks (naro4no poradi transition, ili nenaro4no poradi greshka na maintainer-a) po-veroqtno e mysql-a (e.g. dynamic loader-a, pytq do kojto e zakodiran v mysqld binary-to) da otkazhe da link-ne .so-tata ili da ne gi nameri ... vizh na Bug Tracking System za nesto interesno za tvoq case, no tova e config problem ... -- Greets, fr33zb1 [catching up with Sid (the boy next door who destroyed toys :-)] A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers). http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
RE: lug-bg: problem: php/apache/mysql
Zdravei, ne 4e iskam da se pravaia na umnik(zastoto po princip ne razbiram mnogo mnogo), no zasto ne opitash vrazka prezt eth0 interface vmesto prez lo ?(ili ina4e kazano da polzvash 'machine_mame' vmesto 'localhost'.Nali znaesh 4e po princip ima dva roota edin root@localhost i edin root@host. Probvai i drugo nesto... zna4i moze prosto nesto da se obarakalo i root da niama prava da listva db-s. vmesto tova probvai "select * from mysql"(znam 4e zvu4i tapo stom kazva acces denied ama...); I nakraia posledno nesto... pod kakav user ti raboti apache Ti kkavi prava ima? I posledno...iam edno nesto mysql_install_db-za konfigurirane Pravil li si go ? Pozdravi, Peter Sazalivam ako ideite zvu4at glupavo az sam RH user, not debian guru -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ivan Dimitrov Sent: Friday, August 30, 2002 1:18 PM To: [EMAIL PROTECTED] Subject: Re: lug-bg: problem: php/apache/mysql i tova ne e, preinstalirax mysql otnovo, suzdadox nanovo bazite, tozi put ne sum daval dopulnitelni prava na nikoi, daje iztrix edin red za root@localhost, kato ostavix samo zapisa root@localhost pass=YES i pak sushtata rabota. pochvam da poluchavam glavobolie, analginche nqkoi da ima? nemoga da go sxvana, na mysql_connect mu davam izmisleni stoinosti za vsichki poleta: root2, localhost2, parola2 i pak v loga izpisva access denied for root@localhost Hi! I'm a .signature virus! Copy me into your ~/.signature, please! Ideas, like everything else in life, deserves to be free. On Fri, 30 Aug 2002, Dimitar Peikov wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Thursday 29 August 2002 18:15, Ivan Dimitrov wrote: > > --from web > > Warning: Access denied for user: 'root@localhost' (Using password: NO) in > > /www/a.php on line 2 > > > > Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' > > (Using password: NO) in /www/a.php on line 2 > > FUCK > > > Problema ti e v nastrojkata na MySQL-a. Proveri si accountite za 'localhost'. > Ako imash slednite zapisi : > > User | Host| Password | ... > % localhost > root localhost > root localhost par0la > > moze da imash problem s validiraneto na user-a root. Problema se sastoi imenno > v mnozestvoto zapisi i tochno koj ot tjax shte e purvi! > > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.0.6 (GNU/Linux) > Comment: For info see http://www.gnupg.org > > iD8DBQE9bzStaLnffbPBntcRAuu3AKDATxQwqUr+C4O1vAYeDyASfiDvSwCfQ37i > NPKBtOqnttCnq5+9cxIIye0= > =sjYd > -END PGP SIGNATURE- > > A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers). > http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora > To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html > > A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers). http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers). http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
Re: lug-bg: problem: php/apache/mysql
On Friday 30 August 2002 20:32, Peter An. Zyumbilev wrote: > Zdravei, > ne 4e iskam da se pravaia na umnik(zastoto po princip ne razbiram mnogo > mnogo), no zasto ne opitash vrazka prezt eth0 interface vmesto prez lo > ?(ili ina4e kazano da polzvash 'machine_mame' vmesto 'localhost'.Nali > znaesh 4e po princip ima dva roota edin root@localhost i edin root@host. tova ne e ot zna4enie ... a localhost e prosto konvenciq kakto 127.0.0.1 (e IP-to 127.0.0.1 e lo (koeto e i hardcoded v IP layer-a v kernel-a mislq taka 4e da se zavyrta lokalno, a ne prez realen mrezhov iface) , a ne imeto, vypreki 4e v /etc/hosts se asociira s tova IP ... stoto toj realno (teoreti4no) mozhe da se krysti kak se seti, i da si napishe imena kolkoto se seti ;-) . v /etc/hosts mozhe da ima: 127.0.0.1 localhost debian debilian brat_mu snaha_mu v /etc/hostname debian s vsi4kite tezi names trebe da stava ... ;-) > Probvai i drugo nesto... > zna4i moze prosto nesto da se obarakalo i root da niama prava da listva > db-s. vmesto tova probvai > "select * from mysql"(znam 4e zvu4i tapo stom kazva acces denied ama...); iskash da kazhesh root user-a na MySQL ? stoto systemniq root e syvsem razli4no nesto ... e trqbva da znae (a toj qvno q znae) MySQL root parolata. problema mu e 4e ot web-a (php scripta) MySQL-a mu kazva 4e user-a ne polzva parola ;-). Vypros: na kaj e sobstvenost toq a.php skripta i kakvo svyrzano s MySQL ima toj v $HOME ? > I nakraia posledno nesto... > pod kakav user ti raboti apache apache: www-data mysqld: mysql i tova ne e ot zna4enie stoto toj v scripta si se auth-va pred MySQL s user i pass (a scripta e dostaty4no da e s prava 644). T.e. Apaha->PHP interpreter kojto ima extension za MySQL (php4-mysql debian package, kojto dostavq edno mysql.so, pytq do kojto se opisva s /etc/php4/[apache|cgi]/php.ini, kato za tova go e pital debconf ) -> MySQL daemon. > Ti kkavi prava ima? > I posledno...iam edno nesto mysql_install_db-za konfigurirane > Pravil li si go ? naj-malko e napravil: mysqladmin -u root password his-big-password Ta negoviq script raboti pri men (apaha i php-to sa systite samo mysql-a mi e 3.23.52, ama tova si e nova upstream version i ne sa fixovani nikvi podobni problemi na negovite ;-). T.e. browser http://localhost/a.php pri greshna parola v a.php scripta pokazva: Warning: Access denied for user: 'root@localhost' (Using password: YES) in /var/www/a.php on line 2 Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: YES) in /var/www/a.php on line 2 FUCK pri pravilna parola v scripta: OFFF koeto e i o4akvaniq rezultat ..., sega nqmam tablici v "base" i takava db, no tova ne e ot zna4enie, vazhnoto e 4e mysql-a auth-va OK ;-) /var/log/mysql.log .. 020831 22:13:33 9 Connect root@localhost on parola 020831 22:13:45 10 Connect root@localhost on 10 Query show databases 10 Quit 020831 22:42:05 11 Connect root@localhost on 11 Quit > Pozdravi, > Peter > Sazalivam ako ideite zvu4at glupavo az sam RH user, not debian guru Tova e debian guru-tata e absolutno nevqrno i e kato mit i legenda. Tova mogat da bydat dumi na user ili guru kojto ne e testval Debian sam za sebe si. Ako beshe test-val Debian steshe sam da se ubedish kolko po-lesno e da se administrira ot vsi4ko drugo, stoto ima red i zdrav kontrol pri upravlenieto na softuera v sistemata (e user mozhe da override-va, ako se 4uvstva znaesht)... da, za user-friendly administration ide re4... t.e. sistemata predlaga/pita, pomaga/podskazva/u4i ... a ne user-a da se bori i da si gubi vremeto sys slu4ajni i bezmisleni zabozishe pri izpylnenieto na super rutinni i ezhednevni zada4i (lipsa na tova, nema onova,neznae kyde e i kak da go nameri i t.n.). Ideq nqmash kolko commercial vendors (ne samo Linux/Unix) sa na svetlinni godini zad free support-a i easy-of-use kojto predostavq Debian ... (da kogato support-a e maniashki, bil i toj free, v pove4eto slu4aj e po-dobyr ot commercial-a kydeto nestata se pravqt po prinuda, a ne s hys) P.S. Nikoj ne mozhe da me obvini v commercial ad na Debian, stoto tova e the most neutral and free distroto, taka 4e koristni celi nema i sym free da reklamiram na volq ;-) -- Greets, fr33zb1 [catching up with Sid (the boy next door who destroyed toys :-)] A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers). http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
RE: lug-bg: problem: php/apache/mysql
Zdravei, sega zna4i ideiata pod root@localhost i root@host ne e 4e ne znam za kkavo sluzhi /etc/hosts a e: [EMAIL PROTECTED] i [EMAIL PROTECTED](LAN IP) primerno ...ima golima razliak mezdu dvete Az iamh mnogo nepriatna slu4ka na tazi tema... Dejstvieto se razviva pod win2k: zna4i pisha: >mysqladmin -u root password my_pass #probravm: >mysql Access denied ! Supeer(znai po podrabirane -h=localhost(127.0.0.1) -u=root)za tova ne smam gi pisal.. I se 4uvstavm velik.. Oba4e.. Sled izvesten period ot vreme probvam: >mysql -u root -h 10.30.12.38 i vliazoh bez parola Stiah da padna ot stola... Tobva go otkrish sled kato edin php script uporito mi otkazvash da vlzez s parola >mysqladmin -u root -h my_pc password my_pass Tova beshe anvremeto i hubavo 4e beshe testova mashina :):):):) zatui ti vikam da se probva prez eth0 a ne prez lo!!! Za 2 to4ka si prav...ne sam vidial 4e mysqld ne e vidial podavanata parola... Za usera pitam zasto mozhe da NIAMA prava da 4ete niakoi konfiguracionni filove (primerno php.ini) to pak ste si raboti bez nego ama:):):):):) Za debiana Dobre 4e povdigna vaprosa Az po princip vkasti si iam RED HAT 7.2 na srevr4esto i doskoro SUSE 8(smenih go s NT 4 zaradi udovolstvieto da polzvam "Allaire homesite 4.5.2") Ta imam opit s tiah dvete(izkliu4vam ot tova 4islo ot4aianite mi opiti da podkram kato horata FREEBSD , prekrasna OS ama vsi4ko i e stranno) :) Dobre e da napravim diskusia na tazi tema zastos ste tribva da izbiram oeracionna sistema za web servera na edin fakuletet na SU . Za sega sam reshil RH 7.2 zastoto: -RPM(mnoggo e udobno) zna za .deb nio kato izkliu4im 7-te originalni CD-ta po sitovete e raidkost da namerish .deb a rpm e dosta 4etso srestano.. -up2date pishesh "up2date -u " i cilata sistema e 100% up 2 date -zastot vsi4ko se namira na standartno miasto(primet /etc/php.ini a ne /etc/php2/php.ini ) -zastoto sam mu sviknal... Ste e hubavo da 4uaia drugi mnenia po vaprosa... Vse pak v diskusiata se razda istinata... Pozdravi, Peter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of George Danchev Sent: Saturday, August 31, 2002 11:09 PM To: [EMAIL PROTECTED] Subject: Re: lug-bg: problem: php/apache/mysql On Friday 30 August 2002 20:32, Peter An. Zyumbilev wrote: > Zdravei, > ne 4e iskam da se pravaia na umnik(zastoto po princip ne razbiram mnogo > mnogo), no zasto ne opitash vrazka prezt eth0 interface vmesto prez lo > ?(ili ina4e kazano da polzvash 'machine_mame' vmesto 'localhost'.Nali > znaesh 4e po princip ima dva roota edin root@localhost i edin root@host. tova ne e ot zna4enie ... a localhost e prosto konvenciq kakto 127.0.0.1 (e IP-to 127.0.0.1 e lo (koeto e i hardcoded v IP layer-a v kernel-a mislq taka 4e da se zavyrta lokalno, a ne prez realen mrezhov iface) , a ne imeto, vypreki 4e v /etc/hosts se asociira s tova IP ... stoto toj realno (teoreti4no) mozhe da se krysti kak se seti, i da si napishe imena kolkoto se seti ;-) . v /etc/hosts mozhe da ima: 127.0.0.1 localhost debian debilian brat_mu snaha_mu v /etc/hostname debian s vsi4kite tezi names trebe da stava ... ;-) > Probvai i drugo nesto... > zna4i moze prosto nesto da se obarakalo i root da niama prava da listva > db-s. vmesto tova probvai > "select * from mysql"(znam 4e zvu4i tapo stom kazva acces denied ama...); iskash da kazhesh root user-a na MySQL ? stoto systemniq root e syvsem razli4no nesto ... e trqbva da znae (a toj qvno q znae) MySQL root parolata. problema mu e 4e ot web-a (php scripta) MySQL-a mu kazva 4e user-a ne polzva parola ;-). Vypros: na kaj e sobstvenost toq a.php skripta i kakvo svyrzano s MySQL ima toj v $HOME ? > I nakraia posledno nesto... > pod kakav user ti raboti apache apache: www-data mysqld: mysql i tova ne e ot zna4enie stoto toj v scripta si se auth-va pred MySQL s user i pass (a scripta e dostaty4no da e s prava 644). T.e. Apaha->PHP interpreter kojto ima extension za MySQL (php4-mysql debian package, kojto dostavq edno mysql.so, pytq do kojto se opisva s /etc/php4/[apache|cgi]/php.ini, kato za tova go e pital debconf ) -> MySQL daemon. > Ti kkavi prava ima? > I posledno...iam edno nesto mysql_install_db-za konfigurirane > Pravil li si go ? naj-malko e napravil: mysqladmin -u root password his-big-password Ta negoviq script raboti pri men (apaha i php-to sa systite samo mysql-a mi e 3.23.52, ama tova si e nova upstream version i ne sa fixovani nikvi podobni problemi na negovite ;-). T.e. browser http://localhost/a.php pri greshna parola v a.php scripta pokazva: Warning: Access denied for user: 'root@localhost' (Using password: YES) in /var/www/a.php on line 2 Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: YES) in /var/www/a.php on line 2 FUCK pri pravilna parola v script
Re: lug-bg: problem: php/apache/mysql
Beware...tezi tvyrdenija (absurdni spored men ;-) za BSD i Debian mogat da porodjat flame ;-) On Sat, 31 Aug 2002 00:28:37 +0300 "Peter An. Zyumbilev" <[EMAIL PROTECTED]> wrote: > Zdravei, > sega > zna4i ideiata pod root@localhost i root@host ne e 4e ne znam za kkavo sluzhi > /etc/hosts a e: > [EMAIL PROTECTED] i [EMAIL PROTECTED](LAN IP) primerno ...ima golima razliak > mezdu dvete > Az iamh mnogo nepriatna slu4ka na tazi tema... > Dejstvieto se razviva pod win2k: > zna4i pisha: > >mysqladmin -u root password my_pass > #probravm: > >mysql > Access denied ! > Supeer(znai po podrabirane -h=localhost(127.0.0.1) -u=root)za tova ne smam > gi pisal.. > I se 4uvstavm velik.. > Oba4e.. > Sled izvesten period ot vreme probvam: > >mysql -u root -h 10.30.12.38 > i vliazoh bez parola > Stiah da padna ot stola... > Tobva go otkrish sled kato edin php script uporito mi otkazvash da vlzez s > parola > >mysqladmin -u root -h my_pc password my_pass > Tova beshe anvremeto i hubavo 4e beshe testova mashina :):):):) > zatui ti vikam da se probva prez eth0 a ne prez > lo!!! > > Za 2 to4ka si prav...ne sam vidial 4e mysqld ne e vidial podavanata > parola... > > Za usera pitam zasto mozhe da NIAMA prava da 4ete niakoi konfiguracionni > filove (primerno php.ini) > to pak ste si raboti bez nego ama:):):):):) > > Za debiana > Dobre 4e povdigna vaprosa > Az po princip vkasti si iam RED HAT 7.2 na srevr4esto i doskoro SUSE > 8(smenih go s NT 4 zaradi udovolstvieto da polzvam "Allaire homesite > 4.5.2") Ta imam opit s tiah dvete(izkliu4vam ot tova 4islo ot4aianite mi > opiti da podkram kato horata FREEBSD , prekrasna OS ama vsi4ko i e stranno) > :) > Dobre e da napravim diskusia na tazi tema zastos ste tribva da izbiram > oeracionna sistema za web servera na edin fakuletet na SU . > Za sega sam reshil RH 7.2 zastoto: > -RPM(mnoggo e udobno) zna za .deb nio kato izkliu4im 7-te originalni CD-ta > po sitovete e raidkost da namerish .deb a rpm e dosta 4etso srestano.. > -up2date pishesh "up2date -u " i cilata sistema e 100% up 2 date > -zastot vsi4ko se namira na standartno miasto(primet /etc/php.ini a ne > /etc/php2/php.ini ) > -zastoto sam mu sviknal... > Ste e hubavo da 4uaia drugi mnenia po vaprosa... > Vse pak v diskusiata se razda istinata... > Pozdravi, > Peter > > > > > > > > > > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of George Danchev > Sent: Saturday, August 31, 2002 11:09 PM > To: [EMAIL PROTECTED] > Subject: Re: lug-bg: problem: php/apache/mysql > > > On Friday 30 August 2002 20:32, Peter An. Zyumbilev wrote: > > Zdravei, > > ne 4e iskam da se pravaia na umnik(zastoto po princip ne razbiram mnogo > > mnogo), no zasto ne opitash vrazka prezt eth0 interface vmesto prez lo > > ?(ili ina4e kazano da polzvash 'machine_mame' vmesto 'localhost'.Nali > > znaesh 4e po princip ima dva roota edin root@localhost i edin root@host. > > tova ne e ot zna4enie ... a localhost e prosto konvenciq kakto 127.0.0.1 (e > IP-to 127.0.0.1 e lo (koeto e i hardcoded v IP layer-a v kernel-a mislq taka > 4e da se zavyrta lokalno, a ne prez realen mrezhov iface) , a ne imeto, > vypreki 4e v /etc/hosts se asociira s tova IP ... stoto toj realno > (teoreti4no) mozhe da se krysti kak se seti, i da si napishe imena kolkoto > se > seti ;-) . v /etc/hosts mozhe da ima: > 127.0.0.1 localhost debian debilian brat_mu snaha_mu > v /etc/hostname > debian > > s vsi4kite tezi names trebe da stava ... ;-) > > > Probvai i drugo nesto... > > zna4i moze prosto nesto da se obarakalo i root da niama prava da listva > > db-s. vmesto tova probvai > > "select * from mysql"(znam 4e zvu4i tapo stom kazva acces denied ama...); > > iskash da kazhesh root user-a na MySQL ? stoto systemniq root e syvsem > razli4no nesto ... e trqbva da znae (a toj qvno q znae) MySQL root parolata. > problema mu e 4e ot web-a (php scripta) MySQL-a mu kazva 4e user-a ne polzva > parola ;-). Vypros: na kaj e sobstvenost toq a.php skripta i kakvo svyrzano > s > MySQL ima toj v $HOME ? > > > I nakraia posledno nesto... > > pod kakav user ti raboti apache > > apache: www-data > mysqld: mysql > > i tova ne e ot zna4enie stoto toj v scripta si se auth-va pred MySQL s user > i > pass (a scripta e dostaty4no da e s prava 644). T.e. Apaha->PHP interpreter > kojto ima extension za MySQL (php4-mysql debian package, kojto dostavq edno > mysql.so, pytq do kojto se opisva s /etc/php4/[apache