[TYPO3-english] cannot connect to database
Alan Campion
alancampion at tiscali.co.uk
Mon Dec 9 18:36:10 CET 2013
Hello Pierre,
As well as advice already given, take a look at your file
/etc/my.cnf. I believe the file is in the same place in Ubuntu as in
openSuSE.
I am a typo3 newbie and had a similar problem with different versions
between my laptop and Desktop machines. I discovered the typo3 core bug
#41596, and found that between the (rpm) package mariaDB
5.5.33-1.16.1.i586 (laptop) and mariaDB 5.5.33-7.2.i586, the usual
openSuSE updates had added the following line to my /etc/my.cnf file.
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
This breaks typo3, and maybe the same has happened in Ubuntu. Setting
this to sql_mode = "" , appeared to fix the problem. Hope this may also
be of help. A little more detail on this, and another issue, I've
encountered can be found under my recent email "Observations of a Typo3
newbie" (13/12/2013).
Regards
Alan
On 09/12/13 11:00, typo3-english-request at lists.typo3.org wrote:
> Send TYPO3-english mailing list submissions to
> typo3-english at lists.typo3.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
> or, via email, send a message with subject or body 'help' to
> typo3-english-request at lists.typo3.org
>
> You can reach the person managing the list at
> typo3-english-owner at lists.typo3.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of TYPO3-english digest..."
>
>
> Today's Topics:
>
> 1. Typo3 6.1.6 Could not connect to SQL database! (Mysql)
> (Pierre Lamoureux)
> 2. Re: Typo3 6.1.6 Could not connect to SQL database! (Mysql)
> (Markus Klein)
> 3. Re: Typo3 6.1.6 Could not connect to SQL database! (Mysql)
> (Dr. Christian A. Caroli (Domain-Verwaltung))
> 4. Re: Typo3 6.1.6 Could not connect to SQL database! (Mysql)
> (Philipp Gampe)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sun, 8 Dec 2013 22:34:00 -0500
> From: Pierre Lamoureux <plamoureux at sympatico.ca>
> Subject: [TYPO3-english] Typo3 6.1.6 Could not connect to SQL
> database! (Mysql)
> To: <typo3-english at lists.typo3.org>
> Message-ID: <mailman.984.1386560087.629.typo3-english at lists.typo3.org>
> Content-Type: text/plain; charset="UTF-8"
>
> Hi,
>
>
>
> I have install on the same server (Ubuntu 12.04) introduction package 4.5.31
> and introduction package 6.1.6. I am able to connect to mysql with 4.5.31
> package. But the 6.1.6 package resist all attempt. I am using the same mysql
> credential in for both package. They are side by side on the same
> everything, and everything is fully writable by web server. After reading
> all I have found on the subject, I understand that a lot of causes can
> produce this behavior, I have try all I have found up to now. Somebody have
> course of try to propose??
>
>
>
> Env. is Apache 2.2.22, PHP 5.4.21, MySql 5.5.34, Zend Server 6.2, Ubuntu
> 12.04 server.
>
>
>
> Pierre Lamoureux
>
>
>
>
>
> Debug information follow:
>
>
>
> TYPO3_SITE_SCRIPT : typo3/install/index.php?TYPO3_INSTALL[type]=phpinfo
>
> TYPO3_SSL :
>
> TYPO3_REV_PROXY :
>
> SCRIPT_NAME : /i616/typo3/install/index.php
>
> TYPO3_DOCUMENT_ROOT : /var/www
>
> SCRIPT_FILENAME : /var/www/i616/typo3/install/index.php
>
> REMOTE_ADDR : 192.168.2.13
>
> REMOTE_HOST :
>
> HTTP_USER_AGENT : Mozilla/5.0 (Windows NT 6.1; WOW64; rv:25.0)
> Gecko/20100101 Firefox/25.0
>
> HTTP_ACCEPT_LANGUAGE: fr,fr-fr;q=0.8,en-us;q=0.5,en;q=0.3
>
> CONST: PHP_OS : Linux
>
> CONST: TYPO3_OS :
>
> CONST: PATH_thisScri: /var/www/i616/typo3/install/index.php
>
> CONST: php_sapi_name: apache2handler
>
> OTHER: TYPO3_VERSION: 6.1.6
>
> OTHER: PHP_VERSION : 5.4.21
>
> imagecreatefromgif(): 1
>
> imagecreatefrompng(): 1
>
> imagecreatefromjpeg(: 1
>
> imagegif() : 1
>
> imagepng() : 1
>
> imagejpeg() : 1
>
> imagettftext() : 1
>
> OTHER: IMAGE_TYPES : 15
>
> SERVER: SERVER_PORT : 80
>
> SERVER: SERVER_SOFTW: Apache/2.2.22 (Ubuntu)
>
> SERVER: GATEWAY_INTE: CGI/1.1
>
> SERVER: SCRIPT_NAME : /i616/typo3/install/index.php
>
> SERVER: PATH_TRANSLA:
>
> T3CV_GFX: image_proc: 1
>
> T3CV_GFX: gdlib : 1
>
> T3CV_GFX: gdlib_png : 1
>
> T3CV_GFX: im : 1
>
> T3CV_GFX: im_path : /usr/bin/
>
> T3CV_GFX: im_path_lz: /usr/bin/
>
> T3CV_GFX: im_version: gm
>
> T3CV_GFX: im_negate_: 0
>
> T3CV_GFX: im_imvMask: 0
>
> T3CV_GFX: im_combine: combine
>
> ### DEBUG SYSTEM INFORMATION - END ###
>
>
>
>
>
>
>
>
>
> ---
> Ce courrier ?lectronique ne contient aucun virus ou logiciel malveillant parce que la protection avast! Antivirus est active.
> http://www.avast.com
>
>
> ------------------------------
>
> Message: 2
> Date: Mon, 9 Dec 2013 10:24:47 +0100
> From: "Markus Klein" <klein.t3 at mfc-linz.at>
> Subject: Re: [TYPO3-english] Typo3 6.1.6 Could not connect to SQL
> database! (Mysql)
> To: "'TYPO3 English'" <typo3-english at lists.typo3.org>
> Message-ID:
> <mailman.1004.1386581087.629.typo3-english at lists.typo3.org>
> Content-Type: text/plain; charset="UTF-8"
>
> Hi!
>
> The main difference here is that 4.5 uses mysql, whereas 6.1 uses mysqli.
> So can you please check your apache error log for error messages?
>
> Kind regards
> Markus
>
> ------------------------------------------------------------
> Markus Klein
> TYPO3 CMS Active Contributors Team Member
>
>> -----Original Message-----
>> From: typo3-english-bounces at lists.typo3.org [mailto:typo3-english-
>> bounces at lists.typo3.org] On Behalf Of Pierre Lamoureux
>> Sent: Monday, December 09, 2013 4:34 AM
>> To: typo3-english at lists.typo3.org
>> Subject: [TYPO3-english] Typo3 6.1.6 Could not connect to SQL database!
>> (Mysql)
>>
>> Hi,
>>
>>
>>
>> I have install on the same server (Ubuntu 12.04) introduction package 4.5.31
>> and introduction package 6.1.6. I am able to connect to mysql with 4.5.31
>> package. But the 6.1.6 package resist all attempt. I am using the same mysql
>> credential in for both package. They are side by side on the same everything,
>> and everything is fully writable by web server. After reading all I have found
>> on the subject, I understand that a lot of causes can produce this behavior, I
>> have try all I have found up to now. Somebody have course of try to
>> propose??
>>
>>
>>
>> Env. is Apache 2.2.22, PHP 5.4.21, MySql 5.5.34, Zend Server 6.2, Ubuntu
>> 12.04 server.
>>
>>
>>
>> Pierre Lamoureux
>>
>>
>>
>>
>>
>> Debug information follow:
>>
>>
>>
>> TYPO3_SITE_SCRIPT :
>> typo3/install/index.php?TYPO3_INSTALL[type]=phpinfo
>>
>> TYPO3_SSL :
>>
>> TYPO3_REV_PROXY :
>>
>> SCRIPT_NAME : /i616/typo3/install/index.php
>>
>> TYPO3_DOCUMENT_ROOT : /var/www
>>
>> SCRIPT_FILENAME : /var/www/i616/typo3/install/index.php
>>
>> REMOTE_ADDR : 192.168.2.13
>>
>> REMOTE_HOST :
>>
>> HTTP_USER_AGENT : Mozilla/5.0 (Windows NT 6.1; WOW64; rv:25.0)
>> Gecko/20100101 Firefox/25.0
>>
>> HTTP_ACCEPT_LANGUAGE: fr,fr-fr;q=0.8,en-us;q=0.5,en;q=0.3
>>
>> CONST: PHP_OS : Linux
>>
>> CONST: TYPO3_OS :
>>
>> CONST: PATH_thisScri: /var/www/i616/typo3/install/index.php
>>
>> CONST: php_sapi_name: apache2handler
>>
>> OTHER: TYPO3_VERSION: 6.1.6
>>
>> OTHER: PHP_VERSION : 5.4.21
>>
>> imagecreatefromgif(): 1
>>
>> imagecreatefrompng(): 1
>>
>> imagecreatefromjpeg(: 1
>>
>> imagegif() : 1
>>
>> imagepng() : 1
>>
>> imagejpeg() : 1
>>
>> imagettftext() : 1
>>
>> OTHER: IMAGE_TYPES : 15
>>
>> SERVER: SERVER_PORT : 80
>>
>> SERVER: SERVER_SOFTW: Apache/2.2.22 (Ubuntu)
>>
>> SERVER: GATEWAY_INTE: CGI/1.1
>>
>> SERVER: SCRIPT_NAME : /i616/typo3/install/index.php
>>
>> SERVER: PATH_TRANSLA:
>>
>> T3CV_GFX: image_proc: 1
>>
>> T3CV_GFX: gdlib : 1
>>
>> T3CV_GFX: gdlib_png : 1
>>
>> T3CV_GFX: im : 1
>>
>> T3CV_GFX: im_path : /usr/bin/
>>
>> T3CV_GFX: im_path_lz: /usr/bin/
>>
>> T3CV_GFX: im_version: gm
>>
>> T3CV_GFX: im_negate_: 0
>>
>> T3CV_GFX: im_imvMask: 0
>>
>> T3CV_GFX: im_combine: combine
>>
>> ### DEBUG SYSTEM INFORMATION - END ###
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> ---
>> Ce courrier ?lectronique ne contient aucun virus ou logiciel malveillant parce
>> que la protection avast! Antivirus est active.
>> http://www.avast.com
>> _______________________________________________
>> TYPO3-english mailing list
>> TYPO3-english at lists.typo3.org
>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
>
>
> ------------------------------
>
> Message: 3
> Date: Mon, 9 Dec 2013 10:44:13 +0100
> From: "Dr. Christian A. Caroli \(Domain-Verwaltung\)"
> <Domain-Verwaltung at Ancient-History.yourweb.de>
> Subject: Re: [TYPO3-english] Typo3 6.1.6 Could not connect to SQL
> database! (Mysql)
> To: "'TYPO3 English'" <typo3-english at lists.typo3.org>
> Message-ID:
> <mailman.1020.1386582255.629.typo3-english at lists.typo3.org>
> Content-Type: text/plain; charset="utf-8"
>
> Try to deactivate the extension "dbal" manually from the configuration file. That is my problem since Typo3 v4.7
> This extension does not work with many servers
>
>
>
> -----Original Message-----
> From: typo3-english-bounces at lists.typo3.org [mailto:typo3-english-bounces at lists.typo3.org] On Behalf Of Pierre Lamoureux
> Sent: Monday, December 09, 2013 4:34 AM
> To: typo3-english at lists.typo3.org
> Subject: [TYPO3-english] Typo3 6.1.6 Could not connect to SQL database! (Mysql)
>
> Hi,
>
>
>
> I have install on the same server (Ubuntu 12.04) introduction package 4.5.31 and introduction package 6.1.6. I am able to connect to mysql with 4.5.31 package. But the 6.1.6 package resist all attempt. I am using the same mysql credential in for both package. They are side by side on the same everything, and everything is fully writable by web server. After reading all I have found on the subject, I understand that a lot of causes can produce this behavior, I have try all I have found up to now. Somebody have course of try to propose??
>
>
>
> Env. is Apache 2.2.22, PHP 5.4.21, MySql 5.5.34, Zend Server 6.2, Ubuntu
> 12.04 server.
>
>
>
> Pierre Lamoureux
>
>
>
>
>
> Debug information follow:
>
>
>
> TYPO3_SITE_SCRIPT : typo3/install/index.php?TYPO3_INSTALL[type]=phpinfo
>
> TYPO3_SSL :
>
> TYPO3_REV_PROXY :
>
> SCRIPT_NAME : /i616/typo3/install/index.php
>
> TYPO3_DOCUMENT_ROOT : /var/www
>
> SCRIPT_FILENAME : /var/www/i616/typo3/install/index.php
>
> REMOTE_ADDR : 192.168.2.13
>
> REMOTE_HOST :
>
> HTTP_USER_AGENT : Mozilla/5.0 (Windows NT 6.1; WOW64; rv:25.0)
> Gecko/20100101 Firefox/25.0
>
> HTTP_ACCEPT_LANGUAGE: fr,fr-fr;q=0.8,en-us;q=0.5,en;q=0.3
>
> CONST: PHP_OS : Linux
>
> CONST: TYPO3_OS :
>
> CONST: PATH_thisScri: /var/www/i616/typo3/install/index.php
>
> CONST: php_sapi_name: apache2handler
>
> OTHER: TYPO3_VERSION: 6.1.6
>
> OTHER: PHP_VERSION : 5.4.21
>
> imagecreatefromgif(): 1
>
> imagecreatefrompng(): 1
>
> imagecreatefromjpeg(: 1
>
> imagegif() : 1
>
> imagepng() : 1
>
> imagejpeg() : 1
>
> imagettftext() : 1
>
> OTHER: IMAGE_TYPES : 15
>
> SERVER: SERVER_PORT : 80
>
> SERVER: SERVER_SOFTW: Apache/2.2.22 (Ubuntu)
>
> SERVER: GATEWAY_INTE: CGI/1.1
>
> SERVER: SCRIPT_NAME : /i616/typo3/install/index.php
>
> SERVER: PATH_TRANSLA:
>
> T3CV_GFX: image_proc: 1
>
> T3CV_GFX: gdlib : 1
>
> T3CV_GFX: gdlib_png : 1
>
> T3CV_GFX: im : 1
>
> T3CV_GFX: im_path : /usr/bin/
>
> T3CV_GFX: im_path_lz: /usr/bin/
>
> T3CV_GFX: im_version: gm
>
> T3CV_GFX: im_negate_: 0
>
> T3CV_GFX: im_imvMask: 0
>
> T3CV_GFX: im_combine: combine
>
> ### DEBUG SYSTEM INFORMATION - END ###
>
>
>
>
>
>
>
>
>
> ---
> Ce courrier ?lectronique ne contient aucun virus ou logiciel malveillant parce que la protection avast! Antivirus est active.
> http://www.avast.com
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
>
>
>
> ------------------------------
>
> Message: 4
> Date: Mon, 09 Dec 2013 10:48:03 +0100
> From: Philipp Gampe <philipp.gampe at typo3.org>
> Subject: Re: [TYPO3-english] Typo3 6.1.6 Could not connect to SQL
> database! (Mysql)
> To: typo3-english at lists.typo3.org
> Message-ID: <mailman.1.1386582483.25205.typo3-english at lists.typo3.org>
> Content-Type: text/plain; charset="UTF-8"
>
> Hi Pierre,
>
> Pierre Lamoureux wrote:
>
>> I have install on the same server (Ubuntu 12.04) introduction package
>> 4.5.31 and introduction package 6.1.6. I am able to connect to mysql
>> with 4.5.31 package. But the 6.1.6 package resist all attempt. I am using
>> the same mysql credential in for both package. They are side by side on
>> the same everything, and everything is fully writable by web server
> Do you use 127.0.0.1 or localhost as server address? If the DB server is on
> the same server, then please try both variants.
>
> Best regards
More information about the TYPO3-english
mailing list