A8/A6 Install on Windows

安装Windows 2012(虚拟机)

本渣这里使用的是OracleVirtualBox虚拟机,配置的方法如下:
图片
成功进入Windows安装界面
图片
语言、货币、输入法都是默认值
图片
现在安装
图片
这里等一下安装程序运行
图片
这里非常关键,必须要选择带GUI的版本
图片

条款是必须要接受的
图片
选择第二个:自定义:仅安装Windows(高级)(C)
图片
选择要安装系统的硬盘
图片
开始跑安装程序
图片
等待系统自动重启
图片
这里不要按回车,让系统自动进去
图片
设置一个administrator(超级管理员)的密码,要比较复杂的。
图片
系统跑一下配置
图片
Windows Server登录需要组合键Ctrl + Alt + Del
图片
输入你刚刚配置的Administrator的密码
图片
建议马上关闭IE增强的安全配置
图片
【非必要】如果你跟本渣一样是用OracleVirtualBox虚拟机的,建议安装增强功能
图片
增强功能会占用了CD-ROM,记得后面要改回来,不然后面会安装不上Framework3.5的。
图片
安装增强功能是为了能读取本机电脑的数据,还有做跨虚拟机复制粘贴的操作。
图片
把MSSQLServer、A8、Chrome的安装包都拷贝进来,现在开始逐一安装。
图片
图片

安装MSSQLServer2012

这里安装的是MS SQLServer 2012 SP1 x64 标准版
系统安装包的时候建议用以管理员身份运行
图片
选择【安装】-【全身SQL Server独立安装或向现有安装添加功能】
图片
做一个系统检查,如果有报错就要逐一修复
图片
输入秘钥,一般TB都有售。
图片
条款是必须要接受的
图片
下载一些更新
图片
准备安装程序
图片
检查系统配置,发现一个错误:
图片
关闭防火墙,修复这个错误。
图片
图片
图片
点击一下重新运行,看看⚠️警告消失了没有。
图片
选择第三个,默认安装所有功能
图片
基本上都勾上√了,不用改了,直接下一步
图片
再次做一些自检
图片
起实例名,建议最好改掉。如果你的网络里面有另外的MSSQL服务器就会有冲突了。
图片
安装需要10个G以上的空间
图片
确保SQL Server 数据库引擎是自动启动的
图片
sa的密码必须要设置好
图片
如果你的C盘空间不够,最好换个数据目录
图片
为分析服务配置权限用户,直接点击添加当前用户即可
图片
为报表服务配置,默认值即可
图片
为分布式充包控制器(我也不知道是啥)配置权限用户,直接点击添加当前用户即可
图片
名称目录都是默认值
图片
错误报告,不勾选
图片
再一次自检
图片
检查一下安装的配置
图片
⚠️如果有NetFx3报错,需要安装Framework3.5来解决
图片
确保Windows2012的安装盘是在的
图片
服务器管理器里面添加角色和功能
图片
勾选安装Framework3.5,其他步骤都是默认值
图片
安装成功就把前面的MSSQL的步骤再执行一次
图片
这次没有报错了,安装成功
图片
点击Windows键,打开菜单,点击SQL Server Management Studio
图片
选择SQLServer身份验证输入【sa】账号和密码来尝试登录
图片
登录成功后是这样的效果
图片
确保SQL Server这个服务是自动运行的,因为如果手工启动,很可能Windows会很难把它启动起来。
图片
检查一下安装好SQL Server后的系统性能还够不够。
图片
图片

安装 MySQL 8.0

用百度打开bing,搜索mysql,记得下载社区版
具体下载链接:https://downloads.mysql.com/archives/installer/
图片
要下载这个完整的安装包8.0.xx,有288.6M大小。不要下载那个2.1M大小的。小版本最新的就行。
图片
下载完打开安装
图片
遇到第一个错误,要安装.net fw 4.5.2
图片
在bing中搜索就能下载到安装包
图片
下载完就执行安装
图片
总是下一步就能安装完成
图片
安装完要重启系统
图片
重启完继续安装MySQL
图片
选Full,啥都不懂就全选
图片
好像要安装确实的支持
图片
系统会自动安装一些支持程序
图片
Microsoft Visual C++ 2019 Redistributable Package (x64)没有安装上,去bing查找解决
图片
图片
下载安装完,就可以下一步继续执行(Execute)
图片
两三分钟就安装完了,下一步是配置
图片
啥都不懂,直接默认选下一步
图片
使用强密码模式,继续默认下一步

这里建议选择第二个(旧方式),后面连接数据库会少一个错误。

图片
配置root用户,新建一个应用使用的用户,这里的密码千万不要忘记。
图片
起一个不会重复的名,作为服务器的名
图片
文件存放目录,如果你不想放在C盘,记得要换。
图片
开始配置初始化MySQL
图片
成功了
图片
下一个配置,Router
图片
不知道在配置啥,反正就是finish
图片
最后一个配置 sample 和 example
图片
输入一下root的密码check一下就下一步。就是上面配置的root密码,是MySQL的密码。
图片
继续执行配置
图片
好了?
图片
安装完成了?
图片
还有两个玩意要启动,感觉没啥用,建议去掉这两个勾,然后finish
图片
打开了shell和workbench的东西,不用管,关了他
图片
在菜单里面安装了三样东西
图片
看看服务,应该是安装成功,并运行成功了。
图片

安装Navicat来尝试连接MySQL。这个软件是可以个人免费试用的。
图片
如果连接时候发生这个错误,按下面方法去修改
图片

1
2
3
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Seeyon@123';
FLUSH PRIVILEGES;

在cmd要进入到C:\Program Files\MySQL\MySQL Server 8.0\bin里面执行mysql -u root -p来登录
图片
成功登录Navicat了
图片

Dbeaver(客户端)

你也可以利用Dbeaver来测试登录
图片

MySQL Shell(命令行)

使用mysql shell来连接mysqlexi

1
2
3
4
5
6
--用mysql sheel连接mysql
\connect seeyon@localhost:3306
-- 用\sql命令从JS切换到sql模式
\sql
--查看sql语句是否正确
show databases;

图片
图片
图片

安装A8(基于MySQL)

现在开始安装A8,先把安装包(ZIP)提取(解压)出来
图片
图片
解压出来后在目录C:\0.SeeyonInstall V5 9.0SP1 B250725\0.SeeyonInstall中找到SeeyonA8-2Install右键点击以管理员身份运行
图片
会有一个系统环境检查,如果通不过,就需要调整操作系统,或增加服务器资源。然后重新运行SeeyonA8-2Install`程序。
图片
协议是只能接受的
图片
安装目录需要修改的话在这里修改,最好只修改盘符,如放去D盘,其他的目录不要修改。
图片

链接MySQL

这个时候大概率会报错
图片

MySQL链接错误1解决,修改my.ini文件解决

修改my.ini文件,这个文件要搜索才能出来C:\ProgramData\MySQL\MySQL Server 8.0
图片
图片

为了省时间,建议之间用我这里的代码替换

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
# Other default tuning values
# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
# ----------------------------------------------------------------------
#
# On Linux you can copy this file to /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options
# (@localstatedir@ for this installation) or to
# ~/.my.cnf to set user-specific options.
#
# On Windows, when MySQL has been installed using MySQL Installer you
# should keep this file in the ProgramData directory of your server
# (e.g. C:\ProgramData\MySQL\MySQL Server X.Y). To make sure the server
# reads the config file, use the startup option "--defaults-file".
#
# To run the server from the command line, execute this in a
# command line shell, e.g.
# mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
#
# To install the server as a Windows service manually, execute this in a
# command line shell, e.g.
# mysqld --install MySQLXY --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
#
# And then execute this in a command line shell to start the server, e.g.
# net start MySQLXY
#
#
# Guidelines for editing this file
# ----------------------------------------------------------------------
#
# In this file, you can use all long options that the program supports.
# If you want to know the options a program supports, start the program
# with the "--help" option.
#
# More detailed information about the individual options can also be
# found in the manual.
#
# For advice on how to change settings please see
# https://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
#
#
# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]

# pipe=

# socket=MYSQL

port=3306

[mysql]
no-beep

# default-character-set=

# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
# server_type=3
[mysqld]

# The next three options are mutually exclusive to SERVER_PORT below.
# skip-networking
# enable-named-pipe
# shared-memory

# shared-memory-base-name=MYSQL

# The Pipe the MySQL Server will use.
# socket=MYSQL

# The access control granted to clients on the named pipe created by the MySQL Server.
# named-pipe-full-access-group=

# The TCP/IP Port the MySQL Server will listen on
port=3306

# Path to installation directory. All paths are usually resolved relative to this.
# basedir="C:/Program Files/MySQL/MySQL Server 8.0/"

# Path to the database root
datadir=C:/ProgramData/MySQL/MySQL Server 8.0\Data

# The default character set that will be used when a new schema or table is
# created and no character set is defined
# character-set-server=


# Administers multifactor authentication (MFA) capabilities. It applies to the authentication
# factor-related clauses of CREATE USER and ALTER USER statements used to manage MySQL account
# definitions, where "factor" corresponds to an authentication method or plugin associated
# with an account.
authentication_policy=*,,

# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB

# The current server SQL mode, which can be set dynamically.
# Modes affect the SQL syntax MySQL supports and the data validation checks it performs. This
# makes it easier to use MySQL in different environments and to use MySQL together with other
# database servers.
sql-mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"

# General and Slow logging.
log-output=FILE

general-log=0

general_log_file="DESKTOP-FH09R9R.log"

slow-query-log=1

slow_query_log_file="DESKTOP-FH09R9R-slow.log"

long_query_time=10

# Error Logging.
log-error="DESKTOP-FH09R9R.err"

# ***** Group Replication Related *****
# Specifies the base name to use for binary log files. With binary logging
# enabled, the server logs all statements that change data to the binary
# log, which is used for backup and replication.
log-bin="DESKTOP-FH09R9R-bin"

# ***** Group Replication Related *****
# Specifies the server ID. For servers that are used in a replication topology,
# you must specify a unique server ID for each replication server, in the
# range from 1 to 2^32 鈭1. "Unique" means that each ID must be different
# from every other ID in use by any other source or replica.
server-id=1

# Indicates how table and database names are stored on disk and used in MySQL.
# Value 0 = Table and database names are stored on disk using the lettercase specified in the CREATE
# TABLE or CREATE DATABASE statement. Name comparisons are case-sensitive. You should not
# set this variable to 0 if you are running MySQL on a system that has case-insensitive file
# names (such as Windows or macOS). If you force this variable to 0 with
# --lower-case-table-names=0 on a case-insensitive file system and access MyISAM tablenames
# using different lettercases, index corruption may result.
# Value 1 = Table names are stored in lowercase on disk and name comparisons are not case-sensitive.
# MySQL converts all table names to lowercase on storage and lookup. This behavior also applies
# to database names and table aliases.
# Value 2 = Table and database names are stored on disk using the lettercase specified in the CREATE TABLE
# or CREATE DATABASE statement, but MySQL converts them to lowercase on lookup. Name comparisons
# are not case-sensitive. This works only on file systems that are not case-sensitive! InnoDB
# table names and view names are stored in lowercase, as for lower_case_table_names=1.
lower_case_table_names=1

# This variable is used to limit the effect of data import and export operations, such as
# those performed by the LOAD DATA and SELECT ... INTO OUTFILE statements and the
# LOAD_FILE() function. These operations are permitted only to users who have the FILE privilege.
secure-file-priv="C:/ProgramData/MySQL/MySQL Server 8.0/Uploads"

# The maximum amount of concurrent sessions the MySQL server will
# allow. One of these connections will be reserved for a user with
# SUPER privileges to allow the administrator to login even if the
# connection limit has been reached.
max_connections=151

# The number of open tables for all threads. Increasing this value increases the number
# of file descriptors that mysqld requires.
table_open_cache=4000

# Defines the maximum amount of memory that can be occupied by the TempTable
# storage engine before it starts storing data on disk.
temptable_max_ram=1G

# Defines the maximum size of internal in-memory temporary tables created
# by the MEMORY storage engine and, as of MySQL 8.0.28, the TempTable storage
# engine. If an internal in-memory temporary table exceeds this size, it is
# automatically converted to an on-disk internal temporary table.
tmp_table_size=512M

# The storage engine for in-memory internal temporary tables (see Section 8.4.4, "Internal
# Temporary Table Use in MySQL"). Permitted values are TempTable (the default) and MEMORY.
internal_tmp_mem_storage_engine=TempTable

#*** MyISAM Specific options
# The maximum size of the temporary file that MySQL is permitted to use while re-creating a
# MyISAM index (during REPAIR TABLE, ALTER TABLE, or LOAD DATA). If the file size would be
# larger than this value, the index is created using the key cache instead, which is slower.
# The value is given in bytes.
myisam_max_sort_file_size=2146435072

# The size of the buffer that is allocated when sorting MyISAM indexes during a REPAIR TABLE
# or when creating indexes with CREATE INDEX or ALTER TABLE.
myisam_sort_buffer_size=387M

# Size of the Key Buffer, used to cache index blocks for MyISAM tables.
# Do not set it larger than 30% of your available memory, as some memory
# is also required by the OS to cache rows. Even if you're not using
# MyISAM tables, you should still set it to 8-64M as it will also be
# used for internal temporary disk tables.
key_buffer_size=8M

# Each thread that does a sequential scan for a MyISAM table allocates a buffer
# of this size (in bytes) for each table it scans. If you do many sequential
# scans, you might want to increase this value, which defaults to 131072. The
# value of this variable should be a multiple of 4KB. If it is set to a value
# that is not a multiple of 4KB, its value is rounded down to the nearest multiple
# of 4KB.
read_buffer_size=128K

# This variable is used for reads from MyISAM tables, and, for any storage engine,
# for Multi-Range Read optimization.
read_rnd_buffer_size=256K

#*** INNODB Specific options ***
# innodb_data_home_dir=

# Use this option if you have a MySQL server with InnoDB support enabled
# but you do not plan to use it. This will save memory and disk space
# and speed up some things.
# skip-innodb

# If set to 1, InnoDB will flush (fsync) the transaction logs to the
# disk at each commit, which offers full ACID behavior. If you are
# willing to compromise this safety, and you are running small
# transactions, you may set this to 0 or 2 to reduce disk I/O to the
# logs. Value 0 means that the log is only written to the log file and
# the log file flushed to disk approximately once per second. Value 2
# means the log is written to the log file at each commit, but the log
# file is only flushed to disk approximately once per second.
innodb_flush_log_at_trx_commit=1

# The size in bytes of the buffer that InnoDB uses to write to the log files on
# disk. The default value changed from 8MB to 16MB with the introduction of 32KB
# and 64KB innodb_page_size values. A large log buffer enables large transactions
# to run without the need to write the log to disk before the transactions commit.
# Thus, if you have transactions that update, insert, or delete many rows, making
# the log buffer larger saves disk I/O.
innodb_log_buffer_size=16M

# The size in bytes of the buffer pool, the memory area where InnoDB caches table
# and index data. The default value is 134217728 bytes (128MB). The maximum value
# depends on the CPU architecture; the maximum is 4294967295 (232-1) on 32-bit systems
# and 18446744073709551615 (264-1) on 64-bit systems. On 32-bit systems, the CPU
# architecture and operating system may impose a lower practical maximum size than the
# stated maximum. When the size of the buffer pool is greater than 1GB, setting
# innodb_buffer_pool_instances to a value greater than 1 can improve the scalability on
# a busy server.
innodb_buffer_pool_size=4096M

# Defines the amount of disk space occupied by redo log files. This variable supersedes the
# innodb_log_files_in_group and innodb_log_file_size variables.
innodb_redo_log_capacity=100M

# Defines the maximum number of threads permitted inside of InnoDB. A value
# of 0 (the default) is interpreted as infinite concurrency (no limit). This
# variable is intended for performance tuning on high concurrency systems.
# InnoDB tries to keep the number of threads inside InnoDB less than or equal to
# the innodb_thread_concurrency limit. Once the limit is reached, additional threads
# are placed into a "First In, First Out" (FIFO) queue for waiting threads. Threads
# waiting for locks are not counted in the number of concurrently executing threads.
innodb_thread_concurrency=17

# The increment size (in MB) for extending the size of an auto-extend InnoDB system tablespace file when it becomes full.
innodb_autoextend_increment=64

# The number of regions that the InnoDB buffer pool is divided into.
# For systems with buffer pools in the multi-gigabyte range, dividing the buffer pool into separate instances can improve concurrency,
# by reducing contention as different threads read and write to cached pages.
innodb_buffer_pool_instances=8

# Determines the number of threads that can enter InnoDB concurrently.
innodb_concurrency_tickets=5000

# Specifies how long in milliseconds (ms) a block inserted into the old sublist must stay there after its first access before
# it can be moved to the new sublist.
innodb_old_blocks_time=1000

# When this variable is enabled, InnoDB updates statistics during metadata statements.
innodb_stats_on_metadata=0

# When innodb_file_per_table is enabled (the default in 5.6.6 and higher), InnoDB stores the data and indexes for each newly created table
# in a separate .ibd file, rather than in the system tablespace.
innodb_file_per_table=1

# Use the following list of values: 0 for crc32, 1 for strict_crc32, 2 for innodb, 3 for strict_innodb, 4 for none, 5 for strict_none.
innodb_checksum_algorithm=0

# If this is set to a nonzero value, all tables are closed every flush_time seconds to free up resources and
# synchronize unflushed data to disk.
# This option is best used only on systems with minimal resources.
flush_time=0

# The minimum size of the buffer that is used for plain index scans, range index scans, and joins that do not use
# indexes and thus perform full table scans.
join_buffer_size=256K

# The maximum size of one packet or any generated or intermediate string, or any parameter sent by the
# mysql_stmt_send_long_data() C API function.
max_allowed_packet=64M

# If more than this many successive connection requests from a host are interrupted without a successful connection,
# the server blocks that host from performing further connections.
max_connect_errors=100

# The number of file descriptors available to mysqld from the operating system
# Try increasing the value of this option if mysqld gives the error "Too many open files".
open_files_limit=8161

# If you see many sort_merge_passes per second in SHOW GLOBAL STATUS output, you can consider increasing the
# sort_buffer_size value to speed up ORDER BY or GROUP BY operations that cannot be improved with query optimization
# or improved indexing.
sort_buffer_size=256K

# Specify the maximum size of a row-based binary log event, in bytes.
# Rows are grouped into events smaller than this size if possible. The value should be a multiple of 256.
binlog_row_event_max_size=8K


# If the value of this variable is greater than 0, a replica synchronizes its master.info file to disk.
# (using fdatasync()) after every sync_source_info events.
sync_source_info=10000

# If the value of this variable is greater than 0, the MySQL server synchronizes its relay log to disk.
# (using fdatasync()) after every sync_relay_log writes to the relay log.
sync_relay_log=10000


# Load mysql plugins at start."plugin_x ; plugin_y".
# plugin_load

# The TCP/IP Port the MySQL Server X Protocol will listen on.
loose_mysqlx_port=33060

transaction_isolation=READ-COMMITTED
log-bin-trust-function-creators=1

你也可以一个个错误的修改,如下图:

修改第1个错误(my.ini配置)

图片

修改第2个错误(my.ini配置)

图片

修改第3个错误(my.ini配置)

图片

修改第4个错误(my.ini配置)

图片

第5个错误(重启失败)

重启MySQL

MySQL重启失败错误解决,ANSI的my.ini编码问题

图片
如果重启的时候出现【本地计算机 上的 MySQL80A6 服务启动后停止。某些服务在未由基他服务或程序使用时将自动停止】这样的错误。就是需要解决
图片
就要把my.ini的文件编码改回来ANSI,用notepad++来改。并且上面的my.ini修改的地方有错误也会出错,如果用了ANSI格式还是报错,就逐条检查修改了的配置有没有写错。或者txt修改时候选择ANSI编码。
图片

第6个错误(安全模式)

如果出现这个错误,就是前面安装MySQL的时候,选错了登录验证的模式。需要换回旧模式。
图片
用cmd登录MySQL

1
2
3
cd C:\Program Files\MySQL\MySQL Server 8.0\bin
mysql -u seeyon - p
# 输入密码进入MySQL命令行模式

接着要创建一个新用户和数据库

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
--新建一个用户叫seeyon,密码是Newpwd123456
mysql> create user 'seeyon'@'%' identified by 'Newpwd123456';
Query OK, 0 rows affected (0.02 sec)
--应用权限
mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)
--赋权给远程用户
mysql> grant all privileges on *.* to 'seeyon'@'%';
Query OK, 0 rows affected (0.03 sec)
--应用权限
mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)
--查看是否新建成功了
mysql> select user,host from mysql.user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| seeyon | % |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+------------------+-----------+
5 rows in set (0.00 sec)
-- - 新建一个叫v8x的数据库,字符集为UTF8MB4,用于安装A8
CREATE DATABASE a8v9 DEFAULT CHARACTER SET UTF8MB4;

图片
继续执行下面三个语句

1
2
3
ALTER USER 'seeyon'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
ALTER USER 'seeyon'@'%' IDENTIFIED WITH mysql_native_password BY 'Newpwd123456';
FLUSH PRIVILEGES;

终于连上了
图片
如果URL缺失了,用这句语句来修改来弄<黄色是IP:端口><红色是数据库名>
jdbc:mysql://127.0.0.1:3306/A8V9?autoReconnection=true&useSSL=false

第7个错误(安装包太旧了)

请找你的运维顾问拿最新的安装包
图片

第8个错误(硬件软件配置太低)

请升级的硬件至少8核16G以上,配置好虚拟内存等系统配置。
图片

以上的8个问题都解决了,终于可以继续了
图片
下一步
图片
安装
图片
等待安装完成
图片
配置密码

  • 超级管理员账号密码:只会用一次,首次登录后就会禁用管理员。需要新建一个新用户来替代管理员。
  • 新用户初始密码:每新建一个新用户都会默认的密码,当然新建的时候可以改的。
  • S1密码:是运维软件的登录密码,千万不要忘记,忘记了就要重装系统了。
    图片

第9个错误(数据库建错了)

如果你的数据库排序和字符集用错了,就需要重建一个再来安装。字符集为UTF8MB4。
图片
图片

继续安装,这个默认值。如果有网络隔离需要,请配置。但是建议通过防火墙来控制,更方便。
图片

点击完成
图片

注册系统(加密狗)

详细请找你的客户经理、实施经理或运维工程师。
图片

启动

用管理员运行C:\Seeyon\A8\ApacheJetspeed\bin\startup.bat
图片
这就证明跑起来了
图片

移动端

配置内网IP和端口就能登录,不需要启动额外服务
图片

打补丁

请找你的运维顾问拿到帮助文档,还有下载补丁工具。当然你购买了维保服务是可以当甩手掌柜的。
图片
图片
在线打补丁:需要在协同关闭的时候进行
漏洞扫描:需要在协同启动的时候进行
图片

升级

跟重新安装一样,这里不展开。建议至少每3年升级一次系统。
图片

S1(运维工具)

在安装完系统的时候的第一次,S1工具就会自动启动。不需要额外安装的。
图片
以后手动启动的目录是S1启动位置C:\Seeyon\A8\S1\bin\start.bat
图片

OfficeTrans(Offic浏览)

默认就会安装上,只需要启动即可。
地址是:C:\Seeyon\A8\OfficeTrans
图片
点击小眼睛就能预览文件了
图片

Mediaservice(音视频)

音视频服务是一个能在协同上直接播放视频的工具
下载了安装包后,安装保路径:D:\1.IndependentService\SeeyonMediaserviceInstall.bat
图片
全部下一步就好了
图片
安装完的目录文件
图片
因为音视频服务需要Nginx服务的支持,所以需要安装Nginx。
下载Nginx:https://nginx.org/en/download.html
图片
首先要知道,刚刚安装好的音视频服务就已经有了C:\Seeyon\Mediaservice\nginx\conf目录中的nginx.confmime.types两个文件
图片

  1. 把下载好的安装包nginx-1.26.3.zip文件解压出来成为nginx-1.26.3文件夹
  2. C:\Seeyon\Mediaservice\nginx\conf目录中的nginx.confmime.types复制出来,放在C:\Seeyon\Mediaservice\nginx-1.26.3\conf中,替换原有的两个文夹。
  3. 删除掉自带的nginx文件夹
  4. nginx-1.26.3文件夹改名为nginx文件夹
    图片
    重启S1服务
    图片
    图片
    在S1里面配置Mediaservice服务
    图片
    配置默认一般就是正确的,点击测试通过就行。注意a8.server.url的IP要跟本机的IP一致。
    图片
    现在可以启动服务了
    图片
    回到A8的知识社区-视频广场,新建一个新的分类
    图片
    可以上传视频并播放了
    图片

搜索服务

具体见运维顾问提供的手册

下载服务

具体见运维顾问提供的手册