HQY 一个和谐有爱的空间

2024-10-31 00:06:31.338 W [MediaServer] [3437-event poller 2] WebHook.cpp:194 operator() | hook http://192.168.1.1:18082/index/hook/on_server_keepalive 1ms,failed[network err]:3(connection refused):{

        "data" : 

        {

                "Buffer" : 17,

                "BufferLikeString" : 1,

                "BufferList" : 0,

                "BufferRaw" : 16,

                "Frame" : 0,

                "FrameImp" : 0,

                "MediaSource" : 0,

                "MultiMediaSourceMuxer" : 0,

                "RtmpPacket" : 0,

                "RtpPacket" : 0,

                "Socket" : 113,

                "TcpClient" : 1,

                "TcpServer" : 83,

                "TcpSession" : 0,

                "UdpServer" : 32,

                "UdpSession" : 0

        },

        "hook_index" : 455,

        "mediaServerId" : "FQ3TF8yT83wh5Wvz"

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

启动wvp/wvp-pro-2.7.0-01251122.jar 后，一直报以上错误信息，查看日志，

Cause: java.sql.SQLSyntaxErrorException: Table 'wvp.wvp_media_server' doesn't exist   关键问题，数据库的表缺失

[root@localhost local]# tail -100 log/wvp.log

        at org.springframework.boot.loader.Launcher.launch(Launcher.java:108)

        at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)

        at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65)

Caused by: org.springframework.jdbc.BadSqlGrammarException: 

### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Table 'wvp.wvp_media_server' doesn't exist

### The error may exist in com/genersoft/iot/vmp/storager/dao/MediaServerMapper.java (best guess)

### The error may involve defaultParameterMap

### The error occurred while setting parameters

### SQL: SELECT * FROM wvp_media_server WHERE default_server=true

### Cause: java.sql.SQLSyntaxErrorException: Table 'wvp.wvp_media_server' doesn't exist

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table 'wvp.wvp_media_server' doesn't exist

        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:236)

        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)

        at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)

        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)

        at com.sun.proxy.$Proxy86.selectOne(Unknown Source)

        at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)

        at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)

        at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)

        at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)

        at com.sun.proxy.$Proxy93.queryDefault(Unknown Source)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:498)

        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)

        at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:241)

        at com.sun.proxy.$Proxy94.queryDefault(Unknown Source)

        at com.genersoft.iot.vmp.service.impl.MediaServerServiceImpl.getDefaultMediaServer(MediaServerServiceImpl.java:310)

        at com.genersoft.iot.vmp.media.zlm.ZLMRunner.run(ZLMRunner.java:58)

        at com.genersoft.iot.vmp.media.zlm.ZLMRunner$$FastClassBySpringCGLIB$$61f3e605.invoke(<generated>)

        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)

从github重新下载对应版本最新的sql文件，再次导入

https://github.com/648540858/wvp-GB28181-pro/tree/master/%E6%95%B0%E6%8D%AE%E5%BA%93/2.6.9 

sudo mysql -u root -p

//视频平台后台+前台

source mysql/wvp-dump-xxxxx.sql;

推荐本站淘宝优惠价购买喜欢的宝贝:

本文链接：https://hqyman.cn/post/8272.html 非本站原创文章欢迎转载，原创文章需保留本站地址！

休息一下~~