[prev in list] [next in list] [prev in thread] [next in thread]
List: mysql-java
Subject: Re: need some help about MySQL installation and connection through java
From: Samuel Noullier <samuel () bean ! ee ! unsw ! edu ! au>
Date: 1999-07-22 6:38:37
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Samuel Noullier wrote:
>
> Hi everybody
>
>
> I introduce myself, My name is Samuel Noullier, I'm a student who
> actually develop a Java Program.
> I want to use MySQL as a Database (of course).
> But I have some problems with it.
>
> I just want to create some table in two databases. I would like that
> all the people from all the host can log at this
> database.
> Of course I use the driver include in JDK-1.1.6, there is no problem
> with it.
> Only when I want to log at the MySQL server with this command
>
> String url = jdbc:mysql://192.168.0.13:3306/loc;
> String userName = guest;
> String passWord = ""; //No password
>
> con = (Connection) DriverManager.getConnection(url, userName,
> passWord);
>
> As you can see, the MySQL daemon runs on the 192.168.0.13 machine. I
> would like to use the port number 3306
> for the communication.
>
> So My question is very simple, but I try to install this the last 3
> days without succes.
>
> I would like that all the user with the userName : guest, could
> connect to this MySQl database from any host
> without password. The aim is to consult some tables in two directories
> ("mao" and "loc"). The users could write
> and read in these tables. I have so many problems with the access.
> Someone could explain me step by step the actions to install the MySQL
> daemon (maybe my installation is
> wrong),
> and to allow these specifics users ("guest") to connect from anywhere
> without password.
>
> I'm not an idle, no I have readed a lot things about mysql
> installation, jdbc....But now I'm lost with the database
> mysql and the tables user, db....
>
> Help !!!!!!!!!!!!!
>
> Thanks guys
>
> --
>
> Shammy the Search Bis
> University of New South Wales
>
> ----------------------------------------------------------------
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail java-thread223@lists.mysql.com
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail java-unsubscribe@lists.mysql.com instead.
>
I'm really sorry guys.
After two hours to read all the messages in the mailing list, I think I
have to put more information about my system
Linux RedHat 5.2
mysql-3.22.22-pc-linux-gnu-i686
I don't remember the version of the driver, but I think it works:
org/gjt/mm/mysql
Maybe I have to put the error text:
[Wed Jul 21 22:07:14 EDT 1999] Starting LocationServerSQL
LocDBSQL constr: running
[Wed Jul 21 22:07:14 EDT 1999] ExpiryCheck: comming up
[Wed Jul 21 22:07:14 EDT 1999] Listener : up and runnnig...
[Wed Jul 21 22:07:14 EDT 1999] Listener : waiting for request
[Wed Jul 21 22:07:44 EDT 1999] ExpiryCheck: checking database for
expired entries
LocSQLHandler constr 1: running
Config constr: new handler for config
FileHandler constr 1: pref_loc, pref_loc/config exist
LocSQLHandler constr: user, passwd is guest,
LocSQLHandler constr: db is 192.168.0.13,loc,3306
LocSQLHandler send: running with query: select * from registered where
ttl<now();
Before Connection
LocSQLHandler connect at: jdbc:mysql://192.168.0.13:3306/loc
LocSQLHandler connect username: guest
LocSQLHandler connect password:
==> SQLException:
ErrorCode: java.sql.SQLException: General Error: 58
Message (send): General Error: 58
SQLState: null
ErrorCode: 0
ErrorCode: java.sql.SQLException: General Error: 58
java.lang.NullPointerException:
at LocDBSQL.getExpired(LocDBSQL.java:124)
at ExpiryChecker.run(ExpiryChecker.java:45)
The bold text is only some System.out.println to catch the location of
the error.
So as I say in my first mail, the problem is with the connection
con = (Connection) DriverManager.getConnection(url, userName, passWord);
And I think this error comes because my MySQL daemon is not installed as
I need.
I hope that someone could help me, just to allows all the "guest"
username to connect from any hostName to the MySQL daemon and to read
some tables in MY database. I know that is really unsecure, but actually
doesn't matter, I only looking for a solution to run my application,
what I put inside is not important on the point of view security.
If someone has a solution, could he explain really carrefully, with some
example if possible.
Have good day guys.
--
Shammy the Search Bis
University of New South Wales
[Attachment #5 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
Samuel Noullier wrote:
<BLOCKQUOTE TYPE=CITE>
<BR>Hi everybody
<BR>
<P>I introduce myself, My name is Samuel Noullier, I'm a student who actually
develop a Java Program.
<BR>I want to use MySQL as a Database (of course).
<BR>But I have some problems with it.
<P>I just want to create some table in two databases. I would like
that all the people from all the host can log at this
<BR>database.
<BR>Of course I use the driver include in JDK-1.1.6, there is no problem
with it.
<BR>Only when I want to log at the MySQL server with this command
<P>String url = jdbc:mysql://192.168.0.13:3306/loc;
<BR>String userName = guest;
<BR>String passWord = ""; //No password
<P>con = (Connection) DriverManager.getConnection(url, userName, passWord);
<P>As you can see, the MySQL daemon runs on the 192.168.0.13 machine. I
would like to use the port number 3306
<BR>for the communication.
<P>So My question is very simple, but I try to install this the last 3
days without succes.
<P>I would like that all the user with the userName : guest, could connect
to this MySQl database from any host
<BR>without password. The aim is to consult some tables in two directories
("mao" and "loc"). The users could write
<BR>and read in these tables. I have so many problems with the access.
<BR>Someone could explain me step by step the actions to install the MySQL
daemon (maybe my installation is
<BR>wrong),
<BR>and to allow these specifics users ("guest") to connect from anywhere
without password.
<P>I'm not an idle, no I have readed a lot things about mysql installation,
jdbc....But now I'm lost with the database
<BR>mysql and the tables user, db....
<P>Help !!!!!!!!!!!!!
<P>Thanks guys
<PRE>--</PRE>
<CENTER>
<ADDRESS>
<B><U><FONT COLOR="#000099"><FONT SIZE=+1>Shammy the Search \
Bis</FONT></FONT></U></B></ADDRESS></CENTER>
<CENTER>
<ADDRESS>
<B><U><FONT COLOR="#000099"><FONT SIZE=+1>University of New South \
Wales</FONT></FONT></U></B></ADDRESS></CENTER>
<PRE>
<HR WIDTH="90%" SIZE=4>---------------------------------------------------------------------
Please check "<A HREF="http://www.mysql.com/Manual_chapter/manual_toc.html">http://www.mysql.com/Manual_chapter/manual_toc.html</A>" \
before posting. To request this thread, e-mail java-thread223@lists.mysql.com
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail java-unsubscribe@lists.mysql.com instead.</PRE>
</BLOCKQUOTE>
<P>I'm really sorry guys.
<BR>After two hours to read all the messages in the mailing list, I think
I have to put more information about my system
<P>Linux RedHat 5.2
<BR>mysql-3.22.22-pc-linux-gnu-i686
<BR>I don't remember the version of the driver, but I think it works: \
org/gjt/mm/mysql <P>Maybe I have to put the error text:
<BR>[Wed Jul 21 22:07:14 EDT 1999] Starting LocationServerSQL
<BR>LocDBSQL constr: running
<BR>[Wed Jul 21 22:07:14 EDT 1999] ExpiryCheck: comming up
<BR>[Wed Jul 21 22:07:14 EDT 1999] Listener : up and runnnig...
<BR>[Wed Jul 21 22:07:14 EDT 1999] Listener : waiting for request
<BR>[Wed Jul 21 22:07:44 EDT 1999] ExpiryCheck: checking database for expired
entries
<BR><B>LocSQLHandler constr 1: running</B>
<BR><B>Config constr: new handler for config</B>
<BR><B>FileHandler constr 1: pref_loc, pref_loc/config exist</B>
<BR><B>LocSQLHandler constr: user, passwd is guest,</B>
<BR><B>LocSQLHandler constr: db is 192.168.0.13,loc,3306</B>
<BR><B>LocSQLHandler send: running with query: select * from registered
where ttl<now();</B>
<BR><B>Before Connection</B>
<BR><B>LocSQLHandler connect at: \
jdbc:mysql://192.168.0.13:3306/loc</B> <BR><B>LocSQLHandler connect username: \
guest</B> <BR><B>LocSQLHandler connect password:</B>
<BR>==> SQLException:
<BR>ErrorCode: java.sql.SQLException: General Error: 58
<BR>Message (send): General Error: 58
<BR>SQLState: null
<BR>ErrorCode: 0
<BR>ErrorCode: java.sql.SQLException: General Error: 58
<BR>java.lang.NullPointerException:
<BR> at \
LocDBSQL.getExpired(LocDBSQL.java:124) <BR> \
at ExpiryChecker.run(ExpiryChecker.java:45) <BR>
<P>The bold text is only some System.out.println to catch the location
of the error.
<BR>So as I say in my first mail, the problem is with the connection
<P><B>con = (Connection) DriverManager.getConnection(url, userName, passWord);</B>
<P>And I think this error comes because my MySQL daemon is not installed
as I need.
<P>I hope that someone could help me, just to allows all the "guest" username
to connect from any hostName to the MySQL daemon and to read some tables
in MY database. I know that is really unsecure, but actually doesn't matter,
I only looking for a solution to run my application, what I put inside
is not important on the point of view security.
<BR>If someone has a solution, could he explain really carrefully, with
some example if possible.
<P>Have good day guys.
<BR>
<P>--
<CENTER>
<ADDRESS>
<B><U><FONT COLOR="#000099"><FONT SIZE=+1>Shammy the Search \
Bis</FONT></FONT></U></B></ADDRESS></CENTER>
<CENTER>
<ADDRESS>
<B><U><FONT COLOR="#000099"><FONT SIZE=+1>University of New South \
Wales</FONT></FONT></U></B></ADDRESS></CENTER> </HTML>
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail java-thread224@lists.mysql.com
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail java-unsubscribe@lists.mysql.com instead.
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic