Thanks I mack composer install in public/legacy
and suiteCRM8 installed success.
Hi Guys,
I am trying to install v8 on Ubuntu v20.10 server but during the installation process I get the message:
âAttempted to call function "mysql_connectâ from the global namespaces.â
My configuration:
Apache 2.4
PHP 7.4 and 8
mySQL 8 .0.23
Is the function âmysql_connectâ not from old php versions ? Where did it get here ?
Thanks for help.
sla
Hi @sla,
Welcome to the community and thank you for trying out Suite 8.
Also, sorry for the delay in replying, we are on a quite busy period at the moment.
Regarding the above question, Suite 8, at the moment still relies on Suite 7 for many things.
More details
just a bit of context:
For several reasons among them backwards compatibility reasons, Suite 8 still relies for a good part of the backend on the Suite 7. Suite 8 âcontainsâ an Suite7 within it on the public/legacy
folder and it uses a concept called âLegacy Handlersâ to call suite 7 for whatever it needs.
Though the only place I see we are using the mysql_connect
is in public/legacy/include/database/MysqlManager.php
. Though preferably we should be using MysqliManager
instead.
Do you have mysqli
php module installed?
More details
The code on legacy is doing the following:
public/legacy/include/database/DBManagerFactory.php
if (empty($config['db_manager'])) {
// standard types
switch ($type) {
case "mysql":
if (empty($sugar_config['mysqli_disabled']) && function_exists('mysqli_connect')) {
$my_db_manager = 'MysqliManager';
} else {
$my_db_manager = "MysqlManager";
}
break;
Finally, thank you for bringing this up.
@Mac-Rae we need to add the list of required php modules to the Suite 8 documentation - Compatibility matrix
@Matt FYI. Probably something we need to look at, though I think we need to drop support for MysqlManager
on php 8
Hi @cherub-chum,
Could you try with a connection without using the socket to check if it works, please?
We need to look into configuration for socket connection.
Hi Guys!
Just fixed the installation and now Iâm workin on this issue for hours . What Iâm doing wrong?
Some of the variables donât seem to reach the legacy module and I canât imagin why.
Anyone here who can help me plz? Thx.
Hi @m.teufel
Welcome to the community and thanks for trying out SuiteCRM 8 Beta.
During debugging have you enabled error reporting?
That kind of error usually shows when you have display_errors
set to true.
You should be able to change this on php.ini
Have a look at the following threads they may help:
Hope this helps
Thank you very much! Switching display_errors=off in php.ini solved the issue.
Hello,
I have a problem with the connexion of my suitecrm
I have access to the DB and I know my username and my password.
Its strange because when I use this like, It works, but I donât get the css.
/public/legacy/index.php?action=Login&module=Users
And when I use
/public/#/Login
i canât connect but the css works
Cordialy
Hi @Robin17
Thank you for trying out SuiteCRM 8 and for the feedback.
From the errors you are getting I imagine you have installed from the repo? and not from the pre-bundled package zip, is that correct?
Regarding the issues described:
1. CSS issue
From the issue description it seems that the legacy theme css hasnât been built.
To fix this issue you should only need to build the legacy them sass. for that follow step 3) and 4) of the Development install guide:
- Run
composer install
in legacy directory (/public/legacy
) - Run legacy theme compile in the legacy directory (
/public/legacy
)
-
NOTE: the
./vendor/bin/pscss
is added as a composer dev dependency, so you need to runcomposer install
without--no-dev
./vendor/bin/pscss -f compressed themes/suite8/css/Dawn/style.scss > themes/suite8/css/Dawn/style.css
2. Login issue
Things to check:
- Check that you have executed:
-
composer install
on Suite 8 root folder -
composer install
on legacy folder (public/legacy
)
-
- Check that the db config is correct on legacy config
config.php
- Check that the db config is correct on
env.local
on Suite8 root folder
If the above donât work, could you please send a screenshot of the graqhql
requests on the network tab that have an error (either a 500
or an error on the response body)? that can help in finding the root cause.
I am trying without any socket, getting following message in log.
Could not connect to DB server localhost as root. port : No such file or directory
Hi Clemente,
I put the content via filezila then I made a classic installation.
For do that, I need to use a terminal ?
Cordialy,
Hi @Robin17,
For the code are you using the zip? or the code from the repo?
The steps differ for both, however there is at least one common step:
- Running
./bin/console suitecrm:app:install
on the command line / terminal.
There is some more info on this on the documentation page:
-
if you are using the zip, have a look at 1) in Installation guide
-
if you are using the repo, have a look at 11) in the Development install guide
Hi @cherub-chum,
was looking into the code that outputs the above message.
Its on public/legacy/include/database/MysqliManager.php
(Suite 7 code)
if (empty($this->database)) {
$GLOBALS['log']->fatal("Could not connect to DB server " . $dbhost . " as " . $configOptions['db_user_name'] . ". port " . $dbport . ": " . mysqli_connect_error());
As you can see from the above, the following message comes from the mysqli_connect_error()
.
It looks like mysqli
is not able to reach the database.
I was looking into this issue and found this stackoverflow thread, which may help:
Could you try with 127.0.0.1
instead of localhost, please?
Note:
- as far as Iâm aware this code hasnât changed in the current SuiteCRM 8 beta release, so it should be the same as the current SuiteCRM 7 version.
Hope this helps.
Suite7 DB credentials that are working on this same instance are
âdbconfigâ =>
array (
âdb_host_nameâ => âlocalhostâ,
âdb_host_instanceâ => âSQLEXPRESSâ,
âdb_user_nameâ => ârootâ,
âdb_passwordâ => âmypasswordâ,
âdb_nameâ => âsuitecrm7â,
âdb_typeâ => âmysqlâ,
âdb_portâ => ââ,
âdb_managerâ => âMysqliManagerâ,
âcollationâ => âutf8_general_ciâ,
âcharsetâ => âutf8â,
),
When you say install from zip , you are referring to zip @ https://docs.suitecrm.com/8.x/admin/releases/8.0-beta/#_8_0_beta_2, or from any other place ?
Hi @milanraval,
Thank you for trying out SuiteCRM 8 Beta version.
You can find the link to official package on the Download and install
section here: https://suitecrm.com/suitecrm-8-beta-preview/
The link youâve mentioned is the zip generated from github. This raises a good point and something we could make more clear on the release page on the documentation site.
Thank you
How to configure MSSQL as database during installation ?
Hi,
I have been trying for few days to install Suite8 but nothing works.
I have za .zip version. Installed all additional tools (angular, yarnâŚ), PHP version is correct, the database is workingâŚ
Installation from folder using command ./bin/console suitecrm:app:install.
I see in databases that data is inserted and all tables are created.
But when I go into the browser in try to open it (localhost/MY_SUITE/public) I get a blank screen.
No error is recorded.
Any advice?
Thanks, Filip
Hi @milanraval, at the moment (SuiteCRM 8 Beta 2) the install command doesnât allow it yet. We will be working on that in the future. However its possible to do the install steps manually.
Hi @fcorluka,
Thank you for trying out SuiteCRM 8 Beta and for the feedback.
Could you check the graphql
requests in the browser network tab, please?
And check see if they match the errors described on this post here: