Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

2001-03-21 Thread denis mettler

Hi,

I'm really tired of this problem...

Here's the error message: 

Can't connect to local MySQL server through socket 
'/var/lib/mysql/mysql.sock' (13) in /usr/local/httpd/htdocs/dbopen.php3 on 
line 5

I have Suse 7.1
Standard installation with apache1.3.14 and php3.0.17

Apache is running
Simple PHP Scripts without MYSQL CONNECTION, too.

Mysql 3.23 is okay.
Mysqld is running
i started mysql and created a db.

But the only thing i could not do is to make
mysql_connect with a php script.

i have the php3.ini and the 
/etc/httpd/ directory

and there is an entry:
mysql.default_socket=   /tmp/mysql.sock

the mysql.sock is there!

I DON'T HAVE ANY IDEA WHY THIS PROBLEM OCCURS!
If u need more Information please let me know

Please help

Regards
Denis

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Can't connect server through socket /var/lib/mysql/mysql.sock(111)

2001-03-20 Thread denis mettler

Hi,

I get the following message if i try to connect to server:

Can't connect server through socket /var/lib/mysql/mysql.sock(111)

Cal said, i should modify my php.ini and should give the exact definition for 
the mysql socket.
but i don't have an entry in the php.ini for mysql socket.

any ideas?

T.i.a.

Regards 
denis


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Can't connect throug socket

2001-03-20 Thread denis mettler

Hi Thanks for the help,

I checked again.
but i don't have an entry in php.ini

[mysql]
mysql.default_socket  = /path/to/mysql/socket

So, i did execute the tip from egon.

But now,
i don't get the content from .php files 
but i think i'll get it to work today.

thanks 
regards
denis

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Problem Setting up MyODBC Driver

2001-03-20 Thread denis mettler

Hi Nick,

I think u have to make the following.
go to mysql prompt:

use mysql;

then 
select * from user;

is there an entry for the mysql client and the user on it?
i don't think so.
so u have to make a new entry.
then:

grant all on *.* to username@clienthostname

username (username u are connecting with from client)
clienthostname (hostname of your client)

after this is done make the following from your mysql directory:

bin/mysqladmin -u root flush-privileges

hope that helps

regards
denis

On Tuesday 20 March 2001 15:31, you wrote:
 HI

 I am trying to set up an ODBC connection between my Windows 2000 PC and
 my Web Server which has a MySQL database on it. I installed the MyODBC
 package for Windows NT and entered all the relevant information:

 DSN E-SkyMySQL
 MySQL host 192.168.1.100
 MySQL Database Name eskylight
 User httpd
 and Password

 I did this as a machine data source

 When I try to connect I get the error message

 S1000[TCX][MYODBC] Host " is not allowed to connect to this MySQL
 Server.

 Any Ideas why this may be happening?

 Thanks

 Nick Steele




 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED] Trouble
 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111)

2001-03-20 Thread denis mettler

Hi,

i deleted mysql in /var
and make re-install in /usr/local/

but received the same error.

so i make an entry in the php3.ini

[mysql]
mysql.default_socket = /temp

where i found the mysql.sock

the error message is still there?

Other ideas?

regards
denis


On Tuesday 20 March 2001 14:52, you wrote:
 it looks like that:

 [MySQL]
 mysql.default_socket= /path/to/mysql/socket


 but I think thats not the problem. has your apache enough rights to access
 the directory /var/lib/mysql ? if not edit /etc/group an add "apache" to
 group "mysql".
 - "mysql:x:27:apache" or something similar, then make "chmod g+rx
 /var/lib/mysql", this should work. if not try to make a "chmod o+rx
 /var/lib/mysql", this should always work, but I think it isnt a good idea
 to leave it that way.

 Egon

 ---
 URL: http://www.snb.at
 mailto:[EMAIL PROTECTED]
 ---
 http://www.grusskarte.at





 denis mettler [EMAIL PROTECTED]
 20.03.01 15:02


 An: [EMAIL PROTECTED]
 Kopie:
 Thema:  Can't connect server through socket
 /var/lib/mysql/mysql.sock(111)

 Hi,

 I get the following message if i try to connect to server:

 Can't connect server through socket /var/lib/mysql/mysql.sock(111)

 Cal said, i should modify my php.ini and should give the exact definition
 for
 the mysql socket.
 but i don't have an entry in the php.ini for mysql socket.

 any ideas?

 T.i.a.

 Regards
 denis


 -
 Before posting, please check:
http://www.mys
 ql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED] Trouble
 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111)

2001-03-20 Thread denis mettler

Hi,

I did. but the problem is the same.

regards
denis

On Tuesday 20 March 2001 17:45, you wrote:
 try:
 [mysql]
 mysql.default_socket = /temp/mysql.sock


 Cal
 http://www.calevans.com


 -Original Message-
 From: denis mettler [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, March 20, 2001 10:40 AM
 To: [EMAIL PROTECTED]
 Subject: Re: Can't connect server through socket
 /var/lib/mysql/mysql.sock(111)


 Hi,

 i deleted mysql in /var
 and make re-install in /usr/local/

 but received the same error.

 so i make an entry in the php3.ini

 [mysql]
 mysql.default_socket = /temp

 where i found the mysql.sock

 the error message is still there?

 Other ideas?

 regards
 denis

 On Tuesday 20 March 2001 14:52, you wrote:
  it looks like that:
 
  [MySQL]
  mysql.default_socket= /path/to/mysql/socket
 
 
  but I think thats not the problem. has your apache enough rights to
  access the directory /var/lib/mysql ? if not edit /etc/group an add
  "apache" to group "mysql".
  - "mysql:x:27:apache" or something similar, then make "chmod g+rx
  /var/lib/mysql", this should work. if not try to make a "chmod o+rx
  /var/lib/mysql", this should always work, but I think it isnt a good
  idea to leave it that way.
 
  Egon
 
  ---
  URL: http://www.snb.at
  mailto:[EMAIL PROTECTED]
  ---
  http://www.grusskarte.at
 
 
 
 
 
  denis mettler [EMAIL PROTECTED]
  20.03.01 15:02
 
 
  An: [EMAIL PROTECTED]
  Kopie:
  Thema:  Can't connect server through socket
  /var/lib/mysql/mysql.sock(111)
 
  Hi,
 
  I get the following message if i try to connect to server:
 
  Can't connect server through socket /var/lib/mysql/mysql.sock(111)
 
  Cal said, i should modify my php.ini and should give the exact definition
  for
  the mysql socket.
  but i don't have an entry in the php.ini for mysql socket.
 
  any ideas?
 
  T.i.a.
 
  Regards
  denis
 
 
  -
  Before posting, please check:
 http://www.mys
  ql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
  [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
  [EMAIL PROTECTED] Trouble
  unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111)

2001-03-20 Thread denis mettler

My question is that,
why is he trying to connect through socket in /var/lib/mysql
cause i have installes in /usr/local
and the path to the mysql.sock is in php3.ini /temp/mysql.sock

any ideas?

regards
denis



On Tuesday 20 March 2001 14:52, you wrote:
 it looks like that:

 [MySQL]
 mysql.default_socket= /path/to/mysql/socket


 but I think thats not the problem. has your apache enough rights to access
 the directory /var/lib/mysql ? if not edit /etc/group an add "apache" to
 group "mysql".
 - "mysql:x:27:apache" or something similar, then make "chmod g+rx
 /var/lib/mysql", this should work. if not try to make a "chmod o+rx
 /var/lib/mysql", this should always work, but I think it isnt a good idea
 to leave it that way.

 Egon

 ---
 URL: http://www.snb.at
 mailto:[EMAIL PROTECTED]
 ---
 http://www.grusskarte.at





 denis mettler [EMAIL PROTECTED]
 20.03.01 15:02


 An: [EMAIL PROTECTED]
 Kopie:
 Thema:  Can't connect server through socket
 /var/lib/mysql/mysql.sock(111)

 Hi,

 I get the following message if i try to connect to server:

 Can't connect server through socket /var/lib/mysql/mysql.sock(111)

 Cal said, i should modify my php.ini and should give the exact definition
 for
 the mysql socket.
 but i don't have an entry in the php.ini for mysql socket.

 any ideas?

 T.i.a.

 Regards
 denis


 -
 Before posting, please check:
http://www.mys
 ql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED] Trouble
 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111)

2001-03-20 Thread denis mettler

That was a mistake by myself.
it was /tmp/

so, if i make ps

i can see that there are 4 mysqld processes are running
could this be the problem?

And if i use:

ps -aux|grep mysqld

there is only a difference between the process id.
nothing else?

ideas???

Regards 
Denis


On Tuesday 20 March 2001 18:25, you wrote:
 It is more likely /tmp/mysql.sock

 tmp has no 'e'.

 denis mettler wrote:
  Hi,
 
  I did. but the problem is the same.
 
  regards
  denis
 
  On Tuesday 20 March 2001 17:45, you wrote:
   try:
   [mysql]
   mysql.default_socket = /temp/mysql.sock
  
  
   Cal
   http://www.calevans.com
  
  
   -Original Message-
   From: denis mettler [mailto:[EMAIL PROTECTED]]
   Sent: Tuesday, March 20, 2001 10:40 AM
   To: [EMAIL PROTECTED]
   Subject: Re: Can't connect server through socket
   /var/lib/mysql/mysql.sock(111)
  
  
   Hi,
  
   i deleted mysql in /var
   and make re-install in /usr/local/
  
   but received the same error.
  
   so i make an entry in the php3.ini
  
   [mysql]
   mysql.default_socket = /temp
  
   where i found the mysql.sock
  
   the error message is still there?
  
   Other ideas?
  
   regards
   denis
  
   On Tuesday 20 March 2001 14:52, you wrote:
it looks like that:
   
[MySQL]
mysql.default_socket= /path/to/mysql/socket
   
   
but I think thats not the problem. has your apache enough rights to
access the directory /var/lib/mysql ? if not edit /etc/group an add
"apache" to group "mysql".
- "mysql:x:27:apache" or something similar, then make "chmod g+rx
/var/lib/mysql", this should work. if not try to make a "chmod o+rx
/var/lib/mysql", this should always work, but I think it isnt a good
idea to leave it that way.
   
Egon
   
---
URL: http://www.snb.at
mailto:[EMAIL PROTECTED]
---
    http://www.grusskarte.at
   
   
   
   
   
denis mettler [EMAIL PROTECTED]
20.03.01 15:02
   
   
An: [EMAIL PROTECTED]
Kopie:
Thema:  Can't connect server through socket
/var/lib/mysql/mysql.sock(111)
   
Hi,
   
I get the following message if i try to connect to server:
   
Can't connect server through socket /var/lib/mysql/mysql.sock(111)
   
Cal said, i should modify my php.ini and should give the exact
definition for
the mysql socket.
but i don't have an entry in the php.ini for mysql socket.
   
any ideas?
   
T.i.a.
   
Regards
denis
   
   
-
Before posting, please check:
   http://www.mys
ql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)
   
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
   
   
   
   
-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)
   
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED] Trouble
unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
  
   -
   Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
  
   To request this thread, e-mail [EMAIL PROTECTED]
   To unsubscribe, e-mail
   [EMAIL PROTECTED] Trouble
   unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
  [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED] Trouble
 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Persistent connection with php to mysql

2001-03-18 Thread Denis Mettler

Hi,

some of you work with php and mysql to connect a website with a mysql
database.
do u prefer an simple connection or a persistent connection?

and if u prefer the last one. how can u make this connection in the
index.php3?
do u make this with an "./include"?

thanks
regards
denis

   .'  '.'  `.
_.-|  o | o  |-._
  .~   `.__.'.__.'^  ~.
.~ ^  /   \  ^ ~.
\-._^   ^| |^_.-/
`\  `-._  \___/ ^_.-' /'
  `\_   `--...--'   /'
 `-..___..-'  /\  /\
__/   \__ | |/ /_
  .'^   ^`.  .'   `__\
.'^ ^  `.__.'^ .\ \
   .' ^ .^   .^  .'  \/
  //^ \'.__.'
 |  ^ /|   ^  |

http://www.denis-mettler.de


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




MYSQL Connection failed

2001-03-18 Thread denis mettler

Hallo,

Kann mir irgend jemand helfen?
Ich kann mit der folgenden Meldung nichts anfangen:

Anbei die Datei zum verbinden zur Datenbank:

_
?
$server = "localhost";  // MySQL-Server
$user   = "root";   // MySQL-Nutzer
$pass   = "geheim"; // MySQL-Kennwort
//
$conn = mysql_connect($server, $user, $pass);
if($conn) {
   echo "BYes, we're open!/B Handle: $conn";
} else {
   echo "BOops, something goes wrong";
   exit;
}
$select = mysql_select_db("customers",$conn);
?



Und hier die Fehlermeldung:

Warning: MySQL Connection Failed: Can't connect to local MySQL server through 
socket '/var/lib/mysql/mysql.sock' (111) in 
/usr/local/httpd/htdocs/dbopen.php3 on line 8
Oops, something goes wrong

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




MYSQL Connection failed

2001-03-18 Thread denis mettler

Hallo,

Kann mir irgend jemand helfen?
Ich kann mit der folgenden Meldung nichts anfangen:

Anbei die Datei zum verbinden zur Datenbank:

_
?
$server = "localhost";  // MySQL-Server
$user   = "root";   // MySQL-Nutzer
$pass   = "geheim"; // MySQL-Kennwort
//
$conn = mysql_connect($server, $user, $pass);
if($conn) {
   echo "BYes, we're open!/B Handle: $conn";
} else {
   echo "BOops, something goes wrong";
   exit;
}
$select = mysql_select_db("customers",$conn);
?



Und hier die Fehlermeldung:

Warning: MySQL Connection Failed: Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (111) in
/usr/local/httpd/htdocs/dbopen.php3 on line 8
Oops, something goes wrong

---

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




ODBC // #gelöscht

2001-03-18 Thread denis mettler

Hi,

Habe folgendes Problem:
Ich verbinde ber ODBC (MDAC 2.5 ist installiert) Access mit einer MySQL 
Datenbank.

Ich kann mit der MySQL Datenbank verbinden,
aber die Eintrge in der Tabelle werden als 

#gelscht

angezeigt.

Ich habe aber auch kein float Feld.
Habe ein auto_increment, Primary Key 
und ein timestamp
Feld.

Aber ich weiss einfach nicht was falsch luft.
Kann mir jemand helfen?

Danke im voraus.
Gruss
Denis

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




ODBC

2001-03-18 Thread denis mettler

Hi there,

I have the following problem which i can not solve.

i try to connect access with odbc to mysql.

i have a table:

name
age
id (primary key, auto_increment)
misc (timestamp)

i can connect but the entries are shown as #deleted-
Why?

i have installed the new MDAC!
i have no float fields!

And, i don't know why this happens.

Any ideas?
with mysql under windows everything works.
but with win2000 and linux, it doesn't.

regards
denis


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




2 Tables

2001-03-17 Thread Denis Mettler

Hi there,

Another problem.
i have the following tables:

table 1:
id, primary key, auto increment
name varchar(50)
city varchar(50)
phone varchar(25)


table 2:
categorie_id, primary key, auto_increment
kategorie varchar(50)


in table one i have the contacts
and in table two the categories (Business, privat...)

but how can i link these tables for a query.
i ask because i know that mysql doesn't support foreign keys.

thanks in advance
denis

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Primary Key

2001-03-16 Thread denis mettler

Hi,

Can i add the Primary key for a table after i created a table?
and if this column is not null and auto_increment will there occur an
error?

t.i.a.

regards
denis

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Error: MYSQL Connection failed

2001-03-16 Thread denis mettler

Hi there,

First i have the mysql db on linux in /usr/local/
then i installed new on /var

now i get the message:
Warning: MYSQL Connection failed:
Can't connect to local MYSQL Server through Socket 
'/var/lib/mysql/mysql.sock' (111) in /usr/local/httpd/htdocs/dbopen.php3 on 
line 8.

This is the text from dbopen.php3:
?
$server = "localhost";  // MySQL-Server
$user   = "root";   // MySQL-Nutzer
$pass   = "secret";  // MySQL-Kennwort
//
$conn = mysql_connect($server, $user, $pass);
if($conn) {
   echo "BYes, we're open!/B Handle: $conn";
} else {
   echo "BOops, something goes wrong";
   exit;
}
$select = mysql_select_db("name_of_db",$conn);
?

Any Ideas?
Thanks in advance

Regards from cologne
denis

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




MySQl // Access // ODBC

2001-03-16 Thread Denis Mettler

Hi,

i read the manual.
but i don't know what to do.

I have a table.
only 2 columns without a primary  key.

so i made the following:

alter table 'tablename'
add id auto_increment primary key;

and

alter table 'tablename'
add Misc timestamp;

But all fields are filled with #deleted.
i don't have fields with float and i have the new mdac from microsoft.

So, i don't know why this happens
any ideas???

regards
denis


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




MySQL over ODBC

2001-03-15 Thread denis mettler

Hi there,

i received the following message:

[TCX][MyODBC] Host 'XYZ' is not allowed to connect to this MySQL Server
(#1130)

any ideas

regards
denis

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




AW: Exporting data from MySQL to Oracle

2001-02-13 Thread Denis Mettler

Hi there,

please check the oracle migration bench at the oracle technet.

http://technet.oracle.com

kind regards
denis mettler


-Urspr?ngliche Nachricht-
Von: Noor Dawod [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 13. Februar 2001 17:23
An: Cal Evans; MySQL List
Betreff: RE: Exporting data from MySQL to Oracle


I couldn't find such product on Oracle's website.

Noor

-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 5:51 PM
To: Noor Dawod; MySQL List
Subject: RE: Exporting data from MySQL to Oracle


Didn't Oracle just release a MySQL to Oracle migration kit?  Check the
Oracle website.

Cal
http://www.calevans.com


-Original Message-
From: Noor Dawod [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 8:41 AM
To: MySQL List
Subject: Exporting data from MySQL to Oracle


Hello,

I'm having a problem exporting MySQL BLOB's to Oracle, especially those
records that has "Carriage Return" or "Line Feed" characters in them.

Has anyone done this before, and how did they do it? I need an immediate
help in this subject. I'd appreciate you help very much.

Thanks

Noor


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php