trying to make a altis life sever but having problems with t

[mclovinbam]

I'm trying to add a database for my SQL i have a SQL That needs to be for my altis life server, but i got that error i can post the whole SQL file if need be

this the SQL file:
This is the main lines of the SQL

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `arma3life`
-- Default Schema
--
CREATE DATABASE IF NOT EXISTS `arma3life` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `arma3life`;

DELIMITER $$
--
-- Procedures
-- Edit arma3 and root to match a user in MySQL
--
CREATE DEFINER=`arma3`@`localhost` PROCEDURE `resetLifeVehicles`()
BEGIN
UPDATE vehicles SET `active`= 0;
END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteDeadVehicles`()
BEGIN
DELETE FROM `vehicles` WHERE `alive` = 0;
END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldHouses`()
BEGIN
DELETE FROM `houses` WHERE `owned` = 0;
END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldGangs`()
BEGIN
DELETE FROM `gangs` WHERE `active` = 0;
END$$

DELIMITER ;

[mclovinbam]

this is the error:
m trying to make a arma 3 Altis-life server and this is the error i get when i make a database
Error
SQL query:




--
-- Database: `arma3life`
-- Default Schema
--
CREATE DATABASE IF NOT EXISTS `arma3life` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
MySQL said: Documentation

#1044 - Access denied for user 'ravegamingsrvrs'@'localhost' to database 'arma3life'

[kraze]

If I remember correctly databases for Altis life won't work here because we don't support using schemas.

Though, your specific error is being caused because you are using 'localhost' to connect. You need to use your domain name as your hostname.

[mclovinbam]

If I remember correctly databases for Altis life won't work here because we don't support using schemas.

Though, your specific error is being caused because you are using 'localhost' to connect. You need to use your domain name as your hostname.

alright So basically i cant run atlis life?

[mclovinbam]

New error im getting
Error
SQL query:




DELIMITER $$
--
-- Procedures
-- Edit arma3 and root to match a user in MySQL
--
CREATE DEFINER=`ravegamingsrvrs`@`ravegamingsrvrs.site.nfoservers.com` PROCEDURE `resetLifeVehicles`()
BEGIN
UPDATE vehicles SET `active`= 0;
END$$
MySQL said: Documentation

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

what my sql file looks like

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `arma3life`
-- Default Schema
--
CREATE DATABASE IF NOT EXISTS `ravegamingsrvrs_arma3life` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `ravegamingsrvrs_arma3life`;

DELIMITER $$
--
-- Procedures
-- Edit arma3 and root to match a user in MySQL
--
CREATE DEFINER=`ravegamingsrvrs`@`ravegamingsrvrs.site.nfoservers.com` PROCEDURE `resetLifeVehicles`()
BEGIN
UPDATE vehicles SET `active`= 0;
END$$

CREATE DEFINER=`ravegamingsrvrs`@`ravegamingsrvrs.site.nfoservers.com` PROCEDURE `deleteDeadVehicles`()
BEGIN
DELETE FROM `vehicles` WHERE `alive` = 0;
END$$

CREATE DEFINER=`ravegamingsrvrs`@`ravegamingsrvrs.site.nfoservers.com` PROCEDURE `deleteOldHouses`()
BEGIN
DELETE FROM `houses` WHERE `owned` = 0;
END$$

CREATE DEFINER=`ravegamingsrvrs`@`ravegamingsrvrs.site.nfoservers.com` PROCEDURE `deleteOldGangs`()
BEGIN
DELETE FROM `gangs` WHERE `active` = 0;
END$$

DELIMITER ;

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

--
-- Table structure for table `players`
--

CREATE TABLE IF NOT EXISTS `players` (
`uid` int(12) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`playerid` varchar(50) NOT NULL,
`cash` int(100) NOT NULL DEFAULT '0',
`bankacc` int(100) NOT NULL DEFAULT '0',
`coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
`cop_licenses` text,
`civ_licenses` text,
`med_licenses` text,
`cop_gear` text NOT NULL,
`med_gear` text NOT NULL,
`mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
`arrested` tinyint(1) NOT NULL DEFAULT '0',
`aliases` text NOT NULL,
`adminlevel` enum('0','1','2','3') NOT NULL DEFAULT '0',
`donatorlvl` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
`civ_gear` text NOT NULL,
`blacklist` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`uid`),
UNIQUE KEY `playerid` (`playerid`),
KEY `name` (`name`),
KEY `blacklist` (`blacklist`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

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

--
-- Table structure for table `vehicles`
--

CREATE TABLE IF NOT EXISTS `vehicles` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`side` varchar(15) NOT NULL,
`classname` varchar(32) NOT NULL,
`type` varchar(12) NOT NULL,
`pid` varchar(32) NOT NULL,
`alive` tinyint(1) NOT NULL DEFAULT '1',
`active` tinyint(1) NOT NULL DEFAULT '0',
`plate` int(20) NOT NULL,
`color` int(20) NOT NULL,
`inventory` varchar(500) NOT NULL,
PRIMARY KEY (`id`),
KEY `side` (`side`),
KEY `pid` (`pid`),
KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table `houses`
-- Needed for extDB latest update on git
--

CREATE TABLE IF NOT EXISTS `houses` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pid` varchar(32) NOT NULL,
`pos` varchar(64) DEFAULT NULL,
`inventory` text,
`containers` text,
`owned` tinyint(4) DEFAULT '0',
PRIMARY KEY (`id`,`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

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

--
-- Table structure for table `gangs`
-- Needed for extDB latest update on git
--

CREATE TABLE IF NOT EXISTS `gangs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`owner` varchar(32) DEFAULT NULL,
`name` varchar(32) DEFAULT NULL,
`members` text,
`maxmembers` int(2) DEFAULT '8',
`bank` int(100) DEFAULT '0',
`active` tinyint(4) DEFAULT '1',
PRIMARY KEY (`id`),
UNIQUE KEY `name_UNIQUE` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[soja]

Altis life requires a specific database name that cannot be changed. Since shared web hosting makes database names have your package id in the database name, it won't work.

You can still run altis life, but you will need to use a different sql server. If you know how to use linux, a single core linux VDS here would be a good choice.