Re: cron daemon sends me errors re: php, mysql, apache
On Mon, 07 Mar 2011 23:40:55 -0500, Mark Grieveson wrote: Hello. I recently upgraded to Squeeze, and I'm getting various cron daemon errors mailed to me: Date: Mon, 07 Mar 2011 17:09:01 -0500 From: Cron Daemon root@debian To: root@debian Subject: Cron root@debian [ -x /usr/lib/php5/maxlifetime ] [ -d /var/lib/php5 ] find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm PHP Deprecated: Comments starting with '#' are deprecated in /etc/php5/cli/conf.d/mysql.ini on line 1 in Unknown on line 0 PHP (...) Those seem to be syntax warnings on the mentioned files, just check it out and correct the offending lines. Probably you will have to use ; instead # for comments (if this is now an upstream default and your PHP package came from Debian repos, you can report it). Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20090626+lfs/mysql.so' - /usr/lib/php5/20090626+lfs/mysql.so: cannot open shared object file: No such file or directory in Unknown on line +0 (...) This looks a bit more serious... oh, a bug has been already reported: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=593266 (see comment #20 for a possible workaround) Greetings, -- Camaleón -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/pan.2011.03.08.12.23...@gmail.com
cron daemon sends me errors re: php, mysql, apache
Hello. I recently upgraded to Squeeze, and I'm getting various cron daemon errors mailed to me: Date: Mon, 07 Mar 2011 17:09:01 -0500 From: Cron Daemon root@debian To: root@debian Subject: Cron root@debian [ -x /usr/lib/php5/maxlifetime ] [ -d /var/lib/php5 ] find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm PHP Deprecated: Comments starting with '#' are deprecated in /etc/php5/cli/conf.d/mysql.ini on line 1 in Unknown on line 0 PHP Deprecated: Comments starting with '#' are deprecated in /etc/php5/cli/conf.d/mysqli.ini on line 1 in Unknown on line 0 PHP Deprecated: Comments starting with '#' are deprecated in /etc/php5/cli/conf.d/pdo_mysql.ini on line 1 in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20090626+lfs/mysql.so' - /usr/lib/php5/20090626+lfs/mysql.so: cannot open shared object file: No such file or directory in Unknown on line +0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20090626+lfs/mysqli.so' - /usr/lib/php5/20090626+lfs/mysqli.so: cannot open shared object file: No such file or directory in Unknown on +line 0 PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20090626+lfs/pdo_mysql.so' - /usr/lib/php5/20090626+lfs/pdo_mysql.so: cannot open shared object file: No such file or directory in Unknown +on line 0 I have no clue what this means, but I seem to get these messages quite a bit. All advice and suggestions are appreciated. Mark -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/20110307234055.13b71...@yahoo.ca
Re: php mysql para email
boa tarde descobri com configurar pear config-set http_proxy http://username:passw...@yourproxy:80 grato Em 5 de julho de 2010 13:56, Anderson Bertling andersonbertl...@gmail.comescreveu: Bom dia estou com problemas para liberar o DB para o squirrelmail no tutorial que estou seguindo ele pede para digitar # pear install DB mas ele me devolve a resposta No releases available for package pear.php.net/DB install failed alguém sabe o que posso fazer minha rede fica atraz de um proxy mas não se o que fazer, o wget e o apt estão ok desde ja fico grato por qualquer ajuda -- Att Anderson Bertling -- Att Anderson Bertling
Re: php/mysql: leere Seite
On 11.03.06 07:24:37, Klaus Becker wrote: Le Freitag 10 März 2006 23:57, Steve Naumann a écrit : Ich hab' vergessen, ich hab' auch noch installiert: apache22.0.54-5 apache2-common 2.0.54-5 apache2-mpm-wo 2.0.54-5 mpm-worker funktioniert nicht mit PHP4, weil PHP4 nicht Threadsafe ist. Welches sollte ich benutzen, apache oder apache2? Das musst du schon selbst wissen. Andreas -- You need no longer worry about the future. This time tomorrow you'll be dead. -- Haeufig gestellte Fragen und Antworten (FAQ): http://www.de.debian.org/debian-user-german-FAQ/ Zum AUSTRAGEN schicken Sie eine Mail an [EMAIL PROTECTED] mit dem Subject unsubscribe. Probleme? Mail an [EMAIL PROTECTED] (engl)
Re: php/mysql: leere Seite
das ist ja höchstwahrscheinlich das apache error log, php hat normalerweise ein eigenes. wenn php und alles andere funktioniert kann man mit einem kurzen skript die php konfiguration als html seite ausgeben lassen: ?php phpinfo(); ?. falls du phpMyAdmin benutzt, das hat auf der startseite auch einen link um diese seite anzuzeigen. wenn dass nicht funktioniert dann musst du wohl in der php.ini nachschauen. die folgenden sind die wichtigsten schlüssel zur fehlerbehandlung: error_reporting = (welche art von fehlern ausgeben) display_errors = (fehlerausgabe an client senden) log_errors = (fehlerausgabe in datei loggen) error_log = (in welche datei loggen) die einstellung für error_reporting kannst du auch im skript auf scharf schalten in dem du dort error_reporting(E_ALL); angibst. grüsse, olli Am Samstag, den 11.03.2006, 07:26 +0100 schrieb Klaus Becker: Le Samstag 11 März 2006 02:03, Oliver Jato a écrit : vermutlich ist auf dem amd64 die fehlerausgabe von php deaktiviert und dieser tippfehler $res = mysql_numrows($req); [mysql_num_rows()] erzeugt einen parse error. vielleicht ist ja das logging von fehlern aktiviert, schau in dem fall mal in die log datei. In /var/log/apache/error.log finde ich nichts anormales. Die Datei meinst du doch oder? Gruß Klaus -- Haeufig gestellte Fragen und Antworten (FAQ): http://www.de.debian.org/debian-user-german-FAQ/ Zum AUSTRAGEN schicken Sie eine Mail an [EMAIL PROTECTED] mit dem Subject unsubscribe. Probleme? Mail an [EMAIL PROTECTED] (engl)
Re: php/mysql: leere Seite
hab noch einen möglichen grund eben vergessen. ich vermute das $cat_id mit der url an das skript übergeben wird und du sprichst es als globale variable an. dann muss auf dem rechner auf dem es funktioniert in der php.ini register_globals = On gesetzt sein. vielleicht ist es ja auf dem anderen rechner auf Off, was auch generell eine gute idee ist. nur musst du get/post/cookie variablen dann anders ansprechen. in diesem fall zB mit $_GET['cat_id'] oder $_REQUEST['cat_id']. und du solltest solche variablen unbedingt mit mysql_real_escape_string() bearbeiten bevor sie in eine datenbank query gesteckt werden. wenn es ums escapen geht musst du dich dann eventuell auch mit magic_quotes_gpc auseinandersetzen. -- Haeufig gestellte Fragen und Antworten (FAQ): http://www.de.debian.org/debian-user-german-FAQ/ Zum AUSTRAGEN schicken Sie eine Mail an [EMAIL PROTECTED] mit dem Subject unsubscribe. Probleme? Mail an [EMAIL PROTECTED] (engl)
Re: php/mysql: leere Seite
Le Samstag 11 März 2006 12:39, Oliver Jato a écrit : hab noch einen möglichen grund eben vergessen. ich vermute das $cat_id mit der url an das skript übergeben wird und du sprichst es als globale variable an. dann muss auf dem rechner auf dem es funktioniert in der php.ini register_globals = On gesetzt sein. Hallo Oliver, das war's in der Tat. So etwas ähnliches hatte ich mir schon gedacht, hätte es aber nie allein gefunden. In php.ini steht dazu: ; You should do your best to write your scripts so that they do not require ; register_globals to be on; Using form variables as globals can easily lead ; to possible security problems, if the code is not very well thought of. register_globals = On. vielleicht ist es ja auf dem anderen rechner auf Off, was auch generell eine gute idee ist. nur musst du get/post/cookie variablen dann anders ansprechen. in diesem fall zB mit $_GET['cat_id'] oder $_REQUEST['cat_id']. und du solltest solche variablen unbedingt mit mysql_real_escape_string() bearbeiten bevor sie in eine datenbank query gesteckt werden. wenn es ums escapen geht musst du dich dann eventuell auch mit magic_quotes_gpc auseinandersetzen. Das ist mir zu hoch. Ich habe keinen Server, sondern schreibe und teste meine Site nur auf meinem Rechner, bevor ich sie zum Provider schicke. Ist das wirklich ein großes Sicherheitsproblem in diesem Fall? auf jeden Fall 1000 Dank, du hast mir sehr weitergeholfen Klaus
Re: php/mysql: leere Seite
bitteschön! aber mit dem rest solltest du dich auf jeden fall beschäftigen, die zusammenhänge muss man sich klar machen, auch in punkto portabilität der skripte auf andere server/konfigurationen. dem server selbst ist dass alles egal und es tut ihm auch nichts, aber es geht um die sicherheit deiner daten, denn so könnte dein skript auch anfällig für sql injections sein. Am Samstag, den 11.03.2006, 12:23 +0100 schrieb Klaus Becker: Le Samstag 11 März 2006 12:39, Oliver Jato a écrit : hab noch einen möglichen grund eben vergessen. ich vermute das $cat_id mit der url an das skript übergeben wird und du sprichst es als globale variable an. dann muss auf dem rechner auf dem es funktioniert in der php.ini register_globals = On gesetzt sein. Hallo Oliver, das war's in der Tat. So etwas ähnliches hatte ich mir schon gedacht, hätte es aber nie allein gefunden. In php.ini steht dazu: ; You should do your best to write your scripts so that they do not require ; register_globals to be on; Using form variables as globals can easily lead ; to possible security problems, if the code is not very well thought of. register_globals = On. vielleicht ist es ja auf dem anderen rechner auf Off, was auch generell eine gute idee ist. nur musst du get/post/cookie variablen dann anders ansprechen. in diesem fall zB mit $_GET['cat_id'] oder $_REQUEST['cat_id']. und du solltest solche variablen unbedingt mit mysql_real_escape_string() bearbeiten bevor sie in eine datenbank query gesteckt werden. wenn es ums escapen geht musst du dich dann eventuell auch mit magic_quotes_gpc auseinandersetzen. Das ist mir zu hoch. Ich habe keinen Server, sondern schreibe und teste meine Site nur auf meinem Rechner, bevor ich sie zum Provider schicke. Ist das wirklich ein großes Sicherheitsproblem in diesem Fall? auf jeden Fall 1000 Dank, du hast mir sehr weitergeholfen Klaus -- Haeufig gestellte Fragen und Antworten (FAQ): http://www.de.debian.org/debian-user-german-FAQ/ Zum AUSTRAGEN schicken Sie eine Mail an [EMAIL PROTECTED] mit dem Subject unsubscribe. Probleme? Mail an [EMAIL PROTECTED] (engl)
Re: php/mysql: leere Seite
On Sat, Mar 11, 2006 at 12:23:07PM +0100, Klaus Becker wrote: [...] Das ist mir zu hoch. Ich habe keinen Server, sondern schreibe und teste meine Site nur auf meinem Rechner, bevor ich sie zum Provider schicke. Ist das wirklich ein großes Sicherheitsproblem in diesem Fall? Ja, z.B.: http://de.wikipedia.org/wiki/SQL_Injection -- -- Haeufig gestellte Fragen und Antworten (FAQ): http://www.de.debian.org/debian-user-german-FAQ/ Zum AUSTRAGEN schicken Sie eine Mail an [EMAIL PROTECTED] mit dem Subject unsubscribe. Probleme? Mail an [EMAIL PROTECTED] (engl)
Re: php/mysql: leere Seite
Um solch Fehler auszuschließen, prüfe ich immer mit echo $sql; was überhaupt an die Datenbank geschickt wird. Erspart einem manchmal viel Zeit. :-)
Re: php/mysql: leere Seite
Hi, ? $db = mysql_connect (localhost, user, mot_de_passe); mysql_select_db (katalogdeutsch, $db); $req = mysql_query (SELECT * FROM liens WHERE cat_id='$cat_id'); $res = mysql_numrows($req); $i = 0; WHILE($res!=$i) { $url = mysql_result($req,$i,url); echo $url; } ? sieht mir nicht grad sauber aus dieses Test-Skript. Versuch mal in dieser Form: ? $db = mysql_connect (localhost, user, mot_de_passe); mysql_select_db (katalogdeutsch, $db); $sql = SELECT * FROM liens WHERE cat_id='$cat_id'; $result = mysql_query($sql); while($row=mysql_fetch_array($result)) { echo $row['url']; } mysql_close(); ? Wenn das Ergebnis definitiv nur 1 Datensatz liefert, ist eine while-Schleife auch nicht erforderlich. Steve -- Haeufig gestellte Fragen und Antworten (FAQ): http://www.de.debian.org/debian-user-german-FAQ/ Zum AUSTRAGEN schicken Sie eine Mail an [EMAIL PROTECTED] mit dem Subject unsubscribe. Probleme? Mail an [EMAIL PROTECTED] (engl)
Re: php/mysql: leere Seite
vermutlich ist auf dem amd64 die fehlerausgabe von php deaktiviert und dieser tippfehler $res = mysql_numrows($req); [mysql_num_rows()] erzeugt einen parse error. vielleicht ist ja das logging von fehlern aktiviert, schau in dem fall mal in die log datei. guten, olli -- Haeufig gestellte Fragen und Antworten (FAQ): http://www.de.debian.org/debian-user-german-FAQ/ Zum AUSTRAGEN schicken Sie eine Mail an [EMAIL PROTECTED] mit dem Subject unsubscribe. Probleme? Mail an [EMAIL PROTECTED] (engl)
Re: php/mysql: leere Seite
Le Freitag 10 März 2006 23:57, Steve Naumann a écrit : Hi, ? $db = mysql_connect (localhost, user, mot_de_passe); mysql_select_db (katalogdeutsch, $db); $req = mysql_query (SELECT * FROM liens WHERE cat_id='$cat_id'); $res = mysql_numrows($req); $i = 0; WHILE($res!=$i) { $url = mysql_result($req,$i,url); echo $url; } ? sieht mir nicht grad sauber aus dieses Test-Skript. Versuch mal in dieser Form: ? $db = mysql_connect (localhost, user, mot_de_passe); mysql_select_db (katalogdeutsch, $db); $sql = SELECT * FROM liens WHERE cat_id='$cat_id'; $result = mysql_query($sql); while($row=mysql_fetch_array($result)) { echo $row['url']; } mysql_close(); ? bringt auch nichts. Ich hab' vergessen, ich hab' auch noch installiert: apache22.0.54-5 apache2-common 2.0.54-5 apache2-mpm-wo 2.0.54-5 apache2-utils 2.0.54-5. Welches sollte ich benutzen, apache oder apache2? Klaus Wenn das Ergebnis definitiv nur 1 Datensatz liefert, ist eine while-Schleife auch nicht erforderlich. ok
Re: php-mysql
[EMAIL PROTECTED] wrote: Thanks for your prompt answer, the LAMP I think is a good idea and it applies to what I want to do, install a webserver, php and mysql. However, I am trying to make a webserver that will be online. The lines below are from the link you send me, does this tutorial is for local installation only? or can it be use for a real webserver that will be online? Then take a look at http://www.aboutdebian.com/internet.htm Read also some other things on the http://www.aboutdebian.com since their tutorials are very good and helpful when wanting to clear some basics of debian and networking. You may also want to check http://www.debian-administration.org/ -- Mitja Podreka http://mitja.kizej.net -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: php-mysql
Hello nano, Friday, October 7, 2005, 1:01:31 AM, you wrote: Hi, I am trying to install php and mysql in Debian(Sarge) in a non gui installation and I am not sure how to install these two programs, please help. Fernando login as root and give the following command apt-get install php4 mysqlserver apache2 The configuration files for these progams you find it on: /etc/httpd/ - for Apache /etc/my.conf - for Mysql /etc/php.ini - for php -- Best regards, Bogdanmailto:[EMAIL PROTECTED] -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://www.bitdefender.com/ -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: php-mysql
Bogdan Rotariu wrote: login as root and give the following command apt-get install php4 mysqlserver apache2 command should be apt-get install php4 mysql-server apache you could use apache2 but then I dont know where the config files are - probably in /etc/apache2 The configuration files for these progams you find it on: /etc/httpd/ - for Apache /etc/my.conf - for Mysql /etc/php.ini - for php I dont know which distribution you use, but in Debian Etch the files are /etc/apache/httpd.conf - for Apache /etc/mysql/my.cnf - for Mysql /etc/php4/apache/php.ini -- Mitja Podreka http://mitja.kizej.net -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: php-mysql
Mitja Podreka wrote: Bogdan Rotariu wrote: login as root and give the following command apt-get install php4 mysqlserver apache2 command should be apt-get install php4 mysql-server apache you could use apache2 but then I dont know where the config files are - probably in /etc/apache2 The configuration files for these progams you find it on: /etc/httpd/ - for Apache /etc/my.conf - for Mysql /etc/php.ini - for php I dont know which distribution you use, but in Debian Etch the files are /etc/apache/httpd.conf - for Apache /etc/mysql/my.cnf - for Mysql /etc/php4/apache/php.ini Hi, The above information is correct. However, if you are new to such setups, this lot will not work 'out of the bag'. For example mysql server will only work on the server console (127.0.0.1) till you tweek /etc/my.conf etc. if you have problems, I can send you copies of my working config files.. Del -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: php-mysql
[EMAIL PROTECTED] wrote: Hi, I am trying to install php and mysql in Debian(Sarge) in a non gui installation and I am not sure how to install these two programs, please help. Easy LAMP on Debian Linux http://www.madcarters.com/content/view/26/1/ -- Mitja Podreka http://mitja.kizej.net -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: PHP + MySql
Além da dica do Gustavo Costa, tente efeturar uma conexão com o banco. Não se esqueça que é preciso definir a senha do root no mysql depois da instalação: mysqladmin --user=root password senhanova [ ]'s Max On 9/29/05, bto [EMAIL PROTECTED] wrote: On Wed, 28 Sep 2005 13:02:27 -0300 Gustavo Costa [EMAIL PROTECTED] wrote: Olá, Tenho instalado um servidor de php, mas verificando no phpinfo está aparecendo --without-mysql, mas já instalei o pacote php4-mysql, alguém sabe o que pode estar faltando para habilitar o suporte ao mysql? Verificar se a linha extension=mysql.so no arquivo /etc/php4/apache2/php.ini está descomentada? [] hpfn -- Maxwillian Miorim - LPIC1 (LPID 85928) Fone: +55 51 81334205
Re: PHP + MySql
On Wed, 28 Sep 2005 13:02:27 -0300 Gustavo Costa [EMAIL PROTECTED] wrote: Olá, Tenho instalado um servidor de php, mas verificando no phpinfo está aparecendo --without-mysql, mas já instalei o pacote php4-mysql, alguém sabe o que pode estar faltando para habilitar o suporte ao mysql? Verificar se a linha extension=mysql.so no arquivo /etc/php4/apache2/php.ini está descomentada? [] hpfn
Re: PHP + MySql
Ol, Tenho todos esse pacotes instalados: ii php-file 1.0.3-1 PHP Pear modules for common file and directo ii php4 4.3.10-15 server-side, HTML-embedded scripting languag ii php4-cli 4.3.10-15 command-line interpreter for the php4 script ii php4-common 4.3.10-15 Common files for packages built from the php ii php4-dev 4.3.10-15 Files for PHP4 module development ii php4-gd 4.3.10-15 GD module for php4 ii php4-mysql 4.3.10-15 MySQL module for php4 ii php4-pear 4.3.10-15 PEAR - PHP Extension and Application Reposit ii phpmyadmin 2.6.2-3 set of PHP-scripts to administrate MySQL ove ii libdbd-mysql-p 2.9006-1 A Perl5 database interface to the MySQL data ii libmysqlclient 4.0.24-10 mysql database client library ii libmysqlclient 4.0.24-10 mysql database development files ii libmysqlclient 4.1.11a-4 mysql database client library ii mysql-admin 1.0.20-1 GUI tool for intuitive MySQL administration ii mysql-admin-co 1.0.20-1 Architecture independent files for MySQL Adm ii mysql-client 4.0.24-10 mysql database client binaries ii mysql-common 4.0.24-10 mysql database common files (e.g. /etc/mysql ii mysql-server 4.0.24-10 mysql database server binaries E mesmo assim continua "--without-mysql", ser que no preciso mexer em algum arquivo de configurao? []s Jorge Pereira escreveu: Tem que instalar a libmysql. apt-cache search libmysql veja, e instale a referente a sua situao... []'s Em 28/09/05, Gustavo Costa [EMAIL PROTECTED] escreveu: Ol, Tenho instalado um servidor de php, mas verificando no phpinfo est aparecendo "--without-mysql", mas j instalei o pacote "php4-mysql", algum sabe o que pode estar faltando para habilitar o suporte ao mysql? []s -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] -- Regards, Jorge Pereira, From: Olinda/PE/Brazil Home: http://www.jorgepereira.com.br/ E-mail:[EMAIL PROTECTED], [EMAIL PROTECTED] Mobile: +55 (81) 8833-2484
Re: php-mysql connection pb
Thank you very much, Oliver It is Ok best regards bela --- Oliver Lupton [EMAIL PROTECTED] wrote: belahcene abdelkader wrote: hi, I am using sarge Official Distro. I have written an application with php-mysql thru apache, it ran correctly ( on previous release before the official sarge without any special config) , i move it to sarge, now I have a problem, I don't if it is a sarge pb or a mysql or mysql-php ? this is the error Fatal error: Call to undefined function: mysql_query() in /var/www/studentNew.php on line 7 I have install php4 with php4-mysql, mysql-server is also installed . the strange thing (for me of course) is that , the phpmyadmin runs correctly and acceed to the database, so I suppose that the php mysql api is installed correctly. Any idea is welcome thank you very much in advance best regards bela Just an idea (unchecked - I run self-compiled php5), but try either putting dl('mysql.so'); at the top of your script, or add a similar line to php.ini (http://php.net/manual/en/ini.core.php#ini.extension) Hope this helps, Oliver -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED] __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: php-mysql connection pb
belahcene abdelkader wrote: hi, I am using sarge Official Distro. I have written an application with php-mysql thru apache, it ran correctly ( on previous release before the official sarge without any special config) , i move it to sarge, now I have a problem, I don't if it is a sarge pb or a mysql or mysql-php ? this is the error Fatal error: Call to undefined function: mysql_query() in /var/www/studentNew.php on line 7 I have install php4 with php4-mysql, mysql-server is also installed . the strange thing (for me of course) is that , the phpmyadmin runs correctly and acceed to the database, so I suppose that the php mysql api is installed correctly. Any idea is welcome thank you very much in advance best regards bela Just an idea (unchecked - I run self-compiled php5), but try either putting dl('mysql.so'); at the top of your script, or add a similar line to php.ini (http://php.net/manual/en/ini.core.php#ini.extension) Hope this helps, Oliver -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: php + mysql???
Per instal·lar-ho no necesistes documentació apt-get install php4 php4-mysql mysql-server libapache2-mod-php4 Tot pot canviar segons les versions que vulguis: libapache2-mod-php4 pot ser libapache-mod-php4 si és l'apache 1 php4 i php4-mysql pot ser php3 o php5 segons la versió de php que vulguis mysql-server pot ser mysql-server-4.1 o mysql-server-5.0 Amb la configuració per defecte ja podràs funcionar. No ho recordo però l'únics que caldria que fessis és donar-li un password al root del mysql i ja està. Salut ! En/na david bayona ha escrit: Bones a tots... a veure si me podeu ajudar. necessitaria instal.lar l'apache i l'mysql en una debian sarge. I per fer-ho no disposo de internet. o sigui que necessitaria un manual que no sigui online. he estat buscant per internet i no n'he trobat cap al igual que manuals de php. Algu me pot indicar una pagina web on hi hagi algun manual o on en puc trobar un. gracies. __ Renovamos el Correo Yahoo! Nuevos servicios, más seguridad http://correo.yahoo.es -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: php + mysql???
Ups, amb sarge no hi ha tantes versions... jo vaig amb inestable i per això hi ha tanta varietat, tu mateix si remenes una mica trobaràs les que tens disponibles amb sarge. apt-cache search php apt-cache search mysql-server Salut ! En/na Ferriol ha escrit: Per instal·lar-ho no necesistes documentació apt-get install php4 php4-mysql mysql-server libapache2-mod-php4 Tot pot canviar segons les versions que vulguis: libapache2-mod-php4 pot ser libapache-mod-php4 si és l'apache 1 php4 i php4-mysql pot ser php3 o php5 segons la versió de php que vulguis mysql-server pot ser mysql-server-4.1 o mysql-server-5.0 Amb la configuració per defecte ja podràs funcionar. No ho recordo però l'únics que caldria que fessis és donar-li un password al root del mysql i ja està. Salut ! En/na david bayona ha escrit: Bones a tots... a veure si me podeu ajudar. necessitaria instal.lar l'apache i l'mysql en una debian sarge. I per fer-ho no disposo de internet. o sigui que necessitaria un manual que no sigui online. he estat buscant per internet i no n'he trobat cap al igual que manuals de php. Algu me pot indicar una pagina web on hi hagi algun manual o on en puc trobar un. gracies. __ Renovamos el Correo Yahoo! Nuevos servicios, más seguridad http://correo.yahoo.es -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: Php + mysql
Hola, creo que esta pregunta tendria mejores respuestas en una lista de programacion o php. De todas maneras, como estas haciendo la autentificacion?, imagino que estas usando las variables $_SESSION, ¿tienes el register_globals activado o desactivado?, que version de PHP estas usando?, en el mensaje de error te dan unas recomendaciones, las tomaste en cuenta? Saludos. On Tue, 02 Nov 2004 10:46:29 -0600, Robin Ross [EMAIL PROTECTED] wrote: Buenas listeros: Los molesto con lo siguiente: resulta que tengo una pagina en la cual necesito que usuarios se identifiquen con su usuario y contraseña, pero no he logrado hacer que estos puedan ingresar, ya esta creada la base de datos y todo esta bien (eso creo), pero no se logran identificar, sacan este error: Warning: Unknown(): Your script possibly relies on a session side-effect which existed until PHP 4.2.3. Please be advised that the session extension does not consider global variables as a source of data, unless register_globals is enabled. You can disable this functionality and this warning by setting session.bug_compat_42 or session.bug_compat_warn to off, respectively. in Unknown on line 0 Alguien sabe que es lo que esta mal aca??, sugerencias, opiniones y demas son bienvenidas, saludos, robin -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED] -- Christian Sanchez Usuario GNU/Linux 234800 Maracay - Venezuela En la ruta al 1º Foro Mundial de Tecnología Libre Caracas, del 17 al 21 de Noviembre
Re: Php + mysql
Te recomiendo que eches un vistazo a estos php-script para sistema de usuarios con privilegios de administrador: http://www.evolt.org/article/PHP_Login_System_with_Admin_Features/17/60384/index.html Yo los he usado pero quitando algunas cosas y poniendo otras para las webs que hago... ah! tendras que activar el register_globasl en el php.ini Saludos El mar, 02-11-2004 a las 10:46 -0600, Robin Ross escribió: Buenas listeros: Los molesto con lo siguiente: resulta que tengo una pagina en la cual necesito que usuarios se identifiquen con su usuario y contraseña, pero no he logrado hacer que estos puedan ingresar, ya esta creada la base de datos y todo esta bien (eso creo), pero no se logran identificar, sacan este error: Warning: Unknown(): Your script possibly relies on a session side-effect which existed until PHP 4.2.3. Please be advised that the session extension does not consider global variables as a source of data, unless register_globals is enabled. You can disable this functionality and this warning by setting session.bug_compat_42 or session.bug_compat_warn to off, respectively. in Unknown on line 0 Alguien sabe que es lo que esta mal aca??, sugerencias, opiniones y demas son bienvenidas, saludos, robin
Re: Php + mysql
Gracias, ya logre ingresar, y efectivamente el register global estaba desactivado, gracias a los dos por sus respuestas, saludos, robin El mar, 02-11-2004 a las 12:01, mario in debian escribió: Te recomiendo que eches un vistazo a estos php-script para sistema de usuarios con privilegios de administrador: http://www.evolt.org/article/PHP_Login_System_with_Admin_Features/17/60384/index.html Yo los he usado pero quitando algunas cosas y poniendo otras para las webs que hago... ah! tendras que activar el register_globasl en el php.ini Saludos El mar, 02-11-2004 a las 10:46 -0600, Robin Ross escribió: Buenas listeros: Los molesto con lo siguiente: resulta que tengo una pagina en la cual necesito que usuarios se identifiquen con su usuario y contraseña, pero no he logrado hacer que estos puedan ingresar, ya esta creada la base de datos y todo esta bien (eso creo), pero no se logran identificar, sacan este error: Warning: Unknown(): Your script possibly relies on a session side-effect which existed until PHP 4.2.3. Please be advised that the session extension does not consider global variables as a source of data, unless register_globals is enabled. You can disable this functionality and this warning by setting session.bug_compat_42 or session.bug_compat_warn to off, respectively. in Unknown on line 0 Alguien sabe que es lo que esta mal aca??, sugerencias, opiniones y demas son bienvenidas, saludos, robin
Re: PHP/MySQL: LOAD DATA LOCAL INFILE
Wir haben unseren Server auf PHP 4.3.8 und MySQL 4.0.2 updated. PHP stammt von debian.moolfreet.com (Dotdeb) und MySQL kommt von backports.org. Nun erhalten einige unsere Kunden die folgende Fehlermeldung: 1148:The used command is not allowed with this MySQL version Diese Meldung als Suche bei Google bringt gleich an erster Stelle dieses: SQLWays Troubleshooting Guide http://www.ispirer.com/doc/sqlways36/troubleshooting/mysql_db.html Dort steht: In MySQL 4.0.x LOCAL will only work if MySQL server was started with --local-infile=1. Ist local-infile bei dir 1? -- ciao Sven -- Haeufig gestellte Fragen und Antworten (FAQ): http://www.de.debian.org/debian-user-german-FAQ/ Zum AUSTRAGEN schicken Sie eine Mail an [EMAIL PROTECTED] mit dem Subject unsubscribe. Probleme? Mail an [EMAIL PROTECTED] (engl)
Re: PHP/MySQL problem SOLVED
On 12/25/2002 6:54 PM, Michael Olds wrote: This problem solved. PHP was working fine, MySql was working fine, MySql support was built into the PHP Apache module ok, but the PHP MySql module was not installed. That gets me every time. ;) -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
RE: PHP/MySQL problem SOLVED
Three teeth-grinding days! -Original Message- From: Steve [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 8:29 AM To: [EMAIL PROTECTED] Subject: Re: PHP/MySQL problem SOLVED On 12/25/2002 6:54 PM, Michael Olds wrote: This problem solved. PHP was working fine, MySql was working fine, MySql support was built into the PHP Apache module ok, but the PHP MySql module was not installed. That gets me every time. ;) -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED] -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
RE: PHP/MySQL problem SOLVED
This problem solved. PHP was working fine, MySql was working fine, MySql support was built into the PHP Apache module ok, but the PHP MySql module was not installed. Best Wishes! Mike Olds www.buddhadust.org -Original Message- From: Michael Olds [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 24, 2002 2:24 PM To: Debian-User Subject: PHP/MySQL problem OK I need a little help here, some insight into what may be going wrong. Setting up on a Debian Woody with Apache; trying to install a PHP BB script. I have checked in with the script folks but I need to work this from both ends. The PHP module is set up and working (I have uncommented the correct line in LoadModule and the two AddType lines -- does there need to be anything like a script alias for php? I still havn't figured out how scripts can be processed in the htdocs folder safely) as is MySQL (I'm not saying nothing can be wrong with the setup, only just that it is working as far as I can tell). I can access the database from the box using the username and password set up for the script. And I have run a couple of small php include scripts and done the ?php info thing and mysql was built in (but my book says there should be a section on MySql and there was none...is there something further that needs to be done to activate PHP/MySql interaction?). I have double checked the spelling, and given the root directory path properly. What happens is I can GET the first page of the Administration setup script for the BB and it appears to POST ok, and then all I get is a blank (white) screen that tells me its done. No error messages at all. I checked my Norton Firewall and refers are allowed...but not recommended while trying to set up PHP scripts...setting this up from my W2K box ftping to the Linux box. I uploaded the script files in ASCII and the permissions are correct. I have checked the on-line documentation and have looked at a couple of books but there is very little in any of them about how to set up (if that is the problem), most are on how to use. Any pointers, clues, hints, insights? Best Wishes! Mike Olds www.buddhadust.org -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED] -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
RE: PHP + MySQL
Hi ! Mir ist schon klar, dass ich die MySQL-Extension ins PHP bekommen muss. Nur weis ich nicht wie das unter Debian/Linux funktioniert. Kann mir jemand helfen? Apt-get install php4-mysql Gruß Florian -- Häufig gestellte Fragen und Antworten (FAQ): http://www.de.debian.org/debian-user-german-FAQ/ Zum AUSTRAGEN schicken Sie eine Mail an [EMAIL PROTECTED] mit dem Subject unsubscribe. Probleme? Mail an [EMAIL PROTECTED] (engl)
Re: PHP + MySQL
Kraus, Thorsten wrote: Hallo, habe einen Debian-PC aufgesetzt und Apache, PHP und MySQL über apt installiert. Wenn ich jetzt phpmyadmin starten will, kommt folgende Fehlermeldung. [1.20] I receive the error cannot load MySQL extension, please check PHP Configuration. To connect to a MySQL server, PHP needs a set of MySQL functions called MySQL extension. This extension may be part of the PHP server (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or mysql.dll. phpMyAdmin tried to load the extension but failed. Usually, the problem is solved by installing a software package called PHP-MySQL or something similar. Mir ist schon klar, dass ich die MySQL-Extension ins PHP bekommen muss. Nur weis ich nicht wie das unter Debian/Linux funktioniert. Kann mir jemand helfen? Danke schon mal apt-get install php4-mysql Kai -- Häufig gestellte Fragen und Antworten (FAQ): http://www.de.debian.org/debian-user-german-FAQ/ Zum AUSTRAGEN schicken Sie eine Mail an [EMAIL PROTECTED] mit dem Subject unsubscribe. Probleme? Mail an [EMAIL PROTECTED] (engl)
RE: php - mysql
Olá Marcelo, Disponibilizar a mensagem de erro ajuda ! ;-) Verifique se o php está devidamente configurado e reconhecendo o módulo do mysql construindo uma página pequena e simples; ? echo phpinfo(); ? Isso fará com que você tenha informações mais precisas de como está o seu ambiente. Você também mencionou um comando connect espero que você esteja usando mysql_connect com os devidos parâmetros certo? Até + Orlando Tempobono - WMaster MK [EMAIL PROTECTED] icq:40367870 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 4:51 AM To: debian Subject: php - mysql Olá Caros, Estou com uma pequena dificuldade... Tenho instalado o potato 2.2r7 apache + php4. Tenho páginas que já utilizam o php4 sem prolemas, no entanto não consigo acessar um banco de dados mysql. De acordo com o Dselect todos os módulos php4 estão instalados e no httpd.conf a linha do módulo mysql não está comentada. Porém, quando eu no código php solicito conexão ao banco mysql, me retorna um erro dizendo que o comando não existe! No mysql do windows + apache funciona muito bem... (claro que só utilizei para testes :)) O usuário do banco também já existe! Tentei até como Root mas não adiantou pois ele não aceita como válido o comando connect. Abraços, Marcelo A. Soares Bill - [EMAIL PROTECTED] Debian User: 419 Linux User: 278667 -- WebMail SecrelNet - www.secrel.com.br -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.380 / Virus Database: 213 - Release Date: 7/24/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.380 / Virus Database: 213 - Release Date: 7/24/2002
Re: php - mysql
certifique se pkg esta instalado: dpkg -l | grep php4-mysql Senao: apt-get install php4-mysql --- [EMAIL PROTECTED] wrote: Olá Caros, Estou com uma pequena dificuldade... Tenho instalado o potato 2.2r7 apache + php4. Tenho páginas que já utilizam o php4 sem prolemas, no entanto não consigo acessar um banco de dados mysql. De acordo com o Dselect todos os módulos php4 estão instalados e no httpd.conf a linha do módulo mysql não está comentada. Porém, quando eu no código php solicito conexão ao banco mysql, me retorna um erro dizendo que o comando não existe! No mysql do windows + apache funciona muito bem... (claro que só utilizei para testes :)) O usuário do banco também já existe! Tentei até como Root mas não adiantou pois ele não aceita como válido o comando connect. Abraços, Marcelo A. Soares Bill - [EMAIL PROTECTED] Debian User: 419 Linux User: 278667 -- WebMail SecrelNet - www.secrel.com.br -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED] __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com
Re: PHP+MYSQL unable to select database
Hi. First, please avoid cross-posting. Try to narrow down the problem by trying from the command line client (i.e. try to rule out PHP as source of the problem). If that doesn't work, try the PHP list. If you are successful, it belongs to the MySQL list (as PHP is no longer part of the problem). And it doesn't sound like any particular debian problem at all. On Mon, Dec 10, 2001 at 11:58:51AM +0100, [EMAIL PROTECTED] wrote: I can't select a database from a php script. What means i can't select? Does it simply show no effect? Do you get an error? Anything else? I've set privileges in both the user and the data base tables and I've done FLUSH PRIVILEGES; WHY? I cannot say, because you did not provide enough information, mainly which error message you get (provided you got one). You may want to have a look at the following section from the fine manual: http://www.mysql.com/doc/A/c/Access_denied.html If that doesn't help, don't forget to mention, what you already have tried. And please write only to one list at a time, the one which seems most appropriate. Thanks. Bye, Benjamin. PS: Reply-To set accordingly. -- [EMAIL PROTECTED]
Re: php-mysql (apache) not found
Subject: php-mysql (apache) not found Date: Tue, Jul 03, 2001 at 05:34:09PM +0200 In reply to:Raffaele Sandrini Quoting Raffaele Sandrini([EMAIL PROTECTED]): Hi, I have installed phpMyAdmin on my apache. Now if i call it i get the message Fatal error: Call to unsupported or undefined function mysql_connect() in lib.inc.php3 on line 255 But i have installed the mysql module for php. after i have even installed the cgi version of the mysql php module? (mysql is perfectly working) Whats wrong or what have i missed? Have you enabled mysql in httpd.conf? VT2 root-2.2r3-prince:/etc/init.d# rgrep -i mysql /etc/apache/* /etc/apache/httpd.conf:LoadModule auth_mysql_module /usr/lib/apache/1.3/mod_auth_mysql.so -- System going down at 1:45 for disk crashing. ___