Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: hayesbro2 on May 14, 2004, 06:51:33 AM

Title: MySQL Connection Problems
Post by: hayesbro2 on May 14, 2004, 06:51:33 AM

Hi I just installed SME Server 6.0.1

I installed phpmyadmin 2.6.0-alpha 2 to manager my databases.  I am trying to install some CMS but when after trying several I get the error "could not connect to the database."  This is a fresh install of SME and I am having it connect to localhost using my admin username and pass.  Any ideas on what I need to do?  Thanks.

Title: MySQL Connection Problems
Post by: Boris on May 14, 2004, 08:29:09 AM

First of all alpha release is not for use and may not work.
Second, before you connect your application to mySQL you need to create database for it and account in mySQL with sufficient rights to that database for your application.
Should be some instructions with CMS you trying to install.

Title: MySQL Connection Problems
Post by: hayesbro2 on May 14, 2004, 09:28:56 PM

I have created the database and have also created a new mysql user.  Although in the CMS installation script it cannot connect to the database.  This is actually the 2nd time I've used the 6.0.1 distro (I've been trying several distros) and it worked fine the first time.  I'm not surre what I'm doing wrong or if I've forgotten something.  Any help would be appreciated.  Thanks!

Title: MySQL Connection Problems
Post by: ergozd on May 15, 2004, 07:38:01 PM

MySQL root password is LOOONG one and stored in

# /root/.my.cnf

Install Nightspirits phpmyadmin contrib
http://mirror.contribs.org/smeserver/contribs/nightspirit/e-smith-phpmyadmin/e-smith-phpmyadmin-2.5.6-3.noarch.rpm
 
and create another MySQL user with admin rights.

You can also run

Code: [Select]

/sbin/e-smith/config show mysqld
mysqld=service
    LocalNetworkingOnly=yes
    status=enabled


to see your mysql configuration

Title: MySQL Connection Problems
Post by: raem on May 19, 2004, 07:30:56 PM

What about this from the 6.0 release notes

The mysql database daemon is configured by default to accept only local connections (i.e. it is not accessible via the network).
This is a security precaution. We only use mysql for webmail preferences, and only require access from localhost.

If you wish to enable local network access, you can do so via:

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart

Title: Mysql php and apache
Post by: gallo_miguel on June 24, 2004, 06:34:46 PM

In this case, what can I do to have Mysql working, reciebing queries from apache/php from my primari site.

I have SME server 5.6

Thanks in advance.


Miguel Gallo

Title: port 3306 is closed
Post by: tenoca on June 25, 2004, 09:09:04 PM

I can't connect to mysql remotely, I did a port scan to my server and port 3306 is not open.  How can I open this port?  Are there any upgraded versions of server-manager that will allow me to control mysql?

Thanks

Title: MySQL Connection Problems
Post by: ergozd on June 25, 2004, 09:54:13 PM

Ray answered your question above

Quote

If you wish to enable local network access, you can do so via:

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart

Title: MySQL Connection Problems
Post by: alejandro on June 26, 2004, 12:49:17 AM

probably you need to restart mysqld to activate your changes

try "service mysqld restart" on your sme box prompt
after creating , giving permissions and so.

as additional info:
 Many mysql related db appliations are provided with some "file.sql" containing he whole instructions (automated) to create the database, tables, permissions, connections etc between "app" and mysql.
this file can be copied into sql section of "phpmyadmin"  to get everything done.
then restart de daemon (mysqld) and that's it.