-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Donald D Henson wrote:

Donald D Henson wrote:

...

I'm not a newbie on computers in general but I am a complete newbie on MySQL. I installed MySQL as part of the xampp install kit for Linux. Everything seemed to go well and the test routines seemed to be passing. I then assigned a (MySQL) root password and everything ground to a halt. I started getting the famous "Error 2002 (HY000)) which basically means nothing can connect. I'm looking for a kind person willing to assist in locating, fixing, and explaining the bug here, even if the bug is me. I've spent quite a bit of time trying a few things I found in Appendix B of the user manual to very little effect. Bottom line? I'm thoroughly confused and need assistance. If you are interested, contact me off-list at wepin@wepin.com. Thanks for your time.

Don Henson

Asking for contact off-list is a courtesy. I have no objections to doing this on-list if that is preferred.

Don Henson

You do not specify which version of openSuSE you are using. There all sorts of possibly interesting ways of shooting yourself in the foot with this bundle on openSuSE after glancing at what it installs. The SuSE versions of various packages tend to be tailored to the OS, and replacing core components like Apache, Perl, PHP and MySQL all at the same time is not something to take on lightly. This does seem to be an RPM based install, so SuSE maintenance utilities are probably not going to be aware of the changes you are applying to this system which is probably going to give a potential for a lot of grief at a future date. It may be more appropriate to check with XAMMP lists (if they exist) to find out what the issues of installing this on openSuSE are likely to be. - -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFIDelUasN0sSnLmgIRAsBrAKDdmsyvppzO9yR976m9gFY2ulSb0ACaAgrs XRIrn2YfRXIwztQ2IdZEEgU= =aRc8 -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

On Tue, Apr 22, 2008 at 3:06 PM, Donald D Henson wrote:

Thanks for the advice. I looked for xampp lists and couldn't find any. I'll have another look. I guess it's true, "Five minutes to do it right or five hours to do it over."

Why did you install xampp ? I installed mysql, apache, php alone using the package manager and all works fine. -- Kind Regards -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Donald D Henson wrote:

Gabriel wrote:

...

On Tue, Apr 22, 2008 at 3:06 PM, Donald D Henson wrote:

...

Thanks for the advice. I looked for xampp lists and couldn't find any. I'll have another look. I guess it's true, "Five minutes to do it right or five hours to do it over."

Why did you install xampp ? I installed mysql, apache, php alone using the package manager and all works fine.

I was thinking of installing Joomla (content management system). Their instructions implied that it would be much easier to install Joomla using xampp. xampp docs also said that xampp had been tested with OpenSUSE. I anticipated about a 30 min install. Ha! FWIW, I've decided to restore the original OpenSUSE installation.

Don Henson

I found Drupal (http://drupal.org) functioned without too much pain, (Midgard I would not bother with at moment, it is on the Build Service somwhere but I could never get it to work). - -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFID1MAasN0sSnLmgIRApzIAJ9RZOBTQ9c6HUb0S6EDxmEpN9+3mACg1OTf GG71nlub3QO3rtM4C8NHlV8= =Mvvy -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Donald D Henson wrote:

Gabriel wrote:

...

On Tue, Apr 22, 2008 at 3:06 PM, Donald D Henson wrote:

...

Thanks for the advice. I looked for xampp lists and couldn't find any. I'll have another look. I guess it's true, "Five minutes to do it right or five hours to do it over."

Why did you install xampp ? I installed mysql, apache, php alone using the package manager and all works fine.

I was thinking of installing Joomla (content management system). Their instructions implied that it would be much easier to install Joomla using xampp. xampp docs also said that xampp had been tested with OpenSUSE. I anticipated about a 30 min install. Ha! FWIW, I've decided to restore the original OpenSUSE installation.

I've installed joomla, and it went perfectly on a server with the standard, suse supplied lamp stack. No need to muddy the waters with some random tarball which was meant for OSes that don't already provide all those things. Joe -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Donald D Henson wrote:

G T Smith wrote: Donald D Henson wrote:

...

...

...

Donald D Henson wrote:

...

I'm not a newbie on computers in general but I am a complete newbie on MySQL. I installed MySQL as part of the xampp install kit for Linux. Everything seemed to go well and the test routines seemed to be passing. I then assigned a (MySQL) root password and everything ground to a halt. I started getting the famous "Error 2002 (HY000)) which basically means nothing can connect. I'm looking for a kind person willing to assist in locating, fixing, and explaining the bug here, even if the bug is me. I've spent quite a bit of time trying a few things I found in Appendix B of the user manual to very little effect. Bottom line? I'm thoroughly confused and need assistance. If you are interested, contact me off-list at wepin@wepin.com. Thanks for your time.

Don, Just a guess, but after assigning the root password, can you access mysql from a konsole window (command line) using: mysql -u root -p After hitting return you will be prompted for the password. The mysql root password is not/does not have to be the linux box root password. If you can access mysql giving the root password, my guess is that you will need to create a user for xampp to access mysql with (probably xampp). It will be in the xampp docs. Remember, http://dev.mysql.com/doc/refman/5.0/en/index.html is your friend. But a quick hack at setting up users is: see: http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html mysql -u root mysql> use mysql SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd'); SET PASSWORD FOR 'root'@'hostname' = PASSWORD('newpwd'); **SET PASSWORD FOR 'root'@'hostname.domain' = PASSWORD('newpwd'); SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('newpwd'); **optional hostname statements confirm: mysql> select host, user, password from user; setting up users: (note, the following sets up additional super users, adjust as required) GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'user'@'hostname' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; **GRANT ALL PRIVILEGES ON *.* TO 'user'@'hostname.domain' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'user'@'127.0.0.1' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; updating password for existing users mysql> UPDATE mysql.user SET Password = PASSWORD('newpwd') WHERE User = 'root'; mysql> FLUSH PRIVILEGES; mysql> exit To quit. To browse/edit mysql from a great gui in kde/gnome, install mysql-gui-tools it will help you with the mysql learning curve. mysql is really pretty easy once you make friends with the quirky syntax. -- David C. Rankin, J.D., P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

G T Smith wrote:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

David C. Rankin wrote:

...

Donald D Henson wrote:

...

G T Smith wrote: Donald D Henson wrote:

...

...

...

Donald D Henson wrote: > I'm not a newbie on computers in general but I am a complete > newbie on > MySQL. I installed MySQL as part of the xampp install kit for Linux. > Everything seemed to go well and the test routines seemed to be > passing. I then assigned a (MySQL) root password and everything > ground > to a halt. I started getting the famous "Error 2002 (HY000)) which > basically means nothing can connect. I'm looking for a kind person > willing to assist in locating, fixing, and explaining the bug here, > even if the bug is me. I've spent quite a bit of time trying a few > things I found in Appendix B of the user manual to very little > effect. > Bottom line? I'm thoroughly confused and need assistance. If you are > interested, contact me off-list at wepin@wepin.com. Thanks for > your time. Don,

Just a guess, but after assigning the root password, can you access mysql from a konsole window (command line) using:

mysql -u root -p

If this is not the case mysql has probably crashed (which would explain the 2002 error). In restarting MySQL a possible issue is that the SuSE mysql startup script is likely to have been replaced, I have in the (distant) past installed MySQL from MySQL sources on SuSE and the main problem at that time was that the standard MySQL startup script did not function correctly on SuSE, replacing it with the SuSE startup script solved that issue at that time.

However, I have never come across the situation where just setting the root mysql password has caused all connectivity to mysql to fail or mysql to crash, which rather suggests to me something rather more fundamental is broken. What I would try and do is keep the relevant XAMMP bits but replace those bits which SuSE does provide from the SuSE RPMs (with things like Perl,PHP and MySQL this should not cause too many problems, some of the more exotic bits may create issues).

Although the XAMMP stuff is placed under /opt one does not have any guarantee that other things may have been pranged in unpredictable ways as well. In this case you may even be inadvertently be attempting to run two instances of MySQL but without knowing what is installed where and how with this bundle one has little to work with.

- -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone.

Bjarne Stroustrup ==============================================================================

-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFIDxEiasN0sSnLmgIRAq6NAJ9A2i+/csFOQz4Tq+1pgVs0PoQOgACfWUlv 8JrkEGBUVsQouZ+l857whOc= =2+2j -----END PGP SIGNATURE-----

Thanks. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Wednesday 2008-04-23 at 01:18 -0500, David C. Rankin wrote:

To browse/edit mysql from a great gui in kde/gnome, install mysql-gui-tools it will help you with the mysql learning curve. mysql is really pretty easy once you make friends with the quirky syntax.

I like better rekall; not for configuration, but for usage. Very nice: the same interface regardless whether it is mysql or postgress. Just add plugins. - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) iD8DBQFID1DmtTMYHG2NR9URApu4AJ9Ssi9hyZLmgzOHkG9Ee4foShstNgCcCShH giDJUilK+hasiu7rbTe7aOE= =0KeH -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Wednesday 2008-04-23 at 11:53 -0400, Carl Hartung wrote:

Hi Carlos,

I see

rekall 2.4.5 (etc) at ~/distribution/10.3/repo/oss/suse

vs.

rekall 2.4.6 (etc.) at ~/repositories/KDE:/Backports/openSUSE_10.3

Which one are you recommending (*not* necessarily which one are you using!) :-)

I have rekall-2.4.5-68. I can not say about the newer version as I haven't tried it. - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) iD8DBQFIEFYutTMYHG2NR9URAsQcAJ96v1ApwhjjEyL/V8HS/cJL9mETsQCfWoEH OEcaK495QH2ItMaxv14GyP0= =Qmar -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Donald D Henson wrote:

Original Post:

I'm not a newbie on computers in general but I am a complete newbie on MySQL. I installed MySQL as part of the xampp install kit for Linux. Everything seemed to go well and the test routines seemed to be passing. I then assigned a (MySQL) root password and everything ground to a halt. I started getting the famous "Error 2002 (HY000)) which basically means nothing can connect. I'm looking for a kind person willing to assist in locating, fixing, and explaining the bug here, even if the bug is me. I've spent quite a bit of time trying a few things I found in Appendix B of the user manual to very little effect. Bottom line? I'm thoroughly confused and need assistance. If you are interested, contact me off-list at wepin@wepin.com. Thanks for your time.

Don Henson

Help:

Lot's of it. All appreciated.

Resolution:

The bottom line is that the server was not running. The main barrier to a solution was that every howto, tutorial, and help dialog that I consulted told me that the start command was:

service mysqld start

In OpenSuSE 10.3, however, the command is:

service mysql start (Note the absence of "d")

One small point - "service" is a redhat thing, and I won't comment on its utility, but IMHO the real handy way to start services on suse is with the good old "rc" scripts, which follow the old school unix convention of "rc" and are in the path, so you don't have to futz around with /etc/rc.d/init.d or whatever crazy place things may hide, and has the big that <TAB> is your friend. Typing "rcmysq would reveal immediately that it's "rcmysql" and not "rcmysqld" - Dunno if its useful to you or not, but I've found that using the rc scipts and tab completion rather than "/etc/rc.d/init.d/blah" or "service foo" saves me typing and guesswork. Joe -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org