Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic Aurora

 AfterLogic Forum : AfterLogic Aurora
Subject Topic: Creating Tables has fail Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
kafui
Newbie
Newbie


Joined: 18 July 2017
Location: Ghana
Online Status: Offline
Posts: 6
Posted: 18 July 2017 at 9:14am | IP Logged Quote kafui

Hello friends,
        I use Microsoft IIS as my webserver and i download the zip package for the aurora cloud beta.I uzip it into the web directory and also created a new subdomain for it,but i open the weblogin and after i try to setup the databbase .i tested the conection and it work but when i try to creat database table i Get error that creating tables has fail.Please what may be the problem and how to i add more modules and it possible to set space limit for each user.
Thanks kafuicreating tables has fail
Back to Top View kafui's Profile Search for other posts by kafui
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 19 July 2017 at 12:46am | IP Logged Quote Igor

Can you confirm when you downloaded the product? It was renamed from Aurora Cloud Beta to Aurora Files Beta quite a while ago, and there was an update since then, so be sure to download the current version of the package. Also, make sure you're using MySQL database, other database engines aren't currently supported.

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 19 July 2017 at 12:59am | IP Logged Quote Igor

To answer your other questions - adding modules is decribed here, guidelines for creating new modules are available here. And of course, you can set User space limit under System > Files, assuming you're logged in as superadmin user.

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
kafui
Newbie
Newbie


Joined: 18 July 2017
Location: Ghana
Online Status: Offline
Posts: 6
Posted: 19 July 2017 at 5:28am | IP Logged Quote kafui

Thanks for your response.I downloaded it Yesterday from this site   

https://afterlogic.org/download/aurora-files
Mysql version is 5.1 and i use IIS
upadated my php to 7


I insert the the sql user name and password with an already datebase name i created on the command line and i click test connect and i had the respond connected succefully but when i click create table the i have this erro message (creating table has fail)



Please i want to know   if i need to create a Database name in the Sql and insert the database section on web setup or the database will be created automaticall with the tablees




I try to create a user but this the error
Error while creating user (API/DB_EXCEPTION_ERROR)

Thanks kafui
Back to Top View kafui's Profile Search for other posts by kafui
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 19 July 2017 at 5:31am | IP Logged Quote Igor

Quote:
Please i want to know   if i need to create a Database name in the Sql and insert the database section on web setup or the database will be created automaticall with the tablees


Yes, you need to create the database in MySQL first, and then run Create Tables from admin interface of Aurora Files.

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
kafui
Newbie
Newbie


Joined: 18 July 2017
Location: Ghana
Online Status: Offline
Posts: 6
Posted: 19 July 2017 at 10:52am | IP Logged Quote kafui

Thanks very much i have been able to fix it but i have one which is when i try to connect the client application on windows i get am errror

Test connection failed. The remote server returned an error: (404) Not Found.

AM i doing something wrong
Thanks
kafui

Back to Top View kafui's Profile Search for other posts by kafui
 
kafui
Newbie
Newbie


Joined: 18 July 2017
Location: Ghana
Online Status: Offline
Posts: 6
Posted: 19 July 2017 at 10:56am | IP Logged Quote kafui

Please Do I need to setup DAV SERVER and please How do i do it
Thanks
kafui
Back to Top View kafui's Profile Search for other posts by kafui
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 20 July 2017 at 12:57am | IP Logged Quote Igor

If you wish to access the files from Aurora Files desktop app, setting up DAV server is required indeed. Guidelines for that can be found here. IIS isn't covered there, though - but there's a chance SabreDAV documentation will help.

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
kafui
Newbie
Newbie


Joined: 18 July 2017
Location: Ghana
Online Status: Offline
Posts: 6
Posted: 20 July 2017 at 2:20am | IP Logged Quote kafui

I have setup the DAV server on IIS but when i connect i get a new Error 403
What might have done wrong ant Sugestion ? Please do i need o do any changes here

Mobile Sync settings
DAV server

I did insert my cloud domian name in the mobile sync setting and did some changes and now i am having this error from the desktop app when i test conection

[2017-07-21 03:33:14] Test connection failed. Invalid URI: The format of the URI could not be determined
I Did some changes and i get reply getting the list of root folder failed
Also do i need to open some firewall ports?





Thanks
kafui
Back to Top View kafui's Profile Search for other posts by kafui
 
aphtek
Newbie
Newbie


Joined: 22 July 2017
Location: Albania
Online Status: Offline
Posts: 2
Posted: 22 July 2017 at 3:50am | IP Logged Quote aphtek

I'm stuck with Creating tables has failed..

It says Connected Successfully..

Whats the issue?
Back to Top View aphtek's Profile Search for other posts by aphtek
 
kafui
Newbie
Newbie


Joined: 18 July 2017
Location: Ghana
Online Status: Offline
Posts: 6
Posted: 23 July 2017 at 7:00am | IP Logged Quote kafui

i manage to fix mine by installing a new mysql to the latest version
Back to Top View kafui's Profile Search for other posts by kafui
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 24 July 2017 at 2:16am | IP Logged Quote Igor

kafui, we don't have any suggestions for IIS at the moment, other than what SabreDAV documentation offers.

aphtek, is this about current v7.7.5 of AfterLogic Aurora? Anything relevant in debug logs?

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
aphtek
Newbie
Newbie


Joined: 22 July 2017
Location: Albania
Online Status: Offline
Posts: 2
Posted: 24 July 2017 at 2:06pm | IP Logged Quote aphtek

Its about Aurora Files (Beta)
Back to Top View aphtek's Profile Search for other posts by aphtek
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 25 July 2017 at 2:22am | IP Logged Quote Igor

There is indeed a known issue with creating tables when the product is installed on Linux. To correct it, you would need to modify modules/Min/Manager.php file, line ~169:

Code:
$sFilePath = dirname(__FILE__) . '/storages/db/sql/create.sql';


as follows:

Code:
$sFilePath = dirname(__FILE__) . '/storages/db/sql/create.sql';


The similar fix should be applied to modules/Min/Manager.php file, modify line ~245:

Code:
$sFilePath = dirname(__FILE__) . '/storages/db/sql/create.sql';


as follows:

Code:
$sFilePath = dirname(__FILE__) . '/storages/db/sql/create.sql';


Drop the tables with any MySQL management tool such as PhpMyAdmin, and run Create Tables tool again.

Hope this helps.

NB: it appears the forum engine dropped the code to lowercase, those paths should be '/Storages/Db/sql/create.sql' and '/Storages/Db/Sql/create.sql' respectively.

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump

Powered by Web Wiz Forums version 7.9
Copyright ©2001-2004 Web Wiz Guide