Welcome Guest. Please Login or Register  


You are here: Index > Softaculous Auto Installer > Bugs > Topic : no MySQL databases are being created

1


Threaded Mode | Print  

 no MySQL databases are being created (36 Replies, Read 22093 times)
SoftDux
Group: NOC
Post Group: Working Member
Posts: 113
Status:
Hi,

This looks like a very promising script,and I have installed it on 3 servers so far, but I can't get it to work properly.

When I login as the root user (who happens to have a live website & account), I can't install any scripts, cause the MySQL Databases never get created. From the email that I receive, it seems like the database should be created, but when I visit the installed script, I get MySQL connection errors. And I can confirm in the cPanel that the relevant MySQL database(s) doesn't exist, nor the MySQL users. How do I fix this?
IP: --   

no MySQL databases are being created
vT16
Group: Member
Post Group: Newbie
Posts: 42
Status:
We have exactly the same problem at our current installation of Softaculous. The database is being created, but the tables are not being filled. The result, a general error occurs.
IP: --   

no MySQL databases are being created
Mmarzex
Group: Member
Post Group: Newbie
Posts: 2
Status:
Have the same error It creates the database but doesn't create the tables.
IP: --   

no MySQL databases are being created
groefie
Group: Member
Post Group: Newbie
Posts: 5
Status:
Same problem here on Centos5 64bit with DirectAdmin-controlpanel. Databases are created well but are empty  :neu: .

Also the index.raw-files don't have read nor write or execute permissions after installation on our box. I had to chmod them before I could access softaculous in the controlpanel .
IP: --   

no MySQL databases are being created
Mmarzex
Group: Member
Post Group: Newbie
Posts: 2
Status:
Seems to just be a problem with direct admin.
IP: --   

no MySQL databases are being created
vT16
Group: Member
Post Group: Newbie
Posts: 42
Status:
My feeling is that it is actually the php config.
In the generic php.ini is at disable_functions probably shell_exec. Softaculous uses before 2.0 this command to import the tables in the database. This is causing the issue.

Either you can remove shell_exec from the disallowed functions or wait until 2.0 (which Alons has stated that will use a different method of importing).
IP: --   

no MySQL databases are being created
alons
Group: Administrator
Post Group: Super Member
Posts: 2280
Status:
shell_exec is used by many software.
Its the way of PHP commnicating with the OS in many ways.
Most of the servers have shell_exec working.
When we got our servers shell_exec was not disabled but was working just fine.

Anyways we are working on a new method of importing MySQL DBs. We hope and plan to implement it by 2.0

Regards,
Alons

-----------------------
For immediate support please email us at our Support email address. PMs sent to any Softaculous Team member or posting in the forums is not the official way to get support.

Virtualizor - The Next Generation VPS Panel
Webuzo - It is Softaculous Standalone for Enterprises, SMB, Developers. Deploy it on Dedicated Servers, VPS, Virtual Appliances or the Cloud
Pinguzo - Server and Domain Monitoring tool
PopularFX - Marketplace of WordPress, Drupal, Joomla, Bootstrap themes
Remote Installer - Use Softaculous over FTP/FTPS/SFTP
IP: --   

no MySQL databases are being created
Boboga
Group: Member
Post Group: Newbie
Posts: 9
Status:
Quote From : alons July 18, 2009, 3:16 pm
shell_exec is used by many software.
Its the way of PHP commnicating with the OS in many ways.
Most of the servers have shell_exec working.
When we got our servers shell_exec was not disabled but was working just fine.

Anyways we are working on a new method of importing MySQL DBs. We hope and plan to implement it by 2.0

Regards,
Alons


We run into the same issue on DA, any idea when we can expect 2.0? Also we've got the error about universal.php which could not be found.
IP: --   

no MySQL databases are being created
alons
Group: Administrator
Post Group: Super Member
Posts: 2280
Status:
Boboga are you facing a problem of CREATION of MySQL Database or Import of MySQL databases i.e. are Mysql databases being created without any data ?

-----------------------
For immediate support please email us at our Support email address. PMs sent to any Softaculous Team member or posting in the forums is not the official way to get support.

Virtualizor - The Next Generation VPS Panel
Webuzo - It is Softaculous Standalone for Enterprises, SMB, Developers. Deploy it on Dedicated Servers, VPS, Virtual Appliances or the Cloud
Pinguzo - Server and Domain Monitoring tool
PopularFX - Marketplace of WordPress, Drupal, Joomla, Bootstrap themes
Remote Installer - Use Softaculous over FTP/FTPS/SFTP
IP: --   

no MySQL databases are being created
Boboga
Group: Member
Post Group: Newbie
Posts: 9
Status:
The creation is working, but the database stays empty.

Also i've got this error when saving settings from the admin page:
The following Errors were found :
  • Could not locate universal.php at the path you specified.
IP: --   

no MySQL databases are being created
Husky
Group: Member
Post Group: Newbie
Posts: 4
Status:
I have the same problem with Softaculous not populating the databases. It's the latest DirectAdmin, installed 3 days ago, Softaculous installed few hours ago.Database is created, but it's empty. I've tested few scripts, and only WordPress is working, as it installed itself after the automatic pre-installation by Softaculous. Everything else just shows the same error - can not read from (or in some cases, write to) tables.
IP: --   

no MySQL databases are being created
SoftDux
Group: NOC
Post Group: Working Member
Posts: 113
Status:
Hi Alson,

Is there any way that we can get users to use Softaculous at the moment? Or, do you have an ETA on when the new release will be available?

On the other hand, do you need  help with anything?
IP: --   

no MySQL databases are being created
alons
Group: Administrator
Post Group: Super Member
Posts: 2280
Status:
The simplest way to get softaculous working is having shell_exec() in PHP work.
And there is a real good news.
We have the alternative to Shell exec import of Database which works on PHP and MySQL alone and we are soon to release 1.8 before the end of this month.

Regards,
Alons

-----------------------
For immediate support please email us at our Support email address. PMs sent to any Softaculous Team member or posting in the forums is not the official way to get support.

Virtualizor - The Next Generation VPS Panel
Webuzo - It is Softaculous Standalone for Enterprises, SMB, Developers. Deploy it on Dedicated Servers, VPS, Virtual Appliances or the Cloud
Pinguzo - Server and Domain Monitoring tool
PopularFX - Marketplace of WordPress, Drupal, Joomla, Bootstrap themes
Remote Installer - Use Softaculous over FTP/FTPS/SFTP
IP: --   

no MySQL databases are being created
Husky
Group: Member
Post Group: Newbie
Posts: 4
Status:
The thing is, I haven't disabled exec nor shell_exec. I looked in both php.ini files (Zend at /usr/local/Zend/etc/ and, to be absolutely sure, the standard php.ini at /usr/local/lib/). Both these files are the same, and in both these functions aren't disabled. Yet the databases aren't populated with tables and data by the Softaculous.For a moment I thought it might be the suhosin extension plugin that is blocking the process, but no - after I've disabled it (and yes, I've completely disabled suhosin and restarted Apache, even checked phpinfo to make sure it's not running) the Softaculous still couldn't paste the data into the database.
IP: --   

no MySQL databases are being created
alons
Group: Administrator
Post Group: Super Member
Posts: 2280
Status:
Quote From : Husky July 23, 2009, 2:24 pm
The thing is, I haven't disabled exec nor shell_exec. I looked in both php.ini files (Zend at /usr/local/Zend/etc/ and, to be absolutely sure, the standard php.ini at /usr/local/lib/). Both these files are the same, and in both these functions aren't disabled. Yet the databases aren't populated with tables and data by the Softaculous.For a moment I thought it might be the suhosin extension plugin that is blocking the process, but no - after I've disabled it (and yes, I've completely disabled suhosin and restarted Apache, even checked phpinfo to make sure it's not running) the Softaculous still couldn't paste the data into the database.


Sir whats the path to your MySQL bin files ?

-----------------------
For immediate support please email us at our Support email address. PMs sent to any Softaculous Team member or posting in the forums is not the official way to get support.

Virtualizor - The Next Generation VPS Panel
Webuzo - It is Softaculous Standalone for Enterprises, SMB, Developers. Deploy it on Dedicated Servers, VPS, Virtual Appliances or the Cloud
Pinguzo - Server and Domain Monitoring tool
PopularFX - Marketplace of WordPress, Drupal, Joomla, Bootstrap themes
Remote Installer - Use Softaculous over FTP/FTPS/SFTP
IP: --   

no MySQL databases are being created
Husky
Group: Member
Post Group: Newbie
Posts: 4
Status:
Quote From : alons July 23, 2009, 3:55 pm
Sir whats the path to your MySQL bin files ?
It's /usr/local/mysql/bin .I should also write that the server was not altered, it's a standard DA 1.33.7 (custombiuld, not customapache, because the latter comes with Apache 1.3).  -- quick update - AEF installed correcly. MyBB and many other scripts still won't work...

Edited by Husky : July 23, 2009, 6:14 pm
IP: --   

no MySQL databases are being created
alons
Group: Administrator
Post Group: Super Member
Posts: 2280
Status:
Can you just let me know whether the following ShelL command works :
/usr/bin/mysql --help

-----------------------
For immediate support please email us at our Support email address. PMs sent to any Softaculous Team member or posting in the forums is not the official way to get support.

Virtualizor - The Next Generation VPS Panel
Webuzo - It is Softaculous Standalone for Enterprises, SMB, Developers. Deploy it on Dedicated Servers, VPS, Virtual Appliances or the Cloud
Pinguzo - Server and Domain Monitoring tool
PopularFX - Marketplace of WordPress, Drupal, Joomla, Bootstrap themes
Remote Installer - Use Softaculous over FTP/FTPS/SFTP
IP: --   

no MySQL databases are being created
groefie
Group: Member
Post Group: Newbie
Posts: 5
Status:
Quote From : alons July 24, 2009, 7:24 am
Can you just let me know whether the following ShelL command works :
/usr/bin/mysql --help


As we have the same problem with empty databases I tried the above shell command and I can confirm that this works fine.
IP: --   

no MySQL databases are being created
SoftDux
Group: NOC
Post Group: Working Member
Posts: 113
Status:
Quote From : alons July 23, 2009, 1:00 pm
The simplest way to get softaculous working is having shell_exec() in PHP work.
And there is a real good news.
We have the alternative to Shell exec import of Database which works on PHP and MySQL alone and we are soon to release 1.8 before the end of this month.

Regards,
Alons


Alons, we have shell_exec enabled, but it still doesn't work. So, how else can we get it to work.

When will 1.8 be released?
IP: --   

no MySQL databases are being created
alons
Group: Administrator
Post Group: Super Member
Posts: 2280
Status:
Quote From : groefie July 24, 2009, 7:30 am
Quote From : alons July 24, 2009, 7:24 am
Can you just let me know whether the following ShelL command works :
/usr/bin/mysql --help


As we have the same problem with empty databases I tried the above shell command and I can confirm that this works fine.


But is shell_exec enabled on your Server.
I asked the above command to work on Husky server.
Also are databases being created on your server or not ?

-----------------------
For immediate support please email us at our Support email address. PMs sent to any Softaculous Team member or posting in the forums is not the official way to get support.

Virtualizor - The Next Generation VPS Panel
Webuzo - It is Softaculous Standalone for Enterprises, SMB, Developers. Deploy it on Dedicated Servers, VPS, Virtual Appliances or the Cloud
Pinguzo - Server and Domain Monitoring tool
PopularFX - Marketplace of WordPress, Drupal, Joomla, Bootstrap themes
Remote Installer - Use Softaculous over FTP/FTPS/SFTP
IP: --   

no MySQL databases are being created
groefie
Group: Member
Post Group: Newbie
Posts: 5
Status:
Quote From : alons July 24, 2009, 5:05 pm
Quote From : groefie July 24, 2009, 7:30 am
Quote From : alons July 24, 2009, 7:24 am
Can you just let me know whether the following ShelL command works :
/usr/bin/mysql --help


As we have the same problem with empty databases I tried the above shell command and I can confirm that this works fine.


But is shell_exec enabled on your Server.
I asked the above command to work on Husky server.
Also are databases being created on your server or not ?


shell_exec is disabled - for security reasons we don't change that setting. Databases are created but are empty.
IP: --   

no MySQL databases are being created
Husky
Group: Member
Post Group: Newbie
Posts: 4
Status:
Same here - the database is created, but empty.  And to answer the question about /usr/bin/mysql --help - no, it doesn't work, as the mysql  binary on my server is located in /usr/local/bin/, not in /usr/bin/.
IP: --   

no MySQL databases are being created
alons
Group: Administrator
Post Group: Super Member
Posts: 2280
Status:
Quote From : Husky July 24, 2009, 5:29 pm
Same here - the database is created, but empty.  And to answer the question about /usr/bin/mysql --help - no, it doesn't work, as the mysql  binary on my server is located in /usr/local/bin/, not in /usr/bin/.


Can you just create a symlink for this purpose.
Things will start working ASAP

groefie 1.8 has the solution to all this problem.
1.8 will make us more capable to compete with Fantastico as even Fantastico cant do without shell_exec.
But Softaculous 1.8 onwards we will entirely remove dependence on MySQL shell exec

Regards,
Alons

-----------------------
For immediate support please email us at our Support email address. PMs sent to any Softaculous Team member or posting in the forums is not the official way to get support.

Virtualizor - The Next Generation VPS Panel
Webuzo - It is Softaculous Standalone for Enterprises, SMB, Developers. Deploy it on Dedicated Servers, VPS, Virtual Appliances or the Cloud
Pinguzo - Server and Domain Monitoring tool
PopularFX - Marketplace of WordPress, Drupal, Joomla, Bootstrap themes
Remote Installer - Use Softaculous over FTP/FTPS/SFTP
IP: --   

no MySQL databases are being created
alons
Group: Administrator
Post Group: Super Member
Posts: 2280
Status:
Quote From : Boboga July 22, 2009, 8:56 am
The creation is working, but the database stays empty.

Also i've got this error when saving settings from the admin page:
The following Errors were found :

  • Could not locate universal.php at the path you specified.



Sir can you please let me know the File Permissions on universal.php
It may be that the admin user may not have permissions for the same.

Regards,
Alons

-----------------------
For immediate support please email us at our Support email address. PMs sent to any Softaculous Team member or posting in the forums is not the official way to get support.

Virtualizor - The Next Generation VPS Panel
Webuzo - It is Softaculous Standalone for Enterprises, SMB, Developers. Deploy it on Dedicated Servers, VPS, Virtual Appliances or the Cloud
Pinguzo - Server and Domain Monitoring tool
PopularFX - Marketplace of WordPress, Drupal, Joomla, Bootstrap themes
Remote Installer - Use Softaculous over FTP/FTPS/SFTP
IP: --   

no MySQL databases are being created
Boboga
Group: Member
Post Group: Newbie
Posts: 9
Status:
Quote From : alons July 24, 2009, 7:25 pm


Sir can you please let me know the File Permissions on universal.php
It may be that the admin user may not have permissions for the same.

Regards,
Alons


root:root has 755 :) (same as the other files in /var/softaculous/aef/)
IP: --   

no MySQL databases are being created
alons
Group: Administrator
Post Group: Super Member
Posts: 2280
Status:
Its fixed in 1.8.
Please let us know if it persists

-----------------------
For immediate support please email us at our Support email address. PMs sent to any Softaculous Team member or posting in the forums is not the official way to get support.

Virtualizor - The Next Generation VPS Panel
Webuzo - It is Softaculous Standalone for Enterprises, SMB, Developers. Deploy it on Dedicated Servers, VPS, Virtual Appliances or the Cloud
Pinguzo - Server and Domain Monitoring tool
PopularFX - Marketplace of WordPress, Drupal, Joomla, Bootstrap themes
Remote Installer - Use Softaculous over FTP/FTPS/SFTP
IP: --   

no MySQL databases are being created
SoftDux
Group: NOC
Post Group: Working Member
Posts: 113
Status:
Quote From : alons July 25, 2009, 3:28 pm
Its fixed in 1.8.
Please let us know if it persists


So does this mean that we can now setup MySQL databases with shell_exec disabled? And also with cPanel on SSL ports?
IP: --   

no MySQL databases are being created
MJMWeb
Group: Member
Post Group: Newbie
Posts: 11
Status:
I have 1.8 and am having this issue
edit: Disregard this post is supposed to be fixed in todays v1.8

Edited by MJMWeb : July 26, 2009, 6:21 am
IP: --   

no MySQL databases are being created
alons
Group: Administrator
Post Group: Super Member
Posts: 2280
Status:
Quote From : SoftDux July 25, 2009, 7:59 pm
Quote From : alons July 25, 2009, 3:28 pm
Its fixed in 1.8.
Please let us know if it persists


So does this mean that we can now setup MySQL databases with shell_exec disabled? And also with cPanel on SSL ports?

Yes once all the packages are updated by 27th

-----------------------
For immediate support please email us at our Support email address. PMs sent to any Softaculous Team member or posting in the forums is not the official way to get support.

Virtualizor - The Next Generation VPS Panel
Webuzo - It is Softaculous Standalone for Enterprises, SMB, Developers. Deploy it on Dedicated Servers, VPS, Virtual Appliances or the Cloud
Pinguzo - Server and Domain Monitoring tool
PopularFX - Marketplace of WordPress, Drupal, Joomla, Bootstrap themes
Remote Installer - Use Softaculous over FTP/FTPS/SFTP
IP: --   

no MySQL databases are being created
SoftDux
Group: NOC
Post Group: Working Member
Posts: 113
Status:
Quote From : alons July 26, 2009, 7:01 am

Yes once all the packages are updated by 27th



Aaah, ok. So that's why I still get empty databases when I install scripts?
IP: --   

no MySQL databases are being created
groefie
Group: Member
Post Group: Newbie
Posts: 5
Status:
Just installed 1.8 on a Direct Admin server and it seems the install of scripts works fine. 

But I noticed when a script is installed in the root folder (public_html) and the script is removed through Softaculous the public_html folder is also deleted so everything else on the web space is also gone which of course is not preferable. Is there a way to prevent this?
IP: --   

no MySQL databases are being created
alons
Group: Administrator
Post Group: Super Member
Posts: 2280
Status:
Sir the root folder will not be deleted.
It will warn you and will never delete it.

-----------------------
For immediate support please email us at our Support email address. PMs sent to any Softaculous Team member or posting in the forums is not the official way to get support.

Virtualizor - The Next Generation VPS Panel
Webuzo - It is Softaculous Standalone for Enterprises, SMB, Developers. Deploy it on Dedicated Servers, VPS, Virtual Appliances or the Cloud
Pinguzo - Server and Domain Monitoring tool
PopularFX - Marketplace of WordPress, Drupal, Joomla, Bootstrap themes
Remote Installer - Use Softaculous over FTP/FTPS/SFTP
IP: --   

no MySQL databases are being created
groefie
Group: Member
Post Group: Newbie
Posts: 5
Status:
Quote From : alons July 29, 2009, 4:44 am
Sir the root folder will not be deleted.
It will warn you and will never delete it.


I'm sorry to say but it does delete the root folder on DirectAdmin servers when you uninstall a script (that's installed in the root folder instead of a sub folder)through the Softaculous panel. There is no warning also.
IP: --   

no MySQL databases are being created
alons
Group: Administrator
Post Group: Super Member
Posts: 2280
Status:
All 100 script packages have been Updated to use the Latest MySQL Import Function embedded in 1.8

This will make Softaculous compatible on Servers not having either shell_exec() function enabled in PHP or MySQL not allowed to import via SHELL.
Please let us know if any bug persists.

Regards,
Alons

-----------------------
For immediate support please email us at our Support email address. PMs sent to any Softaculous Team member or posting in the forums is not the official way to get support.

Virtualizor - The Next Generation VPS Panel
Webuzo - It is Softaculous Standalone for Enterprises, SMB, Developers. Deploy it on Dedicated Servers, VPS, Virtual Appliances or the Cloud
Pinguzo - Server and Domain Monitoring tool
PopularFX - Marketplace of WordPress, Drupal, Joomla, Bootstrap themes
Remote Installer - Use Softaculous over FTP/FTPS/SFTP
IP: --   

no MySQL databases are being created
SoftDux
Group: NOC
Post Group: Working Member
Posts: 113
Status:
I'm getting the following error on many installations:
Quote

The following Errors were found :
The MySQL Connection could not be established.



Even after I have updated the installation to 1.8, I still get the error.


IP: --   

no MySQL databases are being created
alons
Group: Administrator
Post Group: Super Member
Posts: 2280
Status:
Many people who posted in this thread complaining of these issues have PMed consent that things are working all fine.

Sir in Direct Admin or cPanel ?
Can you just let me know which script is this occuring in ?
Also have the latest versions of the scripts been downloaded e.g. Zikula is 1.1.2

-----------------------
For immediate support please email us at our Support email address. PMs sent to any Softaculous Team member or posting in the forums is not the official way to get support.

Virtualizor - The Next Generation VPS Panel
Webuzo - It is Softaculous Standalone for Enterprises, SMB, Developers. Deploy it on Dedicated Servers, VPS, Virtual Appliances or the Cloud
Pinguzo - Server and Domain Monitoring tool
PopularFX - Marketplace of WordPress, Drupal, Joomla, Bootstrap themes
Remote Installer - Use Softaculous over FTP/FTPS/SFTP
IP: --   

no MySQL databases are being created
SoftDux
Group: NOC
Post Group: Working Member
Posts: 113
Status:
I use cPanel.

And I have updated all scripts to the latest, in the last 2 hours.

IP: --   

« Previous    Next »

Threaded Mode | Print  

1


Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is April 19, 2024, 7:00 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.024