• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • If you're using Gesior 2012 or MyAAC, please review this thread for information about a serious security vulnerability and a fix.

UniForm Server "Unable to start Apache (and MySql) Server"

Godsaft

GodSaft - Because Saft Is Gott!
Joined
Apr 3, 2014
Messages
12
Reaction score
0
Hey, i've been experience some issues with UniForm Server.

It all started when I moved my UniServer File from C: to Dropbox, so I could share the file with a friend, so that we easily could edit it between us. But the problem acqured when I was going to start and run the Servers, they were unable to load. I rebooted the computer in hope of any sort of chance that the problem would fix but it never did. All it says is "Unable to start Apache (and MySql) Server"...


Now what I've tried is to rebooting, and also moving it back to C:

It also sometimes happens that either mysql or apache works, but the other don't.

A important thing to add I think is that I redownload a new Uniform server, and it all worked correctly, so I think it's something wrong inside the Uniform servers, it might be something my friend did when he changed in www?



I really appreciate all help that I can get!


Sincerely,
Godsaft
 

dominique120

Science & Reason
Senator
Premium User
Joined
Jun 16, 2013
Messages
3,882
Solutions
3
Reaction score
1,040
Location
Númenor
If you want to share files with a friend the best thing to do is to shave the files inside of the www folder, not the entire uni server folder.

Also, there are a number of reasons as to why apache was unable to start, could be that one of its ports are already being used(skype uses port 80 and 443 for ex.)

Download uniserver and place it in a directory with no spaces and tell your friends to do the same, share only the contents of the www folder.
 
OP
OP
G

Godsaft

GodSaft - Because Saft Is Gott!
Joined
Apr 3, 2014
Messages
12
Reaction score
0
Okey, sounds legit :) But what about our progress so far, because I tried to download Uniserver and replace the files, but it would'nt start at all.
 
OP
OP
G

Godsaft

GodSaft - Because Saft Is Gott!
Joined
Apr 3, 2014
Messages
12
Reaction score
0
Okey so I redownload UniForm Server, and replaced www, I made everything with the database and stuffs you needed. Now threre is one problem showing up when I try to access page "Table 'mydatabase.znote_visitors_details' doesn't exist, how do I import those tables?
 

Znote

<?php echo $title; ?>
Staff member
Global Moderator
Premium User
Joined
Feb 14, 2008
Messages
7,031
Solutions
257
Reaction score
2,085
Location
Norway
GitHub
Znote
Okey so I redownload UniForm Server, and replaced www, I made everything with the database and stuffs you needed. Now threre is one problem showing up when I try to access page "Table 'mydatabase.znote_visitors_details' doesn't exist, how do I import those tables?

In config.php write wrong mysql connection details. And visit the page. An error message will appear along with installation instructions.
 
OP
OP
G

Godsaft

GodSaft - Because Saft Is Gott!
Joined
Apr 3, 2014
Messages
12
Reaction score
0
Import the below schema to a TFS database in phpmyadmin:

CREATE TABLE `znote` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`version` varchar(30) NOT NULL COMMENT 'Znote AAC version',
`installed` int(10) NOT NULL,
`cached` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `znote` (`version`, `installed`) VALUES
('1.3_PUBLIC', '1397149817');

CREATE TABLE `znote_accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL,
`ip` int(10) NOT NULL,
`created` int(10) NOT NULL,
`points` int(10) DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`) VALUES
('1', '0', '1397149817');

CREATE TABLE IF NOT EXISTS `znote_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(30) NOT NULL,
`text` text NOT NULL,
`date` int(11) NOT NULL,
`pid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `znote_paypal` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`txn_id` varchar(30) NOT NULL,
`email` varchar(255) NOT NULL,
`accid` int(11) NOT NULL,
`price` int(11) NOT NULL,
`points` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `znote_paygol` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL,
`price` int(11) NOT NULL,
`points` int(11) NOT NULL,
`message_id` varchar(255) NOT NULL,
`service_id` varchar(255) NOT NULL,
`shortcode` varchar(255) NOT NULL,
`keyword` varchar(255) NOT NULL,
`message` varchar(255) NOT NULL,
`sender` varchar(255) NOT NULL,
`operator` varchar(255) NOT NULL,
`country` varchar(255) NOT NULL,
`currency` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `znote_players` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`player_id` int(11) NOT NULL,
`created` int(11) NOT NULL,
`hide_char` tinyint(4) NOT NULL,
`comment` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

INSERT INTO `znote_players` (`player_id`, `created`, `hide_char`, `comment`) VALUES
('1', '1397149817', '0', '. . .');

CREATE TABLE `znote_shop` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` int(11) NOT NULL,
`itemid` int(11) DEFAULT NULL,
`count` int(11) NOT NULL DEFAULT '1',
`describtion` varchar(255) NOT NULL,
`points` int(11) NOT NULL DEFAULT '10',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `znote_shop_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL,
`player_id` int(11) NOT NULL,
`type` int(11) NOT NULL,
`itemid` int(11) NOT NULL,
`count` int(11) NOT NULL,
`points` int(11) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `znote_shop_orders` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL,
`type` int(11) NOT NULL,
`itemid` int(11) NOT NULL,
`count` int(11) NOT NULL,
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `znote_visitors` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` int(11) NOT NULL,
`value` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `znote_visitors_details` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` int(11) NOT NULL,
`time` int(11) NOT NULL,
`type` tinyint(4) NOT NULL,
`account_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
OP
OP
G

Godsaft

GodSaft - Because Saft Is Gott!
Joined
Apr 3, 2014
Messages
12
Reaction score
0
So yeah thank you guys, it worked Znote :)

Thread is Solved (Download new Uniserver and backup your previous server, then just replace www and SQL, and it worked!)
 
Top