Announcement

Collapse
No announcement yet.

Can't choose Database Name in PROD environment

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • nnara530
    replied
    I looked into MySqli also and it is supported in my current local environment. See the attached image from php_info(). I have installed php and mysql using XAMPP.

    mysqlisupport.jpg

    Leave a comment:


  • nnara530
    replied
    I am attaching the image for more clarity

    errorduringconnection.jpg

    Leave a comment:


  • nnara530
    replied
    I am attaching the image for more clarity

    errorduringconnection.jpg

    Leave a comment:


  • nnara530
    replied
    Hi John L.Santos

    Has this been solved yet? I am running PHP Version 5.5.3 and I am having the same issue. It is not listing any databases. This is going to be serious issue. Can this be resolved ASAP?

    Or at least let us know where to go and edit the configuration file?

    Regards
    Narayanan

    Leave a comment:


  • onmountain
    replied
    Just confirming, this error happens on version 7.01.0014 using PHP5.5. I was able to simply do my deployment into a PHP5.4 environment and it worked normally.
    Peace,
    Jamie

    Leave a comment:


  • onmountain
    replied
    Hi everyone,
    I too have experienced the exact same condition. I am unable to pulldown the database name in the production environment setup. I can click test and it comes out OK, but get the deprecation message at some point.

    I am also using PHP 5.5 , and I will test it again using a PHP 5.4 setup.

    Just including this info to maintain a complete record of the error.
    Peace,
    Jamie

    Leave a comment:


  • John L. Santos
    replied
    Originally posted by Igors View Post
    Indeed my PROD environment is built on PHP 5.5.3.

    Should I try use the same PHP version as in DEV env?
    Hello Mr. Igor,

    This problem occurs because the version of PHP 5.5 and not the version of MySQL
    This is just a warning message, but I do not know why Scriptcase is not listing databases.
    We are checking this problem.


    It is recommended to use either the mysqli or PDO_MySQL extensions. It is not recommended to use the old mysql extension for new development, as it has been deprecated as of PHP 5.5.0 and will be removed in the future.
    You can use PHP version 5.4 without problems.

    Leave a comment:


  • Igors
    replied
    Indeed my PROD environment is built on PHP 5.5.3.

    Should I try use the same PHP version as in DEV env?

    Leave a comment:


  • John L. Santos
    replied
    Hello,

    This problem occurs because the version of PHP 5.5 and not the version of MySQL
    We are checking this problem.

    Leave a comment:


  • Igors
    replied
    Where to find the configuration file for putting manually DB Host, Name, Password for PROD to work?

    Leave a comment:


  • antonio.alcantara
    replied
    More information...
    (using last SC update)


    Writing on Server/Host (Name or IP) and port the rigth info
    leaving empty Username and Password
    and doing Test Connection (with all of the DBMS Type: MYSQL transaction, MYSQL and MYSQL PDO)
    the result is 'Connection Success'.

    Connection to MYSQL database server without user and password isn't really possible. (I've tried it specifically on my server where I've seen the SC action described and it isn't possible.)
    Last edited by antonio.alcantara; 01-02-2014, 05:53 PM.

    Leave a comment:


  • aducom
    replied
    Mmmm, that's beyond me. But MySql PDO is supported. I'm running mysql 5.1.x so I can't look into it. I advise to post a message to SC. I'll attend them on this thread.

    Leave a comment:


  • antonio.alcantara
    replied
    Same problem with
    linux ubuntu 13.10
    PHP 5.5.3-1
    mysql-server 5.5.34-0
    in development a production environment.
    SC last update

    App in development environment runs ok but ...

    After deployment of the application to the production environment (and done chmod 777 _lib -R).

    On 'Test connection' the message 'Connection Success' y shown.

    The next error appears at the moment of 'Database name'clic:
    "Connection error mysql_connect() : the mysql extension is deprecated and will be removed in the future : use mysqli or PDO instead"

    After a clic on 'Test connection' the message dissapears and connection seems to be ok but no connection has been done and no databases are shown. Only if the procces is done form the beginig is possible to see the error message again.

    (Database paramenters are ok and phpmyadmin gives access to the database winth same parametres).

    ----------------------------------

    More info:

    Link to a comment about the php problem "Connection error mysql_connect() : the mysql extension is deprecated and will be removed in the future : use mysqli or PDO instead"

    The way to solve is not possible for SC users: the php code is inside SC.

    http://www.bestwebframeworks.com/tut...future-of-php/

    ABSTRACT:
    "...

    Why was mysql deprecated in PHP 5.5?

    Johannes Schl├╝ter, one of the PHP developers listed missing points like these:

    Stored Procedures
    Prepared Statements
    (SSL-)Encryption
    Compression
    Full charset support


    How to solve the warnings?

    Currently mostly many MySQL connections in PHP use this construct:
    php:
    <?php
    $link = mysql_connect('localhost', 'user', 'password');
    mysql_select_db('dbname', $link);

    The way with MySQLi would be like this:
    php:
    <?php
    $link = mysqli_connect('localhost', 'user', 'password', 'dbname');

    To run database queries is also simple and nearly identical with the old way:
    php:
    <?php
    // Old
    mysql_query('CREATE TEMPORARY TABLE `table`', $link);
    // New
    mysqli_query($link, 'CREATE TEMPORARY TABLE `table`');

    Alternative solutions

    Besides the shown possibility there's are also solutions like using MySQLi in object oriented style or even switch to PHPs PDO (PHP Data Objects) like shown in this PDO Tutorial for MySQL Developers.

    Filthy and fastest solution

    Suppress all deprecated warnings including them from mysql_*:
    php:
    <?php
    error_reporting(E_ALL ^ E_DEPRECATED);

    ..."
    Last edited by antonio.alcantara; 01-02-2014, 04:34 PM.

    Leave a comment:


  • aducom
    replied
    It looks like your DB in production is not accessible somehow. It looks like a config problem. Can you access your db from phpMyAdmin?

    Leave a comment:


  • Igors
    replied
    Thank you for fast reply.

    DB is on the other server and is fully operating.

    In SC under Database->Edit Connection I can choose my DB connection and there is "List Database" button near Database Name Dropdown box.
    I can see all Databases.

    Leave a comment:

Working...
X