ERROR 1449

[sammeh]

When I start the server I get the error: The user specified as a definer ('web2vi'@'%') does not exist

The server still starts and people can connect/play fine, but I don't know if it has anything to do with vehicles not spawning?

PLEASE HELP XD

Thanks

 

[ShootingBlanks]

web2vi is the sql user. @% means that user can connect from any host. so... i really dont know where to go,from here. this would be in your sql procedures, maybe edit those to match your login name from the hiveext.ini
or edit the users table and create a user with that name and access from %
and make sure thst user has all the permissions for that db
just guessing ... and yes, that would affect vehicle spawns. i am not fluent in sql workings to debug the problem without seeing the files and lots of trial and error

 

[sammeh]

I have no idea what you mean, I'm new to all this

Thanks though

 

[ShootingBlanks]

how do you access your database? phpmyadmin? the ussr listed in your sql,file does not match a user listed in the db privileges. google how to add user using the app you use

 

[sammeh]

how do you access your database? phpmyadmin? the ussr listed in your sql,file does not match a user listed in the db privileges. google how to add user using the app you use

I use navicat to access the database.

 

[sammeh]

Please guide me through it as I have no idea, I can run and setup a server I just can't do my SQL

 

[ShootingBlanks]

you will have to wait until i get home. cellphone is useless for that.
an hour or 2 ...

 

[sammeh]

Any help?

 

[ShootingBlanks]

Okay. You are using pwnozors private server pack which comes with its own mysql server. Here is a link for more information. https://dev.mysql.com/doc/refman/5.0/en/stored-programs-security.html

What is a "definer". Its a user in the mysql database who is used to run this 'procedure'. Whatever permissions that user has, is what that script is allowed to do. So when you are told the definer does not exist, its saying there is no user acccount on your mysql server with that name. the solution is to change the procedures definer to an account that DOES exist and DOES have permissions. The account to use is the one that is named in your hiveext.ini file. By default that is the user 'dayz'. Using HeidiSQL you would open the hivemind database and then the Stored Procedures need to be opened and edit the name from 'root' to 'dayz'
I have never been unfortunate enough to have to use heidiSQL so I cant help you directly, the video is showing where I would change the files using mysql workbench (which is part of the mysql package)

 

[sammeh]

The video is private :O Thanks though

 

[sammeh]

Bump really need help with this, as i'm not paying to host a server just so I can play with friends

 

[ShootingBlanks]

Video was not published .. I hate that because it displays for me so there is no visual clue saying its not publicly available. .. fixed.

Are you hosting on a VPS? Or on your personal computer? I told you what to do in the previous post

Using HeidiSQL you would open the hivemind database and then the Stored Procedures need to be opened and edit the name from 'root' to 'dayz'

SORRY! . I just noticed you said you used navicat, I thought you said heidisql.. I dont understand why people use Mysql but dont use the FREE database editor that is provided WITH mysql .. mysqlworkbench. Then we would ALL be using the same software and could explain things to other people more easily.

http://stackoverflow.com/questions/...created-stored-procedure-in-navicat-for-mysql

http://www.navicat.com/manual/online_manual/en/navicat/win_manual/FunctionsSQLServer.html

 

[sammeh]

I can see the video now, I'll give it a go

 

[sammeh]

in my pmain I don't see a definer?

 

[sammeh]

FIXED IT

THANKS SO MUCH

 

[sammeh]

Changed the "definer" to dayz instead of root@%