Where is 'sqlplus.hh' ?

2003-07-08 Thread Peter Moscatt
I have just installed MySQL++ 1.7.9 using the RPMs
from Rpmfind.com.

It installed all Ok.  The reason why I installed the
RPM over the source was that I can't get the source to
compile.

When I go and search the drive after the installation
I don't see the 'sqlplus.hh'

I am using Mandrake 9.1.

Where have I gone wrong ?

Pete


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Won't mysql_init();

2003-07-07 Thread Peter Moscatt
I am trying to connect to a simple database, basically
to check that I have the gist of programming with
MySQL.

I have tried the following code:

#include 
#include "linlog.h"

LinLog::LinLog(QWidget *parent, const char *name) :
PGM_Window(parent, name)
{
  MYSQL mysql;

  mysql_init(&mysql);
 
if(!mysql_real_connect(&mysql,"localhost","root","passw","database",0,NULL,0));
{
  fprintf(stderr,"Failed to connect to database:
Error: %s\n",mysql_error(&mysql));
};
}



Then try to 'make' and end up with the following
errors:

/home/pmoscatt/C++/linlog/linlog/linlog.cpp:9:
undefined reference to `mysql_init' 
linlog.o(.text+0x65):/home/pmoscatt/C++/linlog/linlog/linlog.cpp:10:
undefined reference to `mysql_real_connect' 
linlog.o(.text+0x7a):/home/pmoscatt/C++/linlog/linlog/linlog.cpp:12:
undefined reference to `mysql_error' 
linlog.o(.text+0xd4): In function
`LinLog::LinLog[in-charge](QWidget*, char const*)': 
/home/pmoscatt/C++/linlog/linlog/linlog.cpp:9:
undefined reference to `mysql_init' 
linlog.o(.text+0xfd):/home/pmoscatt/C++/linlog/linlog/linlog.cpp:10:
undefined reference to `mysql_real_connect' 
linlog.o(.text+0x112):/home/pmoscatt/C++/linlog/linlog/linlog.cpp:12:
undefined reference to `mysql_error' 
collect2: ld returned 1 exit status 
gmake[2]: *** [linlog] Error 1 
gmake[2]: Leaving directory
`/home/pmoscatt/C++/linlog/linlog' 
gmake[1]: Leaving directory
`/home/pmoscatt/C++/linlog' 
gmake[1]: *** [all-recursive] Error 1 
gmake: *** [all-recursive-am] Error 2 
*** failed *** 



I am programming using KDE.

What's the GO ?

Pete


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Dissapearing mysql.sock ?

2003-06-30 Thread Peter Moscatt
I am trying to install MySQL-server onto my Mandrake
9.1.

When I first install 'mysql' using the latest RPMs all
goes well and it places the mysql.sock into
'/var/lib/mysql'

But when I reboot and then come back to run mysql I
get an error indicating that it can't connect though
mysql.sock.

When I go and check the directory, I now see that the
mysql.sock has dissapeared.  

How can I prevent this from happening ?

Pete


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Starting MySQL 4.0 ?

2003-06-30 Thread Peter Moscatt
I have just installed 'MySQL-server' and
'MySQL-client' onto a Mandrake 9.1 system.

The two RPMs installed without error and running mysql
from the shell was fine and did what was expected of
it.

I have now rebooted the system and when I go to the
shell to issue the 'mysql' command I get the following
error:

ERROR 2002: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock'

What has happened and what needs to be done to get
things going again ?

Pete


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Mandrake 9.1 & MySql++ ?

2003-06-20 Thread Peter Moscatt
I am trying to install MySql++ (1.7.9) onto my Mandrake 9.1.

Initially is indicated that it couldn;t find the mysql libraries and I
assume is because I installed Mysql as one of the install options when
installing Mandrake 9.1 as I believe it dosen't include the needed
libraries for mysql++.

I then tryed to install the latest MySql-devel from 'rpmfind' but it
indicates that it didn't satisfy the already installed MySql and as a
result failed.

What do I need to do to get MySql++ installed on a Mandrake 9.1 system ?

Pete


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Trying to install MySql++ ??

2003-06-18 Thread Peter Moscatt
I am trying to install MySql++.  When I issue the
./configure command all seems to go well until it
generates an error which you can see below.

The version I am trying to install is 1.7.9 from
memory. I am using Mandrake 9.1 which has MySQL as one
of the installable options, which I have chosen. 
MySQL server works fine and able to create, drop...

What does the error message indicate:

updating cache ./config.cache
loading cache ./config.cache
checking whether to enable maintainer-specific
portions of Makefiles... no
checking for MySQL library directory...
configure: error: Didn't find the mysql library dir in
''




Pete

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Starting the Server at Boot Time ??

2002-05-28 Thread Peter Moscatt

I have just installed mysql 3.23.49 onto my Mandrake installation using the RPMs.

How can I get the mysql server to start as the PC is booting ??

Pete


__
Your favorite stores, helpful shopping tools and great gift ideas. Experience the 
convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/


-
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




Changing Database Location ?

2001-08-31 Thread Peter Moscatt

Can you change the location of a MySQL database ?  The default is 
'/var/lib/mysql'.

Pete



-
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




How To Change Database Location ?

2001-08-29 Thread Peter Moscatt

With MySQL is there a way that you can create a database from the default
location, which at the moment on my Linux install is:
'/var/lib/mysql/my_database'  ?

Pete


-
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




Setting User Privilges ? Confused !!

2001-08-29 Thread Peter Moscatt

I am pretty new to MySQL, in fact that also covers Linux as well.

I have Mandrake 8.0 which I have installed MySQL using the RPM format. 
 I plan to write code (python) to access the database to manage what 
data it may hold.

The server automatically starts on boot - which is fine.

To be able to do anything with MySQL I have to be logged on as 'root'

If I try to access the database I have created under my normal logon 
('pmoscatt') I get the following error message:

ERROR 1044: Access denied for user '@localhost' to database 'MCMaint'

I have read the manual to see how I can get around this but find it 
confusing.

Can anyone help me to allow me to access databases under my normal user 
account.

Pete



-
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