Re: [SLE] I HAD IT WORKING! MySQL under SuSE 9.0 Woes

From: Lars Noren (lars.noren_at_mbox321.swipnet.se)
Date: 04/13/04

  • Next message: John Pettigrew: "[SLE] SuSE 8.2 (or 9.1) and Firewire/IEEE1394 for video"
    Date: Tue, 13 Apr 2004 11:22:01 +0200
    To: Mark Seven Smith <pampaluz@cox.net>
    
    

    Mark Seven Smith wrote:
    >
    > /.../
    >
    > it is NOT working! ALSO I can't get phpMyAdmin to work; I tried to install
    > it using YAST as someone said to do, but it didn't put anything into /usr/bin
    > that I could run. I don't understand how it works!

    Install phpMyAdmin via YaST, configure the file 'config.inc.php' in
    '/srv/www/htdocs/phpMyAdmin' (*) and run phpMyAdmin in a web browser:
    http://localhost/phpMyAdmin/index.php

    (*) These are my values in 'config.inc.php':
    $cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin/';
    $cfg['Servers'][$i]['auth_type'] = 'http';

    PhpMyAdmin requires php running which is an Apache-module, so you have
    to install Apache as well.

    Installing Apache or Apache2 via YaST should be easy, if everything
    works as it's supposed to. This is what I myself have installed when it
    comes to Apache2:
      apache2
      apache2-doc
      apache2-example-pages
      apache2-prefork
      libapr0

    This is what I have installed related to php:
      apache2-mod_php4
      mod_php4-core
      phpdoc
      phpMyAdmin

    Get Apache2 starting at boot via the Editor for runlevels in YaST
    Control Center.

    Good luck.

    /Lars

       I did what it says at
    > the page about phpMyAdmin, but it I get all sorts of errors about not being a
    > server, or something. And Apache? Forget it!
    >
    > Check this out; this is exactly the routine I have been trying to follow to
    > make this thing work. It did just fine the other day...I went through and
    > tried all the ideas that everyone had given me before:
    >
    > =============================================
    > markvii@linux:~> mysql -u pampaluz -p
    > Enter password:
    > ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/
    > mysql/mysql.sock' (2)
    > markvii@linux:~> su
    > Password:
    > linux:/home/markvii # mysqld --standalone
    > mysqld: ERROR: unknown variable 'innodb_data_home_dir=/var/lib/mysql/'
    > linux:/home/markvii # /etc/init.d/mysql start
    > Starting service MySQL
    > failed
    > linux:/home/markvii # /etc/init.d/mysql restart
    > Restarting service MySQL
    > Shutting down service mysql
    > done
    > Starting service MySQL
    > failed
    > linux:/home/markvii # rcmysql status
    > Checking for service MySQL:
    > unused
    > linux:/home/markvii # chkconfig -s mysql on
    > linux:/home/markvii # rcmysql status
    > Checking for service MySQL:
    > unused
    > linux:/home/markvii # /etc/init.d/mysql start
    > Starting service MySQL
    > failed
    > linux:/home/markvii # chkconfig -l mysql
    > mysql 0:off 1:off 2:on 3:on 4:off 5:on
    > 6:off
    > linux:/home/markvii #
    > =============================================
    >
    >
    > Please, I hope someone will know what to do. I mean, I had it working *once*,
    > then it stopped, and I had to remove EVERYTHING and start over; and then I
    > thought I had it made! It worked; up until yesterday when I was done, and I
    > did "shutdown -h now". Today I brought up the system (actually, just a
    > notebook computer, a Compaq Presario 906US), and MySQL won't work! It won't
    > start, just like before when I couldn't make it work, and had to re-install.
    > Does EVERYONE re-install, every time they want to use it? How do you make a
    > database in a single day and get all the use from it that you need in that
    > one day? This doesn't make sense!
    >
    >
    > Thanks in advance,
    >
    > --Mark VII (who is considering switching back to Debian--I had no graphics, no
    > X under Debian because I could not configure my notebook under it; but at
    > least I had a console, and I'll bet I could get MySQL to work there, with
    > "apt-get"!)
    >
    >

    -- 
    Check the headers for your unsubscription address
    For additional commands send e-mail to suse-linux-e-help@suse.com
    Also check the archives at http://lists.suse.com
    Please read the FAQs: suse-linux-e-faq@suse.com
    

  • Next message: John Pettigrew: "[SLE] SuSE 8.2 (or 9.1) and Firewire/IEEE1394 for video"

    Relevant Pages

    • Re: How to completely remove an application as well as the configuration files?
      ... I am trying to install apache2, php5, and my sql and ... apache2 and reinstall ... My problem is sudo apt-get remove apache2 then ... Now it seems that apache 2 is working with my configuration files as I ...
      (Ubuntu)
    • Apache on XP Pro SP2 - who blocks my port 80
      ... It's a different story from the laptop none of the two are available. ... I did disable all the firewall software (MCAffe that took over the ... I was planning to install the apache2 on the laptop to see if is ...
      (comp.security.misc)
    • Re: php5 and apache2? -- Resolved
      ... >> install binary packages, right? ... > Might also be a good idea to delete the php5 options file first too. ... there is not an option for using apache2. ...
      (freebsd-questions)
    • Re: Setting up a simple Web Server
      ... I have installed the apache2 package, ... I would like to set up a Virtual Server but don't know how... ... > I wold like to install a simple Web Server on my Ubuntu 6.06. ... I wold like to make a few pictures available to my family overseas. ...
      (Ubuntu)