No Aliasdomain & Subdomains listed??

Discussion in 'ISPConfig 3 Priority Support' started by [email protected], Apr 14, 2019.

  1. danhansen@denmark

    [email protected] Member HowtoForge Supporter

    Hi,


    I have an ISPConfig 3.1 server, clean installation on Ubuntu 18.04.2. Everything seems to be running fine, but creating my subdomains and aliasdomains I ran into trouble. Non of the created subdomains and aliasdomains where are listed. Trying to create these again, the systems tells me that these are allready in place. And thats trur, they work! But I cant see them which is a big issue...

    KR
    Dan
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Maybe you use a filter in the subdomain or alias list which prevents them to show up? Did you check the lists as admin user?
     
  3. danhansen@denmark

    [email protected] Member HowtoForge Supporter

    Hi Till ;)

    Logged in as admin. Didn't change admin account yet. Waiting till its all in place and working.

    Filter? Come again, Till ???

    What are the DB fields/dropdown boxes on the page for adding new subdomains and aliasdomains? I would have showed you a screendump here, but I can't FTP to my server.
    It says:
    "Active", "Server", "Website"
    and whats in those boxes changes. Right now it says:
    The FQDM, one of my clients shop.s domain, and under website this https://192.168.1.101:8080/# , the servers ip. On the old server, I can sort the long lists using these boxes. I guess these are still used for this, but why does this information appear here? Is this a database issue? I installed this ISPconfig server a lot of times. Had some issues a few weeks back, but now in the end it worked out perfectly. PhpMyAdmin works too.
     
    Last edited: Apr 15, 2019
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Please post a screenshot so I can see what exactly you mean.
     
  5. danhansen@denmark

    [email protected] Member HowtoForge Supporter

    Hi,

    Apparently all you need is to delete the content of the fields/boxes and then hit enter, then the subdomains and aliasdomains are listed again. Problem solved. But a weird one...
     
  6. danhansen@denmark

    [email protected] Member HowtoForge Supporter

    Di you still want a screenshot? I've got access to FTP now ;) So if you want it, to see how it looked, let me know... ;)

    A question on the fly... my last issue is the DB's... I've been reading about how you import these DB's using PhpMyAdmin, but it will still not work. I downloaded a SQL backup from ISPconfig31 CP, and tried to import it to the new ISPConfig server. I did of course, create the user, and the site first. I've got the database created on the new server, same name. But fields empty, no records. Do you know if you are suppose to import the records into an existing DB or import the entire DB to without a DB being created on the new server?
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    You said it works now, so I don't need a screenshot, especially as the solution you described shows that you had a filter applied, which was the guess in my first answer.

    You can use phpmyadmin to import a SQL dump or you use the mysql command:

    mysql -u myuser -p mydatabase < mysqlfile.sql

    The command will ask for the password then.
     
  8. danhansen@denmark

    [email protected] Member HowtoForge Supporter

    Hi Till,


    Regarding the DB import, I think its the size. My DB is 24.000Kb and the limit is 2048Kb ?????

    Import to server
    File to import:
    Filen kan være komprimeret (gzip, bzip2, zip) eller ukomprimeret.
    En komprimeret fil skal slutte med .[format].[compression]. Eksempel: .sql.zip
    Gennemse din computer:(Maksimum size: 2,048KiB)
    Du kan også trække og slippe en fil på hvilken som helst side.
    Tegnsæt for filen:

    -----

    "....You said it works now, so I don't need a screenshot, especially as the solution you described shows that you had a filter applied, which was the guess in my first answer..."

    It was a line in the last field, which said "https://192.168.1.100:8080/#" - when I "cleaned" this/deleted this fields, it appeared. I don't know why this appeared. It was there automatically ;)
    The filter values was a test I did, during the issue and after. I didn't know what the function was for, so I tried my way. This was what made me delete all fields, the ipnummer, port and # shown above too, which made it work in the end. And yes, you where right, again ;)

    KR
    Dan
     
    Last edited: Apr 21, 2019
  9. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  10. till

    till Super Moderator Staff Member ISPConfig Developer

    Or set a higher php upload limit in /etc/php/7.1/apache2/php.ini and then restart apache.
     
  11. danhansen@denmark

    [email protected] Member HowtoForge Supporter

    Hi Till & Taleman,


    Thanks, but I'm still having issues exporting and then importing the database. I have read, that there's several flags which has to be set during export or "Export Method".

    ----------------------------------------------------------------------------------
    Exporting tables from "c1ildershop" database
    Export Method:
    • Quick
    • User defined
    Table(s):
    Select all / Deselect all
    Output:
    • Save output to a file
      • File name template:[​IMG] brug dette til fremtidige eksports
      • Tegnsæt for filen:
    Compression:
    • View output as text
    Format:

    Format-specific options:
    • Vis kommentarer (inkluderer info som eksport tidsstempel, PHP version og serverversion)
      • Additional custom header comment (\n splits lines):
      • Inkluder et tidsstempel for hvornår databaser blev oprettet, sidst opdateret og sidst checket
    • Inkludér eksport i en transaktion[​IMG]
    • Slå fremmednøgle-checks fra[​IMG]
    • Databasesystem eller ældre MYSQL server til maksimering af kompatibiltet af output:
    • [​IMG]
    • Dump table

      • struktur
      • data
      • structure and data
    Object creation options
    • Add statements:

      • Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement
      • Add CREATE PROCEDURE / FUNCTION / EVENT statement
      • Muligheder for CREATE TABLE:
        • IF NOT EXISTS
        • AUTO_INCREMENT
    • Omgiv tabel- og feltnavne med backquotes (Beskytter felt- og tabelnavne indeholdende specielle tegn og nøgleord)
    Data dump options
    • I stedet for INSERT forespørgsler, brug:

      • INSERT DELAYED forespørgsler[​IMG]
      • INSERT IGNORE forspørgsler[​IMG]
    • Funktioner der bruges, når data udtrækkes:
    • Syntaks der bruges, når data indsættes:

      • inkluder kolonnenavne i hver INSERT forespørgsel
        Eksempel: INSERT INTO tbl_name (col_A,col_B,col_C) VALUES (1,2,3)
      • indsæt flere rækker i hver INSERT forespørgsel
        Eksempel: INSERT INTO tbl_name VALUES (1,2,3), (4,5,6), (7,8,9)
      • begge af ovenstående
        Eksempel: INSERT INTO tbl_name (col_A,col_B) VALUES (1,2,3), (4,5,6), (7,8,9)
      • ingen af ovenstående
        Eksempel: INSERT INTO tbl_name VALUES (1,2,3)
    • Maksimal længde på oprettet forespørgsel
    • Udtræk binære kolonner i hexadecimal notation (fx, "abc" becomes 0x616263)
    • Udtræk TIMESTAMP kolonner i UTC (gør at TIMESTAMP kolonner kan udtrækkes og indsættes i servere på tværs af tidszoner)
    ----------------------------------------------------------------------------------

    Sorry for the danish frases, the headlines is in English, so that you can see what I mean.
    And, when hitting "Import" in the new database, errors occur instantly.

    ----------------------------------------------------------------------------------
    Warning in ./libraries/plugin_interface.lib.php#551
    [​IMG] count(): Parameter must be an array or an object that implements Countable

    Backtrace

    ./libraries/display_import.lib.php#371: PMA_pluginGetOptions(
    string 'Import',
    array,
    )
    ./libraries/display_import.lib.php#456: PMA_getHtmlForImportOptionsFormat(array)
    ./libraries/display_import.lib.php#691: PMA_getHtmlForImport(
    string '5cd63945dd367',
    string 'database',
    string 'c1ildershop',
    string '',
    integer 2097152,
    array,
    NULL,
    NULL,
    string '',
    )
    ./db_import.php#43: PMA_getImportDisplay(
    string 'database',
    string 'c1ildershop',
    string '',
    integer 2097152,
    )
    ----------------------------------------------------------------------------------
     
  12. danhansen@denmark

    [email protected] Member HowtoForge Supporter

    Hi Till,


    I'll try that, but is it ok to fiddl with this file. Some ini files isn't suppose to be edited in ubuntu I believe...

    # nano /etc/php/7.2/apache2/php.ini

    [...]
    ;;;;;;;;;;;;;;;;
    ; File Uploads ;
    ;;;;;;;;;;;;;;;;

    ; Whether to allow HTTP file uploads.
    ; http://php.net/file-uploads
    file_uploads = On

    ; Temporary directory for HTTP uploaded files (will use system default if not
    ; specified).
    ; http://php.net/upload-tmp-dir
    ;upload_tmp_dir =

    ; Maximum allowed size for uploaded files.
    ; http://php.net/upload-max-filesize
    upload_max_filesize = 2M <------------------------ THIS ONE?

    ; Maximum number of files that can be uploaded via a single request
    max_file_uploads = 20
    [...]


    If, I lost, because it's the import that goes wrong...
    Cliking import in PhpMyAdmin, on the new server:


    Warning in ./libraries/plugin_interface.lib.php#551
    [​IMG] count(): Parameter must be an array or an object that implements Countable

    Backtrace

    ./libraries/display_import.lib.php#371: PMA_pluginGetOptions(
    string 'Import',
    array,
    )
    ./libraries/display_import.lib.php#456: PMA_getHtmlForImportOptionsFormat(array)
    ./libraries/display_import.lib.php#691: PMA_getHtmlForImport(
    string '5cd6b6033e27d',
    string 'database',
    string 'c1ildershop',
    string '',
    integer 8388608,
    array,
    NULL,
    NULL,
    string '',
    )
    ./db_import.php#43: PMA_getImportDisplay(
    string 'database',
    string 'c1ildershop',
    string '',
    integer 8388608,
    )


    But! The db I'm trying to move from the old server to the new server is 24.340Kb large....
     
    Last edited: May 11, 2019
  13. till

    till Super Moderator Staff Member ISPConfig Developer

    Yes, this Limit must be raised.
     

Share This Page