I just first installed suiteCRM 7.11.12 the latest version which is downloaded from official site.
But I can’t logon to the system at all, because I have no valid username.
Furthermore, there is not a default account for the system.
The error message is: You must specify a valid username and password.
What shall I do?
Thanks.
Hi,
welcome to the suitecrm-community!
Usually, you create an admin account during the installation - username and password are therefore not preset. Are you using some kind of image or did you use the regular installer package?
hi, thanks for your reply.
which is present admin? and I just used the regular installer package from website of ‘suitecrm.com/download’ .
hi, thanks for your reply.
which is present admin? and I just used the regular installer package from website of ‘suitecrm.com/download’ .
I have a question: the ‘free SuiteCRM account’ is necessary or not?
Hi,
the installation works standalone - you do not need external accounts somewhere. Just download e.g. SuiteCRM-7.11.12.zip and follow the manual:
yes, i did it .
when display ‘Creating the database suitecrm on localhost…done’ like the screenshot uploaded here, does is mean: SuiteCRM is installed successfully?
Hi,
there should be a line like
The setup of SuiteCRM 7.11.12 is now complete!
and a “next” button below it. In case you are stuck on this page and nothing changes, have a look at the log files.
since I’m a new user, I have no the privilege to attach log files. Here is the contents in ‘suitecrm.log’ file…
Wed Mar 11 07:20:56 2020 [9056][-none-][FATAL] Mysqli_query failed.
Wed Mar 11 07:20:56 2020 [9056][-none-][FATAL] Error creating table: users_feeds Query Failed: CREATE TABLE users_feeds (user_id varchar(36) NULL ,feed_id varchar(36) NULL ,rank int NULL ,date_modified datetime NULL ,deleted bool DEFAULT ‘0’ NULL , KEY idx_ud_user_id (user_id, feed_id)) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank int NULL ,date_modified datetime NULL ,deleted bool DEFAULT ‘0’ NULL , ’ at line 1
Wed Mar 11 07:26:57 2020 [9056][-none-][FATAL] SECURITY: User authentication for admin failed
Wed Mar 11 07:26:57 2020 [9056][-none-][FATAL] FAILED LOGIN:attempts[1], ip[::1], username[admin]
Wed Mar 11 07:39:19 2020 [9056][-none-][FATAL] SECURITY: User authentication for admin71112b failed
Wed Mar 11 07:39:19 2020 [9056][-none-][FATAL] FAILED LOGIN:attempts[1], ip[::1], username[admin71112b]
Wed Mar 11 08:28:28 2020 [9056][-none-][FATAL] FAILED LOGIN:attempts[1], ip[::1], username[admin]
Wed Mar 11 08:28:57 2020 [9056][-none-][FATAL] FAILED LOGIN:attempts[1], ip[::1], username[admin]
Wed Mar 11 08:32:25 2020 [9056][-none-][FATAL] FAILED LOGIN:attempts[1], ip[::1], username[leon]
Wed Mar 11 08:32:47 2020 [9056][-none-][FATAL] FAILED LOGIN:attempts[1], ip[::1], username[admin]
Wed Mar 11 08:35:54 2020 [9056][-none-][FATAL] FAILED LOGIN:attempts[1], ip[::1], username[admin]
Wed Mar 11 08:36:16 2020 [9056][-none-][FATAL] FAILED LOGIN:attempts[1], ip[::1], username[admin]
Wed Mar 11 08:36:35 2020 [9056][-none-][FATAL] FAILED LOGIN:attempts[1], ip[::1], username[leon]
Wed Mar 11 08:40:26 2020 [9056][-none-][FATAL] FAILED LOGIN:attempts[1], ip[::1], username[admin]
Thu Mar 12 01:38:45 2020 [9056][-none-][FATAL] SECURITY: User authentication for admin71112b failed
Thu Mar 12 01:38:45 2020 [9056][-none-][FATAL] FAILED LOGIN:attempts[1], ip[::1], username[admin71112b]
Thu Mar 12 02:04:09 2020 [9056][-none-][FATAL] FAILED LOGIN:attempts[1], ip[::1], username[admin]
Thu Mar 12 02:04:22 2020 [9056][-none-][FATAL] FAILED LOGIN:attempts[1], ip[::1], username[leon]
Thu Mar 12 03:07:55 2020 [3092][-none-][FATAL] Could not connect to DB server localhost as root. port : 由于目标计算机积极拒绝，无法连接。
Thu Mar 12 03:09:58 2020 [3092][-none-][FATAL] Could not connect to DB server localhost as root. port : 由于目标计算机积极拒绝，无法连接。
Thu Mar 12 03:15:55 2020 [3092][-none-][FATAL] iCal Server - Invalid request.
Thu Mar 12 03:16:14 2020 [3092][-none-][FATAL] Invalid Argument: Username is not set
Thu Mar 12 03:16:51 2020 [3092][-none-][FATAL] iCal Server - Invalid request.
Thu Mar 12 04:10:45 2020 [3092][-none-][FATAL] SECURITY: User authentication for admin71112b failed
Thu Mar 12 04:10:45 2020 [3092][-none-][FATAL] FAILED LOGIN:attempts[1], ip[::1], username[admin71112b]
Thu Mar 12 05:02:27 2020 [3092][-none-][FATAL] FAILED LOGIN:attempts[1], ip[::1], username[admin]
Thu Mar 12 05:51:05 2020 [9228][-none-][FATAL] FAILED LOGIN:attempts[1], ip[::1], username[admin]
Thu Mar 12 06:00:59 2020 [9228][-none-][FATAL] FAILED LOGIN:attempts[1], ip[::1], username[admin]
maybe my SuiteCRM is not installed completely.
my platform is windows 8.1, apache 2.4, php 7.4.3, mysql 8.0. Is there OK?
Did you install using install.php, or silent installer?
Did you go through the install wizard and insert an admin username and password?
Hi,
have you seen the compatibility matrix?
Don’t know how problematic the newer php/mysql-versions really are, but if you experience issues this mismatch could be the cause.
Nice catch, it’s definitely the versions. That rank error is a known MySQL 8 incompatibility.
Got it. thanks a lot.
Is MySQL 7.x ok? I will download it.
The Compatibility Matrix requires the version of MySQL is 5.x(5.5, 5,6&5.7).
I Must download one of them.
