Re: [PHP-DB] Can't Connect to MySQL local Server
Some further information/questions on this problem. I wrote a small program just to see if I could connect to the mysql socket, and I could. Looking at seliunx policy, I note an item called Allow HTTPD scripts to and modules to connect to the network. That item is unchecked. Should it be checked in order for the php script to connect using a socket? Chris [EMAIL PROTECTED] 10/26/2006 5:33 PM ROGER DEBRY wrote: Janet and Miles, Thank you for your suggestions. Here is more information for you. I am running: Fedora core 5 Linux php 5.14 apache 2.2.2 mysql 5.0.22 I have added the mysql_error code to my script as you suggested. I already knew the what the error was by looking in the error logs. It is, Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) That means 'permission denied'. Are you sure mysql is running on localhost ? FC5 has selinux doesn't it - make sure permissions are set up properly for that too. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Can't Connect to MySQL local Server
Alle 16:36, venerdì 27 ottobre 2006, ROGER DEBRY ha scritto: check if your mysql daemon doesn't skip networking Some further information/questions on this problem. I wrote a small program just to see if I could connect to the mysql socket, and I could. Looking at seliunx policy, I note an item called Allow HTTPD scripts to and modules to connect to the network. That item is unchecked. Should it be checked in order for the php script to connect using a socket? Chris [EMAIL PROTECTED] 10/26/2006 5:33 PM ROGER DEBRY wrote: Janet and Miles, Thank you for your suggestions. Here is more information for you. I am running: Fedora core 5 Linux php 5.14 apache 2.2.2 mysql 5.0.22 I have added the mysql_error code to my script as you suggested. I already knew the what the error was by looking in the error logs. It is, Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) That means 'permission denied'. Are you sure mysql is running on localhost ? FC5 has selinux doesn't it - make sure permissions are set up properly for that too. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem with executing Oracle query for creating procedure
Hi, i have problem with PHP and Oracle database. I read with PHP script an sql files like this: create or replace procedure test_proc1(p1 IN number, p3 OUT number) as begin p3 := p1 + 10; end; And when I execute it I receive an error: Warning: ociexecute(): OCIStmtExecute: OCI_SUCCESS_WITH_INFO: ORA-24344: success with compilation error in... And the procedue doesn't put in the database. When I edit the .sql file - all to be on 1 row - like this: create or replace procedure test_proc1(p1 IN number, p2 OUT number) as begin p2 := p1 + 10; end; Then I have no problems. Can someone help me with this? Thanks in advance, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Can't Connect to MySQL local Server
skip-networking is uncommented in the [mysqld] section of my.cnf I did discover something interesting this morning. When starting the MySQL server with mysqld_safe, I cannot connect to the server with my php script. However, I started the server this morning with /etc/init.d/mysqld start, and the php script connects just fine. Can anyone tell me why the difference? Matteo Cisilino [EMAIL PROTECTED] 10/27/2006 9:15 AM Alle 16:36, venerdì 27 ottobre 2006, ROGER DEBRY ha scritto: check if your mysql daemon doesn't skip networking Some further information/questions on this problem. I wrote a small program just to see if I could connect to the mysql socket, and I could. Looking at seliunx policy, I note an item called Allow HTTPD scripts to and modules to connect to the network. That item is unchecked. Should it be checked in order for the php script to connect using a socket? Chris [EMAIL PROTECTED] 10/26/2006 5:33 PM ROGER DEBRY wrote: Janet and Miles, Thank you for your suggestions. Here is more information for you. I am running: Fedora core 5 Linux php 5.14 apache 2.2.2 mysql 5.0.22 I have added the mysql_error code to my script as you suggested. I already knew the what the error was by looking in the error logs. It is, Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) That means 'permission denied'. Are you sure mysql is running on localhost ? FC5 has selinux doesn't it - make sure permissions are set up properly for that too. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Converting text field to barcode CODE 39
Hello. Can anyone tell me where I can find information or examples about printing on screen or in PDF (with FDPF for example) for text fields stored on a MySQL Database with PHP 4 , PHP 5. Best regards, Jorge Gimenez
Re: [PHP-DB] Problem with executing Oracle query for creating procedure
Rosen wrote: Hi, i have problem with PHP and Oracle database. I read with PHP script an sql files like this: create or replace procedure test_proc1(p1 IN number, p3 OUT number) as begin p3 := p1 + 10; end; And when I execute it I receive an error: Warning: ociexecute(): OCIStmtExecute: OCI_SUCCESS_WITH_INFO: ORA-24344: success with compilation error in... And the procedue doesn't put in the database. When I edit the .sql file - all to be on 1 row - like this: create or replace procedure test_proc1(p1 IN number, p2 OUT number) as begin p2 := p1 + 10; end; Then I have no problems. Can someone help me with this? Thanks in advance, Rosen Normally I'd use a tool such as SQL Developer or SQL*Plus to pre-create database resident things like tables and PL/SQL procedures. However, back to your problem: use UNIX style end of line characters. Or build up the statement using PHP string concatenation. Chris -- Christopher Jones, Oracle Email: [EMAIL PROTECTED]Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Converting text field to barcode CODE 39
www.fpdf.org has a free class / tutorial bastien From: Jorge Giménez [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Converting text field to barcode CODE 39 Date: Fri, 27 Oct 2006 23:49:22 +0200 Hello. Can anyone tell me where I can find information or examples about printing on screen or in PDF (with FDPF for example) for text fields stored on a MySQL Database with PHP 4 , PHP 5. Best regards, Jorge Gimenez _ Experience Live Search from your PC or mobile device today. http://www.live.com/?mkt=en-ca -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Converting text field to barcode CODE 39
Jorge, If you have downloaded FPDF you will se that it comes with a couple of examples that you can use to learn. Miguel Guirao -Original Message- From: Jorge Giménez [mailto:[EMAIL PROTECTED] Sent: Viernes, 27 de Octubre de 2006 04:49 p.m. To: php-db@lists.php.net Subject: [PHP-DB] Converting text field to barcode CODE 39 Hello. Can anyone tell me where I can find information or examples about printing on screen or in PDF (with FDPF for example) for text fields stored on a MySQL Database with PHP 4 , PHP 5. Best regards, Jorge Gimenez Este mensaje es exclusivamente para el uso de la persona o entidad a quien esta dirigido; contiene informacion estrictamente confidencial y legalmente protegida, cuya divulgacion es sancionada por la ley. Si el lector de este mensaje no es a quien esta dirigido, ni se trata del empleado o agente responsable de esta informacion, se le notifica por medio del presente, que su reproduccion y distribucion, esta estrictamente prohibida. Si Usted recibio este comunicado por error, favor de notificarlo inmediatamente al remitente y destruir el mensaje. Todas las opiniones contenidas en este mail son propias del autor del mensaje y no necesariamente coinciden con las de Radiomovil Dipsa, S.A. de C.V. o alguna de sus empresas controladas, controladoras, afiliadas y subsidiarias. Este mensaje intencionalmente no contiene acentos. This message is for the sole use of the person or entity to whom it is being sent. Therefore, it contains strictly confidential and legally protected material whose disclosure is subject to penalty by law. If the person reading this message is not the one to whom it is being sent and/or is not an employee or the responsible agent for this information, this person is herein notified that any unauthorized dissemination, distribution or copying of the materials included in this facsimile is strictly prohibited. If you received this document by mistake please notify immediately to the subscriber and destroy the message. Any opinions contained in this e-mail are those of the author of the message and do not necessarily coincide with those of Radiomovil Dipsa, S.A. de C.V. or any of its control, controlled, affiliates and subsidiaries companies. No part of this message or attachments may be used or reproduced in any manner whatsoever. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php