headers
PathFinder Software | 4 Sep 2002 21:41

Problems installing MySQLGUI 1.7.5-1

Anyone have any experience with the MySQLGUI 1.7.5-1

I am running Red Hat 6.2 with MySQL installed and running.

Frankly I have read the README and HELP and still not sure as to
what I am suppose to do with the my.cnf.

When I try to run it with the ./my.cnf from the directory where
MySQLGUI 1.7.5-1 is installed here is the error message I get:

[root <at> mail mysqlgui-1.7.5-1-linux-static]# ./my.cnf

./my.cnf: [client]: command not found
./my.cnf: port: command not found
Using domain server:
Name: localhost.track2you.com
Address: 127.0.0.1
Aliases:

Host not found.
./my.cnf: [client_fltk]: command not found
./my.cnf: database: command not found

================================

Can you walk me though with what to do and perhaps how to
configure the my.cnf?

Your time is appreciatted.
(Continue reading)

Permalink | Reply | 0 comments |
headers
nick j | 5 Sep 2002 15:47
Picon
Favicon

hooking up Perl to mysql


Hello Jochen Wiedmann,

I am trying to configure the Apache web server with Perl DBI to Mysql on a Win32 PC in order to test CGI
programs. If you are willing to help me, please can you guide me to any reference materials on the web. 

Yours

Nick T. Johnson

nick6j <at> yahoo.com

---------------------------------
Get a bigger mailbox -- choose a size that fits your needs.
Permalink | Reply | 1 comment |
headers
Jochen Wiedmann | 5 Sep 2002 16:43
Picon

Re: hooking up Perl to mysql

Zitiere nick j <nick6j <at> yahoo.co.uk>:

> I am trying to configure the Apache web server with Perl DBI to Mysql on
> a Win32 PC in order to test CGI programs. If you are willing to help me,
> please can you guide me to any reference materials on the web. 

http://www.mysql.com/doc/en/Windows_Perl.html

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread1901 <at> 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 msql-mysql-modules-unsubscribe <at> lists.mysql.com instead.
Permalink | Reply | 0 comments |
headers
Pat Traynor | 5 Sep 2002 21:52

undefined symbol: mysql_real_escape_stromg

While I still have a little hair to pull out, someone please save me.

I've recently upgraded my Linux box to Perl 5.8 and I'm trying to
install the DBI::mysql module.  CPAN failed miserably.  So I'm trying to
do it by hand.

The make seemed to go ok (with some work), but maybe not.  Make test
failed, though.  Here is the bulk of the output from "perl Makefile.PL.
I had to pass several libraries to it since it complained that they
weren't there.  I simply don't have libgz - could that be killing me?

---------------
  cflags        (guessed     ) = -I/usr/local/include/mysql
  libs          (Users choice) = -L/usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/libgcc.a
-L/usr/local/lib/mysql/libmysqlclient.a
-L/usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/libgcc.a -lz -lgz
  nocatchstderr (default     ) = 0
  ssl           (guessed     ) = 0
  testdb        (default     ) = test
  testhost      (default     ) = 
  testpassword  (default     ) = 
  testuser      (default     ) = 

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Note (probably harmless): No library found for -lgz
Using DBI 1.30 installed in /usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBI
Writing Makefile for DBD::mysql
-------------
(Continue reading)

Permalink | Reply | 3 comments |
headers
Jochen Wiedmann | 6 Sep 2002 07:55
Picon

Re: undefined symbol: mysql_real_escape_stromg

Zitiere Pat Traynor <pat <at> ssih.com>:

> undefined symbol: mysql_real_escape_string at

Possible reasons include:

  - You have an outdated version of MySQL.
  - You haven't installed the package mysql-devel.
  - You have compiled against a shared library,
    which cannot be found for some reason. Try to
    change the "libs" from
      -L/usr/local/lib/mysql/libmysqlclient.a
    to
      -L/usr/local/lib/mysql -lmysqlclient
    or
      -L/usr/local/lib/mysql -lmysqlclient.a
    or
      /usr/local/lib/mysql/libmysqlclient

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread1905 <at> 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 msql-mysql-modules-unsubscribe <at> lists.mysql.com instead.
Permalink | Reply | 2 comments |
headers
Pat Traynor | 6 Sep 2002 14:52

Re: undefined symbol: mysql_real_escape_stromg

On Fri, 6 Sep 2002, Jochen Wiedmann wrote:

> Zitiere Pat Traynor <pat <at> ssih.com>:
> 
> > undefined symbol: mysql_real_escape_string at
> 
> Possible reasons include:
> 
>   - You have an outdated version of MySQL.
>   - You haven't installed the package mysql-devel.
>   - You have compiled against a shared library,
>     which cannot be found for some reason. Try to
>     change the "libs" from
>       -L/usr/local/lib/mysql/libmysqlclient.a
>     to
>       -L/usr/local/lib/mysql -lmysqlclient
>     or
>       -L/usr/local/lib/mysql -lmysqlclient.a
>     or
>       /usr/local/lib/mysql/libmysqlclient

Thanks for the tips - I really appreciate them.  From that list, I've
narrowed the search down to mysql-devel not being installed.

Is there any way to do that without rpm?  Although I do have rpm on my
Slackware machine, it complained that it wasn't a recent enough version
to do the install.  When I tried to upgrade rpm to version 4, I got a
LONG list of failed dependencies.

--pat--
(Continue reading)

Permalink | Reply | 1 comment |
headers
Jochen Wiedmann | 6 Sep 2002 15:44
Picon

Re: undefined symbol: mysql_real_escape_stromg

Zitiere Pat Traynor <pat <at> ssih.com>:

> Thanks for the tips - I really appreciate them.  From that list, I've
> narrowed the search down to mysql-devel not being installed.
> 
> Is there any way to do that without rpm?  Although I do have rpm on my
> Slackware machine, it complained that it wasn't a recent enough version
> to do the install.  When I tried to upgrade rpm to version 4, I got a
> LONG list of failed dependencies.

Install the thing from the tar ball.

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread1907 <at> 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 msql-mysql-modules-unsubscribe <at> lists.mysql.com instead.
Permalink | Reply | 0 comments |
headers
Roman @ Melihhov | 6 Sep 2002 22:01
Favicon

Auto-increment problem

I have table defined as:

CREATE TABLE  messages (
	_rowid TIMESTAMP(14) NOT NULL,
	msg_mode enum('p','a') default NULL,
	acct INT(10) UNSIGNED NOT NULL DEFAULT 1,
	threadID INT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
	re_threadID INT(5) UNSIGNED DEFAULT NULL,
	k_0 TINYTEXT,
	k_1 TINYTEXT,
	k_2 TINYTEXT,
	k_3 TINYTEXT,
	k_4 TINYTEXT,
	k_5 TINYTEXT,
	k_6 TINYTEXT,
	k_7 TINYTEXT,
	k_8 TINYTEXT,
	k_9 TINYTEXT,
	comment_remote TINYTEXT,
	comment_author TINYTEXT,
	comment_headline TINYTEXT,
	comment_body TEXT,
	PRIMARY KEY (_rowid, acct, threadID)
) TYPE=MyISAM

$sth = $dbh ->prepare("INSERT INTO $m_table VALUES (NOW(), ... $ acct, 'mysql_insert_id()'

does not increment threadID value, it's just 1 (in every row added). What gives. Ideas appreciated.

Romaneth.
(Continue reading)

Permalink | Reply | 0 comments |
headers
Reine Delwall | 7 Sep 2002 22:09
Picon

test

testmail..
--

-- 
Reine Delwall <reine <at> tuba.nu>

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread1909 <at> 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 msql-mysql-modules-unsubscribe <at> lists.mysql.com instead.
Permalink | Reply | 0 comments |
headers
Reine Delwall | 7 Sep 2002 22:19
Picon

Help!

I am having problems with DBD:mysql.... getting this shit when i run
make test...

root <at> katarina:~/DBD-mysql-2.1018# make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0,
'blib/lib', 'blib/arch')" t/*.t
t/00base...........install_driver(mysql) failed: Can't load
'/root/DBD-mysql-2.1018/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
/root/DBD-mysql-2.1018/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol:
mysql_real_escape_string at /usr/local/lib/perl5/5.8.0/i686-linux/DynaLoader.pm line 229.
 at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at t/00base.t line 38
t/00base...........dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 4-5
        Failed 2/5 tests, 60.00% okay
t/10dsnlist........install_driver(mysql) failed: Can't load
'/root/DBD-mysql-2.1018/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
/root/DBD-mysql-2.1018/blib/arch/auto/DBD/mysql/mysql.so: undefined symbol:
mysql_real_escape_string at /usr/local/lib/perl5/5.8.0/i686-linux/DynaLoader.pm line 229.
 at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at t/10dsnlist.t line 45
t/10dsnlist........dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-3
        Failed 3/3 tests, 0.00% okay
(Continue reading)

Permalink | Reply | 0 comments |

Gmane