Author Topic: mysql installation not recognized :-(  (Read 16665 times)

Offline holstenralle

  • Newbie
  • *
  • Posts: 8
mysql installation not recognized :-(
« on: April 01, 2012, 08:55:31 AM »
Hi Guys,

I´m just trying to install Roundcube.
I´ve installed mysql successful, created user with all priviliges, importted the initialize.sql and can see everything with webmin.

But the "Roundcube Webmail Installer" says "MySQL:  NOT AVAILABLE(Not installed)" ??

What can I do to make roundcube to understand that there is a working mysql-installation??

Thank you so much for your hints.


Best regards from Hamburg, Ralf

Offline oldschool

  • Sr. Member
  • ****
  • Posts: 406
Re: mysql installation not recognized :-(
« Reply #1 on: April 01, 2012, 11:22:26 AM »
If the sql-server is running it should be connectable at a defined port.
So, configure rc with the needed datas...


Rgds.

Offline holstenralle

  • Newbie
  • *
  • Posts: 8
Re: mysql installation not recognized :-(
« Reply #2 on: April 01, 2012, 11:37:55 AM »
Thanks for the reply.

But on the next page there is only SQLite selectable.
How can I configure RC for mysql?

Offline oldschool

  • Sr. Member
  • ****
  • Posts: 406
Re: mysql installation not recognized :-(
« Reply #3 on: April 01, 2012, 12:56:31 PM »
Do you really know what you are doing?

Standard mysql port is 3306.
This will be checked from the installer.

If you have a non standard installation you have to modify the rc config.


Rgds.

Offline holstenralle

  • Newbie
  • *
  • Posts: 8
Re: mysql installation not recognized :-(
« Reply #4 on: April 01, 2012, 01:57:37 PM »
Yes, I know what I´m doing  :)

It´s a standard mysql-installation on port 3306 and RC-installer obviously doesn´t recognize this.
So, what shall I configure??

Best regards, Ralf

Offline oldschool

  • Sr. Member
  • ****
  • Posts: 406
Re: mysql installation not recognized :-(
« Reply #5 on: April 01, 2012, 02:17:07 PM »
You don't really get!

Before anyone could give any hint some infos are needed!
I.e. running os, webserver...

So, you say the mysql server is running at 3306?
Take a look at the config files for rc, edit them and restart your webserver.

The installer is not needed to get a running rc webmail interface...



Rgds.


PS: Das kostet langsam 'ne Kiste Knollen.
:)
« Last Edit: April 01, 2012, 02:24:34 PM by oldschool »

Offline holstenralle

  • Newbie
  • *
  • Posts: 8
Re: mysql installation not recognized :-(
« Reply #6 on: April 01, 2012, 02:36:31 PM »
Sorry ...

Debian 5.0.10
Apache 2.29
mysql 5.0.51

Checking PHP version

Version:  OK(PHP 5.2.6-1+lenny16 detected)
Checking PHP extensions

The following modules/extensions are required to run Roundcube:

PCRE:  OK
DOM:  OK
Session:  OK
XML:  OK
JSON:  OK
The next couple of extensions are optional and recommended to get the best performance:

FileInfo:  NOT AVAILABLE(See http://www.php.net/manual/en/book.fileinfo.php)
Libiconv:  OK
Multibyte:  OK
OpenSSL:  OK
Mcrypt:  OK
Intl:  NOT AVAILABLE(See http://www.php.net/manual/en/book.intl.php)
Checking available databases

Check which of the supported extensions are installed. At least one of them is required.

MySQL:  NOT AVAILABLE(Not installed)
MySQLi:  NOT AVAILABLE(Not installed)
PostgreSQL:  NOT AVAILABLE(Not installed)
SQLite (v2):  OK
Check for required 3rd party libs

This also checks if the include path is set correctly.

PEAR:  OK
MDB2:  OK
Net_SMTP:  OK
Net_IDNA2:  OK
Mail_mime:  OK
Checking php.ini/.htaccess settings

The following settings are required to run Roundcube:

file_uploads:  OK
session.auto_start:  OK
zend.ze1_compatibility_mode:  OK
mbstring.func_overload:  OK
suhosin.session.encrypt:  OK
The following settings are optional and recommended:

date.timezone:  OK
 
Port 3306 is open from outside, apache restarted ...   So, maybe you can give me an advise which configuration file is to prepare ..
Can I skip the installer-routine??

Die Knollen gibts bei Erfolg  ;) ;) ;)

Offline oldschool

  • Sr. Member
  • ****
  • Posts: 406
Re: mysql installation not recognized :-(
« Reply #7 on: April 01, 2012, 03:20:47 PM »
Hmmkay, the answer is in your posted datas.

Take off the sunglasses, search for "mysql" in your post and read...
:)


Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,879
    • SKaero - Custom Roundcube development
Re: mysql installation not recognized :-(
« Reply #8 on: April 01, 2012, 04:40:19 PM »
Do you have the php5-mysql package?

Offline oldschool

  • Sr. Member
  • ****
  • Posts: 406
Re: mysql installation not recognized :-(
« Reply #9 on: April 01, 2012, 04:52:16 PM »
Do you have the php5-mysql package?

Hey, there is NO learning effect.
Thanks!

Offline holstenralle

  • Newbie
  • *
  • Posts: 8
Re: mysql installation not recognized :-(
« Reply #10 on: April 02, 2012, 05:01:18 AM »
OK, thats right, it was missing ...
Thanky you very much!


Does any documentation exist about what to add:


"MySQL:  NOT AVAILABLE(Could be loaded. Please add in php.ini)"

----

[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
mysql.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
mysql.max_links = -1

; Default port number for mysql_connect().  If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
mysql.default_port =

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =

; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
mysql.default_password =

; Maximum time (in seconds) for connect timeout. -1 means no limit
mysql.connect_timeout = 60

; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
; SQL-Errors will be displayed.
mysql.trace_mode = Off
---

Offline oldschool

  • Sr. Member
  • ****
  • Posts: 406
Re: mysql installation not recognized :-(
« Reply #11 on: April 02, 2012, 10:31:43 AM »
@holstenralle
Check mal deine PMs.


Offline holstenralle

  • Newbie
  • *
  • Posts: 8
Re: mysql installation not recognized :-(
« Reply #12 on: April 05, 2012, 12:37:26 PM »
reboot tut gut, Danke für die Hilfe

Offline oldschool

  • Sr. Member
  • ****
  • Posts: 406
Re: mysql installation not recognized :-(
« Reply #13 on: April 05, 2012, 04:01:34 PM »
No prob.
 ;D